R_CFinRpldSuplrInvcItmGLAcctTP

DDL: R_CFINRPLDSUPLRINVCITMGLACCTTP Type: view_entity TRANSACTIONAL
17 Fields 1 Data Sources 1 Associations

CFin Rpld Supplier Invc Item GLAcc - TP

R_CFinRpldSuplrInvcItmGLAcctTP is a Transactional CDS View that provides data about "CFin Rpld Supplier Invc Item GLAcc - TP" in SAP S/4HANA. It reads from 1 data source (R_CFinRpldSuplrInvcItemGLAcct) and exposes 17 fields with key field CFinRpldSuplrInvcItmGLAcctUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CFinRpldSuplrInvcItemGLAcct R_CFinRpldSuplrInvcItemGLAcct from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CFinRpldSuplrInvcItmGLAcct _Extension $projection.CFinRpldSuplrInvcItmGLAcctUUID = _Extension.CFinRpldSuplrInvcItmGLAcctUUID

Annotations (7)

NameValueLevelField
EndUserText.label CFin Rpld Supplier Invc Item GLAcc - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CFinRpldSuplrInvcItmGLAcctUUID CFinRpldSuplrInvcItmGLAcctUUID DB Key
CFinRpldSuplrInvcItmGLParUUID CFinRpldSuplrInvcItmGLParUUID Parent Key
CFinRpldSupplierInvoiceUUID CFinRpldSupplierInvoiceUUID Root Key
SourceSystemLogicalSystem SourceSystemLogicalSystem Sender Log Sys.
CFinRpldSupplierInvoice CFinRpldSupplierInvoice Central Finance Repl. Supplier Invoice
FiscalYear FiscalYear G/L Fiscal Year
OrdinalNumber OrdinalNumber Sequence Number
TaxCode TaxCode Tax Code
DocumentCurrency DocumentCurrency Document Currency
SupplierInvoiceItemAmount SupplierInvoiceItemAmount Amount
DebitCreditCode DebitCreditCode Single-Character Flag
IsNegativePosting IsNegativePosting Negative Posting
AccountType AccountType Accounting Type(dtl)
GLAccount GLAccount General Ledger
TimeDependentTaxValidFromDate TimeDependentTaxValidFromDate Tax Rate Valid-From
TaxCountry TaxCountry Tax Ctry/Reg.
_CFinRpldSupplierInvoice _CFinRpldSupplierInvoice

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_CFinRpldSuplrInvcItmGLAcctTP.
-- 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_CFinRpldSuplrInvcItmGLAcctTP AS
SELECT
  CFinRpldSuplrInvcItmGLAcctUUID,
  CFinRpldSuplrInvcItmGLParUUID,
  CFinRpldSupplierInvoiceUUID,
  SourceSystemLogicalSystem,
  CFinRpldSupplierInvoice,
  FiscalYear,
  OrdinalNumber,
  TaxCode,
  DocumentCurrency,
  SupplierInvoiceItemAmount,
  DebitCreditCode,
  IsNegativePosting,
  AccountType,
  GLAccount,
  TimeDependentTaxValidFromDate,
  TaxCountry
FROM R_CFinRpldSuplrInvcItemGLAcct
LEFT OUTER JOIN E_CFinRpldSuplrInvcItmGLAcct AS _Extension ON CFinRpldSuplrInvcItmGLAcctUUID = _Extension.CFinRpldSuplrInvcItmGLAcctUUID  -- association [1..1]
;

Learn More