R_PURCHASEORDER

CDS View
87 Fields 18 CDS Views

Purchase Order Internal View

R_PURCHASEORDER is a CDS View in S/4HANA. Purchase Order Internal View. It contains 87 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
A_PurchaseOrder view from COMPOSITE Purchase Order
C_CntrlSuplrConfPurOrdVH view from CONSUMPTION Replicated Purchase Order
C_POProdComplianceCriticality view from CONSUMPTION Purchase Order Product Compliance Criticality Rating
C_SuplrConfPurchaseOrderVH view from CONSUMPTION Purchase Order Value Help
ESH_N_PURCHASE_ORDER view from
I_ARunSupSelRulePurOrdVH view from BASIC
I_POSupplierConfirmationAPI01 view inner BASIC Supplier Confirmation Data in PurOrd
I_PurchaseOrderAPI01 view from BASIC Purchase Order
I_PurchaseOrderChangeDocument view inner BASIC Purchase Order Change Document
I_PurchaseOrderEnhanced view from COMPOSITE Purchase Order enhanced
I_PurchaseOrderHistoryBasic view inner COMPOSITE Purchase Order History
I_PurchaseOrderTP view from TRANSACTIONAL Transactional View for Purchase Order
I_PurOrdChangeDocumentItem view inner BASIC Purchase Order Change Document Items
R_PurchaseOrderPartner view inner BASIC Purchase Order Partner
R_PurchaseOrderPlainLongText view from COMPOSITE Restricted view for Purchase Order Long text
R_PurchaseOrderTP view_entity from TRANSACTIONAL Purchase Order Transactional View
R_PurOrdExternalReference view_entity inner BASIC PO External References
R_PurOrdHistoryDeliveryCost view inner COMPOSITE Purchase Order History Delivery Cost

Fields (87)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder ARunSupplySelRuleAttribVal,PurchaseOrder 9
_CompanyCode _CompanyCode 2
_CreatedByUser _CreatedByUser 1
_DocumentCurrency _DocumentCurrency 2
_IncotermsClassification _IncotermsClassification 2
_IncotermsVersion _IncotermsVersion 2
_InvoicingParty _InvoicingParty 2
_Language _Language 2
_PaymentTerms _PaymentTerms 2
_PurchaseOrderCalcFields _PurchaseOrderCalcFields 1
_PurchaseOrderDeletionCode _PurchaseOrderDeletionCode 1
_PurchaseOrderType _PurchaseOrderType 1
_PurchasingGroup _PurchasingGroup 2
_PurchasingOrganization _PurchasingOrganization 2
_Supplier _Supplier 2
_SupplierAddress _SupplierAddress_2 1
_SupplyingPlant _SupplyingPlant 1
_SupplyingSupplier _SupplyingSupplier 1
CashDiscount1Days CashDiscount1Days 2
CashDiscount1Percent CashDiscount1Percent 2
CashDiscount2Days CashDiscount2Days 2
CashDiscount2Percent CashDiscount2Percent 2
CompanyCode CompanyCode 4
CorrespncExternalReference CorrespncExternalReference 2
CorrespncInternalReference CorrespncInternalReference 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
Customer Customer 1
DocumentCurrency DocumentCurrency 2
DownPaymentAmount DownPaymentAmount 1
DownPaymentDueDate DownPaymentDueDate 1
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt 1
DownPaymentType DownPaymentType 1
ExchangeRate ExchangeRate 1
ExchangeRateIsFixed ExchangeRateIsFixed 2
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 1
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 1
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 1
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 2
InvoicingParty InvoicingParty 2
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 2
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 2
ItemNumberIntervalForSubItems ItemNumberIntervalForSubItems 1
Language Language 2
LastChangeDateTime LastChangeDateTime 2
ManualSupplierAddressID ManualSupplierAddressID 2
NetPaymentDays NetPaymentDays 2
PaymentTerms PaymentTerms 2
PricingDocument PricingDocument,PurchasingDocumentCondition 2
PricingProcedure PricingProcedure 2
PurchaseContract PurchaseContract 2
PurchaseOrderDate PurchaseOrderDate 2
PurchaseOrderDeletionCode PurchaseOrderDeletionCode,PurchasingDocumentDeletionCode 2
PurchaseOrderSubtype PurchaseOrderSubtype 2
PurchaseOrderType PurchaseOrderType 7
PurchasingCompletenessStatus PurchasingCompletenessStatus 2
PurchasingDocumentOrigin PurchasingDocumentOrigin 2
PurchasingGroup PurchasingGroup 7
PurchasingOrganization PurchasingOrganization 7
PurchasingProcessingStatus PurchasingProcessingStatus 2
PurchasingReleaseStrategy PurchasingReleaseStrategy 2
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts 2
PurgAggrgdProdMarketabilitySts PurgAggrgdProdMarketabilitySts 2
PurgAggrgdSftyDataSheetStatus PurgAggrgdSftyDataSheetStatus 2
PurgProdCmplncTotDngrsGoodsSts PurgProdCmplncTotDngrsGoodsSts 2
PurgReasonForDocCancellation PurgReasonForDocCancellation 1
PurgReleaseSequenceStatus PurgReleaseSequenceStatus 1
PurgReleaseTimeTotalAmount PurgReleaseTimeTotalAmount 1
QuotationSubmissionDate QuotationSubmissionDate 1
ReleaseCode ReleaseCode 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 2
RequestForQuotation RequestForQuotation 1
Supplier Supplier 4
SupplierAddressID SupplierAddressID 1
SupplierPhoneNumber SupplierPhoneNumber 2
SupplierQuotationExternalID SupplierQuotationExternalID 2
SupplierRespSalesPersonName SupplierRespSalesPersonName 2
SupplyingPlant SupplyingPlant 2
SupplyingSupplier SupplyingSupplier 2
TaxReturnCountry TaxReturnCountry 1
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2
VATRegistrationCountry VATRegistrationCountry 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 Internal View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURCHASEORDER (
    PURCHASEORDER,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _INVOICINGPARTY,
    _LANGUAGE,
    _PAYMENTTERMS,
    _PURCHASEORDERCALCFIELDS,
    _PURCHASEORDERDELETIONCODE,
    _PURCHASEORDERTYPE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    _SUPPLIERADDRESS,
    _SUPPLYINGPLANT,
    _SUPPLYINGSUPPLIER,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    DOCUMENTCURRENCY,
    DOWNPAYMENTAMOUNT,
    DOWNPAYMENTDUEDATE,
    DOWNPAYMENTPERCENTAGEOFTOTAMT,
    DOWNPAYMENTTYPE,
    EXCHANGERATE,
    EXCHANGERATEISFIXED,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSSUPCHNDVTGLOCADDLUUID,
    INCOTERMSSUPCHNLOC1ADDLUUID,
    INCOTERMSSUPCHNLOC2ADDLUUID,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISINTRASTATREPORTINGEXCLUDED,
    ISINTRASTATREPORTINGRELEVANT,
    ITEMNUMBERINTERVALFORSUBITEMS,
    LANGUAGE,
    LASTCHANGEDATETIME,
    MANUALSUPPLIERADDRESSID,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PRICINGDOCUMENT,
    PRICINGPROCEDURE,
    PURCHASECONTRACT,
    PURCHASEORDERDATE,
    PURCHASEORDERDELETIONCODE,
    PURCHASEORDERSUBTYPE,
    PURCHASEORDERTYPE,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    PURCHASINGRELEASESTRATEGY,
    PURGAGGRGDPRODCMPLNCSUPLRSTS,
    PURGAGGRGDPRODMARKETABILITYSTS,
    PURGAGGRGDSFTYDATASHEETSTATUS,
    PURGPRODCMPLNCTOTDNGRSGOODSSTS,
    PURGREASONFORDOCCANCELLATION,
    PURGRELEASESEQUENCESTATUS,
    PURGRELEASETIMETOTALAMOUNT,
    QUOTATIONSUBMISSIONDATE,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    REQUESTFORQUOTATION,
    SUPPLIER,
    SUPPLIERADDRESSID,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATIONEXTERNALID,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    SUPPLYINGSUPPLIER,
    TAXRETURNCOUNTRY,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (PURCHASEORDER)
);

Learn More