What is C_CO_DIANStRpCustomerOpenItemQ in SAP S/4HANA?

C_CO_DIANStRpCustomerOpenItemQ is a consumption CDS view in SAP S/4HANA. Cust. Balances Query for Colombia DIAN It contains 77 fields.

Which tables does C_CO_DIANStRpCustomerOpenItemQ read from?

C_CO_DIANStRpCustomerOpenItemQ reads data from: C_CO_DIANStRpCustomerOpenItemC.

What VDM layer is C_CO_DIANStRpCustomerOpenItemQ?

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

C_CO_DIANStRpCustomerOpenItemQ

DDL: C_CO_DIANSTRPCUSTOMEROPENITEMQ Type: view CONSUMPTION

77 Fields 1 Data Sources

Cust. Balances Query for Colombia DIAN

C_CO_DIANStRpCustomerOpenItemQ is a Consumption CDS View that provides data about "Cust. Balances Query for Colombia DIAN" in SAP S/4HANA. It reads from 1 data source (C_CO_DIANStRpCustomerOpenItemC) and exposes 77 fields with key fields CompanyCode, FiscalYear, StatryRptgEntity, StatryRptCategory, StatryRptRunID.

Data Sources (1)

Source	Alias	Join Type
C_CO_DIANStRpCustomerOpenItemC	C_CO_DIANStRpCustomerOpenItemC	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	CSRCOCUSTOPITEMQ	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Analytics.settings.zeroValues.handling	#HIDE	view
Analytics.settings.zeroValues.hideOnAxis	#ROWS	view
Analytics.query	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Cust. Balances Query for Colombia DIAN	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_CO_DIANStRpDebtorOpenItemQ	view
VDM.viewType	#CONSUMPTION	view

Fields (77)

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

Depth:

C_CO_DIANStRpCustomerOpenItemQ view

C_CO_DIANStRpCustomerOpenItemC view