I_PRODNPRODUCTHIERASSGMT

CDS View
8 Fields 4 CDS Views

Prod Hier Assgmt for Production

I_PRODNPRODUCTHIERASSGMT is a CDS View in S/4HANA. Prod Hier Assgmt for Production. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProdnProductHierAssgmtTP view_entity from TRANSACTIONAL Prod Hier For Production Assignment TP
P_CapPlngProductHierNode view_entity from COMPOSITE Production Hierarchy Node for Product
P_ProdnProductHierarcyNode view_entity from COMPOSITE Prod. Execution HierNode for Product
P_ProdnProductHierNode view_entity from COMPOSITE Product Hierarchy and Hierarchy Node for Production

Fields (8)

KeyField CDS FieldsUsed in Views
KEY MRPPlant MRPPlant,ProductionPlant 3
KEY ProdnProductHierarchyPurpose ProdnProductHierarchyPurpose 3
KEY UniversalHierVersValidFrom UniversalHierVersValidFrom 3
KEY UniversalHierVersValidTo UniversalHierVersValidTo 3
_MRPPlant _MRPPlant 3
_ProdnProductHierarchyPurpose _ProdnProductHierarchyPurpose 1
_ProductHierarchyVH _ProductHierarchyVH 1
ProductionProductHierarchy ProductionProductHierarchy 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.

-- Prod Hier Assgmt for Production
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODNPRODUCTHIERASSGMT (
    MRPPLANT,
    PRODNPRODUCTHIERARCHYPURPOSE,
    UNIVERSALHIERVERSVALIDFROM,
    UNIVERSALHIERVERSVALIDTO,
    _MRPPLANT,
    _PRODNPRODUCTHIERARCHYPURPOSE,
    _PRODUCTHIERARCHYVH,
    PRODUCTIONPRODUCTHIERARCHY,
    PRIMARY KEY (MRPPLANT, PRODNPRODUCTHIERARCHYPURPOSE, UNIVERSALHIERVERSVALIDFROM, UNIVERSALHIERVERSVALIDTO)
);

Learn More