I_PURCHASEORDER

CDS View
61 Fields 105 CDS Views

Purchase Order

I_PURCHASEORDER is a CDS View in S/4HANA. Purchase Order. It contains 61 fields. 105 CDS views read from this table.

CDS Views using this table (105)

ViewTypeJoinVDMDescription
C_APProcessFlowPurchaseOrder view from CONSUMPTION AP Process Flow Purchase Order
C_APProcessFlowPurOrdItemVH view from CONSUMPTION AP Process Flow Purchase Order Item VH
C_ChgImpactPurOrdDets view from CONSUMPTION Purchase Order Details
C_POItemChangeCount view left_outer CONSUMPTION Purchase Order Item Changes
C_POItemCountForSuplrCube view inner CONSUMPTION PO and Item Count for Total Supplier - Cube
C_PurchaseOrderFeature view from CONSUMPTION Feature of Purchase Order
C_PurchaseOrderFeatureDetail view from CONSUMPTION Feature Detail of Purchase Order
C_PurchaseOrderMassUpdate view from CONSUMPTION Mass Changes to Purchase Orders
C_PurchaseOrderSolution view from CONSUMPTION Purchase Order Solution
C_PurchaseOrderValueHelp view from CONSUMPTION Purchase Order Value Help
C_PurchaserValueHelp view inner CONSUMPTION Purchaser Value Help
C_PurDocListInvoiceDetails view left_outer CONSUMPTION
C_PurDocListPOAll view left_outer CONSUMPTION Purchase Order : Header + Item
C_Purdoclistpoitemstatus view left_outer CONSUMPTION PO Item Status
C_PurgDataForTimeSheet view left_outer CONSUMPTION Purchasing Data for Time Sheet
C_PurOrdItmSts view left_outer CONSUMPTION Purchase Order Item Status
C_PurOrdRefDocPO view left_outer CONSUMPTION Reference Documents for PO Creation - Purchase Order Items
C_PurReturnDelItem view inner CONSUMPTION MM SSP Return Delivery Items
C_RFQProcessFlow view inner CONSUMPTION RFQ Process Flow
C_ServiceEntrySheetProcessFlow view inner CONSUMPTION Process Flow For Service Entry Sheet
C_SSPPurchaseOrderStsForBPF view from CONSUMPTION PO Status in SSP Requisition Application
I_APProcessFlowDocumentVH view from COMPOSITE Document Number
I_ChgRecdRefPurOrdTP view left_outer TRANSACTIONAL Change Record Reference Object Pur Ord
I_EDCPurchaseOrderRecords view_entity inner BASIC EDC Relevant Purchase Order Records
I_FldLogsRetServicePurOrdVH view inner COMPOSITE Service PO F4 Help for FL Returns
I_MMTimeRecording view inner BASIC Time Sheet (CATS): Transfer to MM
I_PPS_PurchaseOrderStatus view from COMPOSITE PPS Status of a purchase order
I_PurchaseOrderCalcFields view from COMPOSITE Collection of calculated fields on PO header level
I_PurchaseOrderEMailParameter view from COMPOSITE Parameters for Purchase Order Email Template
I_PurchaseOrderPartner view inner BASIC Purchase Order Partner
I_PurchaseOrderPricingElement view inner BASIC Purchase Order Pricing Element on Header
I_PurchaseOrderStatus view from COMPOSITE Status of a purchase order
I_PurchaseOrderStdVH view from COMPOSITE Purchase Order
I_PurchaseOrderSupplierAddress view from COMPOSITE Supplier Address in Purchase Order
I_PurOrdItemPricingElement view inner BASIC Purchase Order Pricing Element on Item
I_PurOrdPricingElement view inner COMPOSITE Purchase Order Pricing Element
I_PurOrdScheduleLineBasic view inner BASIC Purchasing Document Schedule Line Basic
I_RFM_MngPOHdr view from COMPOSITE Composite View for Hdr details Manage PO
I_StockTransportOrder view from BASIC Stock Transport Order
I_VMSVehicleStdPurchaseOrder view from BASIC Purchase Order details
M_V_Purchord_Output_Params view from Paramters for Purchase Order Output Determination
N_ChangeRecordObjPgPurOrd view left_outer Change Record Reference Object Page Pur Ord
P_DeliveryCostBasedOnPOItm view inner CONSUMPTION
P_InspLotPurgOrdDocs view inner CONSUMPTION Inspectionlot for purchase orders
P_InvoicesCreatedBeforePO view from CONSUMPTION
P_PDOCITEMWITHOUTACCTASSGMT view union_all CONSUMPTION
P_POCastedAmounts view from CONSUMPTION Casted Amounts for Purchase Order
P_PODOWNPAYTSTSCALCFINAL view from CONSUMPTION Private View for Status Calculation
P_PODwnPaytAmountCalc view from CONSUMPTION Down Payment Calc Fields for PO
P_PODwnPaytDuDteIntvlCalc1 view from CONSUMPTION Due Date Interval Calc1
P_PODwnPaytDueDateInterval view from CONSUMPTION Due Date Interval for PO Dwn Pymt
P_POHistInDateRange view inner CONSUMPTION PO History in date range
P_POHistoryForGR view inner CONSUMPTION
P_POHistoryForInvoice view inner CONSUMPTION
P_POIDeliveryCostGR view inner CONSUMPTION
P_POIDeliveryCostInvoice view inner CONSUMPTION
P_POItemChangeDocHeader view from CONSUMPTION POI Change Document Header
P_POItemInvoicePrice view from CONSUMPTION PO Item for Invoice Price
P_PRToFirstPurchasOrder view inner CONSUMPTION First Purchas Order created to a PR
P_PRToFirstPurchasOrder1 view inner CONSUMPTION First Purchase Order created to a PR
P_PurcContractLeakagePC1 view inner CONSUMPTION P_PurcContractLeakagePC1
P_PurchaseContractLeakage view inner CONSUMPTION
P_PurchaseContractleakage1 view inner CONSUMPTION Purchase Contract Leakage 1
P_Purchasecontractleakage3 view inner CONSUMPTION
P_PurchaseOrderCommitment view inner COMPOSITE
P_PurchaseOrderHistory_Basic view inner BASIC
P_PURCHASEORDERITEMCHANGEDOC view from CONSUMPTION
P_PurchaseOrderItemPAI view inner CONSUMPTION
P_PurchaseOrderItemPAI_04 view left_outer CONSUMPTION
P_PurchaseOrderMassUpdate view from CONSUMPTION Mass Update of Purchase Orders
P_PurchaseOrderMigration view inner CONSUMPTION Purchase Order for Migration Report
P_PurchaseOrderPriceVariance view inner CONSUMPTION
P_PurchaseOrderQuantity view from CONSUMPTION Purchase Order Quantity
P_PurchaseOrderQuantity view union_all CONSUMPTION Purchase Order Quantity
P_PURCHASEORDERSENDTOSUPPLR view from CONSUMPTION Purchase order send to supplier
P_PurchaseOrderSupplierAddress view from COMPOSITE
P_PurchasingGroupAnalysis2 view inner CONSUMPTION Purchasing Group Analysis 2
P_PurchasingSpndComparison3 view inner CONSUMPTION Purchasing Spend Comparison
P_PurchOrderFiltered view from CONSUMPTION Purchase Order filtered by date
P_PurDocStat view left_outer CONSUMPTION
P_PurFutureSpend view inner CONSUMPTION Purchasing Future Spend
P_PurOrdDownPaymentMntr view union CONSUMPTION Monitor Purchase Order Down Payments
P_PurOrdItemAcctAssgmt view inner CONSUMPTION Purchase Order Item Account Assignment
P_PurOrdItmAcctAssgmt1 view inner CONSUMPTION
P_PURORDITMACCTASSGMT2 view union_all CONSUMPTION
P_PurOrdItmServiceSpnd view inner CONSUMPTION Purchase Order Item - Service Spend
P_PurOrdMaintainHdrActCalFsHlp view from CONSUMPTION
P_PurOrdMaintainHeaderActAddr view from CONSUMPTION
P_PurOrdMaintainHeaderActive view from CONSUMPTION
P_PurOrdMaintainHeadersList view from CONSUMPTION
P_PurOrdMaintainHeaderStatus view from CONSUMPTION
P_PurOrdOutputAutomation1 view from CONSUMPTION PO Output Automation CreationDate
P_PurOrdSchedAcct1 view inner CONSUMPTION Scheduled Purchase Orders
P_PurOrdServiceInvoice1 view inner CONSUMPTION Purchase Order Service Invoice
P_PurOrdsForConfirmation view from COMPOSITE
P_QltyNotifPurgDocs1 view inner CONSUMPTION Supplier Eval by Quality Notification
P_ReqnToOrderCycleTime1 view inner CONSUMPTION
P_SlsOrdProcFlowM12 view inner CONSUMPTION Sales Order Process Flow: Level -1 IC Purchase Order
P_SuplrEvalByQltyNotif2 view inner CONSUMPTION PO
P_SupplierMaterialGroupSpend view inner CONSUMPTION Supplier Material Group Spend
P_UserContactCardPO view from CONSUMPTION Purchase Order User Contact Card
P_WrkflwPurchaseOrderItem view inner CONSUMPTION P View of Purchase Order item Workflow
R_POSubcontractingComponent view inner BASIC Internal Basic View for PO Subcontracting Components
R_PurOrdItemPricingElement view inner COMPOSITE Purchase Order Pricing Element
SHSM_SHP_VIEW_RFQ view from CDS-based Value Help Selection Method SHP_VIEW_RFQ

Fields (61)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser CreatedByUser 12
KEY PurchaseOrder LevelM1Document,PurchaseOrder,PurchasingDocument,SubsequentDocument 33
_CompanyCode _CompanyCode 2
_CreatedByUser _CreatedByUser 1
_DocumentCurrency _DocumentCurrency 2
_IncotermsClassification _IncotermsClassification 2
_IncotermsVersion _IncotermsVersion 1
_PaymentTerms _PaymentTerms 2
_PurchaseOrderType _PurchaseOrderType 1
_PurchasingGroup _PurchasingGroup 2
_PurchasingOrganization _PurchasingOrganization 2
_Supplier _Supplier 3
CashDiscount1Days CashDiscount1Days 3
CashDiscount1Percent CashDiscount1Percent 3
CashDiscount2Days CashDiscount2Days 3
CashDiscount2Percent CashDiscount2Percent 3
CompanyCode CompanyCode,PurgDocHdrCompanyCode 25
CreationDate CreationDate,LastChangeDate 3
Customer Customer 1
DocumentCurrency Currency,DocumentCurrency 17
DownPaymentDueDate DownPaymentDueDate 1
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt 1
DownPaymentType DownPaymentType 1
ExchangeRate ExchangeRate 1
IncotermsClassification IncotermsClassification 5
IncotermsLocation1 IncotermsLocation1 3
IncotermsLocation2 IncotermsLocation2 3
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 4
InvoicingParty InvoicingParty 3
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 5
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 1
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 1
Language Language 1
LastChangeDateTime LastChangeDateTime 1
ManualSupplierAddressID ManualSupplierAddressID 1
NetPaymentDays NetPaymentDays 3
PaymentTerms PaymentTerms 6
PricingProcedure PricingProcedure 3
PurchaseContract PurchaseContract 2
PurchaseOrderDate PurchaseOrderDate 25
PurchaseOrderSubtype PurchaseOrderSubtype,PurchasingDocumentSubtype 3
PurchaseOrderType PurchaseOrderType,PurchasingDocumentType 26
PurchasingCompletenessStatus IsHeld,PurchasingCompletenessStatus 4
PurchasingDocumentCondition PurchasingDocumentCondition 4
PurchasingDocumentDeletionCode IsDeletedHeader,PurchasingDocumentDeletionCode 4
PurchasingDocumentIsAged PurchasingDocumentIsAged 1
PurchasingDocumentOrigin PurchasingDocumentOrigin,PurchasingDocumentStatus 2
PurchasingGroup PurchasingGroup,PurOrdPurchasingGroup 37
PurchasingOrganization PurchasingOrganization,PurOrdPurchasingOrganization 37
PurchasingProcessingStatus PurchasingProcessingStatus 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 4
Supplier FixedSupplierName,Supplier 32
SupplierAddressID PurchaseOrderAddressNumber,SupplierAddressID 2
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotationExternalID SupplierQuotationExternalID 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingPlant name1_sp,SupplyingPlant 5
SupplyingSupplier SupplyingSupplier 1
ValidityEndDate PurchaseOrderValidityEndDate,ValidityEndDate 4
ValidityStartDate PurchaseOrderValidityStartDate,ValidityStartDate 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.

-- Purchase Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEORDER (
    CREATEDBYUSER,
    PURCHASEORDER,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _PAYMENTTERMS,
    _PURCHASEORDERTYPE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CREATIONDATE,
    CUSTOMER,
    DOCUMENTCURRENCY,
    DOWNPAYMENTDUEDATE,
    DOWNPAYMENTPERCENTAGEOFTOTAMT,
    DOWNPAYMENTTYPE,
    EXCHANGERATE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISENDOFPURPOSEBLOCKED,
    ISINTRASTATREPORTINGEXCLUDED,
    ISINTRASTATREPORTINGRELEVANT,
    LANGUAGE,
    LASTCHANGEDATETIME,
    MANUALSUPPLIERADDRESSID,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PRICINGPROCEDURE,
    PURCHASECONTRACT,
    PURCHASEORDERDATE,
    PURCHASEORDERSUBTYPE,
    PURCHASEORDERTYPE,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCUMENTCONDITION,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTISAGED,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    RELEASEISNOTCOMPLETED,
    SUPPLIER,
    SUPPLIERADDRESSID,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATIONEXTERNALID,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    SUPPLYINGSUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CREATEDBYUSER, PURCHASEORDER)
);

Learn More