R_PurchaseContract

DDL: R_PURCHASECONTRACT SQL: RPURCHASECTR Type: view BASIC
69 Fields 1 Data Sources 1 Associations

Purchase Contract Base View

R_PurchaseContract is a Basic CDS View that provides data about "Purchase Contract Base View" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocument) and exposes 69 fields with key field PurchaseContract. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PurchasingDocument R_PurchasingDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_PurchaseContractItem _PurchaseContractItem $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RPURCHASECTR view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Contract Base View view
ObjectModel.representativeKey PurchaseContract view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract Purchasing Document
PurchaseContractType PurchasingDocumentType RFQ Type
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
LastChangeDateTime LastChangeDateTime Timestamp
CreationDate CreationDate Time Stamp
Supplier Supplier Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
DocumentCurrency DocumentCurrency Document Currency
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PurchaseContractTargetAmount TargetAmount Target Value
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ReleaseCode ReleaseCode Release ind.
CreatedByUser CreatedByUser User Name
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
SupplyingSupplier SupplyingSupplier Goods Supplier
InvoicingParty InvoicingParty Supplier
ExchangeRate ExchangeRate Exchange rate
ExchangeRateIsFixed ExchangeRateIsFixed Fixed Exch.Rate
QuotationSubmissionDate QuotationSubmissionDate Quotation Date
SupplierQuotation SupplierQuotationExternalID Quotation
CorrespncExternalReference CorrespncExternalReference Your Reference
CorrespncInternalReference CorrespncInternalReference Our Reference
SupplierRespSalesPersonName SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber SupplierPhoneNumber Telephone
IncotermsVersion IncotermsVersion Inco. Version
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID Location UUID
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID Location UUID
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID Location UUID
PurchasingDocumentName PurchasingDocumentName Purch. Doc. Name
PurchasingDocumentOrigin PurchasingDocumentOrigin Status
ReleaseIsNotCompleted ReleaseIsNotCompleted Subj.to Release
PurchasingProcessingStatus PurchasingProcessingStatus Proc. State
ManualSupplierAddressID ManualSupplierAddressID Address Number
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PurgDocExternalReference PurgDocExternalReference Ext. Reference ID
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts Supplier Check Sts
PurgAggrgdProdMarketabilitySts PurgAggrgdProdMarketabilitySts Prod. Marktablty Sts
PurgAggrgdSftyDataSheetStatus PurgAggrgdSftyDataSheetStatus Sfty Data Sheet Sts
PurgProdCmplncTotDngrsGoodsSts PurgProdCmplncTotDngrsGoodsSts Dangerous Goods Sts
PurgHasCatalogRelevantItems PurgHasCatalogRelevantItems Ctlg Item Rlvt Doc
ActivePurchasingDocument ActivePurchasingDocument Active Purchase Doc
PurchasingDocumentVersion PurchasingDocumentVersion Version
PurgDocChangeRequestStatus PurgDocChangeRequestStatus Change Request Stat.
_PurchaseContractItem _PurchaseContractItem
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingDocumentType _PurchasingDocumentType
_IncotermsClassification _IncotermsClassification
_Supplier _Supplier
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_CreatedByUser _CreatedByUser
_DocumentCurrency _DocumentCurrency
_ReleaseCode _ReleaseCode
_SupplyingSupplier _SupplyingSupplier
_InvoicingParty _InvoicingParty
_PaymentTerms _PaymentTerms

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_PurchaseContract.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RPURCHASECTR

CREATE VIEW R_PurchaseContract AS
SELECT
  cast (PurchasingDocument as vdm_purchasecontract preserving type) AS PurchaseContract,
  PurchasingDocumentType AS PurchaseContractType,
  PurchasingDocumentCategory,
  LastChangeDateTime,
  CreationDate,
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  TargetAmount AS PurchaseContractTargetAmount,
  ValidityStartDate,
  ValidityEndDate,
  ReleaseCode,
  CreatedByUser,
  PurchasingDocumentDeletionCode,
  SupplyingSupplier,
  InvoicingParty,
  ExchangeRate,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotationExternalID AS SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  PurchasingDocumentName,
  PurchasingDocumentOrigin,
  ReleaseIsNotCompleted,
  PurchasingProcessingStatus,
  ManualSupplierAddressID,
  IsEndOfPurposeBlocked,
  PurgDocExternalReference,
  PurgAggrgdProdCmplncSuplrSts,
  PurgAggrgdProdMarketabilitySts,
  PurgAggrgdSftyDataSheetStatus,
  PurgProdCmplncTotDngrsGoodsSts,
  PurgHasCatalogRelevantItems,
  ActivePurchasingDocument,
  PurchasingDocumentVersion,
  PurgDocChangeRequestStatus
FROM R_PurchasingDocument
LEFT OUTER JOIN R_PurchaseContractItem AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract  -- association [0..*]
;

Learn More