I_MSTRPROJPURORDITEM

CDS View
29 Fields 4 CDS Views

View for Master Project Purchase Order Item

I_MSTRPROJPURORDITEM is a CDS View in S/4HANA. View for Master Project Purchase Order Item. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_MstrProjPurOrdItem view from CONSUMPTION Consumption View for Master Project Purchase Order Item
I_MstrProjPOOverdue view from COMPOSITE Master Project Purchase Order Overdue
P_MPProcurement view union COMPOSITE
P_MPPurReqPurOrd view from COMPOSITE

Fields (29)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 3
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
KEY PurchaseRequisition PurchaseRequisition 1
KEY PurchaseRequisitionItem PurchaseRequisitionItem 1
BaseUnit BaseUnit 2
ControllingObjectDescription ControllingObjectDescription 3
ControllingObjectExternalID ControllingObjectExternalID 2
DeliveryDate DeliveryDate 2
DocumentCurrency DocumentCurrency 2
DocumentDate DocumentDate 2
InvoicedAmount InvoicedAmount 1
InvoicedQuantity InvoicedQuantity 2
MasterProjectName MasterProjectName 2
Material Material 3
MaterialGroup MaterialGroup 2
NetAmount NetAmount 1
NetPriceAmount NetPriceAmount 2
NetPriceQuantity NetPriceQuantity 2
OrderPriceUnit OrderPriceUnit 2
Plant Plant 1
PurchaseOrderItemText PurchaseOrderItemText 1
PurchaseOrderStatus ProcessingStatus 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
ReleaseCode ReleaseCode 3
ServicePerformer ServicePerformer 1
Supplier Supplier 1
TotalQuantity TotalQuantity 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.

-- View for Master Project Purchase Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MSTRPROJPURORDITEM (
    MASTERPROJECT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    BASEUNIT,
    CONTROLLINGOBJECTDESCRIPTION,
    CONTROLLINGOBJECTEXTERNALID,
    DELIVERYDATE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    INVOICEDAMOUNT,
    INVOICEDQUANTITY,
    MASTERPROJECTNAME,
    MATERIAL,
    MATERIALGROUP,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    ORDERPRICEUNIT,
    PLANT,
    PURCHASEORDERITEMTEXT,
    PURCHASEORDERSTATUS,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RELEASECODE,
    SERVICEPERFORMER,
    SUPPLIER,
    TOTALQUANTITY,
    PRIMARY KEY (MASTERPROJECT, PURCHASEORDER, PURCHASEORDERITEM, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More