P_CO_DIANFrmt1001JrnlEntrItem3

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_DIANFrmt1001JrnlEntrItem3.
-- 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_DIANFrmt1001JrnlEntrItem3 AS
SELECT
  DIANJournalEntryItem.StatryRptgEntity AS StatryRptgEntity,
  DIANJournalEntryItem.StatryRptCategory AS StatryRptCategory,
  DIANJournalEntryItem.StatryRptRunID AS StatryRptRunID,
  DIANJournalEntryItem.CO_DIANReportFormat AS CO_DIANReportFormat,
  DIANJournalEntryItem.CO_DIANReportItemType AS CO_DIANReportItemType,
  DIANJournalEntryItem.Ledger AS Ledger,
  DIANJournalEntryItem.CompanyCode AS CompanyCode,
  DIANJournalEntryItem.FiscalYear AS FiscalYear,
  DIANJournalEntryItem.AccountingDocument AS AccountingDocument,
  DIANJournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  DIANJournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  DIANJournalEntryItem.GLAccount AS GLAccount,
  DIANJournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  DIANJournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  DIANJournalEntryItem.PostingDate AS PostingDate,
  DIANJournalEntryItem.FinancialAccountType AS FinancialAccountType,
  DIANJournalEntryItem.PurchasingDocument AS PurchasingDocument,
  DIANJournalEntryItem.OneTimeAccountingDocument AS OneTimeAccountingDocument,
  DIANJournalEntryItem.CO_DIANBPTaxLongNumber AS CO_DIANBPTaxLongNumber,
  DIANJournalEntryItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  DIANJournalEntryItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  DIANJournalEntryItem.Supplier AS Supplier,
  DIANJournalEntryItem.Customer AS Customer,
  DIANJournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  DIANJournalEntryItem.BusinessPlace AS BusinessPlace,
  cast( coalesce(coalesce(_OneTimeAccountBP.IsNaturalPerson , _Supplier.IsNaturalPerson), _Customer.NFPartnerIsNaturalPerson ) as stkzn preserving type ) AS IsNaturalPerson,
  cast( coalesce( _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerCategory, _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory ) as bu_type preserving type ) AS BusinessPartnerCategory,
  cast( coalesce( _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner, _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner ) as bu_partner preserving type ) AS BusinessPartner,
  cast( coalesce(coalesce(_OneTimeAccountBP.Country,_Supplier._AddressRepresentation.Country), _Customer._AddressRepresentation.Country ) as land1 preserving type ) AS BusinessPartnerCountry,
  cast( coalesce(coalesce(_OneTimeAccountBP.Region,_Supplier._AddressRepresentation.Region), _Customer._AddressRepresentation.Region ) as regio preserving type ) AS Region,
  cast( coalesce(coalesce(_OneTimeAccountBP._Address.CityCode,_Supplier._AddressRepresentation.CityNumber), _Customer._AddressRepresentation.CityNumber) as ad_citynum preserving type ) AS CityCode,
  cast( coalesce(coalesce(_OneTimeAccountBP.CityName,_Supplier._AddressRepresentation.CityName), _Customer._AddressRepresentation.CityName ) as ad_city1 preserving type ) AS CityName,
  cast( coalesce(coalesce(_OneTimeAccountBP.StreetAddressName,_Supplier._AddressRepresentation.StreetName), _Customer._AddressRepresentation.StreetName ) as ad_street preserving type ) AS StreetName,
  DIANJournalEntryItem.CompanyCodeCountry AS CompanyCodeCountry,
  DIANJournalEntryItem.CO_DIANAmountClassificationGL AS CO_DIANAmountClassificationGL,
  DIANJournalEntryItem.CO_DIANAmountClassificationVAT AS CO_DIANAmountClassificationVAT,
  DIANJournalEntryItem.CO_DIANAmountClassfctnWhldg AS CO_DIANAmountClassfctnWhldg,
  DIANJournalEntryItem.ReportingCurrency AS ReportingCurrency,
  DIANJournalEntryItem.DcblGLAcctPaytsAmtInRptgCrcy AS DcblGLAcctPaytsAmtInRptgCrcy,
  DIANJournalEntryItem.NonDcblGLAcctPaytAmtInRptgCrcy AS NonDcblGLAcctPaytAmtInRptgCrcy,
  DIANJournalEntryItem.DcblVATIncrdCostInRptgCrcy AS DcblVATIncrdCostInRptgCrcy,
  DIANJournalEntryItem.NonDcblVATIncrdCostInRptgCrcy AS NonDcblVATIncrdCostInRptgCrcy,
  DIANJournalEntryItem.WhldgTxIncAmtInRptgCurrency AS WhldgTxIncAmtInRptgCurrency,
  DIANJournalEntryItem.TakenWhldgTaxIncAmtInRptgCrcy AS TakenWhldgTaxIncAmtInRptgCrcy,
  DIANJournalEntryItem.WhldgTaxCommonVATAmtInRptgCrcy AS WhldgTaxCommonVATAmtInRptgCrcy,
  DIANJournalEntryItem.TknWhldgSimpfdVATAmtInRptgCrcy AS TknWhldgSimpfdVATAmtInRptgCrcy,
  DIANJournalEntryItem.WhldgTxForeignVATAmtInRptgCrcy AS WhldgTxForeignVATAmtInRptgCrcy,
  DIANJournalEntryItem.CO_WhldgCREEAmtInRptgCurrency AS CO_WhldgCREEAmtInRptgCurrency,
  DIANJournalEntryItem.CO_TknWhldgCREEAmtInRptgCrcy AS CO_TknWhldgCREEAmtInRptgCrcy,
  DIANJournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
  DIANJournalEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  DIANJournalEntryItem._CompanyCode AS _CompanyCode,
  DIANJournalEntryItem._Country AS _Country,
  DIANJournalEntryItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
  DIANJournalEntryItem._FinancialAccountType AS _FinancialAccountType,
  DIANJournalEntryItem._FiscalYear AS _FiscalYear,
  DIANJournalEntryItem._JournalEntry AS _JournalEntry,
  DIANJournalEntryItem._Ledger AS _Ledger,
  DIANJournalEntryItem._PurchasingDocument AS _PurchasingDocument,
  DIANJournalEntryItem._ReportingCurrency AS _ReportingCurrency,
  DIANJournalEntryItem._Customer AS _Customer,
  DIANJournalEntryItem._OneTimeAccountBP AS _OneTimeAccountBP,
  DIANJournalEntryItem._Supplier AS _Supplier
FROM P_CO_DIANFrmt1001JrnlEntrItem2
LEFT OUTER JOIN I_CO_DIANTaxNumberTypeMapping AS _DIANTaxNumberTypeMapping ON _DIANTaxNumberTypeMapping.TaxNumberType = TaxNumberType  -- association [0..1]
LEFT OUTER JOIN I_CO_DIANCountryMapping AS _CO_DIANCountryMapping ON _CO_DIANCountryMapping.Country = BusinessPartnerCountry  -- association [0..1]
LEFT OUTER JOIN I_CO_DIANCountryMapping AS _CompanyCodeCountryMapping ON _CompanyCodeCountryMapping.Country = CompanyCodeCountry  -- association [0..1]
LEFT OUTER JOIN C_CO_DIANCityCode AS _DIANCityCode ON BusinessPartnerCountry = _DIANCityCode.Country AND Region = _DIANCityCode.Region AND CityName = _DIANCityCode.CityName  -- association [0..1]
;