R_PPS_PURCHASEORDER

CDS View
92 Fields 5 CDS Views

PPS Purchase Order

R_PPS_PURCHASEORDER is a CDS View in S/4HANA. PPS Purchase Order. It contains 92 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_PPS_PurContrProcessFlow view_entity inner COMPOSITE PPS Process Flow for Purchase Contract
I_PPS_PurOrdForCloseout view_entity from COMPOSITE Purchase Order Closeout
R_PPS_PurchaseOrderPartner view_entity inner COMPOSITE Purchase Order Partners
R_PPS_PurchaseOrderTP view_entity from TRANSACTIONAL Purchase Order - TP
R_PPS_PurOrdVersionHistory view_entity inner COMPOSITE Purchase Order Version History

Fields (92)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 2
_CompanyCode _CompanyCode 2
_CreatedByUser _CreatedByUser 2
_DocumentCurrency _DocumentCurrency 1
_IncotermsClassification _IncotermsClassification 1
_IncotermsVersion _IncotermsVersion 1
_InvoicingParty _InvoicingParty 1
_Language _Language 2
_PaymentTerms _PaymentTerms 2
_PurchaseOrderCalcFields _PurchaseOrderCalcFields 1
_PurchaseOrderDeletionCode _PurchaseOrderDeletionCode 1
_PurchasingGroup _PurchasingGroup 2
_PurchasingOrganization _PurchasingOrganization 2
_Supplier _Supplier 2
_SupplierCurrency _SupplierCurrency 1
_SupplyingPlant _SupplyingPlant 1
_SupplyingSupplier _SupplyingSupplier 1
ActivePurchasingDocument ActivePurchasingDocument 3
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 3
DownPaymentAmount DownPaymentAmount 2
DownPaymentDueDate DownPaymentDueDate 2
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt 2
DownPaymentType DownPaymentType 2
ExchangeRateIsFixed ExchangeRateIsFixed 2
IncotermsClassification IncotermsClassification 3
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 2
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 2
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 2
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 2
InvoicingParty InvoicingParty 1
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 1
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 1
ItemNumberIntervalForSubItems ItemNumberIntervalForSubItems 2
Language Language 2
LastChangeDateTime LastChangeDateTime 2
ManualSupplierAddressID ManualSupplierAddressID 1
NetPaymentDays NetPaymentDays 2
PaymentTerms PaymentTerms 2
PricingDocument PricingDocument 2
PricingProcedure PricingProcedure 2
PurchaseContract PurchaseContract 2
PurchaseOrderDate PurchaseOrderDate 2
PurchaseOrderDeletionCode PurchaseOrderDeletionCode 2
PurchaseOrderSubtype PurchaseOrderSubtype 2
PurchaseOrderType PurchaseOrderType 4
PurchasingCompletenessStatus PurchasingCompletenessStatus 2
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentName PurchasingDocumentName 1
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentVersion PurchasingDocumentVersion 2
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
PurchasingProcessingStatus PurchasingProcessingStatus 3
PurchasingReleaseStrategy PurchasingReleaseStrategy 2
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts 2
PurgAggrgdProdMarketabilitySts PurgAggrgdProdMarketabilitySts 1
PurgAggrgdSftyDataSheetStatus PurgAggrgdSftyDataSheetStatus 1
PurgDocChangeRequestStatus PurgDocChangeRequestStatus 2
PurgDocHdrInvcRtntnPct PurgDocHdrInvcRtntnPct 1
PurgProdCmplncTotDngrsGoodsSts PurgProdCmplncTotDngrsGoodsSts 1
PurgReasonForDocCancellation PurgReasonForDocCancellation 2
PurgReleaseSequenceStatus PurgReleaseSequenceStatus 2
PurgReleaseTimeTotalAmount PurgReleaseTimeTotalAmount 2
QuotationSubmissionDate QuotationSubmissionDate 2
ReleaseCode ReleaseCode 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 2
RequestForQuotation RequestForQuotation 1
RetentionType RetentionType 1
Supplier Supplier 3
SupplierAddressID SupplierAddressID 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotationExternalID SupplierQuotationExternalID 2
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingPlant SupplyingPlant 1
SupplyingSupplier SupplyingSupplier 1
TaxReturnCountry TaxReturnCountry 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2
VATRegistrationCountry VATRegistrationCountry 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.

-- PPS Purchase Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PPS_PURCHASEORDER (
    PURCHASEORDER,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _INVOICINGPARTY,
    _LANGUAGE,
    _PAYMENTTERMS,
    _PURCHASEORDERCALCFIELDS,
    _PURCHASEORDERDELETIONCODE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    _SUPPLIERCURRENCY,
    _SUPPLYINGPLANT,
    _SUPPLYINGSUPPLIER,
    ACTIVEPURCHASINGDOCUMENT,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    DOCUMENTCURRENCY,
    DOWNPAYMENTAMOUNT,
    DOWNPAYMENTDUEDATE,
    DOWNPAYMENTPERCENTAGEOFTOTAMT,
    DOWNPAYMENTTYPE,
    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,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTNAME,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGDOCUMENTVERSION,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    PURCHASINGRELEASESTRATEGY,
    PURGAGGRGDPRODCMPLNCSUPLRSTS,
    PURGAGGRGDPRODMARKETABILITYSTS,
    PURGAGGRGDSFTYDATASHEETSTATUS,
    PURGDOCCHANGEREQUESTSTATUS,
    PURGDOCHDRINVCRTNTNPCT,
    PURGPRODCMPLNCTOTDNGRSGOODSSTS,
    PURGREASONFORDOCCANCELLATION,
    PURGRELEASESEQUENCESTATUS,
    PURGRELEASETIMETOTALAMOUNT,
    QUOTATIONSUBMISSIONDATE,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    REQUESTFORQUOTATION,
    RETENTIONTYPE,
    SUPPLIER,
    SUPPLIERADDRESSID,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATIONEXTERNALID,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    SUPPLYINGSUPPLIER,
    TAXRETURNCOUNTRY,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (PURCHASEORDER)
);

Learn More