I_TaxBoxStructure

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_TaxBoxStructure.
-- 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: ITAXBOXSTRUC

CREATE VIEW I_TaxBoxStructure AS
SELECT
  TaxBoxStructure.mandt AS SAPClient,
  TaxBoxStructure.land1 AS Country,
  TaxBoxStructure.fdate AS TaxBoxStrucValidityStartDate,
  cast (TaxBoxStructure.tbstype as fot_atr_tax_box_struct_type) AS TaxBoxStructureType,
  TaxGroupBoxAssignment.acr_tg AS TaxGroup,
  TaxGroup.mwskz AS TaxCode,
  TaxGroup.ktosl AS TransactionTypeDetermination,
  TaxGroup.shkzg_umsv AS DebitCreditCode,
  TaxGroup.blart AS AccountingDocumentType,
  TaxGroup.umskz AS SpecialGLCode,
  TaxGroup.ktokk AS SupplierAccountGroup,
  case when TaxBoxStructureValidTo.ValidTo = '99991231' then TaxBoxStructureValidTo.ValidTo else dats_add_days(TaxBoxStructureValidTo.ValidTo, -1, 'INITIAL' ) end as ValidTo AS ValidTo1INITIALendasValidTo,
  TaxBoxStructure.fdate AS ValidFrom,
  cast (TaxBoxStructure.tsxbstr as fot_atr_tax_box_structure) AS TaxBoxStructure,
  _TaxBoxStructureText[1: langu = $session.system_language].txt50 AS TaxBoxStructureName,
  TaxGroupBoxAssignment.taxbox AS TaxBox,
  _TaxBoxText[1: langu = $session.system_language].tbname AS TaxBoxName,
  TaxBox.tb_condition AS TaxBoxCondition,
  TaxBox.taxbox_ot AS TaxBoxOutputType,
  division(TaxGroup.kbetr,100,2) AS TaxRate,
  TaxGroup.opera AS TaxGroupOperation,
  TaxGroupBoxAssignment.operation AS TaxBoxAggregationOperation
FROM vgtbs AS TaxBoxStructure
INNER JOIN P_TaxBoxStructureValidTo2 AS TaxBoxStructureValidTo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vgtgtb AS TaxGroupBoxAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vgtaxbox AS TaxBox ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vgtaxgr AS TaxGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vgtbst AS _TaxBoxStructureText ON Country = _TaxBoxStructureText.land1 AND ValidFrom = _TaxBoxStructureText.fdate AND TaxBoxStructure.tbstype = _TaxBoxStructureText.tbstype  -- association [0..*]
LEFT OUTER JOIN vgtaxboxt AS _TaxBoxText ON Country = _TaxBoxText.land1 AND ValidFrom = _TaxBoxText.fdate AND TaxBoxStructure.tbstype = _TaxBoxText.tbstyp AND TaxBox = _TaxBoxText.taxbox  -- association [0..*]
;