What is P_CO_DIANStRpAggrgCreditor in SAP S/4HANA?

P_CO_DIANStRpAggrgCreditor is a consumption CDS view in SAP S/4HANA. Union Creditors for Colombia DIAN It contains 149 fields.

Which tables does P_CO_DIANStRpAggrgCreditor read from?

P_CO_DIANStRpAggrgCreditor reads data from: C_CO_DIANStRpSuplrCustOpnItemC, I_CO_DIANItemType, C_CO_DIANStRpEmployeeOpenItemC.

What VDM layer is P_CO_DIANStRpAggrgCreditor?

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

P_CO_DIANStRpAggrgCreditor

DDL: P_CO_DIANSTRPAGGRGCREDITOR Type: view CONSUMPTION

149 Fields 3 Data Sources 1 Associations

Union Creditors for Colombia DIAN

P_CO_DIANStRpAggrgCreditor is a Consumption CDS View that provides data about "Union Creditors for Colombia DIAN" in SAP S/4HANA. It reads from 3 data sources (C_CO_DIANStRpSuplrCustOpnItemC, I_CO_DIANItemType, C_CO_DIANStRpEmployeeOpenItemC) and exposes 149 fields with key fields CompanyCode, FiscalYear, CO_DIANReportFormat, CO_DIANReportItemType, AccountingDocument. It has 1 association to related views.

Data Sources (3)

Source	Alias	Join Type
C_CO_DIANStRpSuplrCustOpnItemC	C_CO_DIANStRpSuplrCustOpnItemC	from
I_CO_DIANItemType	DIANItemType	inner
C_CO_DIANStRpEmployeeOpenItemC	Employee	union_all

Parameters (3)

Name	Type	Default
P_Ledger	fins_ledger
P_KeyDate	vdm_v_key_date
P_ExchangeRateType	kurst

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_CO_DIANCountryMapping	_CompanyCodeCountryMapping	`$projection.CompanyCodeCountry = _CompanyCodeCountryMapping.Country`

Annotations (12)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	PSRCOAGGRGCRDTR	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Union Creditors 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 (149)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	FiscalYear		FiscalYear	Fiscal Year
KEY	CO_DIANReportFormat		CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType		CO_DIANReportItemType	Item Type
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	ReportedTaxNumber		ReportedTaxNumber	VAT Reg. No.
KEY	TaxNumberType		TaxNumberType	Tax number type
KEY	StatryRptgEntity		StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory		StatryRptCategory	Report ID
KEY	StatryRptRunID		StatryRptRunID	Report Run ID
	ReferenceDocument		ReferenceDocument	Reference Document
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	SpecialGLCode		SpecialGLCode	Special G/L Ind
	GLAccount		GLAccount	General Ledger
	GLAccountName		GLAccountName	Short Text
	AlternativeGLAccount		AlternativeGLAccount	Group Account
	CreationUTCDateTime			Time Stamp
	CreatedByUser		AccountingDocCreatedByUser	User Name
	CO_DIANTaxNumberType
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	TaxNumber3		TaxNumber3
	TaxNumber4		TaxNumber4
	TaxNumber5		TaxNumber5
	VATRegistration		VATRegistration	VAT Registration No.
	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
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	CO_DIANCountry		CO_DIANCountry
	Region		Region	Venue Region
	StreetName		StreetName	Text
	CityCode		CityCode	IATA: City
	CityName		CityName	Name
	BusinessPartnerCountry		BusinessPartnerCountry	Venue: Ctry/Reg
	BusinessPlace		BusinessPlace	Business place
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	PostingDate		PostingDate	Posting Date for GR
	ReportingCurrency		ReportingCurrency
	AmountInReportingCurrency		AmountInReportingCurrency
	OpnItmAmountInCountryCurrency		OpnItmAmountInCountryCurrency
	TransactionCurrency		TransactionCurrency
	AmountInTransactionCurrency		AmountInTransactionCurrency
	CompanyCodeCurrency		CompanyCodeCurrency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency
	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
	_CompanyCode		_CompanyCode
	CountrykeyCompanyCode
KEY	FiscalYear		PayrollYear	Fiscal Year
KEY	CO_DIANReportFormat	C_CO_DIANStRpEmployeeOpenItemC	CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType	C_CO_DIANStRpEmployeeOpenItemC	CO_DIANReportItemType	Item Type
KEY	AccountingDocument			Journal Entry
KEY	ReportedTaxNumber		TaxNumber1	VAT Reg. No.
KEY	TaxNumberType			Tax number type
KEY	StatryRptgEntity		StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory		StatryRptCategory	Report ID
KEY	StatryRptRunID		StatryRptRunID	Report Run ID
	ReferenceDocument			Reference Document
	FinancialAccountType			Fin. Account Type
	SpecialGLCode			Special G/L Ind
	GLAccount			General Ledger
	GLAccountName			Short Text
	AlternativeGLAccount			Group Account
	CreationUTCDateTime		CreationUTCDateTime	Time Stamp
	CreatedByUser		CreatedByUser	User Name
	CO_DIANTaxNumberType
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2			Tax Number 2
	TaxNumber3
	TaxNumber4
	TaxNumber5
	VATRegistration			VAT Registration No.
	BusinessPartnerCategory			Partner Cat.
	BusinessPartner			Issuing Authority
	FirstName		FirstName	First Name
	MiddleName		MiddleName	Middle Name
	LastName		LastName	Last Name
	AdditionalLastName		AdditionalLastName	Other Last Name
	OrganizationBPName1			Name 1
	OrganizationBPName2			Name 2
	OrganizationBPName3			Name 3
	OrganizationBPName4			Name 4
	IsNaturalPerson			Natural person
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	CO_DIANCountry		CO_DIANCountry
	Region		Region	Venue Region
	StreetName		StreetName	Text
	CityCode		CityCode	IATA: City
	CityName			Name
	BusinessPartnerCountry		Country	Venue: Ctry/Reg
	BusinessPlace			Business place
	AccountingDocumentType			Journal Entry Type
	PostingDate			Posting Date for GR
	ReportingCurrency		CO_DIANPyrlItmTypeCalcdAmtCrcy
	AmountInReportingCurrency		CO_DIANPyrlItmTypeCalcdAmt
	OpnItmAmountInCountryCurrency		CO_DIANPyrlItmTypeCalcdAmt
	TransactionCurrency		CO_DIANPyrlItmTypeCalcdAmtCrcy
	AmountInTransactionCurrency		CO_DIANPyrlItmTypeCalcdAmt
	CompanyCodeCurrency		CO_DIANPyrlItmTypeCalcdAmtCrcy
	AmountInCompanyCodeCurrency		CO_DIANPyrlItmTypeCalcdAmt
	BalanceTransactionCurrency			Currency
	AmountInBalanceTransacCrcy			Amount in Balance Transaction Currency
	GlobalCurrency			GM Billing Element: Global Currency
	AmountInGlobalCurrency			Amount in Global Currency
	FreeDefinedCurrency1			Freely Defined Currency 1
	AmountInFreeDefinedCurrency1			Amount in Freely Defined Currency 1
	FreeDefinedCurrency2			Freely Defined Currency 2
	AmountInFreeDefinedCurrency2			Amount in Freely Defined Currency 2
	FreeDefinedCurrency3			Freely Defined Currency 3
	AmountInFreeDefinedCurrency3			Amount in Freely Defined Currency 3
	FreeDefinedCurrency4			Freely Defined Currency 4
	AmountInFreeDefinedCurrency4			Amount in Freely Defined Currency 4
	FreeDefinedCurrency5			Freely Defined Currency 5
	AmountInFreeDefinedCurrency5			Amount in Freely Defined Currency 5
	FreeDefinedCurrency6			Freely Defined Currency 6
	AmountInFreeDefinedCurrency6			Amount in Freely Defined Currency 6
	FreeDefinedCurrency7			Freely Defined Currency 7
	AmountInFreeDefinedCurrency7			Amount in Freely Defined Currency 7
	FreeDefinedCurrency8			Freely Defined Currency 8
	AmountInFreeDefinedCurrency8			Amount in Freely Defined Currency 8
	_CompanyCode	C_CO_DIANStRpEmployeeOpenItemC	_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 P_CO_DIANStRpAggrgCreditor.
-- 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_DIANStRpAggrgCreditor AS
SELECT
  CompanyCode,
  FiscalYear,
  CO_DIANReportFormat,
  CO_DIANReportItemType,
  AccountingDocument,
  ReportedTaxNumber,
  TaxNumberType,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  ReferenceDocument,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  GLAccountName,
  AlternativeGLAccount,
  cast( cast( 0 as abap.dec( 15 , 0 ) ) as timestamp preserving type) AS CreationUTCDateTime,
  AccountingDocCreatedByUser AS CreatedByUser,
  coalesce( CO_DIANTaxNumberType, '00' ) AS CO_DIANTaxNumberType,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  TaxNumber5,
  VATRegistration,
  BusinessPartnerCategory,
  BusinessPartner,
  FirstName,
  MiddleName,
  LastName,
  AdditionalLastName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  IsNaturalPerson,
  CompanyCodeCountry,
  CO_DIANCountry,
  Region,
  StreetName,
  CityCode,
  CityName,
  BusinessPartnerCountry,
  BusinessPlace,
  AccountingDocumentType,
  PostingDate,
  ReportingCurrency,
  AmountInReportingCurrency,
  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,
  Employee._CompanyCode AS _CompanyCode
FROM C_CO_DIANStRpSuplrCustOpnItemC
INNER JOIN I_CO_DIANItemType AS DIANItemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CO_DIANCountryMapping AS _CompanyCodeCountryMapping ON CompanyCodeCountry = _CompanyCodeCountryMapping.Country  -- association [0..1]
-- UNION ALL with additional select branch(es): C_CO_DIANStRpEmployeeOpenItemC
;

Depth:

P_CO_DIANStRpAggrgCreditor view

P_CO_DIANStRpFinalCrdtrOpenItm view
P_CO_DIANStRpTotAmtByCreditor view