I_PLANNINGSCOPEMBOMTP
Document BOM Links Draft
I_PLANNINGSCOPEMBOMTP is a CDS View in S/4HANA. Document BOM Links Draft. It contains 23 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_PlanningScopeMBOM | view | from | CONSUMPTION | Consumption View for Document Mbom links |
Fields (23)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DocumentId | DocumentId | 1 |
| KEY | PlanningScopeAlternative | PlanningScopeAlternative | 1 |
| KEY | PlanningScopeItemCount | PlanningScopeItemCount | 1 |
| KEY | SourceMaterial | SourceMaterial | 1 |
| _BillOfMaterialVariantUsage | _BillOfMaterialVariantUsage | 1 | |
| _BillOfOperationsGroup | _BillOfOperationsGroup | 1 | |
| _BillOfOperationsType | _BillOfOperationsType | 1 | |
| _BOMHeader | _BOMHeader | 1 | |
| AlternativeBillOfMaterial | AlternativeBillOfMaterial | 1 | |
| BillOfMaterialHeaderUUID | BillOfMaterialHeaderUUID | 1 | |
| BOMHeaderDraftUUID | BOMHeaderDraftUUID | 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 Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANNINGSCOPEMBOMTP (
DOCUMENTID,
PLANNINGSCOPEALTERNATIVE,
PLANNINGSCOPEITEMCOUNT,
SOURCEMATERIAL,
_BILLOFMATERIALVARIANTUSAGE,
_BILLOFOPERATIONSGROUP,
_BILLOFOPERATIONSTYPE,
_BOMHEADER,
ALTERNATIVEBILLOFMATERIAL,
BILLOFMATERIALHEADERUUID,
BOMHEADERDRAFTUUID,
BOMISACTIVE,
CHANGENUMBER,
MATERIAL,
MBOMSTATE,
MBOMUSAGE,
MFGBILLOFMATERIALCATEGORY,
PLANT,
STATUSCOUNT,
SYNCEDWITHSYNCUNITUUID,
TASKLISTGROUP,
TASKLISTGROUPCOUNTER,
TASKLISTTYPE,
PRIMARY KEY (DOCUMENTID, PLANNINGSCOPEALTERNATIVE, PLANNINGSCOPEITEMCOUNT, SOURCEMATERIAL)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA