I_CENTRALPURCHASEORDERTP

CDS View
53 Fields 2 CDS Views

Central Purchase Order

I_CENTRALPURCHASEORDERTP is a CDS View in S/4HANA. Central Purchase Order. It contains 53 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CentralPurchaseOrderTP view from CONSUMPTION Central Purchase Order
C_CntrlPurOrdFactSht view from CONSUMPTION Central Purchase Order Fact Sheet

Fields (53)

KeyField CDS FieldsUsed in Views
KEY ExtSourceSystem ExtSourceSystem 2
KEY PurchaseOrder ProcurementHubPO 2
ApproverName ApproverName 1
ApproverUser ApproverUser 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CompanyCode CompanyCode 2
CompanyCodeCountry CompanyCodeCountry 1
CreatedByUserFullName CreatedByUserFullName 2
CreationDate CreationDate 2
DeliveryDocumentCondition DeliveryDocumentCondition 1
DocumentCurrency DocumentCurrency 2
ExchangeRateForEdit ExchangeRateForEdit 1
ExchangeRateIsFixed ExchangeRateIsFixed 1
HasAttachment HasAttachment 1
HasNote HasNote 1
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
InvoicingParty InvoicingParty 1
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 1
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 1
Language Language 2
ManualSupplierAddressID ManualSupplierAddressID 1
NetPaymentDays NetPaymentDays 1
NumberOfOverduePurOrdItm NumberOfOverduePurOrdItm 1
PricingProcedure PricingProcedure 1
ProcmtHubLastExtractionTime ProcmtHubLastExtractionTime 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderNetAmount PurchaseOrderNetAmount,PurchaseOrderNetAmount_H 2
PurchaseOrderOutputDateTime PurchaseOrderOutputDateTime 1
PurchaseOrderOutputStatus PurchaseOrderOutputStatus 1
PurchaseOrderStatus PurchaseOrderStatus 1
PurchaseOrderType PurchaseOrderType 2
PurchasingCompletenessStatus PurchasingCompletenessStatus 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingGroup PurchasingGroup 2
PurchasingProcessingStatus PurchasingProcessingStatus 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 1
Supplier Supplier 2
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingPlant SupplyingPlant 1
SupplyingSupplier SupplyingSupplier 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1
WeightedRelevance WeightedRelevance 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.

-- Central Purchase Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CENTRALPURCHASEORDERTP (
    EXTSOURCESYSTEM,
    PURCHASEORDER,
    APPROVERNAME,
    APPROVERUSER,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    CREATEDBYUSERFULLNAME,
    CREATIONDATE,
    DELIVERYDOCUMENTCONDITION,
    DOCUMENTCURRENCY,
    EXCHANGERATEFOREDIT,
    EXCHANGERATEISFIXED,
    HASATTACHMENT,
    HASNOTE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISINTRASTATREPORTINGEXCLUDED,
    ISINTRASTATREPORTINGRELEVANT,
    LANGUAGE,
    MANUALSUPPLIERADDRESSID,
    NETPAYMENTDAYS,
    NUMBEROFOVERDUEPURORDITM,
    PRICINGPROCEDURE,
    PROCMTHUBLASTEXTRACTIONTIME,
    PURCHASEORDERDATE,
    PURCHASEORDERNETAMOUNT,
    PURCHASEORDEROUTPUTDATETIME,
    PURCHASEORDEROUTPUTSTATUS,
    PURCHASEORDERSTATUS,
    PURCHASEORDERTYPE,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGGROUP,
    PURCHASINGPROCESSINGSTATUS,
    RELEASEISNOTCOMPLETED,
    SCHEDULELINEDELIVERYDATE,
    SUPPLIER,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    SUPPLYINGSUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WEIGHTEDRELEVANCE,
    PRIMARY KEY (EXTSOURCESYSTEM, PURCHASEORDER)
);

Learn More