P_CHANGERECORDBOMHEADERSEARCH

CDS View

Change Record BOM Header for search

P_CHANGERECORDBOMHEADERSEARCH is a CDS View in S/4HANA. Change Record BOM Header for search. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChangeRecordEngBOMHdrSearch view from BASIC Change Record Engineering BOM Header Search
I_ChangeRecordMfgBOMHdrSearch view from BASIC Change Record Manufacturing BOM Header Search

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 2
KEY BillOfMaterialCategory BillOfMaterialCategory 2
KEY BillOfMaterialVariant BillOfMaterialVariant 2
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
KEY BillOfMaterialVersion BillOfMaterialVersion 2
BillOfMaterialStatus BillOfMaterialStatus 2
BOMVersionStatus BOMVersionStatus 2

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.

-- Change Record BOM Header for search
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CHANGERECORDBOMHEADERSEARCH (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BILLOFMATERIALSTATUS,
    BOMVERSIONSTATUS,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION)
);