C_CN_TaxInvcBindgRecd

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_CN_TaxInvcBindgRecd.
-- 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 C_CN_TaxInvcBindgRecd AS
SELECT
  Active.CN_TaxInvcBindgUUID AS CN_TaxInvcBindgUUID,
  Active.CN_TaxInvcBindgItmUUID AS CN_TaxInvcBindgItmUUID,
  Active.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  Active.CN_TaxEntityID AS CN_TaxEntityID,
  Active.CN_TaxInvcBindgSrceBusObjType AS CN_TaxInvcBindgSrceBusObjType,
  _ObjectTypeDescription[ 1: Language = $session.system_language ].CN_TaxInvcSourceBusObjTypeDesc AS CN_TaxInvcSourceBusObjTypeDesc,
  Active.CN_TaxInvcBindgSrceBusObjKey AS CN_TaxInvcBindgSrceBusObjKey,
  Active.ObjectKey AS ObjectKey,
  cast('' as char40) AS DocumentStatusDesc,
  cast(' ' as boolean) AS IsDeleted,
  Active.CN_TxInvcJournalEntryKeysText AS CN_TxInvcJournalEntryKeysText
FROM C_CN_TaxInvcBindgRecdActv AS Active
LEFT OUTER JOIN C_CN_TaxInvcBindingConfignText AS _ObjectTypeDescription ON CN_TaxInvcBindgSrceBusObjType = _ObjectTypeDescription.CN_TaxInvcBindgSrceBusObjType  -- association [0..*]
-- UNION ALL with additional select branch(es): C_CN_TaxInvcBindgRecdDrft
;