I_DEPDNTRESVNQUICKVIEW

CDS View
58 Fields 3 CDS Views

Dependent Requirement and Order Reservation Details

I_DEPDNTRESVNQUICKVIEW is a CDS View in S/4HANA. Dependent Requirement and Order Reservation Details. It contains 58 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_DepdntRqmtOrderResvnItem view_entity from CONSUMPTION MRP Depdnt Requirement and Order Resvn
C_MRPProdnPlngDepdntResvnCard view_entity from CONSUMPTION Reservation Order
C_ProdnPlngDepdntResvnQuickVw view from CONSUMPTION Dependent Requirement and Order Reservation Details

Fields (58)

KeyField CDS FieldsUsed in Views
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
_Order _Order 1
BaseUnit BaseUnit 1
BasicEndDate BasicEndDate 1
BasicStartDate BasicStartDate 1
CommittedQuantity CommittedQuantity 1
Customer Customer 1
CustomerName CustomerName 1
ExpectedDeviationQuantity ExpectedDeviationQuantity 1
GoodsReceiptQty GoodsReceiptQty 1
InHouseProductionTime InHouseProductionTime 1
InternalContactEmailAddress InternalContactEmailAddress 1
InternalContactPersonName InternalContactPersonName 1
LotSizeRoundingQuantity LotSizeRoundingQuantity 1
ManufacturingOrder MaintenanceOrder,ManufacturingOrder,ProcessOrder,ProductionOrder 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderImportance ManufacturingOrderImportance 1
Material Material 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MaterialProcurementType MaterialProcurementType 1
MaterialProcurementTypeName MaterialProcurementTypeName 1
MaterialRoundingProfileName MaterialRoundingProfileName 1
MaximumLotSizeQuantity MaximumLotSizeQuantity 1
MfgOrderReleasedCode MfgOrderReleasedCode 1
MfgOrderScheduledEndDate MfgOrderScheduledEndDate 1
MfgOrderScheduledReleaseDate MfgOrderScheduledReleaseDate 1
MfgOrderScheduledStartDate MfgOrderScheduledStartDate 1
MinimumLotSizeQuantity MinimumLotSizeQuantity 1
MRPController MRPController 1
MRPControllerName MRPControllerName 1
MRPElementOpenQuantity MRPElementOpenQuantity 1
MRPElementPlannedScrapQuantity MRPElementPlannedScrapQuantity 1
OrderedQuantity OrderedQuantity 1
OrderType OrderType 1
OrderTypeName OrderTypeName 1
ParentComponent ParentComponent 1
ParentPlant ParentPlant 1
PlannedOrder PlannedOrder 1
PlannedOrderOpeningDate PlannedOrderOpeningDate 1
Plant Plant 1
ProductionLine ProductionLine 1
ProductionLineText ProductionLineText 1
ProductionPlant ProductionPlant 1
ProductionPlantName ProductionPlantName 1
ProductionSupervisor ProductionSupervisor 1
ProductionSupervisorName ProductionSupervisorName 1
ProductionVersion ProductionVersion 1
ProductionVersionText ProductionVersionText 1
RequirementDate RequirementDate 1
RequirementType RequirementType 1
RoundingProfile RoundingProfile 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
TotalQuantity TotalQuantity 1
TotalReplenishmentLeadTime TotalReplenishmentLeadTime 1
WithdrawnQuantity WithdrawnQuantity 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.

-- Dependent Requirement and Order Reservation Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEPDNTRESVNQUICKVIEW (
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _ORDER,
    BASEUNIT,
    BASICENDDATE,
    BASICSTARTDATE,
    COMMITTEDQUANTITY,
    CUSTOMER,
    CUSTOMERNAME,
    EXPECTEDDEVIATIONQUANTITY,
    GOODSRECEIPTQTY,
    INHOUSEPRODUCTIONTIME,
    INTERNALCONTACTEMAILADDRESS,
    INTERNALCONTACTPERSONNAME,
    LOTSIZEROUNDINGQUANTITY,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERIMPORTANCE,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALPROCUREMENTTYPE,
    MATERIALPROCUREMENTTYPENAME,
    MATERIALROUNDINGPROFILENAME,
    MAXIMUMLOTSIZEQUANTITY,
    MFGORDERRELEASEDCODE,
    MFGORDERSCHEDULEDENDDATE,
    MFGORDERSCHEDULEDRELEASEDATE,
    MFGORDERSCHEDULEDSTARTDATE,
    MINIMUMLOTSIZEQUANTITY,
    MRPCONTROLLER,
    MRPCONTROLLERNAME,
    MRPELEMENTOPENQUANTITY,
    MRPELEMENTPLANNEDSCRAPQUANTITY,
    ORDEREDQUANTITY,
    ORDERTYPE,
    ORDERTYPENAME,
    PARENTCOMPONENT,
    PARENTPLANT,
    PLANNEDORDER,
    PLANNEDORDEROPENINGDATE,
    PLANT,
    PRODUCTIONLINE,
    PRODUCTIONLINETEXT,
    PRODUCTIONPLANT,
    PRODUCTIONPLANTNAME,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONSUPERVISORNAME,
    PRODUCTIONVERSION,
    PRODUCTIONVERSIONTEXT,
    REQUIREMENTDATE,
    REQUIREMENTTYPE,
    ROUNDINGPROFILE,
    SALESORDER,
    SALESORDERITEM,
    TOTALQUANTITY,
    TOTALREPLENISHMENTLEADTIME,
    WITHDRAWNQUANTITY,
    PRIMARY KEY (RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More