I_SALESORDERBOMHEADER

CDS View
47 Fields 2 CDS Views

Sales Order Bill Of Material Header

I_SALESORDERBOMHEADER is a CDS View in S/4HANA. Sales Order Bill Of Material Header. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_SalesOrderBillOfMaterialTP view_entity from TRANSACTIONAL Sales Order BOM Header TP
R_SalesOrderBillOfMaterialTP_1 view_entity from TRANSACTIONAL Sales Order Bill of Material Header

Fields (47)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 1
KEY BillOfMaterialCategory BillOfMaterialCategory 2
KEY BillOfMaterialVariant BillOfMaterialVariant 2
KEY EngineeringChangeDocument EngineeringChangeDocForEdit,EngineeringChangeDocument 2
KEY Material Material 2
KEY Plant Plant 2
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 2
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 2
BillOfMaterialStatus BillOfMaterialStatus 2
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
BOMAlternativeText BOMAlternativeText 2
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 2
BOMExplosionApplication BOMExplosionApplication 2
BOMGroup BOMGroup 2
BOMHeaderBaseUnit BOMHeaderBaseUnit 2
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 2
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit 2
BOMHeaderText BOMHeaderText 2
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 1
BOMIsToBeDeleted BOMIsToBeDeleted 2
BOMTechnicalType BOMTechnicalType 1
BOMUsagePriority BOMUsagePriority 2
BOMVersionStatus BOMVersionStatus 1
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 2
CreatedByUser CreatedByUser 2
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 2
HeaderValidityEndDate ValidityEndDate 2
HeaderValidityStartDate ValidityStartDate 2
IndicatorIsBOMChangedWithHist IndicatorIsBOMChangedWithHist 1
IndicatorIsBOMWithDateHistory IndicatorIsBOMWithDateHistory 1
IsALE IsALE 1
IsConfiguredMaterial IsConfiguredMaterial 2
IsLatestBOMVersion IsLatestBOMVersion 1
IsMarkedForDeletion IsMarkedForDeletion 2
IsMultipleBOMAlt IsMultipleBOMAlt 1
IsVersionBillOfMaterial IsVersionBillOfMaterial 2
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 2
LastChangeDate LastChangeDate 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
MaterialToLotSizeQuantity MaterialToLotSizeQuantity 1
MatFromLotSizeQuantity MatFromLotSizeQuantity 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RecordCreationDate RecordCreationDate 2
SalesOrder SalesOrder 2
SalesOrderItem SalesOrderItem 2
SoldToParty SoldToParty 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.

-- Sales Order Bill Of Material Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORDERBOMHEADER (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    ENGINEERINGCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALVARIANTUSAGE,
    BOMALTERNATIVETEXT,
    BOMASSETNTWKHNDOVRISRELEVANT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERINTERNALCHANGECOUNT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISARCHIVEDFORDELETION,
    BOMISTOBEDELETED,
    BOMTECHNICALTYPE,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    CHGTOENGINEERINGCHGDOCUMENT,
    CREATEDBYUSER,
    DOCUMENTISCREATEDBYCAD,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    INDICATORISBOMCHANGEDWITHHIST,
    INDICATORISBOMWITHDATEHISTORY,
    ISALE,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMARKEDFORDELETION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIALTOLOTSIZEQUANTITY,
    MATFROMLOTSIZEQUANTITY,
    PURCHASEORDERBYCUSTOMER,
    RECORDCREATIONDATE,
    SALESORDER,
    SALESORDERITEM,
    SOLDTOPARTY,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, ENGINEERINGCHANGEDOCUMENT, MATERIAL, PLANT)
);

Learn More