C_CL_StRpGlobalWhldgTxItmQ

DDL: C_CL_STRPGLOBALWHLDGTXITMQ Type: view_entity CONSUMPTION
73 Fields 1 Data Sources

CL Global Compl Tax Reporting - Query

C_CL_StRpGlobalWhldgTxItmQ is a Consumption CDS View that provides data about "CL Global Compl Tax Reporting - Query" in SAP S/4HANA. It reads from 1 data source (I_CL_StRpGlobalWhldgTxItmC) and exposes 73 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType.

Data Sources (1)

SourceAliasJoin Type
I_CL_StRpGlobalWhldgTxItmC wht from

Annotations (9)

NameValueLevelField
EndUserText.label CL Global Compl Tax Reporting - Query view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.query true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (73)

KeyFieldSource TableSource FieldDescription
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
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
ReportingDate ReportingDate
WithholdingTaxCode WithholdingTaxCode WTax Code
WhldgTaxCodeName WhldgTaxCodeName Withholding Tax Code Description
WithholdingTaxIncomeType WithholdingTaxIncomeType
OfficialWhldgTaxCode OfficialWhldgTaxCode
DocumentReferenceID DocumentReferenceID Reference
DocumentItemText DocumentItemText Text
WithholdingTaxCertificate WithholdingTaxCertificate WHT Certificate
CompanyCodeName CompanyCodeName Company Name
CompanyHouseNumber CompanyHouseNumber
CompanyStreetName CompanyStreetName
CompanyCodeCityName CompanyCodeCityName
CompanyDistrict CompanyDistrict
CompanyRegion CompanyRegion Region
RegionName RegionName Description
CompanyEmailAddress CompanyEmailAddress
CompanyFaxNumber CompanyFaxNumber
CompanyPhoneNumber CompanyPhoneNumber
CompanyCodeParameterValue CompanyCodeParameterValue Company Code
BusinessPartner I_CL_StRpGlobalWhldgTxItmC BusinessPartner Supplier/Customer
BusinessPartnerNumber I_CL_StRpGlobalWhldgTxItmC BusinessPartnerNumber
Name Name Zone name
TaxNumber1 TaxNumber1 VAT Reg. No.
Language Language Report Text Language
NumberOfBusinessPartners Number Of Business Partners
BusinessPartnerType BusinessPartnerType Undefined range (can be used for patch levels)
BusinessPartnerTypeDesc BusinessPartnerTypeDesc
WithholdingTaxPercent WithholdingTaxPercent
SupplierRecipientType SupplierRecipientType Recipient Type
CalendarMonth CalendarMonth Calendar Month
ReportingMonth ReportingMonth
ReportingCurrency ReportingCurrency Currency
WhldgTaxBaseAmtInCoCodeCrcy WhldgTaxBaseAmtInCoCodeCrcy Withholding Tax Base Amount
WhldgTaxAmtInCoCodeCrcy WhldgTaxAmtInCoCodeCrcy
GrossAmountInCoCodeCurrency GrossAmountInCoCodeCurrency
NetAmountInCoCodeCurrency NetAmountInCoCodeCurrency
CL_PersnWhgdTxAmtInCCCrcy CL_PersnWhgdTxAmtInCCCrcy
CL_Drctr01WhldgTaxAmtInCCCrcy CL_Drctr01WhldgTaxAmtInCCCrcy
CL_Drctr02WhldgTaxAmtInCCCrcy CL_Drctr02WhldgTaxAmtInCCCrcy
WhldgTxBase01AmtInCoCodeCrcy WhldgTxBase01AmtInCoCodeCrcy
WhldgTxBase02AmtInCoCodeCrcy WhldgTxBase02AmtInCoCodeCrcy
WhldgTxBase03AmtInCoCodeCrcy WhldgTxBase03AmtInCoCodeCrcy
WhldgTxBase04AmtInCoCodeCrcy WhldgTxBase04AmtInCoCodeCrcy
WhldgTxBase05AmtInCoCodeCrcy WhldgTxBase05AmtInCoCodeCrcy
WhldgTxBase06AmtInCoCodeCrcy WhldgTxBase06AmtInCoCodeCrcy
WhldgTxBase07AmtInCoCodeCrcy WhldgTxBase07AmtInCoCodeCrcy
WhldgTxBase08AmtInCoCodeCrcy WhldgTxBase08AmtInCoCodeCrcy
WhldgTxBase09AmtInCoCodeCrcy WhldgTxBase09AmtInCoCodeCrcy
WhldgTxBase10AmtInCoCodeCrcy WhldgTxBase10AmtInCoCodeCrcy
WhldgTxBase11AmtInCoCodeCrcy WhldgTxBase11AmtInCoCodeCrcy
WhldgTxBase12AmtInCoCodeCrcy WhldgTxBase12AmtInCoCodeCrcy
TransactionCurrency I_CL_StRpGlobalWhldgTxItmC TransactionCurrency Transaction Currency
AdditionalCurrency1 I_CL_StRpGlobalWhldgTxItmC AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_CL_StRpGlobalWhldgTxItmC AdditionalCurrency2 Local curr. 3
WhldgTaxBaseAmtInTransacCrcy I_CL_StRpGlobalWhldgTxItmC WhldgTaxBaseAmtInTransacCrcy
WhldgTaxBaseAmtInAddlCrcy2 I_CL_StRpGlobalWhldgTxItmC WhldgTaxBaseAmtInAddlCrcy2
WhldgTaxBaseAmtInAddlCrcy3 I_CL_StRpGlobalWhldgTxItmC WhldgTaxBaseAmtInAddlCrcy3
WhldgTaxAmtInTransacCrcy I_CL_StRpGlobalWhldgTxItmC WhldgTaxAmtInTransacCrcy
WhldgTaxAmtInAddlCrcy2 I_CL_StRpGlobalWhldgTxItmC WhldgTaxAmtInAddlCrcy2
WhldgTaxAmtInAddlCrcy3 I_CL_StRpGlobalWhldgTxItmC WhldgTaxAmtInAddlCrcy3
AmountInTransactionCurrency I_CL_StRpGlobalWhldgTxItmC AmountInTransactionCurrency Pt Crcy Amt
AmountInAdditionalCurrency1 I_CL_StRpGlobalWhldgTxItmC AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 I_CL_StRpGlobalWhldgTxItmC AmountInAdditionalCurrency2 LC2 Amount

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_CL_StRpGlobalWhldgTxItmQ.
-- 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 C_CL_StRpGlobalWhldgTxItmQ AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  WithholdingTaxType,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  PostingDate,
  DocumentDate,
  ReportingDate,
  WithholdingTaxCode,
  WhldgTaxCodeName,
  WithholdingTaxIncomeType,
  OfficialWhldgTaxCode,
  DocumentReferenceID,
  DocumentItemText,
  WithholdingTaxCertificate,
  CompanyCodeName,
  CompanyHouseNumber,
  CompanyStreetName,
  CompanyCodeCityName,
  CompanyDistrict,
  CompanyRegion,
  RegionName,
  CompanyEmailAddress,
  CompanyFaxNumber,
  CompanyPhoneNumber,
  CompanyCodeParameterValue,
  wht.BusinessPartner AS BusinessPartner,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  Name,
  TaxNumber1,
  Language,
  cast(0 as abap.int2) AS NumberOfBusinessPartners,
  BusinessPartnerType,
  BusinessPartnerTypeDesc,
  WithholdingTaxPercent,
  SupplierRecipientType,
  CalendarMonth,
  ReportingMonth,
  ReportingCurrency,
  WhldgTaxBaseAmtInCoCodeCrcy,
  WhldgTaxAmtInCoCodeCrcy,
  GrossAmountInCoCodeCurrency,
  NetAmountInCoCodeCurrency,
  CL_PersnWhgdTxAmtInCCCrcy,
  CL_Drctr01WhldgTaxAmtInCCCrcy,
  CL_Drctr02WhldgTaxAmtInCCCrcy,
  WhldgTxBase01AmtInCoCodeCrcy,
  WhldgTxBase02AmtInCoCodeCrcy,
  WhldgTxBase03AmtInCoCodeCrcy,
  WhldgTxBase04AmtInCoCodeCrcy,
  WhldgTxBase05AmtInCoCodeCrcy,
  WhldgTxBase06AmtInCoCodeCrcy,
  WhldgTxBase07AmtInCoCodeCrcy,
  WhldgTxBase08AmtInCoCodeCrcy,
  WhldgTxBase09AmtInCoCodeCrcy,
  WhldgTxBase10AmtInCoCodeCrcy,
  WhldgTxBase11AmtInCoCodeCrcy,
  WhldgTxBase12AmtInCoCodeCrcy,
  wht.TransactionCurrency AS TransactionCurrency,
  wht.AdditionalCurrency1 AS AdditionalCurrency1,
  wht.AdditionalCurrency2 AS AdditionalCurrency2,
  wht.WhldgTaxBaseAmtInTransacCrcy AS WhldgTaxBaseAmtInTransacCrcy,
  wht.WhldgTaxBaseAmtInAddlCrcy2 AS WhldgTaxBaseAmtInAddlCrcy2,
  wht.WhldgTaxBaseAmtInAddlCrcy3 AS WhldgTaxBaseAmtInAddlCrcy3,
  wht.WhldgTaxAmtInTransacCrcy AS WhldgTaxAmtInTransacCrcy,
  wht.WhldgTaxAmtInAddlCrcy2 AS WhldgTaxAmtInAddlCrcy2,
  wht.WhldgTaxAmtInAddlCrcy3 AS WhldgTaxAmtInAddlCrcy3,
  wht.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  wht.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  wht.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2
FROM I_CL_StRpGlobalWhldgTxItmC AS wht
;

Learn More