What is C_CO_DIANStRpDebtorOpenItemC in SAP S/4HANA?

C_CO_DIANStRpDebtorOpenItemC is a consumption CDS view in SAP S/4HANA. Debtor Balances Cube for Colombia DIAN It contains 81 fields.

Which tables does C_CO_DIANStRpDebtorOpenItemC read from?

C_CO_DIANStRpDebtorOpenItemC reads data from: P_CO_DIANStRpDebtorOpenItem.

What VDM layer is C_CO_DIANStRpDebtorOpenItemC?

C_CO_DIANStRpDebtorOpenItemC is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CO_DIANStRpDebtorOpenItemC

DDL: C_CO_DIANSTRPDEBTOROPENITEMC Type: view CONSUMPTION Package: GLO_FIN_IS_CO_GL

81 Fields 1 Data Sources

Debtor Balances Cube for Colombia DIAN

C_CO_DIANStRpDebtorOpenItemC is a Consumption CDS View (Cube) that provides data about "Debtor Balances Cube for Colombia DIAN" in SAP S/4HANA. It reads from 1 data source (P_CO_DIANStRpDebtorOpenItem) and exposes 81 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_CO_GL.

Data Sources (1)

Source	Alias	Join Type
P_CO_DIANStRpDebtorOpenItem	P_CO_DIANStRpDebtorOpenItem	from

Parameters (3)

Name	Type	Default
P_Ledger	fins_ledger
P_KeyDate	vdm_v_key_date
P_ExchangeRateType	kurst

Annotations (15)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	CSRCODBTROPITEMC	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Debtor Balances Cube for Colombia DIAN	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#CONSUMPTION	view

Fields (81)

Key	Field	Source Field	Description
KEY	StatryRptgEntity	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	StatryRptCategory	Report ID
KEY	StatryRptRunID	StatryRptRunID	Report Run ID
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	LedgerGLLineItem	Journal Entry Item
KEY	CO_DIANReportFormat	CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType	CO_DIANReportItemType	Item Type
KEY	ReportedTaxNumber	ReportedTaxNumber
KEY	TaxNumberVerificationDigit
	ReferenceDocument	ReferenceDocument	Reference Document
	ReferenceDocumentItem	ReferenceDocumentItem	Reference item
	CO_DIANAmountClassification	CO_DIANAmountClassification
	IsBelowMinimumAmountThreshold	IsBelowMinimumAmountThreshold
	TaxNumber1	TaxNumber1	VAT Reg. No.
	TaxNumber2	TaxNumber2	Tax Number 2
	TaxNumber3	TaxNumber3
	TaxNumber4	TaxNumber4
	TaxNumber5	TaxNumber5
	VATRegistration	VATRegistration	VAT Registration No.
	TaxNumberType	TaxNumberType	Tax number type
	BusinessPlace	BusinessPlace	Business place
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	CO_DIANTaxNumberType	CO_DIANTaxNumberType	DIAN Doc. Type
	BusinessPartnerCategory	BusinessPartnerCategory	Partner Cat.
	BusinessPartner	BusinessPartner	Issuing Authority
	FirstName	FirstName	First Name
	MiddleName	MiddleName	Middle Name
	LastName	LastName	Last Name
	AdditionalLastName	AdditionalLastName	Other Last Name
	BusinessPartnerOrgLongName
	OrganizationBPName1	OrganizationBPName1	Name 1
	OrganizationBPName2	OrganizationBPName2	Name 2
	OrganizationBPName3	OrganizationBPName3	Name 3
	OrganizationBPName4	OrganizationBPName4	Name 4
	IsNaturalPerson	IsNaturalPerson	Natural person
	BusinessPartnerCountry	BusinessPartnerCountry	BP Ctry/Reg.
	CO_DIANCountry	CO_DIANCountry
	Region	Region	Venue Region
	StreetName	StreetName	Text
	CityCode
	CityName	CityName	Name
	GLAccount	GLAccount	General Ledger
	GLAccountName	GLAccountName	Short Text
	AlternativeGLAccount	AlternativeGLAccount	Group Account
	DebitCreditCode	DebitCreditCode	Single-Character Flag
	FiscalPeriod	FiscalPeriod	Tax period
	PostingDate	PostingDate	Posting Date for GR
	AccountingDocumentItem	AccountingDocumentItem	Posting View Item
	Supplier	Supplier	Supplier
	Customer	Customer	Sold-to Party
	FinancialAccountType	FinancialAccountType	Fin. Account Type
	SpecialGLCode	SpecialGLCode	Special G/L Ind
	ClearingDate	ClearingDate	Clearing Date
	ReportingCurrency	ReportingCurrency	Currency
	AmountInReportingCurrency	AmountInReportingCurrency
	BalanceTransactionCurrency	BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	TransactionCurrency	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	AmountInGlobalCurrency	Amount in Global Currency
	FreeDefinedCurrency1	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8

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 C_CO_DIANStRpDebtorOpenItemC.
-- 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 C_CO_DIANStRpDebtorOpenItemC AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  ReportedTaxNumber,
  cast ( '' as ficodian_verification_digit ) AS TaxNumberVerificationDigit,
  ReferenceDocument,
  ReferenceDocumentItem,
  CO_DIANAmountClassification,
  IsBelowMinimumAmountThreshold,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATRegistration,
  TaxNumberType,
  BusinessPlace,
  AccountingDocumentType,
  CO_DIANTaxNumberType,
  BusinessPartnerCategory,
  BusinessPartner,
  FirstName,
  MiddleName,
  LastName,
  AdditionalLastName,
  cast(concat(OrganizationBPName1, OrganizationBPName2) as ficodian_bp_org_long_name) AS BusinessPartnerOrgLongName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  IsNaturalPerson,
  BusinessPartnerCountry,
  CO_DIANCountry,
  Region,
  StreetName,
  cast( right(CityCode, 3) as ficodian_city_code ) AS CityCode,
  CityName,
  GLAccount,
  GLAccountName,
  AlternativeGLAccount,
  DebitCreditCode,
  FiscalPeriod,
  PostingDate,
  AccountingDocumentItem,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  ClearingDate,
  ReportingCurrency,
  AmountInReportingCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8
FROM P_CO_DIANStRpDebtorOpenItem
;

Depth:

C_CO_DIANStRpDebtorOpenItemC view

P_CO_DIANStRpDebtorOpenItem view

C_CO_DIANStRpDebtorOpenItemQ view