P_MATLSTKREPSUBSLOGDATE

CDS View
13 Fields 2 CDS Views

P_MATLSTKREPSUBSLOGDATE is a CDS View in S/4HANA. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MatlStkLastRepSubsLog view_entity from COMPOSITE
P_MatlStkLastRepSubsLogActive view_entity from COMPOSITE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY MaterialStockSubscriptionItem MaterialStockSubscriptionItem 2
KEY MaterialStockSubscriptionUUID MaterialStockSubscriptionUUID 2
KEY MatlStkSubscrpnItemIteration MatlStkSubscrpnItemIteration 2
CreationDateTime CreationDateTime 2
FirstGoodsMovementPostingDate FirstGoodsMovementPostingDate 2
LastGoodsMovementPostingDate LastGoodsMovementPostingDate 2
MaterialStockReportRunUUID MaterialStockReportRunUUID 2
MaterialStockReportStep MaterialStockReportStep 2
MaterialStockReportStepStatus MaterialStockReportStepStatus 2
MaterialStockReportUUID MaterialStockReportUUID 2
MatlStkRptOffBoardingDate MatlStkRptOffBoardingDate 2
MatlStockReportStepMessageText MatlStockReportStepMessageText 2
UserID UserID 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MATLSTKREPSUBSLOGDATE (
    MATERIALSTOCKSUBSCRIPTIONITEM,
    MATERIALSTOCKSUBSCRIPTIONUUID,
    MATLSTKSUBSCRPNITEMITERATION,
    CREATIONDATETIME,
    FIRSTGOODSMOVEMENTPOSTINGDATE,
    LASTGOODSMOVEMENTPOSTINGDATE,
    MATERIALSTOCKREPORTRUNUUID,
    MATERIALSTOCKREPORTSTEP,
    MATERIALSTOCKREPORTSTEPSTATUS,
    MATERIALSTOCKREPORTUUID,
    MATLSTKRPTOFFBOARDINGDATE,
    MATLSTOCKREPORTSTEPMESSAGETEXT,
    USERID,
    PRIMARY KEY (MATERIALSTOCKSUBSCRIPTIONITEM, MATERIALSTOCKSUBSCRIPTIONUUID, MATLSTKSUBSCRPNITEMITERATION)
);

Learn More