I_Fr_Strpwhldgtaxitem

DDL: I_FR_STRPWHLDGTAXITEM Type: view_entity COMPOSITE
41 Fields 1 Data Sources 1 Associations

WHT Item For Statutory Reporting France

I_Fr_Strpwhldgtaxitem is a Composite CDS View (Cube) that provides data about "WHT Item For Statutory Reporting France" in SAP S/4HANA. It reads from 1 data source (I_CustomerToBusinessPartner) and exposes 41 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustomerToBusinessPartner _cbp inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _ReportingCurrency $projection.ReportingCurrency = _ReportingCurrency.Currency

Annotations (10)

NameValueLevelField
EndUserText.label WHT Item For Statutory Reporting France view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.technicalName ISRFRWHLDGTXITM view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode WhldgTxItem CompanyCode Receiver Company Code
KEY AccountingDocument WhldgTxItem AccountingDocument Journal Entry
KEY FiscalYear WhldgTxItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem WhldgTxItem AccountingDocumentItem Posting View Item
KEY WithholdingTaxType WhldgTxItem WithholdingTaxType WTax Type
KEY StatryRptgEntity WhldgTxItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory WhldgTxItem StatryRptCategory Report ID
KEY StatryRptRunID WhldgTxItem StatryRptRunID Report Run ID
OfficialWhldgTaxCode WhldgTxItem OfficialWhldgTaxCode
WithholdingTaxCode WhldgTxItem WithholdingTaxCode WTax Code
Creditor WhldgTxItem Creditor Supplier
PostingDate WhldgTxItem PostingDate Posting Date for GR
Debtor WhldgTxItem Debtor Debtor
BusinessPartnerNumber WhldgTxItem BusinessPartnerNumber
ReportingDate
ReportingCurrency WhldgTxItem ReportingCurrency Currency
WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy
WhldgTaxExmptAmtInCoCodeCrcy WhldgTxItem WhldgTaxExmptAmtInCoCodeCrcy
BusinessPartner
CompanyCodeName
FullName
PhoneNumber
CityName
HouseNumber
StreetName
PostalCode
HomeCityName
IsOneTimeAccountendasIsOneTimeAccount
BPTaxNumberendasstcd1asTaxNumber1
TaxNumber2
Nameendasglo_partnerasName
Buildingendasad_bldngasBuilding
CustomerSupplierStreetName
CustomerSupplierPostalCode
CustomerSupplierCityName
CountryendasCountry
_ReportingCurrency _ReportingCurrency
IsReversed WhldgTxItem IsReversed Reversed?
IsReversal WhldgTxItem IsReversal Reversal doc.
SpecialGLCode WhldgTxItem SpecialGLCode Special G/L Ind

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_Fr_Strpwhldgtaxitem.
-- 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 I_Fr_Strpwhldgtaxitem AS
SELECT
  WhldgTxItem.CompanyCode AS CompanyCode,
  WhldgTxItem.AccountingDocument AS AccountingDocument,
  WhldgTxItem.FiscalYear AS FiscalYear,
  WhldgTxItem.AccountingDocumentItem AS AccountingDocumentItem,
  WhldgTxItem.WithholdingTaxType AS WithholdingTaxType,
  WhldgTxItem.StatryRptgEntity AS StatryRptgEntity,
  WhldgTxItem.StatryRptCategory AS StatryRptCategory,
  WhldgTxItem.StatryRptRunID AS StatryRptRunID,
  WhldgTxItem.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  WhldgTxItem.WithholdingTaxCode AS WithholdingTaxCode,
  WhldgTxItem.Creditor AS Creditor,
  WhldgTxItem.PostingDate AS PostingDate,
  WhldgTxItem.Debtor AS Debtor,
  WhldgTxItem.BusinessPartnerNumber AS BusinessPartnerNumber,
  cast( WhldgTxItem.ReportingDate as ftr_reporting_date) AS ReportingDate,
  WhldgTxItem.ReportingCurrency AS ReportingCurrency,
  cast ( WhldgTxItem.WhldgTaxBaseAmtInCoCodeCrcy as fis_qsshh) AS WhldgTaxBaseAmtInCoCodeCrcy,
  cast ( WhldgTxItem.WhldgTaxAmtInCoCodeCrcy as fis_qbshh) AS WhldgTaxAmtInCoCodeCrcy,
  WhldgTxItem.WhldgTaxExmptAmtInCoCodeCrcy AS WhldgTaxExmptAmtInCoCodeCrcy,
  cast(WhldgTxItem.BusinessPartner as /scdl/dl_partyno) AS BusinessPartner,
  WhldgTxItem._CompanyCode.CompanyCodeName AS CompanyCodeName,
  WhldgTxItem._CompanyCode._Address.FullName AS FullName,
  WhldgTxItem._CompanyCode._Address._DefaultPhoneNumber.PhoneNumber AS PhoneNumber,
  WhldgTxItem._CompanyCode.CityName AS CityName,
  WhldgTxItem._CompanyCode._Address.HouseNumber AS HouseNumber,
  WhldgTxItem._CompanyCode._Address.StreetName AS StreetName,
  WhldgTxItem._CompanyCode._Address.PostalCode AS PostalCode,
  WhldgTxItem._CompanyCode._Address.HomeCityName AS HomeCityName,
  case when WhldgTxItem.Debtor = '' then WhldgTxItem._Supplier.IsOneTimeAccount else WhldgTxItem._Customer.IsOneTimeAccount end as IsOneTimeAccount AS IsOneTimeAccountendasIsOneTimeAccount,
  cast(case when WhldgTxItem.Creditor = '' and WhldgTxItem._Customer.IsOneTimeAccount = 'X' then WhldgTxItem.TaxNumber1 when WhldgTxItem.Debtor = '' and WhldgTxItem._Supplier.IsOneTimeAccount = 'X' then WhldgTxItem.TaxNumber1 else BPTxNmbr1.BPTaxNumber end as stcd1) as TaxNumber1 AS BPTaxNumberendasstcd1asTaxNumber1,
  cast(BPTxNmbr2.BPTaxNumber as stcd2) AS TaxNumber2,
  cast(case when BP.BusinessPartnerCategory = '1' then '' else WhldgTxItem.Name end as glo_partner) as Name AS Nameendasglo_partnerasName,
  cast(case when WhldgTxItem.Debtor = '' then WhldgTxItem._Supplier._StandardAddress.Building else WhldgTxItem._Customer._StandardAddress.Building end as ad_bldng) as Building AS Buildingendasad_bldngasBuilding,
  cast( WhldgTxItem.StreetName as glo_partner_street ) AS CustomerSupplierStreetName,
  cast( WhldgTxItem.PostalCode as glo_partner_pocode) AS CustomerSupplierPostalCode,
  cast( WhldgTxItem.CityName as glo_partner_cityname) AS CustomerSupplierCityName,
  case when WhldgTxItem.Debtor = '' then WhldgTxItem._Supplier._StandardAddress.Country else WhldgTxItem._Customer._StandardAddress.Country end as Country AS CountryendasCountry,
  WhldgTxItem.IsReversed AS IsReversed,
  WhldgTxItem.IsReversal AS IsReversal,
  WhldgTxItem.SpecialGLCode AS SpecialGLCode
INNER JOIN I_CustomerToBusinessPartner AS _cbp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
;

Learn More