R_CFinRpldPurchasingDocumentTP

DDL: R_CFINRPLDPURCHASINGDOCUMENTTP Type: view_entity TRANSACTIONAL Package: FINS_CFIN_ACC_VIEW_EX
22 Fields 1 Data Sources 2 Associations

CFin Replicated Purchasing Document

R_CFinRpldPurchasingDocumentTP is a Transactional CDS View that provides data about "CFin Replicated Purchasing Document" in SAP S/4HANA. It reads from 1 data source (I_CFinRpldPurchasingDocument) and exposes 22 fields with key fields SourceSystemLogicalSystem, CFinRpldPurchasingDocument. It has 2 associations to related views. Part of development package FINS_CFIN_ACC_VIEW_EX.

Data Sources (1)

SourceAliasJoin Type
I_CFinRpldPurchasingDocument I_CFinRpldPurchasingDocument from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_CFinRpldPurchasingDocument _Extension $projection.CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument and $projection.SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem
[0..*] R_CFinRpldPurchasingDocItemTP _CFinRpldPurchasingDocItemTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label CFin Replicated Purchasing Document view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name CFinRpldPurchasingDocument view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SourceSystemLogicalSystem SenderLogicalSystem Sender Logical System
KEY CFinRpldPurchasingDocument CFinRpldPurchasingDocument Purchasing Doc.
CompanyCode CompanyCode Receiver Company Code
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
CreationDate CreationDate Time Stamp
Supplier Supplier Supplier
PurchasingGroup PurchasingGroup Purchasing Group
DocumentCurrency DocumentCurrency Document Currency
PurchasingDocumentOrderDate PurchasingDocumentOrderDate PO Date
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
SupplyingSupplier SupplyingSupplier Goods Supplier
SupplyingPlant SupplyingPlant Supplying Plant
InvoicingParty InvoicingParty Supplier
TaxReturnCountry TaxReturnCountry Reporting C/R
CreatedByUser CreatedByUser User Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
IsDeleted
LastChangeDateTime
_CFinRpldPurchasingDocItemTP _CFinRpldPurchasingDocItemTP

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_CFinRpldPurchasingDocumentTP.
-- 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_CFinRpldPurchasingDocumentTP AS
SELECT
  SenderLogicalSystem AS SourceSystemLogicalSystem,
  CFinRpldPurchasingDocument,
  CompanyCode,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingDocumentDeletionCode,
  CreationDate,
  Supplier,
  PurchasingGroup,
  DocumentCurrency,
  PurchasingDocumentOrderDate,
  ValidityStartDate,
  ValidityEndDate,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  TaxReturnCountry,
  CreatedByUser,
  PurchasingOrganization,
  cast( '' as fins_cfin_av_isdeleted preserving type ) AS IsDeleted,
  cast( '00000000000000' as fins_cfin_av_lastchangedon ) AS LastChangeDateTime
FROM I_CFinRpldPurchasingDocument
LEFT OUTER JOIN E_CFinRpldPurchasingDocument AS _Extension ON CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument AND SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem  -- association [1..1]
LEFT OUTER JOIN R_CFinRpldPurchasingDocItemTP AS _CFinRpldPurchasingDocItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More