STAS

Transparent Table Application Table
22 Fields 13 CDS Views

BOMs - Item Selection

STAS is an SAP database table in S/4HANA. BOMs - Item Selection. It contains 22 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_BillOfMaterialItemDEX view inner BASIC Data Extraction BOM Item
I_BOMSelectionEAM view from BASIC Bill of Material Item Selection
I_ChgRecdRefBOMComponent view inner BASIC Bill of Material Components for Change Record Ref.
I_MaterialBOMValidItemsSearch view from BASIC CDS based search model view for BOM Item
P_BillOfMaterialItem_2 view_entity from BASIC Get Valid BOM items
P_BillOfMaterialItemDEX view_entity from BASIC Data extraction BOM Item
P_BOMItems view inner BASIC Get Valid BOM items for BOM header
P_Bomitemvalid_To view left_outer BASIC BOM Item valid To Date
P_Bomitemwithchangenum view union_all BASIC BOM items with Change number To
P_MATLBILLOFMATERIALITEMDEX view_entity from BASIC Private view for Material BOM item
P_SalesOrderBOMItemDEX view_entity from BASIC Private view for Sales Order item
P_WBSBillOfMaterialItemDEX view_entity from BASIC Private view for WBS item
RFM_PP_MBOMConstcyChkItmsSel view from Items Selection

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stlty stlty BOM category
KEY stlnr stnum BOM
KEY stlal stalt Alternative
KEY stlkn stlkn Item node
KEY stasz cim_count Counter
datuv datuv Valid From
techv techv Tech st from
aennr aennr Change Number
lkenz lkenz Deletion Ind.
andat andat Created On
annam annam Created by
aedat aedat Changed On
aenam aenam Changed By
dvdat dvdat Scheduled on
dvnam dvnam Date shifted by
aehlp cc_aehlp Helper Field
stvkn stvkn Item node
idpos cs_idpos Item group
idvar cs_idvar Comp. Variant
lpsrt cs_lpsrt Sort key within a logical item
bom_versn bom_version 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.

-- BOMs - Item Selection
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STAS (
    MANDT,      -- Client [mandt]
    STLTY,      -- BOM category [stlty]
    STLNR,      -- BOM [stnum]
    STLAL,      -- Alternative [stalt]
    STLKN,      -- Item node [stlkn]
    STASZ,      -- Counter [cim_count]
    DATUV,      -- Valid From [datuv]
    TECHV,      -- Tech st from [techv]
    AENNR,      -- Change Number [aennr]
    LKENZ,      -- Deletion Ind. [lkenz]
    ANDAT,      -- Created On [andat]
    ANNAM,      -- Created by [annam]
    AEDAT,      -- Changed On [aedat]
    AENAM,      -- Changed By [aenam]
    DVDAT,      -- Scheduled on [dvdat]
    DVNAM,      -- Date shifted by [dvnam]
    AEHLP,      -- Helper Field [cc_aehlp]
    STVKN,      -- Item node [stvkn]
    IDPOS,      -- Item group [cs_idpos]
    IDVAR,      -- Comp. Variant [cs_idvar]
    LPSRT,      -- Sort key within a logical item [cs_lpsrt]
    BOM_VERSN,  -- BOM Version [bom_version]
    PRIMARY KEY (MANDT, STLTY, STLNR, STLAL, STLKN, STASZ)
);

Learn More