R_CFinRpldPurgReltdMatlDocTP

DDL: R_CFINRPLDPURGRELTDMATLDOCTP Type: view_entity TRANSACTIONAL
30 Fields 1 Data Sources 2 Associations

CFin Rpld PurgDoc Related Material Doc

R_CFinRpldPurgReltdMatlDocTP is a Transactional CDS View that provides data about "CFin Rpld PurgDoc Related Material Doc" in SAP S/4HANA. It reads from 1 data source (I_CFinRpldPurgDocHistory) and exposes 30 fields with key fields SourceSystemLogicalSystem, CFinRpldPurchasingDocument, CFinRpldPurchasingDocumentItem, CFinRpldPurgDocAcctAssgmt, PurchaseOrderTransactionType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CFinRpldPurgDocHistory I_CFinRpldPurgDocHistory from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_CFinRpldPurchasingDocumentTP _CFinRpldPurchasingDocumentTP $projection.SourceSystemLogicalSystem = _CFinRpldPurchasingDocumentTP.SourceSystemLogicalSystem and $projection.CFinRpldPurchasingDocument = _CFinRpldPurchasingDocumentTP.CFinRpldPurchasingDocument
[1..1] E_CFinRpldPurchasingDocHistory _Extension $projection.SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem and $projection.CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument and $projection.CFinRpldPurchasingDocumentItem = _Extension.CFinRpldPurchasingDocumentItem and $projection.CFinRpldPurgDocAcctAssgmt = _Extension.CFinRpldPurgDocAcctAssgmt and $projection.PurchaseOrderTransactionType = _Extension.PurchaseOrderTransactionType and $projection.MaterialDocumentYear = _Extension.MaterialDocumentYear and $projection.CFinSourceMaterialDocument = _Extension.CFinSourceMaterialDocument and $projection.CFinSourceMaterialDocumentItem = _Extension.CFinSourceMaterialDocumentItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label CFin Rpld PurgDoc Related Material Doc view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SourceSystemLogicalSystem SenderLogicalSystem Sender Logical System
KEY CFinRpldPurchasingDocument CFinRpldPurchasingDocument Purchasing Doc.
KEY CFinRpldPurchasingDocumentItem CFinRpldPurchasingDocumentItem Item
KEY CFinRpldPurgDocAcctAssgmt CFinRpldPurgDocAcctAssgmt
KEY PurchaseOrderTransactionType PurchaseOrderTransactionType Transact. Type
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY CFinSourceMaterialDocument CFinSourceMaterialDocument
KEY CFinSourceMaterialDocumentItem CFinSourceMaterialDocumentItem
PostingDate PostingDate Posting Date for GR
Quantity Quantity Value
OrderQuantityUnit OrderQuantityUnit Sales Unit
PurchaseOrderAmount PurchaseOrderAmount Gross Amount
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 Loc. amount
CompanyCodeCurrency CompanyCodeCurrency Local Currency
LastChangeDateTime
_CFinRpldPurchasingDocItemTP _CFinRpldPurchasingDocItemTP
_CFinRpldPurchasingDocumentTP _CFinRpldPurchasingDocumentTP

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_CFinRpldPurgReltdMatlDocTP.
-- 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_CFinRpldPurgReltdMatlDocTP AS
SELECT
  SenderLogicalSystem AS SourceSystemLogicalSystem,
  CFinRpldPurchasingDocument,
  CFinRpldPurchasingDocumentItem,
  CFinRpldPurgDocAcctAssgmt,
  PurchaseOrderTransactionType,
  MaterialDocumentYear,
  CFinSourceMaterialDocument,
  CFinSourceMaterialDocumentItem,
  PostingDate,
  Quantity,
  OrderQuantityUnit,
  PurchaseOrderAmount,
  Currency,
  DebitCreditCode,
  AccountingDocumentCreationDate,
  TimeEntry,
  Material,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentFiscalYear,
  QuantityInBaseUnit,
  BaseUnit,
  QtyInPurchaseOrderPriceUnit,
  OrderPriceUnit,
  IsCompletelyDelivered,
  PurOrdAmountInCompanyCodeCrcy,
  CompanyCodeCurrency,
  cast( '00000000000000' as fins_cfin_av_lastchangedon ) AS LastChangeDateTime
FROM I_CFinRpldPurgDocHistory
LEFT OUTER JOIN R_CFinRpldPurchasingDocumentTP AS _CFinRpldPurchasingDocumentTP ON SourceSystemLogicalSystem = _CFinRpldPurchasingDocumentTP.SourceSystemLogicalSystem AND CFinRpldPurchasingDocument = _CFinRpldPurchasingDocumentTP.CFinRpldPurchasingDocument  -- association [1..1]
LEFT OUTER JOIN E_CFinRpldPurchasingDocHistory AS _Extension ON SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument AND CFinRpldPurchasingDocumentItem = _Extension.CFinRpldPurchasingDocumentItem AND CFinRpldPurgDocAcctAssgmt = _Extension.CFinRpldPurgDocAcctAssgmt AND PurchaseOrderTransactionType = _Extension.PurchaseOrderTransactionType AND MaterialDocumentYear = _Extension.MaterialDocumentYear AND CFinSourceMaterialDocument = _Extension.CFinSourceMaterialDocument AND CFinSourceMaterialDocumentItem = _Extension.CFinSourceMaterialDocumentItem  -- association [1..1]
;

Learn More