P_CO_DIANStRpFinalDbtrOpenItm

DDL: P_CO_DIANSTRPFINALDBTROPENITM Type: view CONSUMPTION Package: GLO_FIN_IS_CO_GL
105 Fields 2 Data Sources

Fnl Debtor Open Item for Colombia DIAN

P_CO_DIANStRpFinalDbtrOpenItm is a Consumption CDS View that provides data about "Fnl Debtor Open Item for Colombia DIAN" in SAP S/4HANA. It reads from 2 data sources (C_CO_DIANStRpSuplrCustOpnItemC, P_CO_DIANStRpFinalDebtorBal) and exposes 105 fields with key fields SourceLedger, FiscalYear, AccountingDocument, Ledger, LedgerGLLineItem. Part of development package GLO_FIN_IS_CO_GL.

Data Sources (2)

SourceAliasJoin Type
C_CO_DIANStRpSuplrCustOpnItemC C_CO_DIANStRpSuplrCustOpnItemC from
P_CO_DIANStRpFinalDebtorBal P_CO_DIANStRpFinalDebtorBal inner

Parameters (3)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_Ledger fins_ledger
P_ExchangeRateType kurst

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PSRCOFNLDBTROPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fnl Debtor Open Item for Colombia DIAN view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SupplierCustomerOpenItem SourceLedger Source Ledger
KEY FiscalYear SupplierCustomerOpenItem FiscalYear G/L Fiscal Year
KEY AccountingDocument SupplierCustomerOpenItem AccountingDocument Journal Entry
KEY Ledger SupplierCustomerOpenItem Ledger Ledger
KEY LedgerGLLineItem SupplierCustomerOpenItem LedgerGLLineItem Journal Entry Item
KEY CompanyCode SupplierCustomerOpenItem CompanyCode Receiver Company Code
KEY BusinessPartner SupplierCustomerOpenItem BusinessPartner Issuing Authority
KEY FinancialAccountType SupplierCustomerOpenItem FinancialAccountType Fin. Account Type
KEY CO_DIANReportFormat SupplierCustomerOpenItem CO_DIANReportFormat Report Format
KEY CO_DIANReportItemType SupplierCustomerOpenItem CO_DIANReportItemType Item Type
KEY StatryRptgEntity SupplierCustomerOpenItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory SupplierCustomerOpenItem StatryRptCategory Report ID
KEY StatryRptRunID SupplierCustomerOpenItem StatryRptRunID Report Run ID
KEY TaxNumberType SupplierCustomerOpenItem TaxNumberType Tax number type
KEY ReportedTaxNumber SupplierCustomerOpenItem ReportedTaxNumber
ReferenceDocument SupplierCustomerOpenItem ReferenceDocument Reference Document
ReferenceDocumentItem SupplierCustomerOpenItem ReferenceDocumentItem Reference item
CO_DIANAmountClassification SupplierCustomerOpenItem CO_DIANAmountClassification
AccountingDocumentType SupplierCustomerOpenItem AccountingDocumentType Journal Entry Type
BusinessPlace SupplierCustomerOpenItem BusinessPlace Business place
Customer SupplierCustomerOpenItem Customer Sold-to Party
Supplier SupplierCustomerOpenItem Supplier Supplier
TaxNumber1 SupplierCustomerOpenItem TaxNumber1 VAT Reg. No.
TaxNumber2 SupplierCustomerOpenItem TaxNumber2 Tax Number 2
TaxNumber3 SupplierCustomerOpenItem TaxNumber3
TaxNumber4 SupplierCustomerOpenItem TaxNumber4
TaxNumber5 SupplierCustomerOpenItem TaxNumber5
VATRegistration SupplierCustomerOpenItem VATRegistration VAT Registration No.
CO_DIANTaxNumberType SupplierCustomerOpenItem CO_DIANTaxNumberType DIAN Doc. Type
BusinessPartnerCategory SupplierCustomerOpenItem BusinessPartnerCategory Partner Cat.
FirstName SupplierCustomerOpenItem FirstName First Name
MiddleName SupplierCustomerOpenItem MiddleName Middle Name
LastName SupplierCustomerOpenItem LastName Last Name
AdditionalLastName SupplierCustomerOpenItem AdditionalLastName Other Last Name
OrganizationBPName1 SupplierCustomerOpenItem OrganizationBPName1 Name 1
OrganizationBPName2 SupplierCustomerOpenItem OrganizationBPName2 Name 2
OrganizationBPName3 SupplierCustomerOpenItem OrganizationBPName3 Name 3
OrganizationBPName4 SupplierCustomerOpenItem OrganizationBPName4 Name 4
IsNaturalPerson SupplierCustomerOpenItem IsNaturalPerson Natural person
CompanyCodeAddressID SupplierCustomerOpenItem CompanyCodeAddressID Ship-to address
BusinessPartnerCountry SupplierCustomerOpenItem BusinessPartnerCountry BP Ctry/Reg.
CompanyCodeCountry SupplierCustomerOpenItem CompanyCodeCountry Reporting Ctry/Reg.
CO_DIANCountry SupplierCustomerOpenItem CO_DIANCountry
Region SupplierCustomerOpenItem Region Venue Region
StreetName SupplierCustomerOpenItem StreetName Text
CityCode SupplierCustomerOpenItem CityCode IATA: City
CityName SupplierCustomerOpenItem CityName Name
AccountingDocumentItem SupplierCustomerOpenItem AccountingDocumentItem Posting View Item
GLAccount SupplierCustomerOpenItem GLAccount General Ledger
GLAccountName SupplierCustomerOpenItem GLAccountName Short Text
AlternativeGLAccount SupplierCustomerOpenItem AlternativeGLAccount Group Account
SpecialGLCode SupplierCustomerOpenItem SpecialGLCode Special G/L Ind
ChartOfAccounts SupplierCustomerOpenItem ChartOfAccounts Node Class
DebitCreditCode SupplierCustomerOpenItem DebitCreditCode Single-Character Flag
FiscalPeriod SupplierCustomerOpenItem FiscalPeriod Tax period
PostingDate SupplierCustomerOpenItem PostingDate Posting Date for GR
ClearingDate SupplierCustomerOpenItem ClearingDate Clearing Date
AccountingDocCreatedByUser SupplierCustomerOpenItem AccountingDocCreatedByUser User which created overhead document
ReportingCurrency SupplierCustomerOpenItem ReportingCurrency Currency
AmountInReportingCurrency SupplierCustomerOpenItem AmountInReportingCurrency
BalanceTransactionCurrency SupplierCustomerOpenItem BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy SupplierCustomerOpenItem AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
TransactionCurrency SupplierCustomerOpenItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency SupplierCustomerOpenItem AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency SupplierCustomerOpenItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency SupplierCustomerOpenItem AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency SupplierCustomerOpenItem GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency SupplierCustomerOpenItem AmountInGlobalCurrency Amount in Global Currency
FreeDefinedCurrency1 SupplierCustomerOpenItem FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 SupplierCustomerOpenItem AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 SupplierCustomerOpenItem FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 SupplierCustomerOpenItem AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 SupplierCustomerOpenItem FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 SupplierCustomerOpenItem AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 SupplierCustomerOpenItem FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 SupplierCustomerOpenItem AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 SupplierCustomerOpenItem FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 SupplierCustomerOpenItem AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 SupplierCustomerOpenItem FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 SupplierCustomerOpenItem AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 SupplierCustomerOpenItem FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 SupplierCustomerOpenItem AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 SupplierCustomerOpenItem FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 SupplierCustomerOpenItem AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
_BalanceTransactionCurrency SupplierCustomerOpenItem _BalanceTransactionCurrency
_CompanyCode SupplierCustomerOpenItem _CompanyCode
_CompanyCodeCountryMapping SupplierCustomerOpenItem _CompanyCodeCountryMapping
_CompanyCodeCurrency SupplierCustomerOpenItem _CompanyCodeCurrency
_DebitCreditCode SupplierCustomerOpenItem _DebitCreditCode
_FinancialAccountType SupplierCustomerOpenItem _FinancialAccountType
_GLAccountInChartOfAccounts SupplierCustomerOpenItem _GLAccountInChartOfAccounts
_FreeDefinedCurrency1 SupplierCustomerOpenItem _FreeDefinedCurrency1
_FreeDefinedCurrency2 SupplierCustomerOpenItem _FreeDefinedCurrency2
_FreeDefinedCurrency3 SupplierCustomerOpenItem _FreeDefinedCurrency3
_FreeDefinedCurrency4 SupplierCustomerOpenItem _FreeDefinedCurrency4
_FreeDefinedCurrency5 SupplierCustomerOpenItem _FreeDefinedCurrency5
_FreeDefinedCurrency6 SupplierCustomerOpenItem _FreeDefinedCurrency6
_FreeDefinedCurrency7 SupplierCustomerOpenItem _FreeDefinedCurrency7
_FreeDefinedCurrency8 SupplierCustomerOpenItem _FreeDefinedCurrency8
_GlobalCurrency SupplierCustomerOpenItem _GlobalCurrency
_TransactionCurrency SupplierCustomerOpenItem _TransactionCurrency
_ReportingCurrency SupplierCustomerOpenItem _ReportingCurrency
_OneTimeAccountBP SupplierCustomerOpenItem _OneTimeAccountBP
_CO_DIANTaxMapping SupplierCustomerOpenItem _CO_DIANTaxMapping
_CO_DIANCountryMapping SupplierCustomerOpenItem _CO_DIANCountryMapping

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_DIANStRpFinalDbtrOpenItm.
-- 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_KeyDate : vdm_v_key_date, P_Ledger : fins_ledger, P_ExchangeRateType : kurst

CREATE VIEW P_CO_DIANStRpFinalDbtrOpenItm AS
SELECT
  SupplierCustomerOpenItem.SourceLedger AS SourceLedger,
  SupplierCustomerOpenItem.FiscalYear AS FiscalYear,
  SupplierCustomerOpenItem.AccountingDocument AS AccountingDocument,
  SupplierCustomerOpenItem.Ledger AS Ledger,
  SupplierCustomerOpenItem.LedgerGLLineItem AS LedgerGLLineItem,
  SupplierCustomerOpenItem.CompanyCode AS CompanyCode,
  SupplierCustomerOpenItem.BusinessPartner AS BusinessPartner,
  SupplierCustomerOpenItem.FinancialAccountType AS FinancialAccountType,
  SupplierCustomerOpenItem.CO_DIANReportFormat AS CO_DIANReportFormat,
  SupplierCustomerOpenItem.CO_DIANReportItemType AS CO_DIANReportItemType,
  SupplierCustomerOpenItem.StatryRptgEntity AS StatryRptgEntity,
  SupplierCustomerOpenItem.StatryRptCategory AS StatryRptCategory,
  SupplierCustomerOpenItem.StatryRptRunID AS StatryRptRunID,
  SupplierCustomerOpenItem.TaxNumberType AS TaxNumberType,
  SupplierCustomerOpenItem.ReportedTaxNumber AS ReportedTaxNumber,
  SupplierCustomerOpenItem.ReferenceDocument AS ReferenceDocument,
  SupplierCustomerOpenItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  SupplierCustomerOpenItem.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  SupplierCustomerOpenItem.AccountingDocumentType AS AccountingDocumentType,
  SupplierCustomerOpenItem.BusinessPlace AS BusinessPlace,
  SupplierCustomerOpenItem.Customer AS Customer,
  SupplierCustomerOpenItem.Supplier AS Supplier,
  SupplierCustomerOpenItem.TaxNumber1 AS TaxNumber1,
  SupplierCustomerOpenItem.TaxNumber2 AS TaxNumber2,
  SupplierCustomerOpenItem.TaxNumber3 AS TaxNumber3,
  SupplierCustomerOpenItem.TaxNumber4 AS TaxNumber4,
  SupplierCustomerOpenItem.TaxNumber5 AS TaxNumber5,
  SupplierCustomerOpenItem.VATRegistration AS VATRegistration,
  SupplierCustomerOpenItem.CO_DIANTaxNumberType AS CO_DIANTaxNumberType,
  SupplierCustomerOpenItem.BusinessPartnerCategory AS BusinessPartnerCategory,
  SupplierCustomerOpenItem.FirstName AS FirstName,
  SupplierCustomerOpenItem.MiddleName AS MiddleName,
  SupplierCustomerOpenItem.LastName AS LastName,
  SupplierCustomerOpenItem.AdditionalLastName AS AdditionalLastName,
  SupplierCustomerOpenItem.OrganizationBPName1 AS OrganizationBPName1,
  SupplierCustomerOpenItem.OrganizationBPName2 AS OrganizationBPName2,
  SupplierCustomerOpenItem.OrganizationBPName3 AS OrganizationBPName3,
  SupplierCustomerOpenItem.OrganizationBPName4 AS OrganizationBPName4,
  SupplierCustomerOpenItem.IsNaturalPerson AS IsNaturalPerson,
  SupplierCustomerOpenItem.CompanyCodeAddressID AS CompanyCodeAddressID,
  SupplierCustomerOpenItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  SupplierCustomerOpenItem.CompanyCodeCountry AS CompanyCodeCountry,
  SupplierCustomerOpenItem.CO_DIANCountry AS CO_DIANCountry,
  SupplierCustomerOpenItem.Region AS Region,
  SupplierCustomerOpenItem.StreetName AS StreetName,
  SupplierCustomerOpenItem.CityCode AS CityCode,
  SupplierCustomerOpenItem.CityName AS CityName,
  SupplierCustomerOpenItem.AccountingDocumentItem AS AccountingDocumentItem,
  SupplierCustomerOpenItem.GLAccount AS GLAccount,
  SupplierCustomerOpenItem.GLAccountName AS GLAccountName,
  SupplierCustomerOpenItem.AlternativeGLAccount AS AlternativeGLAccount,
  SupplierCustomerOpenItem.SpecialGLCode AS SpecialGLCode,
  SupplierCustomerOpenItem.ChartOfAccounts AS ChartOfAccounts,
  SupplierCustomerOpenItem.DebitCreditCode AS DebitCreditCode,
  SupplierCustomerOpenItem.FiscalPeriod AS FiscalPeriod,
  SupplierCustomerOpenItem.PostingDate AS PostingDate,
  SupplierCustomerOpenItem.ClearingDate AS ClearingDate,
  SupplierCustomerOpenItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  SupplierCustomerOpenItem.ReportingCurrency AS ReportingCurrency,
  SupplierCustomerOpenItem.AmountInReportingCurrency AS AmountInReportingCurrency,
  SupplierCustomerOpenItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  SupplierCustomerOpenItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  SupplierCustomerOpenItem.TransactionCurrency AS TransactionCurrency,
  SupplierCustomerOpenItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  SupplierCustomerOpenItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  SupplierCustomerOpenItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  SupplierCustomerOpenItem.GlobalCurrency AS GlobalCurrency,
  SupplierCustomerOpenItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  SupplierCustomerOpenItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  SupplierCustomerOpenItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  SupplierCustomerOpenItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  SupplierCustomerOpenItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  SupplierCustomerOpenItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  SupplierCustomerOpenItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  SupplierCustomerOpenItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  SupplierCustomerOpenItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  SupplierCustomerOpenItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  SupplierCustomerOpenItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  SupplierCustomerOpenItem._CompanyCode AS _CompanyCode,
  SupplierCustomerOpenItem._CompanyCodeCountryMapping AS _CompanyCodeCountryMapping,
  SupplierCustomerOpenItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  SupplierCustomerOpenItem._DebitCreditCode AS _DebitCreditCode,
  SupplierCustomerOpenItem._FinancialAccountType AS _FinancialAccountType,
  SupplierCustomerOpenItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  SupplierCustomerOpenItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  SupplierCustomerOpenItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  SupplierCustomerOpenItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  SupplierCustomerOpenItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  SupplierCustomerOpenItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  SupplierCustomerOpenItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  SupplierCustomerOpenItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  SupplierCustomerOpenItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  SupplierCustomerOpenItem._GlobalCurrency AS _GlobalCurrency,
  SupplierCustomerOpenItem._TransactionCurrency AS _TransactionCurrency,
  SupplierCustomerOpenItem._ReportingCurrency AS _ReportingCurrency,
  SupplierCustomerOpenItem._OneTimeAccountBP AS _OneTimeAccountBP,
  SupplierCustomerOpenItem._CO_DIANTaxMapping AS _CO_DIANTaxMapping,
  SupplierCustomerOpenItem._CO_DIANCountryMapping AS _CO_DIANCountryMapping
FROM C_CO_DIANStRpSuplrCustOpnItemC
INNER JOIN P_CO_DIANStRpFinalDebtorBal ON /* join condition not captured in parsed metadata */
;

Learn More