STPO

Transparent Table Application Table
143 Fields 26 CDS Views

BOM item

STPO is an SAP database table in S/4HANA. BOM item. It contains 143 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
E_BillOfMaterialItemTP view from EXTENSION Extended View For Bill Of Material Item
I_BillOfMaterialItemBasic view from BASIC Bill of Material Item Details
I_BillOfMaterialItemDEX view from BASIC Data Extraction BOM Item
I_BOMItemChangeState view_entity from BASIC Bill Of Material Item Change State
I_BOMItemEAM view from BASIC PM Specific Bill of Material Items
I_BOMItemOldChangeState view_entity inner BASIC BOM Item Old Change State
I_JITOutbBOM view inner BASIC Bill of material details for JIT
I_MaterialBOMValidItemsSearch view inner BASIC CDS based search model view for BOM Item
I_ProdnModOpActyCompInstceBsc view_entity left_outer BASIC OACI Keys and basic data
I_ProdnModOpActyCompInstceBsc view_entity inner BASIC OACI Keys and basic data
P_BillOfMaterialItemDEX view_entity inner BASIC Data extraction BOM Item
P_BOMItemChanges view inner BASIC
P_BOMITEMDELETECHANGES view inner BASIC
P_BOMItems view from BASIC Get Valid BOM items for BOM header
P_ChangeDocumentPlanningScope view left_outer BASIC
P_JITOutBOMData view inner TRANSACTIONAL Bill of material data
P_MaterialBOMSubitemDEX view_entity inner BASIC
P_MATLBILLOFMATERIALITEMDEX view_entity inner BASIC
P_ProjectBOMSubitemDEX view_entity inner BASIC
P_SalesOrderBOMItemDEX view_entity inner BASIC
P_SALESORDERBOMSUBITEMDEX view_entity inner BASIC
P_Valid_Bomitems view inner BASIC Get Valid BOM items for BOM header
P_VALID_COMPONENTS view inner BASIC Get Valid BOM items for BOM header
P_Valid_VersionBomitems view inner BASIC
P_WBSBillOfMaterialItemDEX view_entity inner BASIC
RFM_PP_MBOMConstcyChkItms view from

Fields (143)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY stlty STLTY BOM category
KEY stlnr STNUM BOM
KEY stlkn STLKN Item node
KEY stpoz CIM_COUNT Counter
datuv DATUV Valid From
techv TECHV Tech st from
aennr AENNR Change Number
lkenz LKENZ Deletion Ind.
vgknt VGKNT Previous node
vgpzl VGPZL Prev item count
andat ANDAT Created On
annam ANNAM Created by
aedat AEDAT Changed On
aenam AENAM Changed By
idnrk IDNRK Component
pswrk PSWRK Issuing Plant
postp POSTP Item Category
posnr SPOSN Item
sortf SORTP Sort String
meins KMPME Component UoM
menge KMPMG Quantity
fmeng FMNGE Fixed Quantity
ausch KAUSF Component Scrap
avoau AVOAU Operation Scrap
netau NETAU Net Indicator
schgt SCHGT Bulk material
beikz BEIKZ Mat. Prov. Ind.
erskz ERSKZ Spare Part ID
rvrel RVREL Sales
sanfe SANFE Production
sanin SANIN Plant maint.
sanka CS_SANKA CostingRelevncy
sanko SANKO Engineering
sanvs SANVS HL confign
stkkz STKKZ PM assembly
rekri REKRI Recursive
rekrs REKRS Rec. allowed
cadpo CADPO CAD Indicator
nfmat CS_NFMAT Follow-Up Matl
nlfzt NLFZT Lead-tm offset
verti SA_VERTI Distribution
alpos ALPOS Alternat. item
ewahr EWAHR Usage Prob.
ekgrp EKGRP Purch. Group
lifzt LIFZT Del time (days)
lifnr LIFNR Supplier
preis CPREI Price
peinh PEINH Price unit
waers WAERS Currency
sakto SAKTO Cost element
roanz ROANZ Number Required
roms1 ROMS1 Size 1
roms2 ROMS2 Size 2
roms3 ROMS3 Size 3
romei ROMEI Size unit
romen ROMEN VSI Quantity
rform RFORM VSI Formula
upskz UPSKZ Sub-item ID
valkz VALKZ Alt ID
ltxsp LTXSP_CP Long Text Lang
potx1 POTX1 Item Text
potx2 POTX2 Item Text
objty OBJTY Object Type
matkl MATKL Material Group
webaz WEBAZ GR proc. time
dokar DOKAR Document Type
doknr DOKNR Document
dokvr DOKVR Doc. Version
doktl DOKTL_D Document Part
csstr CSSTR Mat. purity
class KLASSE_D Class
klart KLASSENART Class Type
potpr POTPR Res. item cat.
awakz AWAKZ Sel. ind.
inskz INSKZ Instance
vcekz VCEKZ N.Dis.CE
vstkz VSTKZ N.Dis.ST
vackz VACKZ N.Dis.AC
ekorg EKORG Purchasing Org.
clobk CLOBK Reqd Component
clmul CLMULT Multiple Sel.
clalt CLALT Altern. display
cview ABTEILUNG Org.area
knobj KNOBJ Assgmt no.
lgort CSLGO StorageLocation
kzkup KZKUP Co-product
intrm INTRM Intra Material
tpekz TPEKZ Restr.
stvkn STVKN Item node
dvdat DVDAT Scheduled on
dvnam DVNAM Date shifted by
dspst CS_DISPO Explosion type
alpst CS_ALPST Strategy
alprf CS_ALPRF Priority
alpgr CS_ALPGR AltItemGroup
kznfp CS_KZNFP Follow-Up Item
nfgrp CS_NFGRP Follow-up group
nfeag CS_NFEAG Discont. group
kndvb CS_KNDVB Manual change
kndbz CS_KNDBZ Obj.dep.change
kstty CS_KSTTY BOM category
kstnr CS_KSTNR BOM
kstkn CS_KSTKN Item node
kstpz CS_KSTPZ Counter
clszu CS_CLSZU Classification
kzclb CS_KZCLB as sel. cond.
aehlp CC_AEHLP Helper Field
prvbe PRVBE Supply Area
nlfzv CS_NLFZV Oper. LT offset
nlfmv CS_NLFMV Oper. LTO unit
idpos CS_IDPOS Item group
idhis CS_IDHIS History counter
idvar CS_IDVAR Comp. Variant
alekz CS_ALEKZ ALE indicator
itmid CS_ITMID Item ID
guid CS_CHAR22 Not used
itsob CS_SOBSL SpecProcurement
rfpnt CN_RFPNT Reference point
guidx CS_GUID Guid
sgt_cmkz SGT_CMKZ Seg. maintained
sgt_catv SGT_CATV Seg. Value
valid_to DATUB to
valid_to_rkey DATUB to
ecn_to AENRA Change No. To
ecn_to_rkey AENRA Change No. To
ablad ABLAD Unloading Point
wempf WEMPF Recipient
stvkn_versn STVKN Item node
lastchangedatetime TIMESTAMPL Time Stamp
preliminary_material MAKTX Description
sfwind CS_SFWIND Software component
dummy_stpo_incl_eew_ps STPO_INCL_EEW Ext. Include
cufactor /CUM/CUFACTOR NoCUInstances
fsh_vmkz FSH_VMKZ Dev.vals maint.
fsh_pgqr FSH_QD_PROFILE Qty Distr. prof.
fsh_pgqrrf FSH_PGQRRF Qty Distr.Prof.Ref.
fsh_critical_comp FSH_CRITICAL_COMP Critical Component
fsh_critical_level FSH_CRITICAL_LEVEL Critical Level
funcid CCC_FUNCID Function ID
serviceduration SERVICEDURATION Service Duration
servicedurationunit SERVICEDURATIONUNIT Serv. Dur. Unit
producttype PRODUCT_TYPE Product Type Group

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- BOM item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STPO (
    MANDT,                   -- Client [MANDT]
    STLTY,                   -- BOM category [STLTY]
    STLNR,                   -- BOM [STNUM]
    STLKN,                   -- Item node [STLKN]
    STPOZ,                   -- Counter [CIM_COUNT]
    DATUV,                   -- Valid From [DATUV]
    TECHV,                   -- Tech st from [TECHV]
    AENNR,                   -- Change Number [AENNR]
    LKENZ,                   -- Deletion Ind. [LKENZ]
    VGKNT,                   -- Previous node [VGKNT]
    VGPZL,                   -- Prev item count [VGPZL]
    ANDAT,                   -- Created On [ANDAT]
    ANNAM,                   -- Created by [ANNAM]
    AEDAT,                   -- Changed On [AEDAT]
    AENAM,                   -- Changed By [AENAM]
    IDNRK,                   -- Component [IDNRK]
    PSWRK,                   -- Issuing Plant [PSWRK]
    POSTP,                   -- Item Category [POSTP]
    POSNR,                   -- Item [SPOSN]
    SORTF,                   -- Sort String [SORTP]
    MEINS,                   -- Component UoM [KMPME]
    MENGE,                   -- Quantity [KMPMG]
    FMENG,                   -- Fixed Quantity [FMNGE]
    AUSCH,                   -- Component Scrap [KAUSF]
    AVOAU,                   -- Operation Scrap [AVOAU]
    NETAU,                   -- Net Indicator [NETAU]
    SCHGT,                   -- Bulk material [SCHGT]
    BEIKZ,                   -- Mat. Prov. Ind. [BEIKZ]
    ERSKZ,                   -- Spare Part ID [ERSKZ]
    RVREL,                   -- Sales [RVREL]
    SANFE,                   -- Production [SANFE]
    SANIN,                   -- Plant maint. [SANIN]
    SANKA,                   -- CostingRelevncy [CS_SANKA]
    SANKO,                   -- Engineering [SANKO]
    SANVS,                   -- HL confign [SANVS]
    STKKZ,                   -- PM assembly [STKKZ]
    REKRI,                   -- Recursive [REKRI]
    REKRS,                   -- Rec. allowed [REKRS]
    CADPO,                   -- CAD Indicator [CADPO]
    NFMAT,                   -- Follow-Up Matl [CS_NFMAT]
    NLFZT,                   -- Lead-tm offset [NLFZT]
    VERTI,                   -- Distribution [SA_VERTI]
    ALPOS,                   -- Alternat. item [ALPOS]
    EWAHR,                   -- Usage Prob. [EWAHR]
    EKGRP,                   -- Purch. Group [EKGRP]
    LIFZT,                   -- Del time (days) [LIFZT]
    LIFNR,                   -- Supplier [LIFNR]
    PREIS,                   -- Price [CPREI]
    PEINH,                   -- Price unit [PEINH]
    WAERS,                   -- Currency [WAERS]
    SAKTO,                   -- Cost element [SAKTO]
    ROANZ,                   -- Number Required [ROANZ]
    ROMS1,                   -- Size 1 [ROMS1]
    ROMS2,                   -- Size 2 [ROMS2]
    ROMS3,                   -- Size 3 [ROMS3]
    ROMEI,                   -- Size unit [ROMEI]
    ROMEN,                   -- VSI Quantity [ROMEN]
    RFORM,                   -- VSI Formula [RFORM]
    UPSKZ,                   -- Sub-item ID [UPSKZ]
    VALKZ,                   -- Alt ID [VALKZ]
    LTXSP,                   -- Long Text Lang [LTXSP_CP]
    POTX1,                   -- Item Text [POTX1]
    POTX2,                   -- Item Text [POTX2]
    OBJTY,                   -- Object Type [OBJTY]
    MATKL,                   -- Material Group [MATKL]
    WEBAZ,                   -- GR proc. time [WEBAZ]
    DOKAR,                   -- Document Type [DOKAR]
    DOKNR,                   -- Document [DOKNR]
    DOKVR,                   -- Doc. Version [DOKVR]
    DOKTL,                   -- Document Part [DOKTL_D]
    CSSTR,                   -- Mat. purity [CSSTR]
    CLASS,                   -- Class [KLASSE_D]
    KLART,                   -- Class Type [KLASSENART]
    POTPR,                   -- Res. item cat. [POTPR]
    AWAKZ,                   -- Sel. ind. [AWAKZ]
    INSKZ,                   -- Instance [INSKZ]
    VCEKZ,                   -- N.Dis.CE [VCEKZ]
    VSTKZ,                   -- N.Dis.ST [VSTKZ]
    VACKZ,                   -- N.Dis.AC [VACKZ]
    EKORG,                   -- Purchasing Org. [EKORG]
    CLOBK,                   -- Reqd Component [CLOBK]
    CLMUL,                   -- Multiple Sel. [CLMULT]
    CLALT,                   -- Altern. display [CLALT]
    CVIEW,                   -- Org.area [ABTEILUNG]
    KNOBJ,                   -- Assgmt no. [KNOBJ]
    LGORT,                   -- StorageLocation [CSLGO]
    KZKUP,                   -- Co-product [KZKUP]
    INTRM,                   -- Intra Material [INTRM]
    TPEKZ,                   -- Restr. [TPEKZ]
    STVKN,                   -- Item node [STVKN]
    DVDAT,                   -- Scheduled on [DVDAT]
    DVNAM,                   -- Date shifted by [DVNAM]
    DSPST,                   -- Explosion type [CS_DISPO]
    ALPST,                   -- Strategy [CS_ALPST]
    ALPRF,                   -- Priority [CS_ALPRF]
    ALPGR,                   -- AltItemGroup [CS_ALPGR]
    KZNFP,                   -- Follow-Up Item [CS_KZNFP]
    NFGRP,                   -- Follow-up group [CS_NFGRP]
    NFEAG,                   -- Discont. group [CS_NFEAG]
    KNDVB,                   -- Manual change [CS_KNDVB]
    KNDBZ,                   -- Obj.dep.change [CS_KNDBZ]
    KSTTY,                   -- BOM category [CS_KSTTY]
    KSTNR,                   -- BOM [CS_KSTNR]
    KSTKN,                   -- Item node [CS_KSTKN]
    KSTPZ,                   -- Counter [CS_KSTPZ]
    CLSZU,                   -- Classification [CS_CLSZU]
    KZCLB,                   -- as sel. cond. [CS_KZCLB]
    AEHLP,                   -- Helper Field [CC_AEHLP]
    PRVBE,                   -- Supply Area [PRVBE]
    NLFZV,                   -- Oper. LT offset [CS_NLFZV]
    NLFMV,                   -- Oper. LTO unit [CS_NLFMV]
    IDPOS,                   -- Item group [CS_IDPOS]
    IDHIS,                   -- History counter [CS_IDHIS]
    IDVAR,                   -- Comp. Variant [CS_IDVAR]
    ALEKZ,                   -- ALE indicator [CS_ALEKZ]
    ITMID,                   -- Item ID [CS_ITMID]
    GUID,                    -- Not used [CS_CHAR22]
    ITSOB,                   -- SpecProcurement [CS_SOBSL]
    RFPNT,                   -- Reference point [CN_RFPNT]
    GUIDX,                   -- Guid [CS_GUID]
    SGT_CMKZ,                -- Seg. maintained [SGT_CMKZ]
    SGT_CATV,                -- Seg. Value [SGT_CATV]
    VALID_TO,                -- to [DATUB]
    VALID_TO_RKEY,           -- to [DATUB]
    ECN_TO,                  -- Change No. To [AENRA]
    ECN_TO_RKEY,             -- Change No. To [AENRA]
    ABLAD,                   -- Unloading Point [ABLAD]
    WEMPF,                   -- Recipient [WEMPF]
    STVKN_VERSN,             -- Item node [STVKN]
    LASTCHANGEDATETIME,      -- Time Stamp [TIMESTAMPL]
    PRELIMINARY_MATERIAL,    -- Description [MAKTX]
    SFWIND,                  -- Software component [CS_SFWIND]
    DUMMY_STPO_INCL_EEW_PS,  -- Ext. Include [STPO_INCL_EEW]
    CUFACTOR,                -- NoCUInstances [/CUM/CUFACTOR]
    FSH_VMKZ,                -- Dev.vals maint. [FSH_VMKZ]
    FSH_PGQR,                -- Qty Distr. prof. [FSH_QD_PROFILE]
    FSH_PGQRRF,              -- Qty Distr.Prof.Ref. [FSH_PGQRRF]
    FSH_CRITICAL_COMP,       -- Critical Component [FSH_CRITICAL_COMP]
    FSH_CRITICAL_LEVEL,      -- Critical Level [FSH_CRITICAL_LEVEL]
    FUNCID,                  -- Function ID [CCC_FUNCID]
    SERVICEDURATION,         -- Service Duration [SERVICEDURATION]
    SERVICEDURATIONUNIT,     -- Serv. Dur. Unit [SERVICEDURATIONUNIT]
    PRODUCTTYPE,             -- Product Type Group [PRODUCT_TYPE]
    PRIMARY KEY (MANDT, STLTY, STLNR, STLKN, STPOZ)
);

Learn More