MFGBOM

26 Fields

MFGBOM is an SAP database table in S/4HANA. It contains 26 fields.

Fields (26)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 1
KEY BillOfMaterialCategory BillOfMaterialCategory 1
KEY BillOfMaterialVariant BillOfMaterialVariant 1
KEY BillOfMaterialVersion BillOfMaterialVersion 1
KEY Material Material 1
KEY Plant Plant 1
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 1
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 1
BillOfMaterialStatus BillOfMaterialStatus 1
BillOfMaterialUUID BillOfMaterialUUID 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BOMAlternativeText BOMAlternativeText 1
BOMExplosionApplication BOMExplosionApplication 1
BOMGroup BOMGroup 1
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 1
BOMHeaderText BOMHeaderText 1
BOMPrioritizedVersion BOMPrioritizedVersion 1
BOMTechnicalType BOMTechnicalType 1
BOMUsagePriority BOMUsagePriority 1
BOMVersionStatus BOMVersionStatus 1
HeaderValidityEndDate HeaderValidityEndDate 1
HeaderValidityStartDate HeaderValidityStartDate 1
IsConfiguredMaterial IsConfiguredMaterial 1
IsLatestBOMVersion IsLatestBOMVersion 1
IsMultipleBOMAlt IsMultipleBOMAlt 1
IsVersionBillOfMaterial IsVersionBillOfMaterial 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 MFGBOM (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    MATERIAL,
    PLANT,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALUUID,
    BILLOFMATERIALVARIANTUSAGE,
    BOMALTERNATIVETEXT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERINTERNALCHANGECOUNT,
    BOMHEADERTEXT,
    BOMPRIORITIZEDVERSION,
    BOMTECHNICALTYPE,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, MATERIAL, PLANT)
);

Learn More