I_PMRPSIMLNCAPACITYRQMTBASIC

CDS View
12 Fields 4 CDS Views

pMRP capacity requirement

I_PMRPSIMLNCAPACITYRQMTBASIC is a CDS View in S/4HANA. pMRP capacity requirement. It contains 12 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_PMRPReceiptIssue view inner COMPOSITE pMRP Issue Union
P_PMRPSimlnCapacityRqmt view_entity from COMPOSITE pMRP capacity requirement
P_PMRPSimlnReceiptCapBucket view_entity inner COMPOSITE pMRP Capacity Requirement for Receipt
P_pMRPSimlnResCapaBucketRqmt1 view inner COMPOSITE pMRP Resource capacity requirement

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CapacityRequirementInternalID CapacityRequirementInternalID 2
KEY PMRPSimulation PMRPSimulation 1
KEY ReceiptInternalID ReceiptInternalID 3
KEY TopLevelDemandInternalID TopLevelDemandInternalID 2
BucketInternalID BucketInternalID 2
CapacityBaseQtyUnit CapacityBaseQtyUnit 1
PMRPCapRqmtBcktTopLvlDmndFctr PMRPCapRqmtBcktTopLvlDmndFctr 2
PMRPDurationInBucket PMRPDurationInBucket 1
PMRPReceiptIsFromPullIn PMRPReceiptIsFromPullIn 2
PMRPResourceInternalID PMRPResourceInternalID 1
PMRPStandardFixWorkQty PMRPStandardFixWorkQty 1
PMRPTotalDuration PMRPTotalDuration 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.

-- pMRP capacity requirement
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PMRPSIMLNCAPACITYRQMTBASIC (
    CAPACITYREQUIREMENTINTERNALID,
    PMRPSIMULATION,
    RECEIPTINTERNALID,
    TOPLEVELDEMANDINTERNALID,
    BUCKETINTERNALID,
    CAPACITYBASEQTYUNIT,
    PMRPCAPRQMTBCKTTOPLVLDMNDFCTR,
    PMRPDURATIONINBUCKET,
    PMRPRECEIPTISFROMPULLIN,
    PMRPRESOURCEINTERNALID,
    PMRPSTANDARDFIXWORKQTY,
    PMRPTOTALDURATION,
    PRIMARY KEY (CAPACITYREQUIREMENTINTERNALID, PMRPSIMULATION, RECEIPTINTERNALID, TOPLEVELDEMANDINTERNALID)
);

Learn More