I_IL_StRpWhldgTaxItemLog

DDL: I_IL_STRPWHLDGTAXITEMLOG SQL: IILSTRPWHTITMLOG Type: view COMPOSITE Package: GLO_FIN_IS_WHT_IL
12 Fields 1 Data Sources 1 Associations

IL WHT reported item log

I_IL_StRpWhldgTaxItemLog is a Composite CDS View that provides data about "IL WHT reported item log" in SAP S/4HANA. It reads from 1 data source (I_StRpWhldgTaxItemLog) and exposes 12 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. It has 1 association to related views. Part of development package GLO_FIN_IS_WHT_IL.

Data Sources (1)

SourceAliasJoin Type
I_StRpWhldgTaxItemLog I_StRpWhldgTaxItemLog from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_IL_WhldgTaxDomainText _IL_WhldgTaxDomainText I_StRpWhldgTaxItemLog.IL_WhldgTaxDocumentInfo = _IL_WhldgTaxDomainText.DomainValueLow and _IL_WhldgTaxDomainText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IILSTRPWHTITMLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label IL WHT reported item log view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_StRpWhldgTaxItemLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpWhldgTaxItemLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpWhldgTaxItemLog StatryRptRunID Report Run ID
KEY CompanyCode I_StRpWhldgTaxItemLog CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpWhldgTaxItemLog AccountingDocument Journal Entry
KEY FiscalYear I_StRpWhldgTaxItemLog FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_StRpWhldgTaxItemLog AccountingDocumentItem Posting View Item
KEY WithholdingTaxType I_StRpWhldgTaxItemLog WithholdingTaxType WTax Type
IL_WhldgTaxDocumentInfo I_StRpWhldgTaxItemLog IL_WhldgTaxDocumentInfo Document Info Code
IL_WhldgTaxDeductionInPercent I_StRpWhldgTaxItemLog IL_WhldgTaxDeductionInPercent WHT Deduction Perc.
IL_WhldgTaxDocumentInfoText
_IL_WhldgTaxDomainText _IL_WhldgTaxDomainText

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_StRpWhldgTaxItemLog.
-- 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: IILSTRPWHTITMLOG

CREATE VIEW I_IL_StRpWhldgTaxItemLog AS
SELECT
  I_StRpWhldgTaxItemLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpWhldgTaxItemLog.StatryRptCategory AS StatryRptCategory,
  I_StRpWhldgTaxItemLog.StatryRptRunID AS StatryRptRunID,
  I_StRpWhldgTaxItemLog.CompanyCode AS CompanyCode,
  I_StRpWhldgTaxItemLog.AccountingDocument AS AccountingDocument,
  I_StRpWhldgTaxItemLog.FiscalYear AS FiscalYear,
  I_StRpWhldgTaxItemLog.AccountingDocumentItem AS AccountingDocumentItem,
  I_StRpWhldgTaxItemLog.WithholdingTaxType AS WithholdingTaxType,
  I_StRpWhldgTaxItemLog.IL_WhldgTaxDocumentInfo AS IL_WhldgTaxDocumentInfo,
  I_StRpWhldgTaxItemLog.IL_WhldgTaxDeductionInPercent AS IL_WhldgTaxDeductionInPercent,
  cast ( _IL_WhldgTaxDomainText.IL_WhldgTaxDocumentInfoText as /atl/documentinfotext ) AS IL_WhldgTaxDocumentInfoText
FROM I_StRpWhldgTaxItemLog
LEFT OUTER JOIN I_IL_WhldgTaxDomainText AS _IL_WhldgTaxDomainText ON I_StRpWhldgTaxItemLog.IL_WhldgTaxDocumentInfo = _IL_WhldgTaxDomainText.DomainValueLow AND _IL_WhldgTaxDomainText.Language = $session.system_language  -- association [0..1]
;

Learn More