P_PT_CADocumentTaxBoxConfig

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 P_PT_CADocumentTaxBoxConfig.
-- 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 P_PT_CADocumentTaxBoxConfig AS
SELECT
  _tax_item.CompanyCode AS CompanyCode,
  '' AS AccountingDocument,
  FiscalYear.FiscalYear AS FiscalYear,
  '000' AS TaxItem,
  _tax_map.TransactionTypeDetermination AS TransactionTypeDetermination,
  _tax_item.DebitCreditCode AS DebitCreditCode,
  _tax_map.AccountingDocumentType AS AccountingDocumentType,
  _tax_map.SupplierAccountGroup AS SupplierAccountGroup,
  _tax_map.TaxBox AS TaxBox,
  _tax_map.TaxDeclnAmountType AS TaxDeclnAmountType,
  _tax_map.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  _tax_map.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  _tax_map.TaxGroup AS TaxGroup,
  _tax_item.DebitCreditCode AS TaxItemGrpgDebitCreditCode,
  _tax_map.AccountingDocumentType AS TaxItemGrpgAcctgDocumentType,
  _tax_map.SupplierAccountGroup AS TaxItemGrpgSupplierAcctGroup,
  _tax_map.SpecialGLCode AS TaxItemGrpgSpecialGLCode,
  _tax_item.CADocumentNumber AS CADocumentNumber,
  _tax_item.CAGLItemNumber AS CAGLItemNumber,
  _tax_item.Country AS Country,
  _tax_map.TaxCode AS TaxCode,
  _tax_map.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  _tax_map.TaxBoxStructureType AS TaxBoxStructureType,
  _tax_map.TaxBoxStrucValidityEndDate AS ValidityEndDate,
  _tax_item.TaxCalculationProcedure AS TaxCalculationProcedure,
  _tax_map.TaxRate AS TaxRate,
  _tax_map.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  _tax_item.GLAccount AS GLAccount,
  '' AS TaxItemGroup,
  cast( '' as blart ) AS ReferenceDocumentType,
  _tax_item.CAReferenceDocument AS DocumentReferenceID,
  _tax_item.CAPostingDate AS PostingDate,
  _tax_item.DocumentDate AS DocumentDate,
  case when _tax_item.TaxReportingDate is initial then cast(_tax_item.CAPostingDate as vatdate preserving type) else _tax_item.TaxReportingDate end as TaxReportingDate AS TaxReportingDateendasTaxReportingDate,
  TaxReportingDate AS ReportingDate,
  FiscalYear.FiscalPeriod AS FiscalPeriod,
  '' AS AccountingDocumentHeaderText,
  _tax_item.Country AS CompanyCodeCountry,
  _tax_item.Country AS ReportingCountry,
  _tax_item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _tax_item.TransactionCurrency AS DocumentCurrency,
  _tax_item.CompanyCodeCurrency AS ReportingCurrency,
  _tax_item.CATaxBaseAmountInLocalCurrency AS TaxBaseAmountInRptgCrcy,
  _tax_item.CATaxAmountInLocalCurrency AS TaxAmountInRptgCrcy,
  0.00 AS NonDeductibleInputTaxAmount,
  _tax_item.CATaxBaseAmountInLocalCurrency AS TaxBaseAmountInCoCodeCrcy,
  _tax_item.CATaxAmountInLocalCurrency AS TaxAmountInCoCodeCrcy,
  _tax_item.CATaxBaseAmount AS TaxBaseAmountInTransCrcy,
  _tax_item.CATaxAmount AS TaxAmount,
  '' AS InvoiceReference,
  cast('' as fis_gjahr_no_conv) AS InvoiceReferenceFiscalYear,
  _tax_item.CAInvoicingDocument AS CAInvoicingDocument,
  '#' AS Customer,
  '#' AS Supplier,
  BPTaxNumber AS VATRegistration,
  BPTaxNumber AS CustomerSupplierVATRegn,
  _tax_item.CATransactionKeyAccountDetn AS CATransactionKeyAccountDetn,
  _tax_map.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  _tax_map.TaxBoxStructure AS TaxBoxStructure,
  _tax_map.TaxBoxName AS TaxBoxName,
  _tax_map.TaxBoxCondition AS TaxBoxCondition,
  _tax_item.TaxJurisdiction AS TaxJurisdiction,
  _tax_item.CATaxRate AS CATaxRate,
  _tax_item.Country AS TaxCountry,
  _tax_item.CAPostingDate AS CAPostingDate,
  _tax_item.CAReconciliationAccount AS CAReconciliationAccount,
  _tax_item.BusinessPartner AS BusinessPartner,
  _BPAddress.Country AS BusinessPartnerCountry,
  _tax_item.TransactionCurrency AS TransactionCurrency,
  case when _bp_taxnum[1: BPTaxType = 'PT0' ].BPTaxNumber is not initial then _bp_taxnum[1: BPTaxType = 'PT0'].BPTaxNumber when _bp_taxnum[1: BPTaxType = 'PT1' ].BPTaxNumber is not initial then _bp_taxnum[1: BPTaxType = 'PT1'].BPTaxNumber end as BPTaxNumber AS BPTaxNumberendasBPTaxNumber,
  _tax_item.FiscalYearVariant AS FiscalYearVariant,
  _tax_item.CAReconciliationKey AS CAReconciliationKey,
  P_T007B_GLO.stazf AS TaxIsNotDeductible,
  P_T007B_GLO.stgrp AS TaxType7B,
  _tax_map.TaxBoxStructureName AS TaxBoxStructureName,
  _tax_item.TaxReturnCountry AS TaxReturnCountry,
  _tax_item.TaxType AS TaxType,
  _tax_item.TargetTaxCode AS TargetTaxCode
FROM P_PT_CADOCUMENTTAXBOXCONFIG2 AS _tax_item
INNER JOIN I_StRpTaxItemBoxConfiguration ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_T007B_GLO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerAddress AS _BPAddress ON BusinessPartner = _BPAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _bp_taxnum ON _bp_taxnum.BusinessPartner = _tax_item.BusinessPartner  -- association [1..*]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_TaxTypeText AS _Text ON TaxType = _Text.TaxType  -- association [0..*]
LEFT OUTER JOIN I_FiscalCalendarDate AS FiscalYear ON FiscalYear.CalendarDate = _tax_item.CAPostingDate AND FiscalYear.FiscalYearVariant = _tax_item.FiscalYearVariant  -- association [1..1]
;