I_PURCHASEORDERENHANCED

CDS View
27 Fields 6 CDS Views

Purchase Order enhanced

I_PURCHASEORDERENHANCED is a CDS View in S/4HANA. Purchase Order enhanced. It contains 27 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_ArbErp_ConfIn_PurchaseOrder view from CONSUMPTION CDS View of purchase order for CONF IN
C_Arberp_Ordrout_Purchaseorder view from CONSUMPTION CDS View of purchase order for ORDR OUT
C_BSOrdProcFlwPurchaseOrder view from CONSUMPTION Purchase Order Attrib for BSOrd Prgrs
C_PurchaseOrderFs view from CONSUMPTION Purchase Order
C_PurchaseOrderGR view inner CONSUMPTION View for GR and Purchase Order
C_SupplierPurOrder view from CONSUMPTION Purchase Order

Fields (27)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder,UI5NetworkGraphAttributeValue 4
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
DocumentCurrency Currency,DocumentCurrency 4
IncotermsClassification IncotermsClassification 1
IncotermsTransferLocation IncotermsTransferLocation 1
Language Language 1
NetPaymentDays NetPaymentDays 1
PaymentTerms PaymentTerms 1
PurchaseOrderDate PurchaseOrderDate 3
PurchaseOrderNetAmount PurchaseOrderNetAmount 3
PurchaseOrderType PurchaseOrderType 3
PurchasingDocumentStatus PurchasingDocumentStatus 1
PurchasingGroup PurchasingGroup 3
PurchasingHasItemHierarchy PurchasingHasItemHierarchy 1
PurchasingOrganization PurchasingOrganization 3
Supplier Supplier 4
SupplierAddressID SupplierAddressID 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingPlant SupplyingPlant 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Purchase Order enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEORDERENHANCED (
    PURCHASEORDER,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    LANGUAGE,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASEORDERDATE,
    PURCHASEORDERNETAMOUNT,
    PURCHASEORDERTYPE,
    PURCHASINGDOCUMENTSTATUS,
    PURCHASINGGROUP,
    PURCHASINGHASITEMHIERARCHY,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    SUPPLIERADDRESSID,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (PURCHASEORDER)
);

Learn More