P_BILLOFMATERIALWD

CDS View
45 Fields 1 CDS Views

P_BILLOFMATERIALWD

P_BILLOFMATERIALWD is a CDS View in S/4HANA. P_BILLOFMATERIALWD. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Billofmaterialwd view from COMPOSITE Interface view for Bill Of Material with Draft Data

Fields (45)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 1
KEY DraftUUID DraftUUID 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 1
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialStatus BillOfMaterialStatus 1
BillOfMaterialUUID BillOfMaterialUUID 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BillOfMaterialVersion BillOfMaterialVersion 1
BOMAlternativeText BOMAlternativeText 1
BOMExplosionApplication BOMExplosionApplication 1
BOMGroup BOMGroup 1
BOMHeaderBaseUnit BOMHeaderBaseUnit 1
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 1
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit 1
BOMHeaderText BOMHeaderText 1
BOMIsToBeDeleted BOMIsToBeDeleted 1
BOMPrioritizedVersion BOMPrioritizedVersion 1
BOMUsagePriority BOMUsagePriority 1
BOMVersionStatus BOMVersionStatus 1
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 1
CreatedByUser CreatedByUser 1
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 1
DraftAdministrativeDataUUID DraftAdministrativeDataUUID 1
EngineeringChangeDocument EngineeringChangeDocument 1
HasActiveEntity HasActiveEntity 1
HasDraftEntity HasDraftEntity 1
HeaderValidityEndDate HeaderValidityEndDate 1
HeaderValidityStartDate HeaderValidityStartDate 1
IsActiveEntity IsActiveEntity 1
IsALE IsALE 1
IsConfiguredMaterial IsConfiguredMaterial 1
IsHeaderDraftModified IsHeaderDraftModified 1
IsLatestBOMVersion IsLatestBOMVersion 1
IsMarkedForDeletion IsMarkedForDeletion 1
IsMultipleBOMAlt IsMultipleBOMAlt 1
IsVersionBillOfMaterial IsVersionBillOfMaterial 1
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Material Material 1
MatFromLotSizeQuantity MatFromLotSizeQuantity 1
Plant Plant 1
RecordCreationDate RecordCreationDate 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.

-- P_BILLOFMATERIALWD
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BILLOFMATERIALWD (
    BILLOFMATERIALHEADERUUID,
    DRAFTUUID,
    BILLOFMATERIAL,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BOMALTERNATIVETEXT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERINTERNALCHANGECOUNT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISTOBEDELETED,
    BOMPRIORITIZEDVERSION,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    CHGTOENGINEERINGCHGDOCUMENT,
    CREATEDBYUSER,
    DOCUMENTISCREATEDBYCAD,
    DRAFTADMINISTRATIVEDATAUUID,
    ENGINEERINGCHANGEDOCUMENT,
    HASACTIVEENTITY,
    HASDRAFTENTITY,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    ISACTIVEENTITY,
    ISALE,
    ISCONFIGUREDMATERIAL,
    ISHEADERDRAFTMODIFIED,
    ISLATESTBOMVERSION,
    ISMARKEDFORDELETION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MATERIAL,
    MATFROMLOTSIZEQUANTITY,
    PLANT,
    RECORDCREATIONDATE,
    PRIMARY KEY (BILLOFMATERIALHEADERUUID, DRAFTUUID)
);

Learn More