I_TaxBoxStructure2

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_TaxBoxStructure2.
-- 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: ITAXBOXSTRUC2

CREATE VIEW I_TaxBoxStructure2 AS
SELECT
  TaxBoxStructure.land1 AS Country,
  TaxBoxStructure.type AS TaxBoxStructureType,
  TaxBoxStructure.valid_from AS ValidFrom,
  TaxGroupBoxAssignment.tax_group AS TaxGroup,
  TaxGroup.mwskz AS TaxCode,
  TaxGroup.ktosl AS TransactionTypeDetermination,
  TaxGroupBoxAssignment.tax_box AS TaxBox,
  TaxBoxStructure.valid_to AS ValidTo,
  _TaxBoxStructureTypeText[1: langu = $session.system_language].text AS TaxBoxStructureTypeName,
  TaxBoxStructure.tax_box_struct AS TaxBoxStructure,
  tax_rept_country AS TaxCountry,
  _TaxBoxText[1: langu = $session.system_language].text AS TaxBoxName,
  TaxBox.tax_box_op_type AS TaxBoxOutputType,
  TaxBox.tax_box_cond AS TaxBoxCondition,
  TaxGroup.txdat_from AS TaxRateValidityStartDate,
  TaxGroup.txdat_to AS TaxRateValidityEndDate,
  TransactionKey.stazf AS TaxIsNotDeductible,
  TaxGroup.shkzg_umsv AS DebitCreditCode,
  TaxGroup.txjcd AS TaxJurisdiction,
  TaxGroup.blart AS AccountingDocumentType,
  TaxGroup.umskz AS SpecialGLCode,
  TaxGroup.ktokk AS SupplierAccountGroup,
  TaxGroup.opera AS TaxGroupOperation,
  TaxGroup.fc_code AS TaxGroupFreeClassification,
  TaxGroup.racct AS GLAccount,
  TaxGroupBoxAssignment.opera AS TaxBoxAggregationOperation
FROM fot_atr_tbs AS TaxBoxStructure
LEFT OUTER JOIN fot_atr_tbtg_map AS TaxGroupBoxAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fot_atr_tax_box AS TaxBox ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fot_atr_tax_grp AS TaxGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t007b AS TransactionKey ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fot_atr_tbs_typt AS _TaxBoxStructureTypeText ON Country = _TaxBoxStructureTypeText.land1 AND TaxBoxStructureType = _TaxBoxStructureTypeText.type  -- association [0..*]
LEFT OUTER JOIN fot_atr_tax_boxt AS _TaxBoxText ON Country = _TaxBoxText.land1 AND ValidFrom = _TaxBoxText.valid_from AND TaxBoxStructureType = _TaxBoxText.type AND TaxBox = _TaxBoxText.tax_box  -- association [0..*]
;