A_CFinRpldPurOrdReltdMatlDoc

DDL: A_CFINRPLDPURORDRELTDMATLDOC Type: view_entity CONSUMPTION
27 Fields 1 Data Sources

CFin Rpld PurOrd Related Material Doc

A_CFinRpldPurOrdReltdMatlDoc is a Consumption CDS View that provides data about "CFin Rpld PurOrd Related Material Doc" in SAP S/4HANA. It reads from 1 data source (R_CFinRpldPurgReltdMatlDocTP) and exposes 27 fields with key fields SourceSystemLogicalSystem, CFinReplicatedPurchaseOrder, CFinRpldPurchaseOrderItem, CFinRpldPurOrdAcctAssgmt, PurchaseOrderTransactionType.

Data Sources (1)

SourceAliasJoin Type
R_CFinRpldPurgReltdMatlDocTP R_CFinRpldPurgReltdMatlDocTP projection

Annotations (9)

NameValueLevelField
EndUserText.label CFin Rpld PurOrd Related Material Doc view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name CFinRpldPurOrdReltdMatlDoc_Type 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 (27)

KeyFieldSource TableSource FieldDescription
KEY SourceSystemLogicalSystem SourceSystemLogicalSystem Sender Log Sys.
KEY CFinReplicatedPurchaseOrder Purchasing Doc.
KEY CFinRpldPurchaseOrderItem Item
KEY CFinRpldPurOrdAcctAssgmt
KEY PurchaseOrderTransactionType PurchaseOrderTransactionType
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY CFinSourceMaterialDocument CFinSourceMaterialDocument
KEY CFinSourceMaterialDocumentItem CFinSourceMaterialDocumentItem
PostingDate PostingDate Posting Date for GR
Quantity Quantity Value
PurchaseOrderQuantityUnit OrderQuantityUnit Sales Unit
PurchaseOrderAmount PurchaseOrderAmount
Currency Currency Valuation Crcy
DebitCreditCode DebitCreditCode Single-Character Flag
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
TimeEntry TimeEntry Entered at
Material Material Vehicle Model
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Year Cur.Period
QuantityInBaseUnit QuantityInBaseUnit Quantity
BaseUnit BaseUnit Unit of Measure
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
OrderPriceUnit OrderPriceUnit Order Price Un.
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency

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_CFinRpldPurOrdReltdMatlDoc.
-- 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_CFinRpldPurOrdReltdMatlDoc 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,
  MaterialDocumentYear,
  CFinSourceMaterialDocument,
  CFinSourceMaterialDocumentItem,
  PostingDate,
  Quantity,
  OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchaseOrderAmount,
  Currency,
  DebitCreditCode,
  AccountingDocumentCreationDate,
  TimeEntry,
  Material,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentFiscalYear,
  QuantityInBaseUnit,
  BaseUnit,
  QtyInPurchaseOrderPriceUnit,
  OrderPriceUnit,
  IsCompletelyDelivered,
  PurOrdAmountInCompanyCodeCrcy,
  CompanyCodeCurrency
FROM R_CFinRpldPurgReltdMatlDocTP
;

Learn More