P_BOM_HEADER_DETERMINE

CDS View
46 Fields 3 CDS Views

Bom header determination

P_BOM_HEADER_DETERMINE is a CDS View in S/4HANA. Bom header determination. It contains 46 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BillOfMaterial view from BASIC Bill of Material
I_BillOfMaterialHeaderDEX view from BASIC Data Extraction BOM Header
I_BOMHeaderDetermine view from BASIC BOM Header Determination

Fields (46)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 1
KEY BillOfMaterialCategory BillOfMaterialCategory 3
KEY BillOfMaterialVariant BillOfMaterialVariant 2
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
KEY BillOfMaterialVersion BillOfMaterialVersion 3
KEY BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 3
KEY guidx BillOfMaterialHeaderUUID 1
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 2
BillOfMaterialStatus BillOfMaterialStatus 3
BOMAlternativeText BOMAlternativeText 3
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 3
BOMExplosionApplication BOMExplosionApplication 2
BOMGroup BOMGroup 3
BOMHeaderBaseUnit BOMHeaderBaseUnit 2
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit 2
BOMHeaderText BOMHeaderText 3
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 2
BOMIsConfigurable BOMIsConfigurable 3
BOMIsToBeDeleted BOMIsToBeDeleted 2
BOMOrBOMAltvCrtedInPlnt BOMOrBOMAltvCrtedInPlnt 1
BOMPredecessorVersion BOMPredecessorVersion 3
BOMPrioritizedVersion BOMPrioritizedVersion 2
BOMTechnicalType BOMTechnicalType 1
BOMUsagePriority BOMUsagePriority 2
BOMVersionStatus BOMVersionStatus 3
ChangeNumberTo ChgToEngineeringChgDocument 2
CreatedByUser CreatedByUser 3
DeletionIndicator DeletionIndicator,IsMarkedForDeletion 3
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 3
HeaderEngineeringChgNmbrDoc EngineeringChangeDocument,HeaderEngineeringChgNmbrDoc 3
HeaderValidityEndDate HeaderValidityEndDate 3
HeaderValidityStartDate HeaderValidityStartDate 2
IndicatorIsBOMChangedWithHist IndicatorIsBOMChangedWithHist 1
IndicatorIsBOMWithDateHistory IndicatorIsBOMWithDateHistory 2
IsALE IsALE 3
IsConfiguredMaterial IsConfiguredMaterial 2
IsLatestBOMVersion IsLatestBOMVersion 3
IsMultipleBOMAlt IsMultipleBOMAlt 2
IsVersionBillOfMaterial IsVersionBillOfMaterial 3
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 3
LastChangeDate LastChangeDate 3
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
LongTextLanguage LongTextLanguage 2
mandt SAPClient 1
RecordCreationDate RecordCreationDate 3

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.

-- Bom header determination
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BOM_HEADER_DETERMINE (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BOMHEADERINTERNALCHANGECOUNT,
    GUIDX,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALSTATUS,
    BOMALTERNATIVETEXT,
    BOMASSETNTWKHNDOVRISRELEVANT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISARCHIVEDFORDELETION,
    BOMISCONFIGURABLE,
    BOMISTOBEDELETED,
    BOMORBOMALTVCRTEDINPLNT,
    BOMPREDECESSORVERSION,
    BOMPRIORITIZEDVERSION,
    BOMTECHNICALTYPE,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    CHANGENUMBERTO,
    CREATEDBYUSER,
    DELETIONINDICATOR,
    DOCUMENTISCREATEDBYCAD,
    HEADERENGINEERINGCHGNMBRDOC,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    INDICATORISBOMCHANGEDWITHHIST,
    INDICATORISBOMWITHDATEHISTORY,
    ISALE,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LONGTEXTLANGUAGE,
    MANDT,
    RECORDCREATIONDATE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION, BOMHEADERINTERNALCHANGECOUNT, GUIDX)
);

Learn More