Model / PP / STPO

PP — Production Planning

STPO

125 fields · 6 key · 55 foreign keys · sourced from leanx.eu

BOM Item — individual component line items of a bill of material (quantity, item category, scrap, procurement). Terminal table of the BOM chain.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
CTG keycategoriaBOM categorySTLTYCHAR 1
IXM keyindex materiarumBill of materialSTNUMCHAR 8
POS_NUM keypositio numerusBOM item node numberSTLKNNUMC 8
NMR keynumeratorInternal counterCIM_COUNTNUMC 8
VLA_DIE keyvalidus ab diesValid-From DateDATUVDATS 8
STAstatusTechnical status fromTECHVCHAR 12
NUMnumerusChange NumberAENNRCHAR 12AENR
IDXindexDeletion IndicatorLKENZCHAR 1
VGKNTPredecessor NodeVGKNTNUMC 8
POS_NMRpositio numeratorPrevious item counterVGPZLNUMC 8
DIE_TBL_CREdies tabula creatusDate record created onANDATDATS 8
USR_CRE_TBLusor creatus tabulaUser who created recordANNAMCHAR 12
MUTmutatusChanged OnAEDATDATS 8
NOM_PSN_MUTnomen persona mutatusName of Person Who Changed ObjectAENAMCHAR 12
CMNcomponensBOM componentIDNRKCHAR 18
OFCofficinaIssuing plantPSWRKCHAR 4T001W
POS_CTG_IXMpositio categoria index materiarumItem Category (Bill of Material)POSTPCHAR 1T418
POS_NUM2positio numerusBOM Item NumberSPOSNCHAR 4
SORTFSort StringSORTPCHAR 10
CMN_MENcomponens mensuraComponent unit of measureKMPMEUNIT 3T006
CMN_QNTcomponens quantitasComponent quantityKMPMGQUAN 13,3
FMENGFixed qtyFMNGECHAR 1
CMN2componensComponent scrap in percentKAUSFDEC 5,2
OPEoperatioOperation scrapAVOAUDEC 5,2
IDX_NETindex netusIndicator: Net scrapNETAUCHAR 1
IDX_MATindex materiaIndicator: Bulk MaterialSCHGTCHAR 1
MAT_IDXmateria indexMaterial Provision IndicatorBEIKZCHAR 1T417
IDX2indexIndicator: spare partERSKZCHAR 1T413
IDX_POS_VDTindex positio venditioIndicator: item relevant to salesRVRELCHAR 1TVRL
IDX_POS_PRDindex positio productioIndicator: item relevant to productionSANFECHAR 1
IDX_POS_OFCindex positio officinaIndicator: item relevant to plant maintenanceSANINCHAR 1
IDX3indexIndicator for relevancy to costingCS_SANKACHAR 1TCK08
IDX_POSindex positioIndicator: item relevant to engineeringSANKOCHAR 1
IDX_GRDindex gradusIndicator: high-level configurationSANVSCHAR 1
IDX4indexPM assembly indicatorSTKKZCHAR 1
IDX5indexIndicator: BOM is recursiveREKRICHAR 1
IDX6indexIndicator: recursiveness allowedREKRSCHAR 1
IDX7indexCAD IndicatorCADPOCHAR 1
MAT_POSmateria positioFollow-up material in BOM item - NOT IN USECS_NFMATCHAR 18MARA
TMPtempusLead-time offsetNLFZTDEC 3
DTB_CLV_CMNdistributio clavis componensDistribution key for component consumptionSA_VERTICHAR 4T437V
IDX_POS2index positioIndicator: alternative itemALPOSCHAR 1
POSpositioUsage probability in % (alternative item)EWAHRDEC 3
CTScoetusPurchasing GroupEKGRPCHAR 3T024
TRD_TMPtraditio tempusDelivery time in daysLIFZTDEC 3
RAT_NUM_VENratio numerus venditorAccount Number of Vendor or CreditorLIFNRCHAR 10LFA1
PREpretiumPriceCPREICURR 11,2
PRE_UNIpretium unitasPrice UnitPEINHDEC 5
CVMclavis monetaeCurrency KeyWAERSCUKY 5TCURC
SMP_ELMsumptus elementumCost elementSAKTOCHAR 10
NUM_MGNnumerus magnitudoNumber of variable-size itemsROANZQUAN 13,3
MGNmagnitudoSize 1ROMS1QUAN 13,3
MGN2magnitudoSize 2ROMS2QUAN 13,3
MGN3magnitudoSize 3ROMS3QUAN 13,3
MENmensuraUnit of measure for sizes 1 to 3ROMEIUNIT 3T006
QNT_MGN_POSquantitas magnitudo positioQuantity of variable-size itemROMENQUAN 13,3
CLVclavisFormula keyRFORMCHAR 2T418F
IDX8indexIndicator: sub-items existUPSKZCHAR 1
IDX_POS3index positioIndicator: item in more than one alternativeVALKZCHAR 1
TXT_LNG_DMUtextus lingua documentum mutationisLong Text Language, for Creation of a Change DocumentLTXSP_CPLANG 1T002
POS_TXTpositio textusBOM Item Text (Line 1)POTX1CHAR 40
POS_TXT2positio textusBOM item text (line 2)POTX2CHAR 40
OBI_GEN_POSobiectum genus positioObject type (BOM item)OBJTYCHAR 1
MAT_CTSmateria coetusMaterial GroupMATKLCHAR 9T023
AMR_TMPacceptio mercium tempusGoods Receipt Processing Time in DaysWEBAZDEC 3
GDOgenus documentiDocument TypeDOKARCHAR 3TDWA
NDOnumerus documentiDocument numberDOKNRCHAR 25
DOC_VRSdocumentum versioDocument VersionDOKVRCHAR 2
DOCdocumentumDocument PartDOKTL_DCHAR 3
MATmateriaAverage material purity in %CSSTRDEC 5,2
CLS_NUMclassis numerusClass numberKLASSE_DCHAR 18
CLS_GENclassis genusClass TypeKLASSENARTCHAR 3TCLA
POS_CTGpositio categoriaResulting item categoryPOTPRCHAR 1T418
IDX9indexSelection indicator for configurable BOMsAWAKZCHAR 1
IDX10indexInstance indicatorINSKZCHAR 1
IDX11indexIndicator: not displayed in configuration editorVCEKZCHAR 1
IDX_GRD2index gradusIndicator: not displayed in single-level configurationVSTKZCHAR 1
IDX12indexIndicator: not displayed in automatic configurationVACKZCHAR 1
OEMorganizatio emptionisPurchasing OrganizationEKORGCHAR 4T024E
CMN3componensRequired ComponentCLOBKCHAR 1
CLMULMultiple Selection AllowedCLMULTCHAR 1
CLALTAlternative Display FormatCLALTCHAR 1
AREareaOrganizational AreaABTEILUNGCHAR 10
NUM_OBInumerus obiectumNumber of Object with Assigned DependenciesKNOBJNUMC 18
LOC_PRD_MNDlocus productio mandatumIssue location for production orderCSLGOCHAR 4T001L
IDX13indexIndicator: co-productKZKUPCHAR 1
MAT2materiaIntra MaterialINTRMCHAR 18
IDX14indexIndicator: restrictions existTPEKZCHAR 1
NUM_POSnumerus positioInherited node number of BOM itemSTVKNNUMC 8
DIE_ULT_VICdies ultimus vicisDate of last date shiftDVDATDATS 8
NOM_USR_DIEnomen usor diesName of the user who carried out the date shiftDVNAMCHAR 12
GENgenusExplosion typeCS_DISPOCHAR 2T414
POS2positioAlternative item: strategyCS_ALPSTCHAR 1
POS_MNDpositio mandatumAlternative item: ranking orderCS_ALPRFNUMC 2
POS_CTSpositio coetusAlternative item: groupCS_ALPGRCHAR 2
IDX_POS4index positioIndicator: Follow-Up ItemCS_KZNFPCHAR 1
CTS2coetusFollow-up groupCS_NFGRPCHAR 2
CTS3coetusDiscontinuation groupCS_NFEAGCHAR 2
IDX_VDT_MNDindex venditio mandatumIndicator: manual change to sales order BOMCS_KNDVBCHAR 1
IDX_POS_MUTindex positio mutatusIndicator: BOM item changed/selected via obj. dependenciesCS_KNDBZCHAR 1
CTG_VDT_MNDcategoria venditio mandatumBOM category of original sales order BOM itemCS_KSTTYCHAR 1
IXM_VDT_MNDindex materiarum venditio mandatumBill of material for original sales order BOM itemCS_KSTNRCHAR 8
NUM_VDT_MNDnumerus venditio mandatumNode number of original sales order BOM itemCS_KSTKNNUMC 8
NMR_VDT_MNDnumerator venditio mandatumCounter for original sales order BOM itemCS_KSTPZNUMC 8
NUM2numerusClassification numberCS_CLSZUNUMC 8
IDX_CNDindex condicioIndicator: classification as selection conditionCS_KZCLBCHAR 1
DIE_VIC_HIRdies vicis hierarchiaDate Shift Hierarchy IndicatorCC_AEHLPNUMC 2
PRD_CPA_AREproductio copia areaProduction Supply AreaPRVBECHAR 10PVBE
TMP_OPEtempus operatioLead-time offset for operationCS_NLFZVDEC 3
UNI_TMP_OPEunitas tempus operatioUnit for lead-time offset for operationCS_NLFMVUNIT 3T006
POS_CTS2positio coetusItem groupCS_IDPOSCHAR 20
NMR2numeratorHistory counterCS_IDHISNUMC 5
CMN4componensComponent VariantCS_IDVARCHAR 5
IDX15indexALE indicatorCS_ALEKZCHAR 1
POS3positioExternal identification of an itemCS_ITMIDCHAR 8
GUIDTemporarily not usedCS_CHAR22CHAR 22
GEN_POSgenus positioSpecial procurement type for BOM itemCS_SOBSLCHAR 2
RFRreferentiaReference point for BOM transferCN_RFPNTCHAR 20TCNRFP
POS_STApositio statusGlobal identification of an item's change statusCS_GUIDRAW 16
RFR2referentiaReference Designator (RDS-PP)Y_RDS_PPCHAR 40
CMN5componensPDMLink BOM Component IDY_PDMLINKIDCHAR 36
YY_ITEM_COMMONIDBOMCommonIDY_COMMONIDCHAR 36
NUM3numerusCU: Number of CU Instances/CUM/CUFACTORNUMC 6
FUNCIDFunction IdentifierCCC_FUNCIDCHAR 40

Foreign keys

FieldCheck tableCheck field
AENNRAENRAENNR
AENNRAENRMANDT
BEIKZT417BEIKZ
BEIKZT417MANDT
DOKARTDWADOKAR
DOKARTDWAMANDT
DSPSTT414DISPO
DSPSTT414MANDT
EKGRPT024EKGRP
EKGRPT024MANDT
EKORGT024EEKORG
EKORGT024EMANDT
ERSKZT413ERSKZ
ERSKZT413MANDT
KLARTTCLAKLART
KLARTTCLAMANDT
LGORTT001LLGORT
LGORTT001LWERKS
LGORTT001LMANDT
LIFNRLFA1MANDT
LIFNRLFA1LIFNR
LTXSPT002SPRAS
MANDTT000MANDT
MATKLT023MANDT
MATKLT023MATKL
MEINST006MANDT
MEINST006MSEHI
NFMATMARAMATNR
NFMATMARAMANDT
NLFMVT006MANDT
NLFMVT006MSEHI
POSTPT418POSTP
POSTPT418MANDT
POTPRT418POSTP
POTPRT418MANDT
PRVBEPVBEWERKS
PRVBEPVBEPRVBE
PRVBEPVBEMANDT
PSWRKT001WMANDT
PSWRKT001WWERKS
RFORMT418FMANDT
RFORMT418FRFORM
RFPNTTCNRFPRFPNT
RFPNTTCNRFPMANDT
ROMEIT006MSEHI
ROMEIT006MANDT
RVRELTVRLRVREL
RVRELTVRLMANDT
SANKATCK08SELKZ
SANKATCK08MANDT
VERTIT437VVERTL
VERTIT437VWERKS
VERTIT437VMANDT
WAERSTCURCMANDT
WAERSTCURCWAERS

View STPO.yaml in the repository