C_IL_StRpWhldgTaxItemQuery

DDL: C_IL_STRPWHLDGTAXITEMQUERY SQL: CILACRWHTITMQRY Type: view CONSUMPTION Package: GLO_FIN_IS_WHT_IL
27 Fields 1 Data Sources

IL Withholding Tax Item For Statutory Reporting

C_IL_StRpWhldgTaxItemQuery is a Consumption CDS View that provides data about "IL Withholding Tax Item For Statutory Reporting" in SAP S/4HANA. It reads from 1 data source (I_IL_StRpWhldgTaxItem) and exposes 27 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. Part of development package GLO_FIN_IS_WHT_IL.

Data Sources (1)

SourceAliasJoin Type
I_IL_StRpWhldgTaxItem I_IL_StRpWhldgTaxItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CILACRWHTITMQRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label IL Withholding Tax Item For Statutory Reporting view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY WithholdingTaxType WithholdingTaxType WTax Type
PostingDate PostingDate Posting Date for GR
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
WhldgTaxAmtInCoCodeCrcy WhldgTaxAmtInCoCodeCrcy
WhldgTaxAmtInAddlCrcy2 WhldgTaxAmtInAddlCrcy2
WhldgTaxAmtInAddlCrcy3 WhldgTaxAmtInAddlCrcy3
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
WhldgTaxBaseAmtInCoCodeCrcy WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxBaseAmtInAddlCrcy2 WhldgTaxBaseAmtInAddlCrcy2
WhldgTaxBaseAmtInAddlCrcy3 WhldgTaxBaseAmtInAddlCrcy3
Debtor Debtor Debtor
Creditor Creditor Supplier
BusinessPartnerNumber BusinessPartnerNumber
Name Name Zone name
IL_WhldgTaxDocumentInfoText IL_WhldgTaxDocumentInfoText
IL_WhldgTaxDeductionInPercent IL_WhldgTaxDeductionInPercent

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 C_IL_StRpWhldgTaxItemQuery.
-- 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: CILACRWHTITMQRY

CREATE VIEW C_IL_StRpWhldgTaxItemQuery AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  WithholdingTaxType,
  PostingDate,
  AmountInCompanyCodeCurrency,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  WhldgTaxAmtInCoCodeCrcy,
  WhldgTaxAmtInAddlCrcy2,
  WhldgTaxAmtInAddlCrcy3,
  TaxAmountInCoCodeCrcy,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  WhldgTaxBaseAmtInCoCodeCrcy,
  WhldgTaxBaseAmtInAddlCrcy2,
  WhldgTaxBaseAmtInAddlCrcy3,
  Debtor,
  Creditor,
  BusinessPartnerNumber,
  Name,
  IL_WhldgTaxDocumentInfoText,
  IL_WhldgTaxDeductionInPercent
FROM I_IL_StRpWhldgTaxItem
;

Learn More