P_CO_DIANStRpSuplrCustOplVw2

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_DIANStRpSuplrCustOplVw2.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_CO_DIANStRpSuplrCustOplVw2 AS
SELECT
  OperationalView.StatryRptgEntity AS StatryRptgEntity,
  OperationalView.StatryRptCategory AS StatryRptCategory,
  OperationalView.StatryRptRunID AS StatryRptRunID,
  OperationalView.Ledger AS Ledger,
  OperationalView.SourceLedger AS SourceLedger,
  OperationalView.CompanyCode AS CompanyCode,
  OperationalView.FiscalYear AS FiscalYear,
  OperationalView.AccountingDocument AS AccountingDocument,
  OperationalView.LedgerGLLineItem AS LedgerGLLineItem,
  OperationalView.CO_DIANReportFormat AS CO_DIANReportFormat,
  OperationalView.CO_DIANReportItemType AS CO_DIANReportItemType,
  OperationalView.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  OperationalView.Supplier AS Supplier,
  OperationalView.Customer AS Customer,
  _Supplier.BPSupplierName AS SupplierName,
  _Customer.BPCustomerName AS CustomerName,
  OperationalView.BusinessPlace AS BusinessPlace,
  cast( coalesce(coalesce(_OneTimeAccountBP.IsNaturalPerson , _Supplier.IsNaturalPerson), _Customer.NFPartnerIsNaturalPerson ) as stkzn preserving type ) AS IsNaturalPerson,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID1 ,_Supplier.TaxNumber1), _Customer.TaxNumber1 ) as stcd1 preserving type ) AS TaxNumber1,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID2 ,_Supplier.TaxNumber2), _Customer.TaxNumber2 ) as stcd2 preserving type ) AS TaxNumber2,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID3 ,_Supplier.TaxNumber3), _Customer.TaxNumber3 ) as stcd3 preserving type ) AS TaxNumber3,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID4 ,_Supplier.TaxNumber4), _Customer.TaxNumber4 ) as stcd4 preserving type ) AS TaxNumber4,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID5 ,_Supplier.TaxNumber5), _Customer.TaxNumber5 ) as stcd5 preserving type ) AS TaxNumber5,
  cast( coalesce(_Supplier.VATRegistration, _Customer.VATRegistration) as stceg preserving type ) AS VATRegistration,
  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,
  OperationalView.GLAccount AS GLAccount,
  OperationalView.GLAccountType AS GLAccountType,
  OperationalView.AlternativeGLAccount AS AlternativeGLAccount,
  OperationalView.SpecialGLCode AS SpecialGLCode,
  OperationalView.ChartOfAccounts AS ChartOfAccounts,
  OperationalView.CountryChartOfAccounts AS CountryChartOfAccounts,
  OperationalView.FinancialAccountType AS FinancialAccountType,
  OperationalView.DebitCreditCode AS DebitCreditCode,
  OperationalView.TaxCode AS TaxCode,
  OperationalView.AccountingDocumentItem AS AccountingDocumentItem,
  OperationalView.AccountingDocumentType AS AccountingDocumentType,
  OperationalView.ReferenceDocument AS ReferenceDocument,
  OperationalView.ReferenceDocumentItem AS ReferenceDocumentItem,
  OperationalView.IsReversal AS IsReversal,
  OperationalView.IsReversed AS IsReversed,
  OperationalView.CostCenter AS CostCenter,
  OperationalView.ProfitCenter AS ProfitCenter,
  OperationalView.TransactionTypeDetermination AS TransactionTypeDetermination,
  OperationalView.FiscalPeriod AS FiscalPeriod,
  OperationalView.PostingDate AS PostingDate,
  OperationalView.DocumentDate AS DocumentDate,
  OperationalView.ClearingDate AS ClearingDate,
  OperationalView.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _CompanyCode._Address.Country AS CompanyCodeCountry,
  OperationalView.ReportingCurrency AS ReportingCurrency,
  OperationalView.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  OperationalView.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  OperationalView.TransactionCurrency AS TransactionCurrency,
  OperationalView.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  OperationalView.CompanyCodeCurrency AS CompanyCodeCurrency,
  OperationalView.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OperationalView.GlobalCurrency AS GlobalCurrency,
  OperationalView.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  OperationalView.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  OperationalView.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  OperationalView.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  OperationalView.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  OperationalView.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  OperationalView.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  OperationalView.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  OperationalView.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  OperationalView.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  OperationalView.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  OperationalView.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  OperationalView.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  OperationalView.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  OperationalView.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  OperationalView.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  OperationalView.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  OperationalView._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  OperationalView._CompanyCode AS _CompanyCode,
  OperationalView._CompanyCodeCurrency AS _CompanyCodeCurrency,
  OperationalView._DebitCreditCode AS _DebitCreditCode,
  OperationalView._FinancialAccountType AS _FinancialAccountType,
  OperationalView._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  OperationalView._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  OperationalView._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  OperationalView._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  OperationalView._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  OperationalView._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  OperationalView._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  OperationalView._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  OperationalView._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  OperationalView._GlobalCurrency AS _GlobalCurrency,
  OperationalView._TransactionCurrency AS _TransactionCurrency
FROM P_CO_DIANStRpSuplrCustOplVw
LEFT OUTER JOIN I_CO_DIANTaxNumberTypeMapping AS _CO_DIANTaxMapping ON TaxNumberType = _CO_DIANTaxMapping.TaxNumberType  -- association [0..1]
LEFT OUTER JOIN I_CO_DIANCountryMapping AS _CO_DIANCountryMapping ON BusinessPartnerCountry = _CO_DIANCountryMapping.Country  -- association [0..1]
LEFT OUTER JOIN C_CO_DIANCityCode AS _CO_DIANCityCode ON BusinessPartnerCountry = _CO_DIANCityCode.Country AND Region = _CO_DIANCityCode.Region AND CityName = _CO_DIANCityCode.CityName  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CO_DIANCountryMapping AS _CompanyCodeCountryMapping ON _CompanyCodeCountryMapping.Country = CompanyCodeCountry  -- association [0..1]
;