IEMBWICOMPINFOD

Transparent Table Application Table
60 Fields 1 CDS Views

I_OPACTYWORKINSTRUCTIONTP I_MFGWORKINSTRNCOMPONENTINFOTP

IEMBWICOMPINFOD is an SAP database table in S/4HANA. I_OPACTYWORKINSTRUCTIONTP I_MFGWORKINSTRNCOMPONENTINFOTP. It contains 60 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_MfgWorkInstructionComponent view_entity from EXTENSION Mfg WI Component - Extension

Fields (60)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
parentdraftuuid /BOBF/UUID Key
mfgworkinstruction MPE_WI_ID Work Instruction
mfgworkinstructionverscounter MPE_WI_VERSION_NO Version No.
mfgworkinstructionvariable MPE_WI_VARIABLE Variable
selectedcontexttype MPE_VARIABLE_TYPE Var TYpe
prodnrtgversbominternalid CIM_ZUORD Allocation no.
booopbomiteminternalid CIM_ZUORD Allocation no.
origldgtlmockupcharcsuuid DMU_GUID16 DMU GUID
billofmaterialcategory STLTY BOM category
billofmaterial abap.char
billofmaterialvariant STALT Alternative
billofmaterialversion CIM_BOM_VERSN BOM Version
inheritednodenumberforbomitem KNTNR Nodes
billofmaterialcomponent IDNRK Component
billofmaterialcomponentname MAKTX Description
billofmaterialitemnodenumber STLKN Item node
billofmaterialitemunit KMPME Component UoM
billofmaterialitemquantity KMPMG Quantity
serialnumberprofile SERAIL SerialNoProfile
isbatchmanagementrequired XCHPF_WERKS Batch Mgmt Rqt(Plnt)
matlcompismarkedforbackflush RGEKZ Backflush
dgtlmockupinstcecount abap.int1
createdbyuser USNAM User Name
creationdatetime TZNTSTMPS Time Stamp
changedby USNAM User Name
lastchangedatetime TZNTSTMPS Time Stamp
mfgisitemselected FLAG Indicator
referencedesignatorvalue MPE_RTGV_BOM_REF_DESIGNATOR Ref. Designator
referencedesignator MPE_MRS_DESIGNATOR MRS Designator ID
mfgrefstrucitmrefdsgntrname MPE_MRS_DESIGNATOR_NAME MRS Designator
isbulkmaterialcomponent SCHGT Bulk material
billofmaterialitemcategory POSTP Item Category
variablesizedimension1 ROMS1 Size 1
variablesizedimension2 ROMS2 Size 2
variablesizedimension3 ROMS3 Size 3
variablesizedimensionunit ROMEI Size unit
variablesizecompformulakey RFORM VSI Formula
variablesizecompunitofmeasure ROAME VSI unit
quantityvariablesizeitem ROMEN VSI Quantity
variablesizeitemquantity ROANZ Number Required
variablesizecompformula FORMEL Formula
variablesizecomponentunit ROKME VSI UoM
itemisvariablesized RTPOS Var-size item
mfgrefstrucbomleafassgmtuuid MPE_MRS_LEAF_ASSIGNMENT_UUID Leaf Assignment UUID
assemblysequencenumber MPE_RTGV_PROC_SEQ_NO Assembly Sequence
comptoopactyassignment MPE_RTG_ASSIGNED_TO_OA Current OA Assgmt
matlcompinstceassyisrequired MPE_RTG_HAS_COMP_INSTANCES Instances Exist
bomitmcatisreferenceitem CS_REFERENCE Reference Item
dgtlmockupcharcsuuid CIM_DMU_GUID16 DMU GUID
alternativeitemgroup CS_ALPGR AltItemGroup
usageprobabilitypercent abap.dec
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_mfg_wi_comp_incl_eew_ps CFD_DUMMY Dummy

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.

-- I_OPACTYWORKINSTRUCTIONTP I_MFGWORKINSTRNCOMPONENTINFOTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IEMBWICOMPINFOD (
    MANDT,                          -- Client [MANDT]
    DRAFTUUID,                      -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                -- Key [/BOBF/UUID]
    MFGWORKINSTRUCTION,             -- Work Instruction [MPE_WI_ID]
    MFGWORKINSTRUCTIONVERSCOUNTER,  -- Version No. [MPE_WI_VERSION_NO]
    MFGWORKINSTRUCTIONVARIABLE,     -- Variable [MPE_WI_VARIABLE]
    SELECTEDCONTEXTTYPE,            -- Var TYpe [MPE_VARIABLE_TYPE]
    PRODNRTGVERSBOMINTERNALID,      -- Allocation no. [CIM_ZUORD]
    BOOOPBOMITEMINTERNALID,         -- Allocation no. [CIM_ZUORD]
    ORIGLDGTLMOCKUPCHARCSUUID,      -- DMU GUID [DMU_GUID16]
    BILLOFMATERIALCATEGORY,         -- BOM category [STLTY]
    BILLOFMATERIAL,                 -- abap.char
    BILLOFMATERIALVARIANT,          -- Alternative [STALT]
    BILLOFMATERIALVERSION,          -- BOM Version [CIM_BOM_VERSN]
    INHERITEDNODENUMBERFORBOMITEM,  -- Nodes [KNTNR]
    BILLOFMATERIALCOMPONENT,        -- Component [IDNRK]
    BILLOFMATERIALCOMPONENTNAME,    -- Description [MAKTX]
    BILLOFMATERIALITEMNODENUMBER,   -- Item node [STLKN]
    BILLOFMATERIALITEMUNIT,         -- Component UoM [KMPME]
    BILLOFMATERIALITEMQUANTITY,     -- Quantity [KMPMG]
    SERIALNUMBERPROFILE,            -- SerialNoProfile [SERAIL]
    ISBATCHMANAGEMENTREQUIRED,      -- Batch Mgmt Rqt(Plnt) [XCHPF_WERKS]
    MATLCOMPISMARKEDFORBACKFLUSH,   -- Backflush [RGEKZ]
    DGTLMOCKUPINSTCECOUNT,          -- abap.int1
    CREATEDBYUSER,                  -- User Name [USNAM]
    CREATIONDATETIME,               -- Time Stamp [TZNTSTMPS]
    CHANGEDBY,                      -- User Name [USNAM]
    LASTCHANGEDATETIME,             -- Time Stamp [TZNTSTMPS]
    MFGISITEMSELECTED,              -- Indicator [FLAG]
    REFERENCEDESIGNATORVALUE,       -- Ref. Designator [MPE_RTGV_BOM_REF_DESIGNATOR]
    REFERENCEDESIGNATOR,            -- MRS Designator ID [MPE_MRS_DESIGNATOR]
    MFGREFSTRUCITMREFDSGNTRNAME,    -- MRS Designator [MPE_MRS_DESIGNATOR_NAME]
    ISBULKMATERIALCOMPONENT,        -- Bulk material [SCHGT]
    BILLOFMATERIALITEMCATEGORY,     -- Item Category [POSTP]
    VARIABLESIZEDIMENSION1,         -- Size 1 [ROMS1]
    VARIABLESIZEDIMENSION2,         -- Size 2 [ROMS2]
    VARIABLESIZEDIMENSION3,         -- Size 3 [ROMS3]
    VARIABLESIZEDIMENSIONUNIT,      -- Size unit [ROMEI]
    VARIABLESIZECOMPFORMULAKEY,     -- VSI Formula [RFORM]
    VARIABLESIZECOMPUNITOFMEASURE,  -- VSI unit [ROAME]
    QUANTITYVARIABLESIZEITEM,       -- VSI Quantity [ROMEN]
    VARIABLESIZEITEMQUANTITY,       -- Number Required [ROANZ]
    VARIABLESIZECOMPFORMULA,        -- Formula [FORMEL]
    VARIABLESIZECOMPONENTUNIT,      -- VSI UoM [ROKME]
    ITEMISVARIABLESIZED,            -- Var-size item [RTPOS]
    MFGREFSTRUCBOMLEAFASSGMTUUID,   -- Leaf Assignment UUID [MPE_MRS_LEAF_ASSIGNMENT_UUID]
    ASSEMBLYSEQUENCENUMBER,         -- Assembly Sequence [MPE_RTGV_PROC_SEQ_NO]
    COMPTOOPACTYASSIGNMENT,         -- Current OA Assgmt [MPE_RTG_ASSIGNED_TO_OA]
    MATLCOMPINSTCEASSYISREQUIRED,   -- Instances Exist [MPE_RTG_HAS_COMP_INSTANCES]
    BOMITMCATISREFERENCEITEM,       -- Reference Item [CS_REFERENCE]
    DGTLMOCKUPCHARCSUUID,           -- DMU GUID [CIM_DMU_GUID16]
    ALTERNATIVEITEMGROUP,           -- AltItemGroup [CS_ALPGR]
    USAGEPROBABILITYPERCENT,        -- abap.dec
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_MFG_WI_COMP_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More