A_CFinRpldPurchaseOrder

DDL: A_CFINRPLDPURCHASEORDER Type: view_entity CONSUMPTION Package: FINS_CFIN_ACC_VIEW_EX
20 Fields 1 Data Sources 1 OData Services

CFin Replicated Purchase Order

A_CFinRpldPurchaseOrder is a Consumption CDS View that provides data about "CFin Replicated Purchase Order" in SAP S/4HANA. It reads from 1 data source (R_CFinRpldPurchasingDocumentTP) and exposes 20 fields with key fields SourceSystemLogicalSystem, CFinReplicatedPurchaseOrder. It is exposed through 1 OData service (API_CFINRPLDPURCHASEORDER). Part of development package FINS_CFIN_ACC_VIEW_EX.

Data Sources (1)

SourceAliasJoin Type
R_CFinRpldPurchasingDocumentTP R_CFinRpldPurchasingDocumentTP projection

Annotations (7)

NameValueLevelField
EndUserText.label CFin Replicated Purchase Order view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
API_CFINRPLDPURCHASEORDER API_CFINRPLDPURCHASEORDER V4 C2 NOT_RELEASED

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SourceSystemLogicalSystem CFinRpldPurchasingDocument SourceSystemLogicalSystem Sender Log Sys.
KEY CFinReplicatedPurchaseOrder
CompanyCode CFinRpldPurchasingDocument CompanyCode Receiver Company Code
PurchasingDocumentCategory CFinRpldPurchasingDocument PurchasingDocumentCategory Doc. Category
PurchaseOrderType
PurchasingDocumentDeletionCode CFinRpldPurchasingDocument PurchasingDocumentDeletionCode Del. Indicator
CreationDate CFinRpldPurchasingDocument CreationDate Time Stamp
Supplier CFinRpldPurchasingDocument Supplier Supplier
PurchasingGroup CFinRpldPurchasingDocument PurchasingGroup Purchasing Group
DocumentCurrency CFinRpldPurchasingDocument DocumentCurrency Document Currency
PurchaseOrderDate
ValidityStartDate CFinRpldPurchasingDocument ValidityStartDate Validity Start Date
ValidityEndDate CFinRpldPurchasingDocument ValidityEndDate ValidTo
SupplyingSupplier CFinRpldPurchasingDocument SupplyingSupplier Goods Supplier
SupplyingPlant CFinRpldPurchasingDocument SupplyingPlant Supplying Plant
InvoicingParty CFinRpldPurchasingDocument InvoicingParty Supplier
TaxReturnCountry CFinRpldPurchasingDocument TaxReturnCountry Reporting C/R
CreatedByUser CFinRpldPurchasingDocument CreatedByUser User Name
PurchasingOrganization CFinRpldPurchasingDocument PurchasingOrganization Purchasing Organization
IsDeleted CFinRpldPurchasingDocument IsDeleted TRUE

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 A_CFinRpldPurchaseOrder.
-- 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 A_CFinRpldPurchaseOrder AS
SELECT
  CFinRpldPurchasingDocument.SourceSystemLogicalSystem AS SourceSystemLogicalSystem,
  cast( CFinRpldPurchasingDocument.CFinRpldPurchasingDocument as fins_cfin_av_rpld_purord preserving type ) AS CFinReplicatedPurchaseOrder,
  CFinRpldPurchasingDocument.CompanyCode AS CompanyCode,
  CFinRpldPurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  cast (CFinRpldPurchasingDocument.PurchasingDocumentType as mm_purchaseordertype preserving type ) AS PurchaseOrderType,
  CFinRpldPurchasingDocument.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  CFinRpldPurchasingDocument.CreationDate AS CreationDate,
  CFinRpldPurchasingDocument.Supplier AS Supplier,
  CFinRpldPurchasingDocument.PurchasingGroup AS PurchasingGroup,
  CFinRpldPurchasingDocument.DocumentCurrency AS DocumentCurrency,
  cast ( CFinRpldPurchasingDocument.PurchasingDocumentOrderDate as bedat preserving type) AS PurchaseOrderDate,
  CFinRpldPurchasingDocument.ValidityStartDate AS ValidityStartDate,
  CFinRpldPurchasingDocument.ValidityEndDate AS ValidityEndDate,
  CFinRpldPurchasingDocument.SupplyingSupplier AS SupplyingSupplier,
  CFinRpldPurchasingDocument.SupplyingPlant AS SupplyingPlant,
  CFinRpldPurchasingDocument.InvoicingParty AS InvoicingParty,
  CFinRpldPurchasingDocument.TaxReturnCountry AS TaxReturnCountry,
  CFinRpldPurchasingDocument.CreatedByUser AS CreatedByUser,
  CFinRpldPurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  CFinRpldPurchasingDocument.IsDeleted AS IsDeleted
FROM R_CFinRpldPurchasingDocumentTP
;

Learn More