I_PRODNPRODUCTHIERASSGMT

CDS View
5 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 5 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 from COMPOSITE Production Hierarchy Node for Product
P_ProdnProductHierarcyNode view_entity from COMPOSITE
P_ProdnProductHierNode view from COMPOSITE

Fields (5)

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

-- 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,
    PRIMARY KEY (MRPPLANT, PRODNPRODUCTHIERARCHYPURPOSE, UNIVERSALHIERVERSVALIDFROM, UNIVERSALHIERVERSVALIDTO)
);

Learn More