Which CDS Views use STPO_D?

STPO_D is used by 1 CDS view(s), including: R_WBSBillOfMaterialItemDraft.

STPO_D

Q: How many fields does STPO_D have?

STPO_D has 125 fields. Key fields: mandt, billofmaterial, billofmaterialcategory, billofmaterialvariant, billofmaterialversion, billofmaterialitemnodenumber, headerchangedocument, material, plant, draftuuid.

Transparent Table Application Table

125 Fields 1 CDS Views

Draft table for BOM Items

STPO_D is an SAP database table in S/4HANA. Draft table for BOM Items. It contains 125 fields. 1 CDS views read from this table.

CDS Views using this table (1)

View	Type	Join	VDM	Description
R_WBSBillOfMaterialItemDraft	view_entity	from	BASIC	Draft View for WBS Bill Of Material Item

Fields (125)

Key	Field	Data Element	Description
KEY	mandt	mandt	Client
KEY	billofmaterial	cs_stlnr	BOM
KEY	billofmaterialcategory	stlty	BOM category
KEY	billofmaterialvariant	stalt	Alternative
KEY	billofmaterialversion	bom_version	BOM Version
KEY	billofmaterialitemnodenumber	stlkn	Item node
KEY	headerchangedocument	aennr	Change Number
KEY	material	matnr	Material
KEY	plant	werks_d	Plant
KEY	draftuuid	sdraft_uuid	Draft Document ID
	parentdraftuuid	sdraft_uuid	Draft Document ID
	billofmaterialitemuuid	cs_guid	Guid
	billofmaterialheaderuuid	cs_guidb	Guid
	bomiteminternalchangecount	cim_count	Counter
	validitystartdate	datuv	Valid From
	validityenddate	datub	to
	engineeringchangedocforedit	aennr	Change Number
	engineeringchangedocument	aennr	Change Number
	billofmaterialvariantusage	stlan	Usage
	chgtoengineeringchgdocument	aenra	Change No. To
	inheritednodenumberforbomitem	stvkn	Item node
	bomitemrecordcreationdate	andat	Created On
	bomitemcreatedbyuser	annam	Created by
	bomitemlastchangedate	aedat	Changed On
	bomitemlastchangedbyuser	aenam	Changed By
	billofmaterialcomponent	idnrk	Component
	billofmaterialitemcategory	postp	Item Category
	billofmaterialitemnumber	cs_sposn	Item
	billofmaterialitemunit	kmpme	Component UoM
	billofmaterialitemquantity	kmpmg	Quantity
	isassembly	xfeld	Checkbox
	issubitem	upskz	Sub-item ID
	bomitemsorter	sortp	Sort String
	bomitemhasfixedquantity	fmnge	Fixed Quantity
	purchasinggroup	ekgrp	Purch. Group
	currency	waers	Currency
	materialcomponentprice	preis	Price
	identifierbomitem	cs_itmid	Item ID
	materialpriceunitqty	peinh	Price unit
	componentscrapinpercent	kausf	Component Scrap
	operationscrapinpercent	avoau	Operation Scrap
	isnetscrap	netau	Net Indicator
	variablesizeitemquantity	varsizeitm
	variablesizecompunitofmeasure	abap.unit
	quantityvariablesizeitem	romen	VSI Quantity
	formulakey	rform	VSI Formula
	componentdescription	ojtxp	Description
	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.
	billofmaterialitemobjecttype	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
	opsleadtimeoffsetunit	cs_nlfmv	Oper. LTO unit
	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
	materialiscoproduct	kzkup	Co-product
	explosiontype	cs_dispo	Explosion type
	alternativeitemgroup	cs_alpgr	AltItemGroup
	alternativeitempriority	cs_alprf	Priority
	alternativeitemstrategy	cs_alpst	Strategy
	usageprobabilitypercent	ewahr	Usage Prob.
	followupgroup	cs_nfgrp	Follow-up group
	discontinuationgroup	cs_nfeag	Discont. group
	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
	salesorder	cs_vbeln	Sales Order
	salesorderitem	cs_vbpos	Item
	isphantomitem	xfeld	Checkbox
	lastchangedatetime	timestampl	Time Stamp
	preliminarycomponent	maktx	Description
	productexternalid	matnr_external	Material
	productisconfigurable	kzkfg	Configrable Material
	isbulkmaterialcomponent	schgt	Bulk material
	isitemdraftmodified	char1	Single-Character Flag
	variablesizeitemishidden	boolean	Boolean Variable (X = True, - = False, Space = Unknown)
	classdetailsishidden	boolean	Boolean Variable (X = True, - = False, Space = Unknown)
	nonstockitemdetailsishidden	boolean	Boolean Variable (X = True, - = False, Space = Unknown)
	documentitemdetailsishidden	boolean	Boolean Variable (X = True, - = False, Space = Unknown)
	billofmaterialissubitemhidden	boolean	Boolean Variable (X = True, - = False, Space = Unknown)
	billofmaterialitmnteidentifier	abap.char
	billofmaterialitemcategorydesc	pttxt	Item Category
	materialgrouptext	wgbez60	Mat.Grp Desc. 2
	documentdescription	dktxt	Description
	classdescription	klsbez	Description
	productionsupplyareaname	vdm_pvbtx	Production Supply Area Name
	purchasinggroupname	mm_a_purg_grp_name	Purchasing Grp. Name
	purchasingorganizationname	mm_a_purg_org_name	Purch. Org. Name
	bomitemcategorysecondarydesc	pttxt	Item Category
	altitemstrategydescription	val_text	Short Description

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 table for BOM Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STPO_D (
    MANDT,                           -- Client [mandt]
    BILLOFMATERIAL,                  -- BOM [cs_stlnr]
    BILLOFMATERIALCATEGORY,          -- BOM category [stlty]
    BILLOFMATERIALVARIANT,           -- Alternative [stalt]
    BILLOFMATERIALVERSION,           -- BOM Version [bom_version]
    BILLOFMATERIALITEMNODENUMBER,    -- Item node [stlkn]
    HEADERCHANGEDOCUMENT,            -- Change Number [aennr]
    MATERIAL,                        -- Material [matnr]
    PLANT,                           -- Plant [werks_d]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    BILLOFMATERIALITEMUUID,          -- Guid [cs_guid]
    BILLOFMATERIALHEADERUUID,        -- Guid [cs_guidb]
    BOMITEMINTERNALCHANGECOUNT,      -- Counter [cim_count]
    VALIDITYSTARTDATE,               -- Valid From [datuv]
    VALIDITYENDDATE,                 -- to [datub]
    ENGINEERINGCHANGEDOCFOREDIT,     -- Change Number [aennr]
    ENGINEERINGCHANGEDOCUMENT,       -- Change Number [aennr]
    BILLOFMATERIALVARIANTUSAGE,      -- Usage [stlan]
    CHGTOENGINEERINGCHGDOCUMENT,     -- Change No. To [aenra]
    INHERITEDNODENUMBERFORBOMITEM,   -- Item node [stvkn]
    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 [cs_sposn]
    BILLOFMATERIALITEMUNIT,          -- Component UoM [kmpme]
    BILLOFMATERIALITEMQUANTITY,      -- Quantity [kmpmg]
    ISASSEMBLY,                      -- Checkbox [xfeld]
    ISSUBITEM,                       -- Sub-item ID [upskz]
    BOMITEMSORTER,                   -- Sort String [sortp]
    BOMITEMHASFIXEDQUANTITY,         -- Fixed Quantity [fmnge]
    PURCHASINGGROUP,                 -- Purch. Group [ekgrp]
    CURRENCY,                        -- Currency [waers]
    MATERIALCOMPONENTPRICE,          -- Price [preis]
    IDENTIFIERBOMITEM,               -- Item ID [cs_itmid]
    MATERIALPRICEUNITQTY,            -- Price unit [peinh]
    COMPONENTSCRAPINPERCENT,         -- Component Scrap [kausf]
    OPERATIONSCRAPINPERCENT,         -- Operation Scrap [avoau]
    ISNETSCRAP,                      -- Net Indicator [netau]
    VARIABLESIZEITEMQUANTITY,        -- varsizeitm
    VARIABLESIZECOMPUNITOFMEASURE,   -- abap.unit
    QUANTITYVARIABLESIZEITEM,        -- VSI Quantity [romen]
    FORMULAKEY,                      -- VSI Formula [rform]
    COMPONENTDESCRIPTION,            -- Description [ojtxp]
    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]
    BILLOFMATERIALITEMOBJECTTYPE,    -- 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]
    OPSLEADTIMEOFFSETUNIT,           -- Oper. LTO unit [cs_nlfmv]
    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]
    MATERIALISCOPRODUCT,             -- Co-product [kzkup]
    EXPLOSIONTYPE,                   -- Explosion type [cs_dispo]
    ALTERNATIVEITEMGROUP,            -- AltItemGroup [cs_alpgr]
    ALTERNATIVEITEMPRIORITY,         -- Priority [cs_alprf]
    ALTERNATIVEITEMSTRATEGY,         -- Strategy [cs_alpst]
    USAGEPROBABILITYPERCENT,         -- Usage Prob. [ewahr]
    FOLLOWUPGROUP,                   -- Follow-up group [cs_nfgrp]
    DISCONTINUATIONGROUP,            -- Discont. group [cs_nfeag]
    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]
    SALESORDER,                      -- Sales Order [cs_vbeln]
    SALESORDERITEM,                  -- Item [cs_vbpos]
    ISPHANTOMITEM,                   -- Checkbox [xfeld]
    LASTCHANGEDATETIME,              -- Time Stamp [timestampl]
    PRELIMINARYCOMPONENT,            -- Description [maktx]
    PRODUCTEXTERNALID,               -- Material [matnr_external]
    PRODUCTISCONFIGURABLE,           -- Configrable Material [kzkfg]
    ISBULKMATERIALCOMPONENT,         -- Bulk material [schgt]
    ISITEMDRAFTMODIFIED,             -- Single-Character Flag [char1]
    VARIABLESIZEITEMISHIDDEN,        -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    CLASSDETAILSISHIDDEN,            -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    NONSTOCKITEMDETAILSISHIDDEN,     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    DOCUMENTITEMDETAILSISHIDDEN,     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    BILLOFMATERIALISSUBITEMHIDDEN,   -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    BILLOFMATERIALITMNTEIDENTIFIER,  -- abap.char
    BILLOFMATERIALITEMCATEGORYDESC,  -- Item Category [pttxt]
    MATERIALGROUPTEXT,               -- Mat.Grp Desc. 2 [wgbez60]
    DOCUMENTDESCRIPTION,             -- Description [dktxt]
    CLASSDESCRIPTION,                -- Description [klsbez]
    PRODUCTIONSUPPLYAREANAME,        -- Production Supply Area Name [vdm_pvbtx]
    PURCHASINGGROUPNAME,             -- Purchasing Grp. Name [mm_a_purg_grp_name]
    PURCHASINGORGANIZATIONNAME,      -- Purch. Org. Name [mm_a_purg_org_name]
    BOMITEMCATEGORYSECONDARYDESC,    -- Item Category [pttxt]
    ALTITEMSTRATEGYDESCRIPTION,      -- Short Description [val_text]
    PRIMARY KEY (MANDT, BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, BILLOFMATERIALITEMNODENUMBER, HEADERCHANGEDOCUMENT, MATERIAL, PLANT, DRAFTUUID)
);

Depth:

STPO_D

CDS Views using this table (1)

Fields (125)

Learn More