P_BILLOFMATERIALHEADER

CDS View
49 Fields 2 CDS Views

P_BILLOFMATERIALHEADER is a CDS View in S/4HANA. It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_BOMCreateForUI view union_all CONSUMPTION Consumption view for Create BOM scenario
I_BillOfMaterialHeader view from COMPOSITE BOM Header details

Fields (49)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 1
KEY BillOfMaterialCategory BillOfMaterialCategory 2
KEY BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 1
KEY BillOfMaterialVariant BillOfMaterialVariant 2
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
KEY BillOfMaterialVersion BillOfMaterialVersion 2
KEY EngineeringChangeDocument EngineeringChangeDocument 2
KEY Material Material 2
KEY Plant Plant 2
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 1
BillOfMaterialStatus BillOfMaterialStatus 1
BillOfMaterialUUID BillOfMaterialUUID 1
BOMAlternativeText BOMAlternativeText 1
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 1
BOMExplosionApplication BOMExplosionApplication 1
BOMGroup BOMGroup 1
BOMHeaderBaseUnit BOMHeaderBaseUnit 1
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 1
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit 1
BOMHeaderText BOMHeaderText 1
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 1
BOMIsToBeDeleted BOMIsToBeDeleted 1
BOMPredecessorVersion BOMPredecessorVersion 1
BOMPrioritizedVersion BOMPrioritizedVersion 1
BOMTechnicalType BOMTechnicalType 1
BOMUsagePriority BOMUsagePriority 1
BOMVersionStatus BOMVersionStatus 1
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 1
CreatedByUser CreatedByUser 1
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 1
HeaderValidityEndDate HeaderValidityEndDate 1
HeaderValidityStartDate HeaderValidityStartDate 1
IndicatorIsBOMChangedWithHist IndicatorIsBOMChangedWithHist 1
IndicatorIsBOMWithDateHistory IndicatorIsBOMWithDateHistory 1
IsConfiguredMaterial IsConfiguredMaterial 1
IsLatestBOMVersion IsLatestBOMVersion 1
IsMarkedForDeletion IsMarkedForDeletion 1
IsMultipleBOMAlt IsMultipleBOMAlt 1
IsVersionBillOfMaterial IsVersionBillOfMaterial 1
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LongTextExists LongTextExists 1
LongTextLanguage LongTextLanguage 1
MaterialBOMObjectID MaterialBOMObjectID 1
RecordCreationDate RecordCreationDate 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BILLOFMATERIALHEADER (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALUUID,
    BOMALTERNATIVETEXT,
    BOMASSETNTWKHNDOVRISRELEVANT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERINTERNALCHANGECOUNT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISARCHIVEDFORDELETION,
    BOMISTOBEDELETED,
    BOMPREDECESSORVERSION,
    BOMPRIORITIZEDVERSION,
    BOMTECHNICALTYPE,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    CHGTOENGINEERINGCHGDOCUMENT,
    CREATEDBYUSER,
    DOCUMENTISCREATEDBYCAD,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    INDICATORISBOMCHANGEDWITHHIST,
    INDICATORISBOMWITHDATEHISTORY,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMARKEDFORDELETION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LONGTEXTEXISTS,
    LONGTEXTLANGUAGE,
    MATERIALBOMOBJECTID,
    RECORDCREATIONDATE,
    SALESORDER,
    SALESORDERITEM,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALHEADERUUID, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION, ENGINEERINGCHANGEDOCUMENT, MATERIAL, PLANT)
);

Learn More