R_RecrrgSuplrInvcTmplInstceTP

DDL: R_RECRRGSUPLRINVCTMPLINSTCETP SQL: IRECRRGINVCFOCAR Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 2 Associations

Forecast lines of recrrg suplr invc tmpl

R_RecrrgSuplrInvcTmplInstceTP is a Transactional CDS View that provides data about "Forecast lines of recrrg suplr invc tmpl" in SAP S/4HANA. It reads from 1 data source (fap_rsiv_forcasr) and exposes 16 fields with key field RecrrgSuplrInvcTmplInstceUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
fap_rsiv_forcasr _Forcast from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_AccountingDocument _AccountingDocument $projection.CompanyCode = _AccountingDocument.CompanyCode and $projection.OriginalReferenceDocument = _AccountingDocument.OriginalReferenceDocument and $projection.FiscalYear = _AccountingDocument.FiscalYear
[0..1] I_RecurrenceStatus _RecurrenceStatusText $projection.RecrrgAcctgDocOccrncSts = _RecurrenceStatusText.RecrrgAcctgDocOccrncSts

Annotations (9)

NameValueLevelField
EndUserText.label Forecast lines of recrrg suplr invc tmpl view
Search.searchable true view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY RecrrgSuplrInvcTmplInstceUUID fap_rsiv_forcasr recrrgsuplrinvctmplinstceuuid GUID
RecrrgSuplrInvcTmplUUID fap_rsiv_forcasr recrrgsuplrinvctmpluuid GUID
RecrrgSuplrInvcTmplInstance fap_rsiv_forcasr recrrgsuplrinvctmplinstance Number
RecrrgAcctgDocOccrncSts fap_rsiv_forcasr recrrgacctgdococcrncsts Posting status
PostingDate fap_rsiv_forcasr postingdate Posting Date for GR
AccountingDocument fap_rsiv_forcasr accountingdocument Journal Entry
FiscalYear fap_rsiv_forcasr fiscalyear G/L Fiscal Year
SupplierInvoiceWithItem fap_rsiv_forcasr supplierinvoicewithitem Invoice Number
TransactionCurrency fap_rsiv_forcasr transactioncurrency Transaction Currency
AmountInTransactionCurrency fap_rsiv_forcasr amountintransactioncurrency Pt Crcy Amt
TaxBaseAmountInTransCrcy fap_rsiv_forcasr taxbaseamountintranscrcy Value-Added Tax
CompanyCode _Tmpl CompanyCode Receiver Company Code
OriginalReferenceDocument
_AccountingDocument _AccountingDocument
_RecurrenceStatusText _RecurrenceStatusText
_Tmpl _Tmpl

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_RecrrgSuplrInvcTmplInstceTP.
-- 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.
-- SQL view name: IRECRRGINVCFOCAR

CREATE VIEW R_RecrrgSuplrInvcTmplInstceTP AS
SELECT
  _Forcast.recrrgsuplrinvctmplinstceuuid AS RecrrgSuplrInvcTmplInstceUUID,
  _Forcast.recrrgsuplrinvctmpluuid AS RecrrgSuplrInvcTmplUUID,
  _Forcast.recrrgsuplrinvctmplinstance AS RecrrgSuplrInvcTmplInstance,
  _Forcast.recrrgacctgdococcrncsts AS RecrrgAcctgDocOccrncSts,
  _Forcast.postingdate AS PostingDate,
  _Forcast.accountingdocument AS AccountingDocument,
  _Forcast.fiscalyear AS FiscalYear,
  _Forcast.supplierinvoicewithitem AS SupplierInvoiceWithItem,
  _Forcast.transactioncurrency AS TransactionCurrency,
  _Forcast.amountintransactioncurrency AS AmountInTransactionCurrency,
  _Forcast.taxbaseamountintranscrcy AS TaxBaseAmountInTransCrcy,
  _Tmpl.CompanyCode AS CompanyCode,
  cast(concat( _Forcast.accountingdocument,_Forcast.fiscalyear ) as abap.char( 20 )) AS OriginalReferenceDocument
FROM fap_rsiv_forcasr AS _Forcast
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND OriginalReferenceDocument = _AccountingDocument.OriginalReferenceDocument AND FiscalYear = _AccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_RecurrenceStatus AS _RecurrenceStatusText ON RecrrgAcctgDocOccrncSts = _RecurrenceStatusText.RecrrgAcctgDocOccrncSts  -- association [0..1]
;

Learn More