I_TaxItemProcessFlow

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_TaxItemProcessFlow.
-- 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 I_TaxItemProcessFlow AS
SELECT
  SAPObjectType.SAPObjectType AS SAPObjectType,
  cast( Taxitem.SourceReferenceDocument as txrg_taxflow_reference ) AS TaxFlowNodeReference,
  cast( Billing.FiscalYear as txrg_taxflow_year preserving type ) AS TaxFlowNodeYear,
  cast( '' as farp_blart ) AS AccountingDocumentType,
  cast( 'PO' as txrg_taxflow_status ) AS TaxFlowNodeStatus,
  cast( Billing.BillingDocumentDate as txrg_taxflow_date preserving type ) AS TaxFlowNodeDate,
  cast( Billing.CompanyCode as txrg_taxflow_companycode preserving type ) AS TaxFlowNodeCompanyCode,
  Taxitem.AccountingDocument AS AccountingDocument,
  Taxitem.FiscalYear AS FiscalYear,
  Taxitem.CompanyCode AS CompanyCode,
  Taxitem.TaxItemUUID AS TaxItemUUID,
  Taxitem.TaxCountry AS TaxCountry,
  Taxitem.TaxationType AS TaxationType,
  cast( '' as srf_rep_cat_id ) AS StatryRptCategory,
  cast( hextobin('00000000000000000000000000000000') as /bobf/conf_key preserving type ) AS StatryRptActivityUUID,
  cast( '' as bvorg ) AS IntercompanyTransaction,
  Billing.BillingDocumentType AS BillingDocumentType,
  Billing.SalesOrganization AS SalesOrganization,
  cast( '' as eopblocked ) AS IsEndOfPurposeBlocked,
  cast( '' as txrg_taxpybl_xblocked ) as TxPyblBizPurposeIsCompleted AS SAPObjectTypeasSAPObjectType,
  Taxitem.CreationDateTime AS TaxFlowNodeDateTime,
  '' AS TxPyblBizPurposeIsCompleted
FROM I_TransactionalTaxItem AS Taxitem
INNER JOIN I_BillingDocument AS Billing ON /* join condition not captured in parsed metadata */
INNER JOIN I_SAPObjectType AS SAPObjectType ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierInvoice AS SupplierInvoice ON /* join condition not captured in parsed metadata */
INNER JOIN I_StRpRunDetails AS ACR ON /* join condition not captured in parsed metadata */
INNER JOIN I_TaxPayableDocument AS TaxPayableDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS OperationalAcctgDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntry AS JournalEntry ON /* join condition not captured in parsed metadata */
INNER JOIN I_SAPObjectType ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_TransactionalTaxItem, I_TransactionalTaxItem
;