R_PurchaseOrderTP

DDL: R_PURCHASEORDERTP Type: view_entity TRANSACTIONAL
88 Fields 1 Data Sources 6 Associations

Purchase Order Transactional View

R_PurchaseOrderTP is a Transactional CDS View that provides data about "Purchase Order Transactional View" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrder) and exposes 88 fields with key field PurchaseOrder. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrder PurchaseOrder from

Associations (6)

CardinalityTargetAliasCondition
[1..1] E_PurchasingDocument _PurchaseOrderExtension $projection.PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument
[1..1] I_PurchasingDocumentType _PurchaseOrderType $projection.PurchaseOrderType = _PurchaseOrderType.PurchasingDocumentType and _PurchaseOrderType.PurchasingDocumentCategory = 'F'
[1..*] R_PurchaseOrderItemTP _PurchaseOrderItem
[1..1] R_PurchaseOrdSupplierAddressTP _SupplierAddress
[1..*] R_PurchaseOrderNoteTP _PurchaseOrderNote
[1..*] R_PurchaseOrderPartnerTP _PurchaseOrderPartner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Purchase Order Transactional View view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PurchaseOrder view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (88)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderType R_PurchaseOrder PurchaseOrderType PO Type
PurchaseOrderSubtype R_PurchaseOrder PurchaseOrderSubtype Control
PurchasingDocumentOrigin R_PurchaseOrder PurchasingDocumentOrigin Status
PurchasingDocumentProcessCode PurchasingDocumentProcessCode Process Indicator
CreatedByUser R_PurchaseOrder CreatedByUser User Name
CreationDate R_PurchaseOrder CreationDate Time Stamp
PurchaseOrderDate R_PurchaseOrder PurchaseOrderDate PO Date
LastChangeDateTime R_PurchaseOrder LastChangeDateTime Timestamp
ValidityStartDate R_PurchaseOrder ValidityStartDate Validity Start Date
ValidityEndDate R_PurchaseOrder ValidityEndDate ValidTo
Language R_PurchaseOrder Language Report Text Language
PurchaseOrderDeletionCode R_PurchaseOrder PurchaseOrderDeletionCode Deletion Code
ReleaseIsNotCompleted R_PurchaseOrder ReleaseIsNotCompleted Subj.to Release
PurchasingCompletenessStatus R_PurchaseOrder PurchasingCompletenessStatus Incomplete
PurchasingProcessingStatus R_PurchaseOrder PurchasingProcessingStatus Proc. State
PurgReleaseSequenceStatus R_PurchaseOrder PurgReleaseSequenceStatus Release State
ReleaseCode R_PurchaseOrder ReleaseCode Release ind.
PurchasingReleaseStrategy R_PurchaseOrder PurchasingReleaseStrategy Rel. Strategy
PurgReasonForDocCancellation R_PurchaseOrder PurgReasonForDocCancellation Reas. for Canc.
CompanyCode R_PurchaseOrder CompanyCode Receiver Company Code
PurchasingOrganization R_PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup R_PurchaseOrder PurchasingGroup Purchasing Group
Supplier R_PurchaseOrder Supplier Supplier
ManualSupplierAddressID R_PurchaseOrder ManualSupplierAddressID Address Number
SupplierAddressID R_PurchaseOrder SupplierAddressID Address Number
SupplierRespSalesPersonName R_PurchaseOrder SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber R_PurchaseOrder SupplierPhoneNumber Telephone
SupplyingSupplier R_PurchaseOrder SupplyingSupplier Goods Supplier
SupplyingPlant R_PurchaseOrder SupplyingPlant Supplying Plant
InvoicingParty R_PurchaseOrder InvoicingParty Supplier
Customer R_PurchaseOrder Customer Sold-to Party
PurchaseContract R_PurchaseOrder PurchaseContract Purchasing Doc.
SupplierQuotationExternalID R_PurchaseOrder SupplierQuotationExternalID Quotation
QuotationSubmissionDate R_PurchaseOrder QuotationSubmissionDate Quotation Date
ItemNumberIntervalForSubItems R_PurchaseOrder ItemNumberIntervalForSubItems Subitem Interv.
PaymentTerms R_PurchaseOrder PaymentTerms Pyt Terms
CashDiscount1Days R_PurchaseOrder CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days R_PurchaseOrder CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays R_PurchaseOrder NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent R_PurchaseOrder CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent R_PurchaseOrder CashDiscount2Percent Disc. Percent 2
DownPaymentType R_PurchaseOrder DownPaymentType Down Payment
DownPaymentPercentageOfTotAmt R_PurchaseOrder DownPaymentPercentageOfTotAmt Down Payment %
DownPaymentAmount R_PurchaseOrder DownPaymentAmount Downpayment
DownPaymentDueDate R_PurchaseOrder DownPaymentDueDate Due Date for DP
IncotermsClassification R_PurchaseOrder IncotermsClassification Incoterms
IncotermsTransferLocation R_PurchaseOrder IncotermsTransferLocation Incoterms 2
IncotermsVersion R_PurchaseOrder IncotermsVersion Inco. Version
IncotermsLocation1 R_PurchaseOrder IncotermsLocation1 Inco. Location1
IncotermsLocation2 R_PurchaseOrder IncotermsLocation2 Inco. Location2
IsIntrastatReportingRelevant R_PurchaseOrder IsIntrastatReportingRelevant Intrastat rel.
IsIntrastatReportingExcluded R_PurchaseOrder IsIntrastatReportingExcluded exclude Intra
CorrespncExternalReference R_PurchaseOrder CorrespncExternalReference Your Reference
CorrespncInternalReference R_PurchaseOrder CorrespncInternalReference Our Reference
PurchasingCollectiveNumber PurchasingCollectiveNumber
PricingDocument R_PurchaseOrder PricingDocument Document Condition
PricingProcedure R_PurchaseOrder PricingProcedure Procedure
DocumentCurrency R_PurchaseOrder DocumentCurrency Document Currency
ExchangeRate
ExchangeRateIsFixed R_PurchaseOrder ExchangeRateIsFixed Fixed Exch.Rate
PurgReleaseTimeTotalAmount R_PurchaseOrder PurgReleaseTimeTotalAmount
TaxReturnCountry R_PurchaseOrder TaxReturnCountry Reporting C/R
VATRegistrationCountry R_PurchaseOrder VATRegistrationCountry CtryRgnSlsTxNo.
PurgAggrgdProdCmplncSuplrSts R_PurchaseOrder PurgAggrgdProdCmplncSuplrSts Supplier Check Sts
PurgAggrgdProdMarketabilitySts R_PurchaseOrder PurgAggrgdProdMarketabilitySts Prod. Marktablty Sts
PurgAggrgdSftyDataSheetStatus R_PurchaseOrder PurgAggrgdSftyDataSheetStatus Sfty Data Sheet Sts
PurgProdCmplncTotDngrsGoodsSts R_PurchaseOrder PurgProdCmplncTotDngrsGoodsSts Dangerous Goods Sts
_PurchaseOrderItem _PurchaseOrderItem
_SupplierAddress _SupplierAddress
_PurchaseOrderNote _PurchaseOrderNote
_PurchaseOrderPartner _PurchaseOrderPartner
_CompanyCode R_PurchaseOrder _CompanyCode
_CreatedByUser R_PurchaseOrder _CreatedByUser
_DocumentCurrency R_PurchaseOrder _DocumentCurrency
_IncotermsClassification R_PurchaseOrder _IncotermsClassification
_IncotermsVersion R_PurchaseOrder _IncotermsVersion
_InvoicingParty R_PurchaseOrder _InvoicingParty
_Language R_PurchaseOrder _Language
_PaymentTerms R_PurchaseOrder _PaymentTerms
_PurchaseOrderCalcFields R_PurchaseOrder _PurchaseOrderCalcFields
_PurchaseOrderDeletionCode R_PurchaseOrder _PurchaseOrderDeletionCode
_PurchaseOrderType _PurchaseOrderType
_PurchasingGroup R_PurchaseOrder _PurchasingGroup
_PurchasingOrganization R_PurchaseOrder _PurchasingOrganization
_Supplier R_PurchaseOrder _Supplier
_SupplyingPlant R_PurchaseOrder _SupplyingPlant
_SupplyingSupplier R_PurchaseOrder _SupplyingSupplier

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_PurchaseOrderTP.
-- 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.

CREATE VIEW R_PurchaseOrderTP AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder.PurchaseOrderSubtype AS PurchaseOrderSubtype,
  PurchaseOrder.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  PurchasingDocumentProcessCode,
  PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrder.CreationDate AS CreationDate,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrder.LastChangeDateTime AS LastChangeDateTime,
  PurchaseOrder.ValidityStartDate AS ValidityStartDate,
  PurchaseOrder.ValidityEndDate AS ValidityEndDate,
  PurchaseOrder.Language AS Language,
  PurchaseOrder.PurchaseOrderDeletionCode AS PurchaseOrderDeletionCode,
  PurchaseOrder.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  PurchaseOrder.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  PurchaseOrder.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  PurchaseOrder.PurgReleaseSequenceStatus AS PurgReleaseSequenceStatus,
  PurchaseOrder.ReleaseCode AS ReleaseCode,
  PurchaseOrder.PurchasingReleaseStrategy AS PurchasingReleaseStrategy,
  PurchaseOrder.PurgReasonForDocCancellation AS PurgReasonForDocCancellation,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.ManualSupplierAddressID AS ManualSupplierAddressID,
  PurchaseOrder.SupplierAddressID AS SupplierAddressID,
  PurchaseOrder.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  PurchaseOrder.SupplierPhoneNumber AS SupplierPhoneNumber,
  PurchaseOrder.SupplyingSupplier AS SupplyingSupplier,
  PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  PurchaseOrder.InvoicingParty AS InvoicingParty,
  PurchaseOrder.Customer AS Customer,
  PurchaseOrder.PurchaseContract AS PurchaseContract,
  PurchaseOrder.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  PurchaseOrder.QuotationSubmissionDate AS QuotationSubmissionDate,
  PurchaseOrder.ItemNumberIntervalForSubItems AS ItemNumberIntervalForSubItems,
  PurchaseOrder.PaymentTerms AS PaymentTerms,
  PurchaseOrder.CashDiscount1Days AS CashDiscount1Days,
  PurchaseOrder.CashDiscount2Days AS CashDiscount2Days,
  PurchaseOrder.NetPaymentDays AS NetPaymentDays,
  PurchaseOrder.CashDiscount1Percent AS CashDiscount1Percent,
  PurchaseOrder.CashDiscount2Percent AS CashDiscount2Percent,
  PurchaseOrder.DownPaymentType AS DownPaymentType,
  PurchaseOrder.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  PurchaseOrder.DownPaymentAmount AS DownPaymentAmount,
  PurchaseOrder.DownPaymentDueDate AS DownPaymentDueDate,
  PurchaseOrder.IncotermsClassification AS IncotermsClassification,
  PurchaseOrder.IncotermsTransferLocation AS IncotermsTransferLocation,
  PurchaseOrder.IncotermsVersion AS IncotermsVersion,
  PurchaseOrder.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrder.IncotermsLocation2 AS IncotermsLocation2,
  PurchaseOrder.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  PurchaseOrder.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  PurchaseOrder.CorrespncExternalReference AS CorrespncExternalReference,
  PurchaseOrder.CorrespncInternalReference AS CorrespncInternalReference,
  PurchasingCollectiveNumber,
  PurchaseOrder.PricingDocument AS PricingDocument,
  PurchaseOrder.PricingProcedure AS PricingProcedure,
  PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  cast( PurchaseOrder.ExchangeRate as fis_exchange_rate preserving type ) AS ExchangeRate,
  PurchaseOrder.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  PurchaseOrder.PurgReleaseTimeTotalAmount AS PurgReleaseTimeTotalAmount,
  PurchaseOrder.TaxReturnCountry AS TaxReturnCountry,
  PurchaseOrder.VATRegistrationCountry AS VATRegistrationCountry,
  PurchaseOrder.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  PurchaseOrder.PurgAggrgdProdMarketabilitySts AS PurgAggrgdProdMarketabilitySts,
  PurchaseOrder.PurgAggrgdSftyDataSheetStatus AS PurgAggrgdSftyDataSheetStatus,
  PurchaseOrder.PurgProdCmplncTotDngrsGoodsSts AS PurgProdCmplncTotDngrsGoodsSts,
  PurchaseOrder._CompanyCode AS _CompanyCode,
  PurchaseOrder._CreatedByUser AS _CreatedByUser,
  PurchaseOrder._DocumentCurrency AS _DocumentCurrency,
  PurchaseOrder._IncotermsClassification AS _IncotermsClassification,
  PurchaseOrder._IncotermsVersion AS _IncotermsVersion,
  PurchaseOrder._InvoicingParty AS _InvoicingParty,
  PurchaseOrder._Language AS _Language,
  PurchaseOrder._PaymentTerms AS _PaymentTerms,
  PurchaseOrder._PurchaseOrderCalcFields AS _PurchaseOrderCalcFields,
  PurchaseOrder._PurchaseOrderDeletionCode AS _PurchaseOrderDeletionCode,
  PurchaseOrder._PurchasingGroup AS _PurchasingGroup,
  PurchaseOrder._PurchasingOrganization AS _PurchasingOrganization,
  PurchaseOrder._Supplier AS _Supplier,
  PurchaseOrder._SupplyingPlant AS _SupplyingPlant,
  PurchaseOrder._SupplyingSupplier AS _SupplyingSupplier
FROM R_PurchaseOrder AS PurchaseOrder
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseOrderExtension ON PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchaseOrderType ON PurchaseOrderType = _PurchaseOrderType.PurchasingDocumentType AND _PurchaseOrderType.PurchasingDocumentCategory = 'F'  -- association [1..1]
LEFT OUTER JOIN R_PurchaseOrderItemTP AS _PurchaseOrderItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_PurchaseOrdSupplierAddressTP AS _SupplierAddress ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN R_PurchaseOrderNoteTP AS _PurchaseOrderNote ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_PurchaseOrderPartnerTP AS _PurchaseOrderPartner ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More