R_MngJrnlEntrCrcyTranslation

DDL: R_MNGJRNLENTRCRCYTRANSLATION Type: view_entity COMPOSITE
23 Fields 1 Data Sources

Currency Translation of Journal Entry

R_MngJrnlEntrCrcyTranslation is a Composite CDS View that provides data about "Currency Translation of Journal Entry" in SAP S/4HANA. It reads from 1 data source (I_JrnlEntrAltvCrcyTrnsltnItem) and exposes 23 fields with key fields CompanyCode, AccountingDocument, FiscalYear, JrnlEntrAltvCrcyTrnsltnItem.

Data Sources (1)

SourceAliasJoin Type
I_JrnlEntrAltvCrcyTrnsltnItem _JrnlEntrAltvCrcyTrnsltnItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Currency Translation of Journal Entry view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JrnlEntrAltvCrcyTrnsltnItem CompanyCode Receiver Company Code
KEY AccountingDocument I_JrnlEntrAltvCrcyTrnsltnItem AccountingDocument Journal Entry
KEY FiscalYear I_JrnlEntrAltvCrcyTrnsltnItem FiscalYear G/L Fiscal Year
KEY JrnlEntrAltvCrcyTrnsltnItem I_JrnlEntrAltvCrcyTrnsltnItem JrnlEntrAltvCrcyTrnsltnItem Position
TransToCoCodeCrcyCnvrsnFctr I_JrnlEntrAltvCrcyTrnsltnItem TransToCoCodeCrcyCnvrsnFctr Tax Amt Fctr in LC
TransToRptgCrcyCnvrsnFctr I_JrnlEntrAltvCrcyTrnsltnItem TransToRptgCrcyCnvrsnFctr Tax Amt Fctr in RC
ServicesRenderedDate I_JrnlEntrAltvCrcyTrnsltnItem ServicesRenderedDate Services Rendered Date
PredecessorReferenceDocument I_JrnlEntrAltvCrcyTrnsltnItem PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem I_JrnlEntrAltvCrcyTrnsltnItem PredecessorReferenceDocItem Prec. Ref. Doc. Item
TransToCoCodeCrcyCnvrsnMeth I_JrnlEntrAltvCrcyTrnsltnItem TransToCoCodeCrcyCnvrsnMeth Co. Cd. Fctr. Method
TransToCoCodeCrcyCnvrsnMethTxt _CoCodeCrcyCnvrsnMeth ddtext Short text
TransToRptgCrcyCnvrsnMeth I_JrnlEntrAltvCrcyTrnsltnItem TransToRptgCrcyCnvrsnMeth Country Fctr. Method
TransToRptgCrcyCnvrsnMethTxt _RptgCrcyCnvrsnMeth ddtext Short text
TaxCountry I_JrnlEntrAltvCrcyTrnsltnItem TaxCountry Tax Ctry/Reg.
TaxCountryName
TaxCode I_JrnlEntrAltvCrcyTrnsltnItem TaxCode Tax Code
TaxCodeName
TaxCodeValidFromDate I_JrnlEntrAltvCrcyTrnsltnItem TaxCodeValidFromDate Tax Rate Valid-From
TaxJurisdiction I_JrnlEntrAltvCrcyTrnsltnItem TaxJurisdiction Tax Jurisdiction
TaxJurisdictionName
SDDocumentItem I_JrnlEntrAltvCrcyTrnsltnItem SDDocumentItem Item
TransToCoCodeCrcyExchRate I_JrnlEntrAltvCrcyTrnsltnItem TransToCoCodeCrcyExchRate
TransToRptgCrcyExchRate I_JrnlEntrAltvCrcyTrnsltnItem TransToRptgCrcyExchRate

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_MngJrnlEntrCrcyTranslation.
-- 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_MngJrnlEntrCrcyTranslation AS
SELECT
  _JrnlEntrAltvCrcyTrnsltnItem.CompanyCode AS CompanyCode,
  _JrnlEntrAltvCrcyTrnsltnItem.AccountingDocument AS AccountingDocument,
  _JrnlEntrAltvCrcyTrnsltnItem.FiscalYear AS FiscalYear,
  _JrnlEntrAltvCrcyTrnsltnItem.JrnlEntrAltvCrcyTrnsltnItem AS JrnlEntrAltvCrcyTrnsltnItem,
  _JrnlEntrAltvCrcyTrnsltnItem.TransToCoCodeCrcyCnvrsnFctr AS TransToCoCodeCrcyCnvrsnFctr,
  _JrnlEntrAltvCrcyTrnsltnItem.TransToRptgCrcyCnvrsnFctr AS TransToRptgCrcyCnvrsnFctr,
  _JrnlEntrAltvCrcyTrnsltnItem.ServicesRenderedDate AS ServicesRenderedDate,
  _JrnlEntrAltvCrcyTrnsltnItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  _JrnlEntrAltvCrcyTrnsltnItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  _JrnlEntrAltvCrcyTrnsltnItem.TransToCoCodeCrcyCnvrsnMeth AS TransToCoCodeCrcyCnvrsnMeth,
  _CoCodeCrcyCnvrsnMeth.ddtext AS TransToCoCodeCrcyCnvrsnMethTxt,
  _JrnlEntrAltvCrcyTrnsltnItem.TransToRptgCrcyCnvrsnMeth AS TransToRptgCrcyCnvrsnMeth,
  _RptgCrcyCnvrsnMeth.ddtext AS TransToRptgCrcyCnvrsnMethTxt,
  _JrnlEntrAltvCrcyTrnsltnItem.TaxCountry AS TaxCountry,
  _JrnlEntrAltvCrcyTrnsltnItem._Country._Text[1:Language = $session.system_language].CountryName AS TaxCountryName,
  _JrnlEntrAltvCrcyTrnsltnItem.TaxCode AS TaxCode,
  _JrnlEntrAltvCrcyTrnsltnItem._TaxCode._Text[1:Language = $session.system_language].TaxCodeName AS TaxCodeName,
  _JrnlEntrAltvCrcyTrnsltnItem.TaxCodeValidFromDate AS TaxCodeValidFromDate,
  _JrnlEntrAltvCrcyTrnsltnItem.TaxJurisdiction AS TaxJurisdiction,
  _JrnlEntrAltvCrcyTrnsltnItem._TaxJurisdiction._Text[1:Language = $session.system_language].TaxJurisdictionName AS TaxJurisdictionName,
  _JrnlEntrAltvCrcyTrnsltnItem.SDDocumentItem AS SDDocumentItem,
  _JrnlEntrAltvCrcyTrnsltnItem.TransToCoCodeCrcyExchRate AS TransToCoCodeCrcyExchRate,
  _JrnlEntrAltvCrcyTrnsltnItem.TransToRptgCrcyExchRate AS TransToRptgCrcyExchRate
FROM I_JrnlEntrAltvCrcyTrnsltnItem AS _JrnlEntrAltvCrcyTrnsltnItem
;

Learn More