I_IL_StRpTaxItemLog

DDL: I_IL_STRPTAXITEMLOG SQL: IILSTRPTAXITMLOG Type: view COMPOSITE
37 Fields 2 Data Sources 6 Associations

IL: Tax Item For Statutory Reporting

I_IL_StRpTaxItemLog is a Composite CDS View (Cube) that provides data about "IL: Tax Item For Statutory Reporting" in SAP S/4HANA. It reads from 2 data sources (P_IL_StRpTaxItemLog, I_StRpTaxItem) and exposes 37 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. It has 6 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_IL_StRpTaxItemLog P_IL_StRpTaxItemLog from
I_StRpTaxItem StRpTaxItem inner

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_JournalEntry _JournalEntry $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.AccountingDocument = _JournalEntry.AccountingDocument and $projection.FiscalYear = _JournalEntry.FiscalYear
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_FiscalYearForCompanyCode _FiscalYear $projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode
[1..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_Currency _DocumentAdditionalCurrency1 $projection.AdditionalCurrency1 = _DocumentAdditionalCurrency1.Currency
[0..1] I_Currency _DocumentAdditionalCurrency2 $projection.AdditionalCurrency2 = _DocumentAdditionalCurrency2.Currency

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IILSTRPTAXITMLOG view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label IL: Tax Item For Statutory Reporting view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.internalName #LOCAL view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_IL_StRpTaxItemLog statryrptgentity Reporting Entity
KEY StatryRptCategory P_IL_StRpTaxItemLog statryrptcategory Report ID
KEY StatryRptRunID P_IL_StRpTaxItemLog statryrptrunid Report Run ID
KEY CompanyCode P_IL_StRpTaxItemLog COMPANYCODE Receiver Company Code
KEY AccountingDocument P_IL_StRpTaxItemLog ACCOUNTINGDOCUMENT Journal Entry
KEY FiscalYear P_IL_StRpTaxItemLog FISCALYEAR G/L Fiscal Year
KEY TaxItem P_IL_StRpTaxItemLog TAXITEM Tax Item
CompanyCodeCurrency I_StRpTaxItem CompanyCodeCurrency Local Currency
AdditionalCurrency1 I_StRpTaxItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_StRpTaxItem AdditionalCurrency2 Local curr. 3
TaxBaseAmountInCoCodeCrcy I_StRpTaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxBaseAmtInAdditionalCrcy1 I_StRpTaxItem TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 I_StRpTaxItem TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInCoCodeCrcy I_StRpTaxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmountInAdditionalCurrency1 I_StRpTaxItem TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 I_StRpTaxItem TaxAmountInAdditionalCurrency2 LC 3 Tax
IL_VATRecordType rec_type Totals rec.type
SystemMessageType msgty Msg.Type (E,I,W..)
SystemMessageClass msgid Message ID
SystemMessageNumber msgno Message Number
SystemMessageTextLong SystemMessageTextLong
TaxCode I_StRpTaxItem TaxCode Tax Code
TaxReportingDate I_StRpTaxItem TaxReportingDate Tax Reporting Date
DocumentDate I_StRpTaxItem DocumentDate Journal Entry Date
PostingDate I_StRpTaxItem PostingDate Posting Date for GR
DocumentReferenceID I_StRpTaxItem DocumentReferenceID Reference
Supplier I_StRpTaxItem Supplier Supplier
Customer I_StRpTaxItem Customer Sold-to Party
TransactionTypeDetermination I_StRpTaxItem TransactionTypeDetermination Transaction Key
OfficialDocumentNumberIntType
OfficialDocumentNumber
_JournalEntry _JournalEntry
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_CompanyCodeCurrency _CompanyCodeCurrency
_DocumentAdditionalCurrency1 _DocumentAdditionalCurrency1
_DocumentAdditionalCurrency2 _DocumentAdditionalCurrency2

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 I_IL_StRpTaxItemLog.
-- 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: IILSTRPTAXITMLOG

CREATE VIEW I_IL_StRpTaxItemLog AS
SELECT
  P_IL_StRpTaxItemLog.statryrptgentity AS StatryRptgEntity,
  P_IL_StRpTaxItemLog.statryrptcategory AS StatryRptCategory,
  P_IL_StRpTaxItemLog.statryrptrunid AS StatryRptRunID,
  P_IL_StRpTaxItemLog.COMPANYCODE AS CompanyCode,
  P_IL_StRpTaxItemLog.ACCOUNTINGDOCUMENT AS AccountingDocument,
  P_IL_StRpTaxItemLog.FISCALYEAR AS FiscalYear,
  P_IL_StRpTaxItemLog.TAXITEM AS TaxItem,
  StRpTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  StRpTaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  StRpTaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  StRpTaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  StRpTaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  StRpTaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  StRpTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  StRpTaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  StRpTaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  rec_type AS IL_VATRecordType,
  msgty AS SystemMessageType,
  msgid AS SystemMessageClass,
  msgno AS SystemMessageNumber,
  SystemMessageTextLong,
  StRpTaxItem.TaxCode AS TaxCode,
  StRpTaxItem.TaxReportingDate AS TaxReportingDate,
  StRpTaxItem.DocumentDate AS DocumentDate,
  StRpTaxItem.PostingDate AS PostingDate,
  StRpTaxItem.DocumentReferenceID AS DocumentReferenceID,
  StRpTaxItem.Supplier AS Supplier,
  StRpTaxItem.Customer AS Customer,
  StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  cast('ILODN' as odn_type_int) AS OfficialDocumentNumberIntType,
  cast(coalesce(StRpTaxItem._AccountingDocumentODN[1:OfficialDocumentNumberIntType = OfficialDocumentNumberIntType].OfficialDocumentNumber, StRpTaxItem.DocumentReferenceID ) as odn_value ) AS OfficialDocumentNumber
FROM P_IL_StRpTaxItemLog
INNER JOIN I_StRpTaxItem AS StRpTaxItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND AccountingDocument = _JournalEntry.AccountingDocument AND FiscalYear = _JournalEntry.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentAdditionalCurrency1 ON AdditionalCurrency1 = _DocumentAdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentAdditionalCurrency2 ON AdditionalCurrency2 = _DocumentAdditionalCurrency2.Currency  -- association [0..1]
;

Learn More