P_CO_DIANStRpDebtorOpenItem

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_DIANStRpDebtorOpenItem.
-- 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_KeyDate : vdm_v_key_date, P_ExchangeRateType : kurst

CREATE VIEW P_CO_DIANStRpDebtorOpenItem AS
SELECT
  DebtorOpenItem.StatryRptgEntity AS StatryRptgEntity,
  DebtorOpenItem.StatryRptCategory AS StatryRptCategory,
  DebtorOpenItem.StatryRptRunID AS StatryRptRunID,
  DebtorOpenItem.CompanyCode AS CompanyCode,
  DebtorOpenItem.FiscalYear AS FiscalYear,
  DebtorOpenItem.AccountingDocument AS AccountingDocument,
  DebtorOpenItem.LedgerGLLineItem AS LedgerGLLineItem,
  DebtorOpenItem.CO_DIANReportFormat AS CO_DIANReportFormat,
  DebtorOpenItem.CO_DIANReportItemType AS CO_DIANReportItemType,
  DebtorOpenItem.ReferenceDocument AS ReferenceDocument,
  DebtorOpenItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  DebtorOpenItem.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  DebtorOpenItem.TaxNumber1 AS TaxNumber1,
  DebtorOpenItem.TaxNumber2 AS TaxNumber2,
  DebtorOpenItem.TaxNumber3 AS TaxNumber3,
  DebtorOpenItem.TaxNumber4 AS TaxNumber4,
  DebtorOpenItem.TaxNumber5 AS TaxNumber5,
  DebtorOpenItem.VATRegistration AS VATRegistration,
  DebtorOpenItem.TaxNumberType AS TaxNumberType,
  DebtorOpenItem.BusinessPartnerCategory AS BusinessPartnerCategory,
  DebtorOpenItem.BusinessPartner AS BusinessPartner,
  DebtorOpenItem.BusinessPlace AS BusinessPlace,
  DebtorOpenItem.AccountingDocumentType AS AccountingDocumentType,
  MinAmtCheck.IsBelowMinimumAmountThreshold AS IsBelowMinimumAmountThreshold,
  DebtorOpenItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  DebtorOpenItem.GLAccount AS GLAccount,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountName as fis_txt30_skat ) AS GLAccountName,
  DebtorOpenItem.AlternativeGLAccount AS AlternativeGLAccount,
  DebtorOpenItem.DebitCreditCode AS DebitCreditCode,
  DebtorOpenItem.FiscalPeriod AS FiscalPeriod,
  DebtorOpenItem.PostingDate AS PostingDate,
  DebtorOpenItem.AccountingDocumentItem AS AccountingDocumentItem,
  DebtorOpenItem.Supplier AS Supplier,
  DebtorOpenItem.Customer AS Customer,
  DebtorOpenItem.FinancialAccountType AS FinancialAccountType,
  DebtorOpenItem.SpecialGLCode AS SpecialGLCode,
  DebtorOpenItem.ChartOfAccounts AS ChartOfAccounts,
  DebtorOpenItem.ClearingDate AS ClearingDate,
  DebtorOpenItem.ReportingCurrency AS ReportingCurrency,
  DebtorOpenItem.AmountInReportingCurrency AS AmountInReportingCurrency,
  DebtorOpenItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  DebtorOpenItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  DebtorOpenItem.TransactionCurrency AS TransactionCurrency,
  DebtorOpenItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  DebtorOpenItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  DebtorOpenItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  DebtorOpenItem.GlobalCurrency AS GlobalCurrency,
  DebtorOpenItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  DebtorOpenItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  DebtorOpenItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  DebtorOpenItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  DebtorOpenItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  DebtorOpenItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  DebtorOpenItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  DebtorOpenItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  DebtorOpenItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  DebtorOpenItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  DebtorOpenItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  DebtorOpenItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  DebtorOpenItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  DebtorOpenItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  DebtorOpenItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  DebtorOpenItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  DebtorOpenItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  DebtorOpenItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  DebtorOpenItem._CompanyCode AS _CompanyCode,
  DebtorOpenItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  DebtorOpenItem._DebitCreditCode AS _DebitCreditCode,
  DebtorOpenItem._FinancialAccountType AS _FinancialAccountType,
  DebtorOpenItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  DebtorOpenItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  DebtorOpenItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  DebtorOpenItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  DebtorOpenItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  DebtorOpenItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  DebtorOpenItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  DebtorOpenItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  DebtorOpenItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  DebtorOpenItem._GlobalCurrency AS _GlobalCurrency,
  DebtorOpenItem._TransactionCurrency AS _TransactionCurrency,
  DebtorOpenItem._ReportingCurrency AS _ReportingCurrency,
  DebtorOpenItem._OneTimeAccountBP AS _OneTimeAccountBP,
  DebtorOpenItem._CO_DIANTaxMapping AS _CO_DIANTaxMapping,
  DebtorOpenItem._CO_DIANCountryMapping AS _CO_DIANCountryMapping
FROM P_CO_DIANStRpFinalDbtrOpenItm
;