What is C_CO_DIANStRpSupplierOpenItemC in SAP S/4HANA?

C_CO_DIANStRpSupplierOpenItemC is a consumption CDS view in SAP S/4HANA. Supplier Balances Cube for Colombia DIAN It contains 77 fields.

Which tables does C_CO_DIANStRpSupplierOpenItemC read from?

C_CO_DIANStRpSupplierOpenItemC reads data from: P_CO_DIANStRpSupplierOpenItem.

What VDM layer is C_CO_DIANStRpSupplierOpenItemC?

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

C_CO_DIANStRpSupplierOpenItemC

DDL: C_CO_DIANSTRPSUPPLIEROPENITEMC SQL: CSRCOSUPLROPITMC Type: view CONSUMPTION Package: GLO_FIN_IS_CO_GL

77 Fields 1 Data Sources

Supplier Balances Cube for Colombia DIAN

C_CO_DIANStRpSupplierOpenItemC is a Consumption CDS View (Cube) that provides data about "Supplier Balances Cube for Colombia DIAN" in SAP S/4HANA. It reads from 1 data source (P_CO_DIANStRpSupplierOpenItem) and exposes 77 fields with key fields Ledger, CompanyCode, FiscalYear, CO_DIANReportFormat, CO_DIANReportItemType. Part of development package GLO_FIN_IS_CO_GL.

Data Sources (1)

Source	Alias	Join Type
P_CO_DIANStRpSupplierOpenItem	P_CO_DIANStRpSupplierOpenItem	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.sqlViewName	CSRCOSUPLROPITMC	view
EndUserText.label	Supplier Balances Cube for Colombia DIAN	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
Analytics.dataCategory	#CUBE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
Metadata.allowExtensions	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_CO_DIANStRpCreditorOpenItemC	view

Fields (77)

Key	Field	Source Table	Source Field	Description
KEY	Ledger		Ledger	Ledger
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	CO_DIANReportFormat		CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType		CO_DIANReportItemType	Item Type
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
KEY	StatryRptgEntity		StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory		StatryRptCategory	Report ID
KEY	StatryRptRunID		StatryRptRunID	Report Run ID
	ReferenceDocument		ReferenceDocument	Reference Document
	ReferenceDocumentItem		ReferenceDocumentItem	Reference item
	BusinessPlace		BusinessPlace	Business place
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	Supplier		Supplier	Supplier
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	TaxNumber3		TaxNumber3
	TaxNumber4		TaxNumber4
	TaxNumber5		TaxNumber5
	ReportedTaxNumber		ReportedTaxNumber
	TaxNumberType		TaxNumberType	Tax number type
	CO_DIANTaxNumberType	_CO_DIANTaxMapping	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
	OrganizationBPName1		OrganizationBPName1	Name 1
	OrganizationBPName2		OrganizationBPName2	Name 2
	OrganizationBPName3		OrganizationBPName3	Name 3
	OrganizationBPName4		OrganizationBPName4	Name 4
	IsNaturalPerson		IsNaturalPerson	Natural person
	CompanyCodeAddressID	_CompanyCode	AddressID	Ship-to address
	BusinessPartnerCountry		BusinessPartnerCountry	BP Ctry/Reg.
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	CO_DIANCountry	_CO_DIANCountryMapping	CO_DIANCountry
	CityName		CityName	Name
	AccountingDocumentItem		AccountingDocumentItem	Posting View Item
	GLAccount		GLAccount	General Ledger
	GLAccountName
	AlternativeGLAccount		AlternativeGLAccount	Group Account
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	FiscalPeriod		FiscalPeriod	Tax period
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	SpecialGLCode		SpecialGLCode	Special G/L Ind
	PostingDate		PostingDate	Posting Date for GR
	ClearingDate		ClearingDate	Clearing Date
	AccountingDocCreatedByUser		AccountingDocCreatedByUser	User which created overhead document
	ReportingCurrency		ReportingCurrency	Currency
	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
	_CompanyCode		_CompanyCode
	_CompanyCodeCountryMapping		_CompanyCodeCountryMapping

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_DIANStRpSupplierOpenItemC.
-- 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.
-- SQL view name: CSRCOSUPLROPITMC
-- Parameters: P_Ledger : fins_ledger, P_KeyDate : vdm_v_key_date, P_ExchangeRateType : kurst

CREATE VIEW C_CO_DIANStRpSupplierOpenItemC AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  AccountingDocument,
  LedgerGLLineItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  ReferenceDocument,
  ReferenceDocumentItem,
  BusinessPlace,
  AccountingDocumentType,
  Supplier,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  ReportedTaxNumber,
  TaxNumberType,
  _CO_DIANTaxMapping.CO_DIANTaxNumberType AS CO_DIANTaxNumberType,
  BusinessPartnerCategory,
  BusinessPartner,
  FirstName,
  MiddleName,
  LastName,
  AdditionalLastName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  IsNaturalPerson,
  _CompanyCode.AddressID AS CompanyCodeAddressID,
  BusinessPartnerCountry,
  CompanyCodeCountry,
  _CO_DIANCountryMapping.CO_DIANCountry AS CO_DIANCountry,
  CityName,
  AccountingDocumentItem,
  GLAccount,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountName as fis_txt30_skat ) AS GLAccountName,
  AlternativeGLAccount,
  DebitCreditCode,
  FiscalPeriod,
  FinancialAccountType,
  SpecialGLCode,
  PostingDate,
  ClearingDate,
  AccountingDocCreatedByUser,
  ReportingCurrency,
  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_DIANStRpSupplierOpenItem
;

Depth:

C_CO_DIANStRpSupplierOpenItemC view

P_CO_DIANStRpSupplierOpenItem view