STPO_DRAFT

Transparent Table Application Table
102 Fields 1 CDS Views

Draft Data for BillOfMaterial Item

STPO_DRAFT is an SAP database table in S/4HANA. Draft Data for BillOfMaterial Item. It contains 102 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Billofmaterialitemdraft view from BASIC Bill Of Material Item Draft Data

Fields (102)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
billofmaterialitemuuid cs_guid Guid
isactiveentity sdraft_is_active Is active
hasactiveentity sdraft_has_active Has active
hasdraftentity sdraft_has_draft Has Draft
material matnr Material
plant werks_d Plant
billofmaterialvariantusage stlan Usage
billofmaterialcategory stlty BOM category
billofmaterial stnum BOM
billofmaterialvariant stalt Alternative
billofmaterialitemnodenumber stlkn Item node
bomiteminternalchangecount cim_count Counter
validitystartdate datuv Valid From
validityenddate datub to
engineeringchangedocument aennr Change Number
chgtoengineeringchgdocument aenra Change No. To
inheritednodenumberforbomitem stvkn Item node
bomitemnodecount cim_count Counter
bomitemrecordcreationdate andat Created On
bomitemcreatedbyuser annam Created by
bomitemlastchangedate aedat Changed On
bomitemlastchangedbyuser aenam Changed By
billofmaterialcomponent idnrk Component
billofmaterialitemcategory postp Item Category
billofmaterialitemnumber sposn Item
billofmaterialitemunit kmpme Component UoM
billofmaterialitemquantity kmpmg Quantity
isassembly stlkz Assembly
issubitem upskz Sub-item ID
bomitemsorter sortp Sort String
fixedquantity fmnge Fixed Quantity
purchasinggroup ekgrp Purch. Group
currency waers Currency
materialcomponentprice cprei Price
materialpriceunitqty peinh Price unit
componentscrapinpercent kausf Component Scrap
operationscrapinpercent avoau Operation Scrap
isnetscrap netau Net Indicator
numberofvariablesizeitem roanz Number Required
quantityvariablesizeitem romen VSI Quantity
formulakey rform VSI Formula
bomitemdescription potx1 Item Text
bomitemtext2 potx2 Item Text
materialgroup matkl Material Group
documenttype dokar Document Type
docnumber doknr Document
documentversion dokvr Doc. Version
documentpart doktl_d Document Part
classnumber klasse_d Class
classtype klassenart Class Type
resultingitemcategory potpr Res. item cat.
dependencyobjectnumber knobj Assgmt no.
objecttype objty Object Type
isclassificationrelevant cs_kzclb as sel. cond.
isbulkmaterial schgt Bulk material
bomitemissparepart erskz Spare Part ID
bomitemissalesrelevant rvrel Sales
isproductionrelevant sanfe Production
bomitemisplantmaintrelevant sanin Plant maint.
bomitemiscostingrelevant cs_sanka CostingRelevncy
isengineeringrelevant sanko Engineering
specialprocurementtype cs_sobsl SpecProcurement
isbomrecursiveallowed rekrs Rec. allowed
operationleadtimeoffset cs_nlfzv Oper. LT offset
ismaterialprovision beikz Mat. Prov. Ind.
bomisrecursive rekri Recursive
documentiscreatedbycad cadpo CAD Indicator
distrkeycompconsumption sa_verti Distribution
deliverydurationindays lifzt Del time (days)
creditor lifnr Supplier
costelement sakto Cost element
size1 roms1 Size 1
size2 roms2 Size 2
size3 roms3 Size 3
unitofmeasureforsize1to3 romei Size unit
goodsreceiptduration webaz GR proc. time
purchasingorganization ekorg Purchasing Org.
requiredcomponent clobk Reqd Component
multipleselectionallowed clmult Multiple Sel.
prodorderissuelocation cslgo StorageLocation
explosiontype cs_dispo Explosion type
alternativeitemgroup cs_alpgr AltItemGroup
followupgroup cs_nfgrp Follow-up group
discontinuationgroup cs_nfeag Discont. group
reinsurcontrorgunit abteilung Org.area
isconfigurablebom awakz Sel. ind.
referencepoint cn_rfpnt Reference point
leadtimeoffset nlfzt Lead-tm offset
productionsupplyarea prvbe Supply Area
isdeleted lkenz Deletion Ind.
isale cs_alekz ALE indicator
isphantomitem dumps Phantom item
itemid cs_itmid Item ID
materialiscoproduct kzkup Co-product
opsleadtimeoffsetunit cs_nlfmv Oper. LTO unit
identifierbomitem cs_itmid Item ID
billofmaterialitemstate char1 Single-Character Flag
isitemdraftmodified char1 Single-Character Flag
billofmaterialversion cs_versn BOM Version

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.

-- Draft Data for BillOfMaterial Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STPO_DRAFT (
    MANDT,                          -- Client [mandt]
    DRAFTUUID,                      -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                -- Key [/bobf/uuid]
    BILLOFMATERIALITEMUUID,         -- Guid [cs_guid]
    ISACTIVEENTITY,                 -- Is active [sdraft_is_active]
    HASACTIVEENTITY,                -- Has active [sdraft_has_active]
    HASDRAFTENTITY,                 -- Has Draft [sdraft_has_draft]
    MATERIAL,                       -- Material [matnr]
    PLANT,                          -- Plant [werks_d]
    BILLOFMATERIALVARIANTUSAGE,     -- Usage [stlan]
    BILLOFMATERIALCATEGORY,         -- BOM category [stlty]
    BILLOFMATERIAL,                 -- BOM [stnum]
    BILLOFMATERIALVARIANT,          -- Alternative [stalt]
    BILLOFMATERIALITEMNODENUMBER,   -- Item node [stlkn]
    BOMITEMINTERNALCHANGECOUNT,     -- Counter [cim_count]
    VALIDITYSTARTDATE,              -- Valid From [datuv]
    VALIDITYENDDATE,                -- to [datub]
    ENGINEERINGCHANGEDOCUMENT,      -- Change Number [aennr]
    CHGTOENGINEERINGCHGDOCUMENT,    -- Change No. To [aenra]
    INHERITEDNODENUMBERFORBOMITEM,  -- Item node [stvkn]
    BOMITEMNODECOUNT,               -- Counter [cim_count]
    BOMITEMRECORDCREATIONDATE,      -- Created On [andat]
    BOMITEMCREATEDBYUSER,           -- Created by [annam]
    BOMITEMLASTCHANGEDATE,          -- Changed On [aedat]
    BOMITEMLASTCHANGEDBYUSER,       -- Changed By [aenam]
    BILLOFMATERIALCOMPONENT,        -- Component [idnrk]
    BILLOFMATERIALITEMCATEGORY,     -- Item Category [postp]
    BILLOFMATERIALITEMNUMBER,       -- Item [sposn]
    BILLOFMATERIALITEMUNIT,         -- Component UoM [kmpme]
    BILLOFMATERIALITEMQUANTITY,     -- Quantity [kmpmg]
    ISASSEMBLY,                     -- Assembly [stlkz]
    ISSUBITEM,                      -- Sub-item ID [upskz]
    BOMITEMSORTER,                  -- Sort String [sortp]
    FIXEDQUANTITY,                  -- Fixed Quantity [fmnge]
    PURCHASINGGROUP,                -- Purch. Group [ekgrp]
    CURRENCY,                       -- Currency [waers]
    MATERIALCOMPONENTPRICE,         -- Price [cprei]
    MATERIALPRICEUNITQTY,           -- Price unit [peinh]
    COMPONENTSCRAPINPERCENT,        -- Component Scrap [kausf]
    OPERATIONSCRAPINPERCENT,        -- Operation Scrap [avoau]
    ISNETSCRAP,                     -- Net Indicator [netau]
    NUMBEROFVARIABLESIZEITEM,       -- Number Required [roanz]
    QUANTITYVARIABLESIZEITEM,       -- VSI Quantity [romen]
    FORMULAKEY,                     -- VSI Formula [rform]
    BOMITEMDESCRIPTION,             -- Item Text [potx1]
    BOMITEMTEXT2,                   -- Item Text [potx2]
    MATERIALGROUP,                  -- Material Group [matkl]
    DOCUMENTTYPE,                   -- Document Type [dokar]
    DOCNUMBER,                      -- Document [doknr]
    DOCUMENTVERSION,                -- Doc. Version [dokvr]
    DOCUMENTPART,                   -- Document Part [doktl_d]
    CLASSNUMBER,                    -- Class [klasse_d]
    CLASSTYPE,                      -- Class Type [klassenart]
    RESULTINGITEMCATEGORY,          -- Res. item cat. [potpr]
    DEPENDENCYOBJECTNUMBER,         -- Assgmt no. [knobj]
    OBJECTTYPE,                     -- Object Type [objty]
    ISCLASSIFICATIONRELEVANT,       -- as sel. cond. [cs_kzclb]
    ISBULKMATERIAL,                 -- Bulk material [schgt]
    BOMITEMISSPAREPART,             -- Spare Part ID [erskz]
    BOMITEMISSALESRELEVANT,         -- Sales [rvrel]
    ISPRODUCTIONRELEVANT,           -- Production [sanfe]
    BOMITEMISPLANTMAINTRELEVANT,    -- Plant maint. [sanin]
    BOMITEMISCOSTINGRELEVANT,       -- CostingRelevncy [cs_sanka]
    ISENGINEERINGRELEVANT,          -- Engineering [sanko]
    SPECIALPROCUREMENTTYPE,         -- SpecProcurement [cs_sobsl]
    ISBOMRECURSIVEALLOWED,          -- Rec. allowed [rekrs]
    OPERATIONLEADTIMEOFFSET,        -- Oper. LT offset [cs_nlfzv]
    ISMATERIALPROVISION,            -- Mat. Prov. Ind. [beikz]
    BOMISRECURSIVE,                 -- Recursive [rekri]
    DOCUMENTISCREATEDBYCAD,         -- CAD Indicator [cadpo]
    DISTRKEYCOMPCONSUMPTION,        -- Distribution [sa_verti]
    DELIVERYDURATIONINDAYS,         -- Del time (days) [lifzt]
    CREDITOR,                       -- Supplier [lifnr]
    COSTELEMENT,                    -- Cost element [sakto]
    SIZE1,                          -- Size 1 [roms1]
    SIZE2,                          -- Size 2 [roms2]
    SIZE3,                          -- Size 3 [roms3]
    UNITOFMEASUREFORSIZE1TO3,       -- Size unit [romei]
    GOODSRECEIPTDURATION,           -- GR proc. time [webaz]
    PURCHASINGORGANIZATION,         -- Purchasing Org. [ekorg]
    REQUIREDCOMPONENT,              -- Reqd Component [clobk]
    MULTIPLESELECTIONALLOWED,       -- Multiple Sel. [clmult]
    PRODORDERISSUELOCATION,         -- StorageLocation [cslgo]
    EXPLOSIONTYPE,                  -- Explosion type [cs_dispo]
    ALTERNATIVEITEMGROUP,           -- AltItemGroup [cs_alpgr]
    FOLLOWUPGROUP,                  -- Follow-up group [cs_nfgrp]
    DISCONTINUATIONGROUP,           -- Discont. group [cs_nfeag]
    REINSURCONTRORGUNIT,            -- Org.area [abteilung]
    ISCONFIGURABLEBOM,              -- Sel. ind. [awakz]
    REFERENCEPOINT,                 -- Reference point [cn_rfpnt]
    LEADTIMEOFFSET,                 -- Lead-tm offset [nlfzt]
    PRODUCTIONSUPPLYAREA,           -- Supply Area [prvbe]
    ISDELETED,                      -- Deletion Ind. [lkenz]
    ISALE,                          -- ALE indicator [cs_alekz]
    ISPHANTOMITEM,                  -- Phantom item [dumps]
    ITEMID,                         -- Item ID [cs_itmid]
    MATERIALISCOPRODUCT,            -- Co-product [kzkup]
    OPSLEADTIMEOFFSETUNIT,          -- Oper. LTO unit [cs_nlfmv]
    IDENTIFIERBOMITEM,              -- Item ID [cs_itmid]
    BILLOFMATERIALITEMSTATE,        -- Single-Character Flag [char1]
    ISITEMDRAFTMODIFIED,            -- Single-Character Flag [char1]
    BILLOFMATERIALVERSION,          -- BOM Version [cs_versn]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More