R_PURCHASINGDOCUMENT

CDS View
122 Fields 14 CDS Views

Purchasing Document

R_PURCHASINGDOCUMENT is a CDS View in S/4HANA. Purchasing Document. It contains 122 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_MaintOrdOpOutlineAgreementVH view_entity from CONSUMPTION Outline Agreement
I_ACMPurchaseOrder view from COMPOSITE Purchase Order
I_PPS_PurchasingDocument view_entity from BASIC Purchasing Document
I_PPS_PurContrForCloseout view_entity from COMPOSITE Process Purchase Contract CloseOut
I_PurchaseOrder view from BASIC Purchase Order
I_Schedgagrmthdr view from BASIC Scheduling Agreement Header
P_PurContrMassUpdt view from CONSUMPTION Purchase Contract Hdr
P_PurContrValdtySts view from CONSUMPTION Contract Validity Status Calculation
R_CentralPurchaseContract view from BASIC Central Purchase Contract Base View
R_CentralRequestForQuotation view from BASIC Restricted View for Central Request For Quotation Header
R_CentralSupplierQuotation view from BASIC Restricted View for Central Supplier Quotation Header
R_PPS_PurchaseContractTP view_entity from TRANSACTIONAL Purchase Contract Header - TP
R_PurchaseContract view from BASIC Purchase Contract Base View
R_PurchaseOrder view from BASIC Purchase Order Internal View

Fields (122)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument PurchaseContract,PurchasingDocument,SchedulingAgreement 3
_CompanyCode _CompanyCode 2
_CreatedByUser _CreatedByUser 2
_DocumentCurrency _DocumentCurrency 3
_IncotermsClassification _IncotermsClassification 2
_IncotermsVersion _IncotermsVersion 1
_InvoicingParty _InvoicingParty 2
_Language _Language 2
_PaymentTerms _PaymentTerms 2
_PricingProcedure _PricingProcedure 1
_PurchaseContract _PurchaseContract 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 2
_PurchasingDocumentItem _PurchasingDocumentItem 1
_PurchasingDocumentOrigin _PurchasingDocumentOrigin 1
_PurchasingDocumentPartner _PurchasingDocumentPartner 1
_PurchasingDocumentType _PurchasingDocumentType 2
_PurchasingGroup _PurchasingGroup 2
_PurchasingOrganization _PurchasingOrganization 2
_PurchasingProcessingStatus _PurchasingProcessingStatus 1
_ReleaseCode _ReleaseCode 1
_Supplier _Supplier 2
_SupplierAddress_2 _SupplierAddress_2 1
_SupplyingPlant _SupplyingPlant 1
_SupplyingSupplier _SupplyingSupplier 2
ActivePurchasingDocument ActivePurchasingDocument 2
BindingPeriodValidityEndDate BindingPeriodValidityEndDate 3
CashDiscount1Days CashDiscount1Days 4
CashDiscount1Percent CashDiscount1Percent 4
CashDiscount2Days CashDiscount2Days 4
CashDiscount2Percent CashDiscount2Percent 4
CompanyCode CompanyCode 5
CorrespncExternalReference CorrespncExternalReference 2
CorrespncInternalReference CorrespncInternalReference 3
CreatedByUser CreatedByUser 5
CreationDate CreationDate 5
Customer Customer 1
DocumentCurrency DocumentCurrency 5
DownPaymentAmount DownPaymentAmount 1
DownPaymentDueDate DownPaymentDueDate 1
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt 1
DownPaymentType DownPaymentType 1
ExchangeRate ExchangeRate 2
ExchangeRateIsFixed ExchangeRateIsFixed 2
FollowOnDocumentCategory FollowOnDocumentCategory 2
FollowOnDocumentType FollowOnDocumentType,PurgDocFollowOnDocumentType 2
IncotermsClassification IncotermsClassification 5
IncotermsLocation1 IncotermsLocation1 4
IncotermsLocation2 IncotermsLocation2 4
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 2
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 2
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 2
IncotermsTransferLocation IncotermsTransferLocation 4
IncotermsVersion IncotermsVersion 4
InvoicingParty InvoicingParty 2
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 4
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 1
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 1
ItemNumberInterval ItemNumberInterval 1
ItemNumberIntervalForSubItems ItemNumberIntervalForSubItems 1
Language Language 4
LastChangeDateTime LastChangeDateTime 4
LatestRegistrationDate LatestRegistrationDate 1
ManualSupplierAddressID ManualSupplierAddressID 1
NetPaymentDays NetPaymentDays 4
PaymentTerms PaymentTerms 4
PricingDocument CentralSuplrQuotationCondition,PricingDocument 2
PricingProcedure PricingProcedure 2
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID 1
PurchaseContract PurchaseContract 1
PurchasingCollectiveNumber PurchasingCollectiveNumber 1
PurchasingCompletenessStatus PurchasingCompletenessStatus 1
PurchasingDocumentCategory PurchasingDocumentCategory 5
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 3
PurchasingDocumentIsAged PurchasingDocumentIsAged 1
PurchasingDocumentName PurchasingDocumentName 2
PurchasingDocumentOrderDate PurchasingDocumentOrderDate 3
PurchasingDocumentOrigin PurchasingDocumentOrigin 2
PurchasingDocumentProcessCode PurchasingDocumentProcessCode 1
PurchasingDocumentSubtype PurchasingDocumentSubtype 2
PurchasingDocumentType PurchaseContractType,PurchasingDocumentType 3
PurchasingDocumentVersion PurchasingDocumentVersion 1
PurchasingGroup PurchasingGroup 5
PurchasingOrganization PurchasingOrganization 3
PurchasingParentDocument PurchasingParentDocument 1
PurchasingProcessingStatus PurchasingProcessingStatus 2
PurchasingReleaseStrategy PurchasingReleaseStrategy 1
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts 2
PurgAggrgdProdMarketabilitySts PurgAggrgdProdMarketabilitySts 1
PurgAggrgdSftyDataSheetStatus PurgAggrgdSftyDataSheetStatus 1
PurgDocChangeRequestStatus PurgDocChangeRequestStatus 1
PurgDocDefaultShippingType PurgDocDefaultShippingType 1
PurgDocExternalReference PurgDocExternalReference 1
PurgDocFollowOnDocumentType PurgDocFollowOnDocumentType 1
PurgDocHdrInvcRtntnPct PurgDocHdrInvcRtntnPct 1
PurgDocumentDistributionType PurgDocumentDistributionType 1
PurgHasCatalogRelevantItems PurgHasCatalogRelevantItems 1
PurgProdCmplncTotDngrsGoodsSts PurgProdCmplncTotDngrsGoodsSts 1
PurgReasonForDocCancellation PurgReasonForDocCancellation 1
PurgReleaseSequenceStatus PurgReleaseSequenceStatus 1
PurgReleaseTimeTotalAmount PurgReleaseTimeTotalAmount 1
QuotationEarliestSubmsnDate QuotationEarliestSubmsnDate 2
QuotationLatestSubmissionDate QuotationLatestSubmissionDate 3
QuotationSubmissionDate QuotationSubmissionDate 3
ReleaseCode ReleaseCode 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
RequestForQuotation RequestForQuotation 1
RetentionType RetentionType 1
RetsMgmtProcess RetsMgmtProcess 1
ScheduleAgreementHasReleaseDoc ScheduleAgreementHasReleaseDoc 2
Supplier Supplier 4
SupplierAddressID SupplierAddressID 1
SupplierPhoneNumber SupplierPhoneNumber 2
SupplierQuotationExternalID SupplierQuotationExternalID 3
SupplierRespSalesPersonName SupplierRespSalesPersonName 2
SupplyingPlant SupplyingPlant 1
SupplyingSupplier SupplyingSupplier 2
TargetAmount PurchaseContractTargetAmount,TargetAmount 5
TaxReturnCountry TaxReturnCountry 1
ValidityEndDate PurContrValidityEndDate,ValidityEndDate 4
ValidityStartDate PurContrValidityStartDate,ValidityStartDate 3
VATRegistration CompanyVATRegistration,VATRegistration 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.

-- Purchasing Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURCHASINGDOCUMENT (
    PURCHASINGDOCUMENT,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _INVOICINGPARTY,
    _LANGUAGE,
    _PAYMENTTERMS,
    _PRICINGPROCEDURE,
    _PURCHASECONTRACT,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURCHASINGDOCUMENTITEM,
    _PURCHASINGDOCUMENTORIGIN,
    _PURCHASINGDOCUMENTPARTNER,
    _PURCHASINGDOCUMENTTYPE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _PURCHASINGPROCESSINGSTATUS,
    _RELEASECODE,
    _SUPPLIER,
    _SUPPLIERADDRESS_2,
    _SUPPLYINGPLANT,
    _SUPPLYINGSUPPLIER,
    ACTIVEPURCHASINGDOCUMENT,
    BINDINGPERIODVALIDITYENDDATE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    DOCUMENTCURRENCY,
    DOWNPAYMENTAMOUNT,
    DOWNPAYMENTDUEDATE,
    DOWNPAYMENTPERCENTAGEOFTOTAMT,
    DOWNPAYMENTTYPE,
    EXCHANGERATE,
    EXCHANGERATEISFIXED,
    FOLLOWONDOCUMENTCATEGORY,
    FOLLOWONDOCUMENTTYPE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSSUPCHNDVTGLOCADDLUUID,
    INCOTERMSSUPCHNLOC1ADDLUUID,
    INCOTERMSSUPCHNLOC2ADDLUUID,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISENDOFPURPOSEBLOCKED,
    ISINTRASTATREPORTINGEXCLUDED,
    ISINTRASTATREPORTINGRELEVANT,
    ITEMNUMBERINTERVAL,
    ITEMNUMBERINTERVALFORSUBITEMS,
    LANGUAGE,
    LASTCHANGEDATETIME,
    LATESTREGISTRATIONDATE,
    MANUALSUPPLIERADDRESSID,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PRICINGDOCUMENT,
    PRICINGPROCEDURE,
    PROCMTHUBCOMPANYCODEGROUPINGID,
    PURCHASECONTRACT,
    PURCHASINGCOLLECTIVENUMBER,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTISAGED,
    PURCHASINGDOCUMENTNAME,
    PURCHASINGDOCUMENTORDERDATE,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGDOCUMENTPROCESSCODE,
    PURCHASINGDOCUMENTSUBTYPE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGDOCUMENTVERSION,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPARENTDOCUMENT,
    PURCHASINGPROCESSINGSTATUS,
    PURCHASINGRELEASESTRATEGY,
    PURGAGGRGDPRODCMPLNCSUPLRSTS,
    PURGAGGRGDPRODMARKETABILITYSTS,
    PURGAGGRGDSFTYDATASHEETSTATUS,
    PURGDOCCHANGEREQUESTSTATUS,
    PURGDOCDEFAULTSHIPPINGTYPE,
    PURGDOCEXTERNALREFERENCE,
    PURGDOCFOLLOWONDOCUMENTTYPE,
    PURGDOCHDRINVCRTNTNPCT,
    PURGDOCUMENTDISTRIBUTIONTYPE,
    PURGHASCATALOGRELEVANTITEMS,
    PURGPRODCMPLNCTOTDNGRSGOODSSTS,
    PURGREASONFORDOCCANCELLATION,
    PURGRELEASESEQUENCESTATUS,
    PURGRELEASETIMETOTALAMOUNT,
    QUOTATIONEARLIESTSUBMSNDATE,
    QUOTATIONLATESTSUBMISSIONDATE,
    QUOTATIONSUBMISSIONDATE,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    REQUESTFORQUOTATION,
    RETENTIONTYPE,
    RETSMGMTPROCESS,
    SCHEDULEAGREEMENTHASRELEASEDOC,
    SUPPLIER,
    SUPPLIERADDRESSID,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATIONEXTERNALID,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    SUPPLYINGSUPPLIER,
    TARGETAMOUNT,
    TAXRETURNCOUNTRY,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (PURCHASINGDOCUMENT)
);

Learn More