I_MAINTORDCOMPRESVNPURGDOC

CDS View

Purchasing Document for Reservation

I_MAINTORDCOMPRESVNPURGDOC is a CDS View in S/4HANA. Purchasing Document for Reservation. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MaintOrdDirectProcmtViaPO view left_outer COMPOSITE
P_MaintOrdDirectProcmtViaPR view inner COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
KEY PurchaseRequisition PurchaseRequisition 1
KEY PurchaseRequisitionItem PurchaseRequisitionItem 1
RecordType ReservationType 1
Reservation Reservation 2
ReservationItem ReservationItem 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.

-- Purchasing Document for Reservation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTORDCOMPRESVNPURGDOC (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);