I_PLANNINGSCOPEMBOM

CDS View

Document BOM Links

I_PLANNINGSCOPEMBOM is a CDS View in S/4HANA. Document BOM Links. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PlanningScopeMBOMTP view from TRANSACTIONAL Document BOM Links Draft

Fields (23)

KeyField CDS FieldsUsed in Views
KEY DocumentId DocumentId 1
KEY PlanningScopeAlternative PlanningScopeAlternative 1
KEY PlanningScopeItemCount PlanningScopeItemCount 1
KEY SourceMaterial SourceMaterial 1
_BillOfMaterialStatusText _BillOfMaterialStatusText 1
_BillOfMaterialVariantUsage _BillOfMaterialVariantUsage 1
_BillOfOperationsGroup _BillOfOperationsGroup 1
_BillOfOperationsType _BillOfOperationsType 1
_BOMHeader _BOMHeader 1
AlternativeBillOfMaterial AlternativeBillOfMaterial 1
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 1
BOMIsActive BOMIsActive 1
ChangeNumber ChangeNumber 1
Material Material 1
MBOMState MBOMState 1
MBOMUsage MBOMUsage 1
MfgBillOfMaterialCategory MfgBillOfMaterialCategory 1
Plant Plant 1
StatusCount StatusCount 1
SyncedWithSyncUnitUUID SyncedWithSyncUnitUUID 1
TaskListGroup TaskListGroup 1
TaskListGroupCounter TaskListGroupCounter 1
TaskListType TaskListType 1

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.

-- Document BOM Links
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANNINGSCOPEMBOM (
    DOCUMENTID,
    PLANNINGSCOPEALTERNATIVE,
    PLANNINGSCOPEITEMCOUNT,
    SOURCEMATERIAL,
    _BILLOFMATERIALSTATUSTEXT,
    _BILLOFMATERIALVARIANTUSAGE,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _BOMHEADER,
    ALTERNATIVEBILLOFMATERIAL,
    BILLOFMATERIALHEADERUUID,
    BOMISACTIVE,
    CHANGENUMBER,
    MATERIAL,
    MBOMSTATE,
    MBOMUSAGE,
    MFGBILLOFMATERIALCATEGORY,
    PLANT,
    STATUSCOUNT,
    SYNCEDWITHSYNCUNITUUID,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    PRIMARY KEY (DOCUMENTID, PLANNINGSCOPEALTERNATIVE, PLANNINGSCOPEITEMCOUNT, SOURCEMATERIAL)
);