I_CENTRALPURCHASEORDER

CDS View
74 Fields 15 CDS Views

Central Purchase Order Header

I_CENTRALPURCHASEORDER is a CDS View in S/4HANA. Central Purchase Order Header. It contains 74 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_PrmtHbRpldPurchaseOrderVH view from CONSUMPTION Replicated Purchase Orders in Procmt Hub
I_CentralPurchaseOrderTP view from TRANSACTIONAL Central Purchase Order
I_CntrlPurOrderSuplrAddr view from COMPOSITE Central Purchase Order Supplier Address
I_PrmtHbRpldPOWrkflwCard view from BASIC ToDo Workflow Card info of MPOC
I_PrmtHbRpldPurOrderEnhcd view from COMPOSITE Replicated PO enhanced
I_ProcmtHubPurOrdHdrAPI01 view from BASIC Centrally Managed Purchase Order Header
I_ProcmtHubRpldPOEmailParam view from COMPOSITE Params for Replicated PO Email Template
I_ProcmtHubRpldPurchaseOrder view_entity from COMPOSITE Extensibility of Purchase Order in Procurement Hub
P_AnaHubPurOrdSchdlnMigrData view from CONSUMPTION Migration data for Hub po Schedule line
P_CntralPurOrderItm view inner CONSUMPTION Central Purchase Order item Monitor
P_CntrlProcmtMtrgPurchaseOrder view_entity from COMPOSITE CP: Private View for Central Purchase Order
P_CntrlProcmtMtrgPurchaseOrder view_entity union COMPOSITE CP: Private View for Central Purchase Order
P_CntrlPurOrderItemPrcgKey view from BASIC Pricing for Central Purchase Order
P_PrmtHbRpldPOOutputStatusInd view from COMPOSITE Status of a purchase order
R_PrmtHbRpldPurOrdSrch view from BASIC Central Purchase Order

Fields (74)

KeyField CDS FieldsUsed in Views
KEY ExtSourceSystem BE_SOURCE_SYS,ExtSourceSystem 8
KEY PurchaseOrder ProcurementHubPO,PurchaseOrder 7
AbsoluteExchangeRate AbsoluteExchangeRate 2
ApproverName ApproverName 3
ApproverUser ApproverUser 3
CashDiscount1Days CashDiscount1Days 3
CashDiscount1Percent CashDiscount1Percent 3
CashDiscount2Days CashDiscount2Days 3
CashDiscount2Percent CashDiscount2Percent 3
CompanyCode CompanyCode 4
CompanyCodeCountry CompanyCodeCountry 3
CorrespncExternalReference CorrespncExternalReference 2
CorrespncInternalReference CorrespncInternalReference 2
CreatedByUser CreatedByUser,ernam 6
CreatedByUserName CreatedByUserFullName 3
CreationDate aedat,CreationDate 7
DeliveryDocumentCondition DeliveryDocumentCondition 4
DocumentCurrency DocumentCurrency,waers,WAERS_BASE 6
EffectiveExchangeRate EffectiveExchangeRate 2
ExchangeRate ExchangeRate 2
ExchangeRateIsFixed ExchangeRateIsFixed 3
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation 2
HasAttachment HasAttachment 3
HasNote HasNote 3
IncotermsClassification IncotermsClassification 4
IncotermsLocation1 IncotermsLocation1 3
IncotermsLocation2 IncotermsLocation2 3
IncotermsTransferLocation IncotermsTransferLocation 3
IncotermsVersion IncotermsVersion 3
InvoicingParty InvoicingParty 3
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 3
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 3
Language Language 3
LastChangeDateTime LastChangeDateTime 6
ManualSupplierAddressID ManualSupplierAddressID 3
NetPaymentDays NetPaymentDays 3
NumberOfOverduePurOrders NumberOfOverduePurOrders 3
NumberOfOverduePurOrdItm NumberOfOverduePurOrdItm 3
PaymentTerms PaymentTerms 4
PricingProcedure PricingProcedure 3
ProcmtHubLastExtractionTime ProcmtHubLastExtractionTime 1
PurchaseOrderDate PurchaseOrderDate 5
PurchaseOrderNetAmount PurchaseOrderNetAmount 1
PurchaseOrderOutputDateTime PurchaseOrderOutputDateTime 3
PurchaseOrderOutputIndCode PurchaseOrderOutputIndCode 2
PurchaseOrderOutputIndDesc PurchaseOrderOutputIndDesc 2
PurchaseOrderOutputStatus PurchaseOrderOutputStatus 4
PurchaseOrderOutputStatusName PurchaseOrderOutputStatusName 3
PurchaseOrderStatus PurchaseOrderStatus 4
PurchaseOrderStatusName PurchaseOrderStatusName 3
PurchaseOrderSubtype PurchaseOrderSubtype 3
PurchaseOrderType bsart,PurchaseOrderType 6
PurchasingCompletenessStatus memory,PurchasingCompletenessStatus 4
PurchasingDocCompletionStatus PurchasingDocCompletionStatus 1
PurchasingDocumentCategory bstyp 1
PurchasingDocumentDeletionCode LOEKZ_POHDR,PurchasingDocumentDeletionCode 4
PurchasingDocumentIsAged isaged 1
PurchasingDocumentOrderDate BEDAT_POHDR,PurchaseOrderDate 2
PurchasingDocumentOrigin PurchasingDocumentOrigin,STATU 4
PurchasingGroup ekgrp,PurchasingGroup 6
PurchasingOrganization ekorg,PurchasingOrganization 4
PurchasingProcessingStatus procstat,PurchasingProcessingStatus 5
PurOrdOutputCtrlType PurOrdOutputCtrlType 3
ReleaseIsNotCompleted frgrl,ReleaseIsNotCompleted 4
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 3
Supplier lifnr,Supplier 6
SupplierPhoneNumber SupplierPhoneNumber 3
SupplierRespSalesPersonName SupplierRespSalesPersonName 3
SupplyingPlant reswk,SupplyingPlant 5
SupplyingSupplier SupplyingSupplier 3
ValidityEndDate ValidityEndDate 3
ValidityStartDate ValidityStartDate 3
VATRegistrationCountry VATRegistrationCountry 1
WeightedRelevance WeightedRelevance 3

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.

-- Central Purchase Order Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CENTRALPURCHASEORDER (
    EXTSOURCESYSTEM,
    PURCHASEORDER,
    ABSOLUTEEXCHANGERATE,
    APPROVERNAME,
    APPROVERUSER,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATEDBYUSERNAME,
    CREATIONDATE,
    DELIVERYDOCUMENTCONDITION,
    DOCUMENTCURRENCY,
    EFFECTIVEEXCHANGERATE,
    EXCHANGERATE,
    EXCHANGERATEISFIXED,
    EXCHRATEISINDIRECTQUOTATION,
    HASATTACHMENT,
    HASNOTE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISINTRASTATREPORTINGEXCLUDED,
    ISINTRASTATREPORTINGRELEVANT,
    LANGUAGE,
    LASTCHANGEDATETIME,
    MANUALSUPPLIERADDRESSID,
    NETPAYMENTDAYS,
    NUMBEROFOVERDUEPURORDERS,
    NUMBEROFOVERDUEPURORDITM,
    PAYMENTTERMS,
    PRICINGPROCEDURE,
    PROCMTHUBLASTEXTRACTIONTIME,
    PURCHASEORDERDATE,
    PURCHASEORDERNETAMOUNT,
    PURCHASEORDEROUTPUTDATETIME,
    PURCHASEORDEROUTPUTINDCODE,
    PURCHASEORDEROUTPUTINDDESC,
    PURCHASEORDEROUTPUTSTATUS,
    PURCHASEORDEROUTPUTSTATUSNAME,
    PURCHASEORDERSTATUS,
    PURCHASEORDERSTATUSNAME,
    PURCHASEORDERSUBTYPE,
    PURCHASEORDERTYPE,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCCOMPLETIONSTATUS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTISAGED,
    PURCHASINGDOCUMENTORDERDATE,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    PURORDOUTPUTCTRLTYPE,
    RELEASEISNOTCOMPLETED,
    SCHEDULELINEDELIVERYDATE,
    SUPPLIER,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    SUPPLYINGSUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VATREGISTRATIONCOUNTRY,
    WEIGHTEDRELEVANCE,
    PRIMARY KEY (EXTSOURCESYSTEM, PURCHASEORDER)
);

Learn More