P_CO_DIANFrmt1001JrnlEntrItem2

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_CO_DIANFrmt1001JrnlEntrItem2.
-- 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.
-- Parameters: P_Ledger : fins_ledger, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_CO_DIANFrmt1001JrnlEntrItem2 AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  VatTaxCode,
  ChartOfAccounts,
  GLAccount,
  CountryChartOfAccounts,
  AlternativeGLAccount,
  PostingDate,
  FinancialAccountType,
  PurchasingDocument,
  OneTimeAccountingDocument,
  CO_DIANBPTaxLongNumber,
  Reference1IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  Supplier,
  Customer,
  CompanyCodeCountry,
  BusinessPlace,
  AccountingDocumentType,
  CO_DIANAmountClassificationGL,
  CO_DIANAmountClassificationVAT,
  CO_DIANAmountClassfctnWhldg,
  ReportingCurrency,
  cast (case when CO_DIANAmountClassificationGL = 'PAGO' then TaxBaseAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_paymcred_dcblgl preserving type ) AS DcblGLAcctPaytsAmtInRptgCrcy,
  cast (case when CO_DIANAmountClassificationGL = 'PNDED' then TaxBaseAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_paymcred_nondcblgl preserving type ) AS NonDcblGLAcctPaytAmtInRptgCrcy,
  cast (case when CO_DIANAmountClassificationVAT = 'IDED' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_incrdcost_dcblvat preserving type ) AS DcblVATIncrdCostInRptgCrcy,
  cast (case when CO_DIANAmountClassificationVAT = 'INDED' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_incrdcost_nondcblvat preserving type ) AS NonDcblVATIncrdCostInRptgCrcy,
  cast (case when CO_DIANAmountClassfctnWhldg = 'RETP' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_prac_whldg_income preserving type ) AS WhldgTxIncAmtInRptgCurrency,
  cast (case when CO_DIANAmountClassfctnWhldg = 'RETA' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_taken_whldg_income preserving type ) AS TakenWhldgTaxIncAmtInRptgCrcy,
  cast (case when CO_DIANAmountClassfctnWhldg = 'COMUN' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_whldg_common_vat preserving type ) AS WhldgTaxCommonVATAmtInRptgCrcy,
  cast (case when CO_DIANAmountClassfctnWhldg = 'SIMP' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_tkn_whldg_spfd_vat preserving type ) AS TknWhldgSimpfdVATAmtInRptgCrcy,
  cast (case when CO_DIANAmountClassfctnWhldg = 'NDOM' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_prac_wht_foreign_vat preserving type ) AS WhldgTxForeignVATAmtInRptgCrcy,
  cast (case when CO_DIANAmountClassfctnWhldg = 'RCREE' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_prac_wht_cree preserving type ) AS CO_WhldgCREEAmtInRptgCurrency,
  cast (case when CO_DIANAmountClassfctnWhldg = 'RASUM' then TaxAmount else cast( 0 as abap.curr( 23, 2 ) ) end as ficodian_tkn_wht_cree preserving type ) AS CO_TknWhldgCREEAmtInRptgCrcy
FROM P_CO_DIANFrmt1001JrnlEntryItem
;