C_CO_DIANStRpBPTaxItemCube

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_CO_DIANStRpBPTaxItemCube.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_CompanyCode : fis_bukrs

CREATE VIEW C_CO_DIANStRpBPTaxItemCube AS
SELECT
  BPTaxItem.CompanyCode AS CompanyCode,
  BPTaxItem.AccountingDocument AS AccountingDocument,
  BPTaxItem.FiscalYear AS FiscalYear,
  BPTaxItem.TaxItem AS TaxItem,
  BPTaxItem.CO_DIANReportFormat AS CO_DIANReportFormat,
  BPTaxItem.CO_DIANReportItemType AS CO_DIANReportItemType,
  BPTaxItem.StatryRptgEntity AS StatryRptgEntity,
  BPTaxItem.StatryRptCategory AS StatryRptCategory,
  BPTaxItem.StatryRptRunID AS StatryRptRunID,
  BPTaxItem.ReportedTaxNumber AS ReportedTaxNumber,
  cast ( '' as ficodian_verification_digit preserving type ) AS TaxNumberVerificationDigit,
  BPTaxItem.TaxNumber1 AS TaxNumber1,
  BPTaxItem.TaxNumber2 AS TaxNumber2,
  BPTaxItem.TaxNumber3 AS TaxNumber3,
  BPTaxItem.TaxNumber4 AS TaxNumber4,
  BPTaxItem.TaxNumber5 AS TaxNumber5,
  BPTaxItem.VATRegistration AS VATRegistration,
  BPTaxItem.CO_DIANBPTaxLongNumber AS CO_DIANBPTaxLongNumber,
  BPTaxItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  BPTaxItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  BPTaxItem.CO_DIANTaxNumberType AS CO_DIANTaxNumberType,
  BPTaxItem.TaxNumberType AS TaxNumberType,
  _CO_DIANCountryMapping.CO_DIANCountry AS CO_DIANCountry,
  BPTaxItem.TaxReportingDate AS TaxReportingDate,
  BPTaxItem.DocumentDate AS DocumentDate,
  BPTaxItem.PostingDate AS PostingDate,
  BPTaxItem.ReportingDate AS ReportingDate,
  BPTaxItem.AccountingDocumentItem AS AccountingDocumentItem,
  BPTaxItem.AccountingDocumentType AS AccountingDocumentType,
  BPTaxItem.TaxCode AS TaxCode,
  BPTaxItem.TaxCodeName AS TaxCodeName,
  BPTaxItem.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  BPTaxItem.TaxType AS TaxType,
  BPTaxItem.TaxJurisdiction AS TaxJurisdiction,
  BPTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  BPTaxItem.GLAccount AS GLAccount,
  BPTaxItem.GLAccountName AS GLAccountName,
  BPTaxItem.Customer AS Customer,
  BPTaxItem.Supplier AS Supplier,
  BPTaxItem.BusinessPartnerCategory AS BusinessPartnerCategory,
  BPTaxItem.BusinessPartner AS BusinessPartner,
  BPTaxItem.BusinessPlace AS BusinessPlace,
  BPTaxItem.FirstName AS FirstName,
  BPTaxItem.MiddleName AS MiddleName,
  BPTaxItem.LastName AS LastName,
  BPTaxItem.AdditionalLastName AS AdditionalLastName,
  cast( concat( BPTaxItem.OrganizationBPName1, BPTaxItem.OrganizationBPName2 ) as ficodian_bp_org_long_name ) AS BusinessPartnerOrgLongName,
  BPTaxItem.OrganizationBPName1 AS OrganizationBPName1,
  BPTaxItem.OrganizationBPName2 AS OrganizationBPName2,
  BPTaxItem.OrganizationBPName3 AS OrganizationBPName3,
  BPTaxItem.OrganizationBPName4 AS OrganizationBPName4,
  BPTaxItem.IsNaturalPerson AS IsNaturalPerson,
  BPTaxItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  BPTaxItem.Region AS Region,
  BPTaxItem.StreetName AS StreetName,
  BPTaxItem.CityName AS CityName,
  BPTaxItem.ReferenceDocument AS ReferenceDocument,
  BPTaxItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  BPTaxItem.BusinessPartnerUUID AS BusinessPartnerUUID,
  BPTaxItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  BPTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  BPTaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  BPTaxItem.TaxReturnCountry AS TaxReturnCountry,
  BPTaxItem.ReportingCountry AS ReportingCountry,
  BPTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  BPTaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  BPTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  BPTaxItem.CountryCurrency AS CountryCurrency,
  BPTaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  BPTaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  BPTaxItem.ReportingCurrency AS ReportingCurrency,
  cast( BPTaxItem.TaxBaseAmountInRptgCrcy as ficodian_tax_base_amt preserving type ) AS TaxBaseAmountInRptgCrcy,
  cast( BPTaxItem.TaxAmountInRptgCrcy as ficodian_tax_amt preserving type ) AS TaxAmountInRptgCrcy,
  BPTaxItem.InptTxDebitAmtInCntryCurrency AS InptTxDebitAmtInCntryCurrency,
  BPTaxItem.OutpTxDebitAmtInCntryCurrency AS OutpTxDebitAmtInCntryCurrency,
  BPTaxItem.CO_VATHigherThanCostAmount AS CO_VATHigherThanCostAmount,
  BPTaxItem.OutpTxCrdtAmtInCntryCurrency AS OutpTxCrdtAmtInCntryCurrency,
  BPTaxItem.InptTxCrdtAmtInCntryCurrency AS InptTxCrdtAmtInCntryCurrency,
  BPTaxItem.CnsmpnTxAmtInCountryCurrency AS CnsmpnTxAmtInCountryCurrency
FROM P_CO_DIANStRpBPTaxItem4
;