I_STOCKLEVELPROPOSALTP

CDS View
30 Fields 1 CDS Views

Transactional View for DD Proposed Stock Levels

I_STOCKLEVELPROPOSALTP is a CDS View in S/4HANA. Transactional View for DD Proposed Stock Levels. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_StockLevelMgmtTP view from CONSUMPTION Manage Buffer Levels

Fields (30)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MRPArea MRPArea 1
KEY Plant Plant 1
KEY ProposalStartDate ProposalStartDate 1
KEY ProposalVersion ProposalVersion 1
_BufMatPlant _BufMatPlant 1
BOMExplosionDate BOMExplosionDate 1
BOMUsageCode BOMUsageCode 1
ConsumptionCode ConsumptionCode 1
CurGreenZoneAdjustmentFctr CurGreenZoneAdjustmentFctr 1
CurRedZoneAdjustmentFctr CurRedZoneAdjustmentFctr 1
CurYellowZoneAdjustmentFctr CurYellowZoneAdjustmentFctr 1
MaterialBaseUnit BaseUnit 1
MRPController MRPController 1
MRPGroup MRPGroup 1
OriglProposedGreenZone OriglProposedGreenZone 1
OriglProposedRedZone OriglProposedRedZone 1
OriglProposedYellowZone OriglProposedYellowZone 1
PrevGreenZoneAdjustmentFctr PrevGreenZoneAdjustmentFctr 1
PrevRedZoneAdjustmentFctr PrevRedZoneAdjustmentFctr 1
PrevYellowZoneAdjustmentFctr PrevYellowZoneAdjustmentFctr 1
ProcurementType ProcurementType 1
ProposedGreenZone ProposedGreenZone 1
ProposedRedZone ProposedRedZone 1
ProposedYellowZone ProposedYellowZone 1
PurchasingGroup PurchasingGroup 1
ReplenishmentLeadTimeCode ProposedMatlLeadTimeCode,ReplenishmentLeadTimeCode 1
StockLevelProposalID StockLevelProposalID 1
StockLevelProposalStatus StockLevelProposalStatus 1
VariabilityCode ProposedMatlVariabilityCode,VariabilityCode 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.

-- Transactional View for DD Proposed Stock Levels
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STOCKLEVELPROPOSALTP (
    MATERIAL,
    MRPAREA,
    PLANT,
    PROPOSALSTARTDATE,
    PROPOSALVERSION,
    _BUFMATPLANT,
    BOMEXPLOSIONDATE,
    BOMUSAGECODE,
    CONSUMPTIONCODE,
    CURGREENZONEADJUSTMENTFCTR,
    CURREDZONEADJUSTMENTFCTR,
    CURYELLOWZONEADJUSTMENTFCTR,
    MATERIALBASEUNIT,
    MRPCONTROLLER,
    MRPGROUP,
    ORIGLPROPOSEDGREENZONE,
    ORIGLPROPOSEDREDZONE,
    ORIGLPROPOSEDYELLOWZONE,
    PREVGREENZONEADJUSTMENTFCTR,
    PREVREDZONEADJUSTMENTFCTR,
    PREVYELLOWZONEADJUSTMENTFCTR,
    PROCUREMENTTYPE,
    PROPOSEDGREENZONE,
    PROPOSEDREDZONE,
    PROPOSEDYELLOWZONE,
    PURCHASINGGROUP,
    REPLENISHMENTLEADTIMECODE,
    STOCKLEVELPROPOSALID,
    STOCKLEVELPROPOSALSTATUS,
    VARIABILITYCODE,
    PRIMARY KEY (MATERIAL, MRPAREA, PLANT, PROPOSALSTARTDATE, PROPOSALVERSION)
);

Learn More