/ISDFPS/MATSPPLN

Materials Planned for Force Element | #transactional | Component: Structures Workbench
Column Name Description
CLIENT FK Client
PLANNING_GUID Planning GUID
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
QUPLN Planned Quantity
Column Name Description
DELIVERY_DATE Delivery Date
RETURN_DATE Return Date for Loan
MBDAT Material Staging/Availability Date
DAT_SP Collectn Pt Date
CREATED_ON Date Record Created On
CHANGED_ON Last Changed On
Column Name Description
REF_TYPE Type of Reference Relationship Show values
REF_TYPE2 Type of Reference Relationship Show values
FLAG_LOAN Loan Show values
FLAG_LOAN_RET Loan Return Show values
FLAG_EV Relocation: Initial Supply Show values
FBSTA Relocation: Follow-On Document Status Show values
FLAG_HISTORY Record Is Historical Show values
FLAG_MAINTENANCE Change of Ownership Show values
FLAG_COMPLETED Completely Processed Show values
FLAG_FORWARDED Purchase Requisition Forwarded Show values
FLAG_DERIVED PReq Is Derived (Forwarding) Show values
FLAG_WB Planned Record Created in Workbench Show values
FLAG_SUBITEM Subitem Show values
FLAG_RETURN Return Delivery Show values
FLAG_RES_FWD Forwarded Reservation Show values
FLAG_SERNR_PREQ Serial Number PReq Show values
Column Name Description Domain name
RECTYPE Record Type Planning /ISDFPS/FDPMAT_RECTYPE
FORCE_REC_ID Internal Key for Force Element SYSUUID_C
FORCE_REC_CNT Internal (Version) Counter NUMC6
PLANT_REC Plant WERKS
STORAGE_LOC_REC Storage location LGORT
HU_LOC_REC HU Storage Location LGORT
FORCE_PROV_ID Internal Key for Force Element SYSUUID_C
FORCE_PROV_CNT Internal (Version) Counter NUMC6
PLANT_PROV Plant WERKS
STORAGE_LOC_PROV Storage location LGORT
HU_LOC_PROV HU Storage Location LGORT
SERNR Serial Number GERNR
BATCH Batch Number CHARG
PSPNR WBS Element PS_POSNR
HU_EXID External Handling Unit Identification EXIDV
VEPOS Handling Unit Item VEPOS
PACK_MAT Packaging Materials MATNR
RSNUM Number of reservation/dependent requirements RSNUM
COMNT Planning Comment TEXT40
REF_GUID Planning GUID SYSUUID_C
REF_GUID2 Planning GUID SYSUUID_C
PREQ_NO Purchase Requisition Number BANFN
PREQ_ITEM Item number of purchase requisition BNFPO
RECORD_INVISIBLE Single-Character Flag CHAR1
RELOC_ID Relocation ID /ISDFPS/RELOC_ID
RELOC_SEQ_ID Relocation Step ID /ISDFPS/RELOC_SEQ_ID
PNGUID Internal Identification for PVS Objects SYSUUID
FORCEM_CNT Internal (Version) Counter NUMC6
DGUID Distribution Assignment ID SYSUUID_C
FORCE_ASGN_ID Internal Key for Force Element SYSUUID_C
FORCE_ASGN_CNT Internal (Version) Counter NUMC6
BSART Order Type (Purchasing) BSART
LFART Delivery Type LFART
ROUTE Route ROUTE
APPLOBJ_TYPE Application Object Type for iPPE PVS_APPLOBJ_TYPE
PNAME iPPE Node Description PVS_PNODE
FLAG_PROV Provisions
LOCATION_S_GUID ISDFPS: Location ID (GUID) SYSUUID_C
LOCATION_D_GUID ISDFPS: Location ID (GUID) SYSUUID_C
CREATED_BY User who created record USNAM
CHANGED_BY Name of Person Who Changed Object USNAM
VBELN Delivery VBELN
VSBED Shipping Conditions VSBED
RSPOS Item Number of Reservation / Dependent Requirements RSPOS
SERNR_PREQ Serial Number GERNR
RELSEQ_TYPE Relocation Step Type /ISDFPS/RELSEQ_TYPE
Master Data Relations Join Conditions
Client /ISDFPS/MATSPPLN.CLIENT == T000.MANDT
Material Number
  • Material Number
  • Client
  • /ISDFPS/MATSPPLN.MATNR == MARA.MATNR
  • /ISDFPS/MATSPPLN.CLIENT == MARA.MANDT