A_CFinRpldPurOrdReltdSuplrInvc

DDL: A_CFINRPLDPURORDRELTDSUPLRINVC Type: view_entity CONSUMPTION
24 Fields 1 Data Sources

CFin Rpld Purchase Order Related SI

A_CFinRpldPurOrdReltdSuplrInvc is a Consumption CDS View that provides data about "CFin Rpld Purchase Order Related SI" in SAP S/4HANA. It reads from 1 data source (R_CFinRpldPurgDocReltdInvcTP) and exposes 24 fields with key fields SourceSystemLogicalSystem, CFinReplicatedPurchaseOrder, CFinRpldPurchaseOrderItem, CFinRpldPurOrdAcctAssgmt, PurchaseOrderTransactionType.

Data Sources (1)

SourceAliasJoin Type
R_CFinRpldPurgDocReltdInvcTP R_CFinRpldPurgDocReltdInvcTP projection

Annotations (8)

NameValueLevelField
EndUserText.label CFin Rpld Purchase Order Related SI view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.query.implementedBy ABAP:CL_FINS_CFIN_AV_EX_QRY_NO_IMPL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SourceSystemLogicalSystem SourceSystemLogicalSystem Sender Log Sys.
KEY CFinReplicatedPurchaseOrder Purchasing Doc.
KEY CFinRpldPurchaseOrderItem Item
KEY CFinRpldPurOrdAcctAssgmt
KEY PurchaseOrderTransactionType PurchaseOrderTransactionType
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CFinRpldSupplierInvoice CFinRpldSupplierInvoice Central Finance Repl. Supplier Invoice
KEY CFinRpldSupplierInvoiceItem CFinRpldSupplierInvoiceItem Item
PostingDate PostingDate Posting Date for GR
Quantity Quantity Value
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy
PurchaseOrderAmount PurchaseOrderAmount
Currency Currency Valuation Crcy
DebitCreditCode DebitCreditCode Single-Character Flag
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
TimeEntry TimeEntry Entered at
Material Material Vehicle Model
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PurchaseOrderQuantityUnit OrderQuantityUnit Sales Unit
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Year Cur.Period
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
OrderPriceUnit OrderPriceUnit Order Price Un.

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_CFinRpldPurOrdReltdSuplrInvc.
-- 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_CFinRpldPurOrdReltdSuplrInvc AS
SELECT
  SourceSystemLogicalSystem,
  cast( CFinRpldPurchasingDocument as fins_cfin_av_rpld_purord preserving type ) AS CFinReplicatedPurchaseOrder,
  cast( CFinRpldPurchasingDocumentItem as fins_cfin_av_rpld_purord_item preserving type ) AS CFinRpldPurchaseOrderItem,
  cast( CFinRpldPurgDocAcctAssgmt as fins_cfin_av_rpld_pur_ord_acc preserving type ) AS CFinRpldPurOrdAcctAssgmt,
  PurchaseOrderTransactionType,
  FiscalYear,
  CFinRpldSupplierInvoice,
  CFinRpldSupplierInvoiceItem,
  PostingDate,
  Quantity,
  PurOrdAmountInCompanyCodeCrcy,
  PurchaseOrderAmount,
  Currency,
  DebitCreditCode,
  AccountingDocumentCreationDate,
  TimeEntry,
  Material,
  CompanyCodeCurrency,
  OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentFiscalYear,
  QtyInPurchaseOrderPriceUnit,
  OrderPriceUnit
FROM R_CFinRpldPurgDocReltdInvcTP
;

Learn More