What is P_CO_DIAN1001ItmTypeBPMinAmt in SAP S/4HANA?

P_CO_DIAN1001ItmTypeBPMinAmt is a consumption CDS view in SAP S/4HANA. DIAN 1001 Item Type and BP Total Amounts It contains 49 fields.

Which tables does P_CO_DIAN1001ItmTypeBPMinAmt read from?

P_CO_DIAN1001ItmTypeBPMinAmt reads data from: P_CO_DIANStRpAggrgFormat1001.

What VDM layer is P_CO_DIAN1001ItmTypeBPMinAmt?

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

P_CO_DIAN1001ItmTypeBPMinAmt

DDL: P_CO_DIAN1001ITMTYPEBPMINAMT SQL: PCO1001TOTMINAMT Type: view CONSUMPTION

49 Fields 1 Data Sources

DIAN 1001 Item Type and BP Total Amounts

P_CO_DIAN1001ItmTypeBPMinAmt is a Consumption CDS View that provides data about "DIAN 1001 Item Type and BP Total Amounts" in SAP S/4HANA. It reads from 1 data source (P_CO_DIANStRpAggrgFormat1001) and exposes 49 fields with key fields CompanyCode, FiscalYear, StatryRptgEntity, StatryRptCategory, StatryRptRunID.

Data Sources (1)

Source	Alias	Join Type
P_CO_DIANStRpAggrgFormat1001	P_CO_DIANStRpAggrgFormat1001	from

Parameters (3)

Name	Type	Default
P_Ledger	fins_ledger
P_FromPostingDate	fis_budat_from
P_ToPostingDate	fis_budat_to

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	PCO1001TOTMINAMT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#P	view
EndUserText.label	DIAN 1001 Item Type and BP Total Amounts	view

Fields (49)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	AggregatedEntries	CompanyCode	Receiver Company Code
KEY	FiscalYear	AggregatedEntries	FiscalYear	G/L Fiscal Year
KEY	StatryRptgEntity	AggregatedEntries	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	AggregatedEntries	StatryRptCategory	Report ID
KEY	StatryRptRunID	AggregatedEntries	StatryRptRunID	Report Run ID
KEY	CO_DIANReportFormat	AggregatedEntries	CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType	AggregatedEntries	CO_DIANReportItemType	Item Type
KEY	ReportedTaxNumber	AggregatedEntries	ReportedTaxNumber
	BusinessPlace	AggregatedEntries	BusinessPlace	Business place
	CO_DIANTaxNumberType	AggregatedEntries	CO_DIANTaxNumberType	DIAN Doc. Type
	TaxNumberType	AggregatedEntries	TaxNumberType	Tax number type
	BusinessPartnerCategory	AggregatedEntries	BusinessPartnerCategory	Partner Cat.
	BusinessPartner	AggregatedEntries	BusinessPartner	Issuing Authority
	FirstName	AggregatedEntries	FirstName	First Name
	MiddleName	AggregatedEntries	MiddleName	Middle Name
	LastName	AggregatedEntries	LastName	Last Name
	AdditionalLastName	AggregatedEntries	AdditionalLastName	Other Last Name
	OrganizationBPName1	AggregatedEntries	OrganizationBPName1	Name 1
	OrganizationBPName2	AggregatedEntries	OrganizationBPName2	Name 2
	OrganizationBPName3	AggregatedEntries	OrganizationBPName3	Name 3
	OrganizationBPName4	AggregatedEntries	OrganizationBPName4	Name 4
	IsNaturalPerson	AggregatedEntries	IsNaturalPerson	Natural person
	BusinessPartnerCountry	AggregatedEntries	BusinessPartnerCountry	BP Ctry/Reg.
	CompanyCodeCountry	AggregatedEntries	CompanyCodeCountry	Reporting Ctry/Reg.
	CO_DIANCountry	AggregatedEntries	CO_DIANCountry
	Region	AggregatedEntries	Region	Venue Region
	CityCode	AggregatedEntries	CityCode	IATA: City
	CityName	AggregatedEntries	CityName	Name
	StreetName	AggregatedEntries	StreetName	Text
	TaxNumber1	AggregatedEntries	TaxNumber1	VAT Reg. No.
	TaxNumber2	AggregatedEntries	TaxNumber2	Tax Number 2
	TaxNumber3	AggregatedEntries	TaxNumber3
	TaxNumber4	AggregatedEntries	TaxNumber4
	TaxNumber5	AggregatedEntries	TaxNumber5
	VATRegistration	AggregatedEntries	VATRegistration	VAT Registration No.
	ReportingCurrency	AggregatedEntries	ReportingCurrency	Currency
	DcblGLAcctPaytsAmtInRptgCrcy
	NonDcblGLAcctPaytAmtInRptgCrcy
	DcblVATIncrdCostInRptgCrcy
	NonDcblVATIncrdCostInRptgCrcy
	WhldgTxIncAmtInRptgCurrency
	TakenWhldgTaxIncAmtInRptgCrcy
	WhldgTaxCommonVATAmtInRptgCrcy
	TknWhldgSimpfdVATAmtInRptgCrcy
	WhldgTxForeignVATAmtInRptgCrcy
	CO_WhldgCREEAmtInRptgCurrency
	CO_TknWhldgCREEAmtInRptgCrcy
	_CompanyCode	AggregatedEntries	_CompanyCode
	_CompanyCodeCountryMapping	AggregatedEntries	_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_DIAN1001ItmTypeBPMinAmt.
-- 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: PCO1001TOTMINAMT
-- Parameters: P_Ledger : fins_ledger, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_CO_DIAN1001ItmTypeBPMinAmt AS
SELECT
  AggregatedEntries.CompanyCode AS CompanyCode,
  AggregatedEntries.FiscalYear AS FiscalYear,
  AggregatedEntries.StatryRptgEntity AS StatryRptgEntity,
  AggregatedEntries.StatryRptCategory AS StatryRptCategory,
  AggregatedEntries.StatryRptRunID AS StatryRptRunID,
  AggregatedEntries.CO_DIANReportFormat AS CO_DIANReportFormat,
  AggregatedEntries.CO_DIANReportItemType AS CO_DIANReportItemType,
  AggregatedEntries.ReportedTaxNumber AS ReportedTaxNumber,
  AggregatedEntries.BusinessPlace AS BusinessPlace,
  AggregatedEntries.CO_DIANTaxNumberType AS CO_DIANTaxNumberType,
  AggregatedEntries.TaxNumberType AS TaxNumberType,
  AggregatedEntries.BusinessPartnerCategory AS BusinessPartnerCategory,
  AggregatedEntries.BusinessPartner AS BusinessPartner,
  AggregatedEntries.FirstName AS FirstName,
  AggregatedEntries.MiddleName AS MiddleName,
  AggregatedEntries.LastName AS LastName,
  AggregatedEntries.AdditionalLastName AS AdditionalLastName,
  AggregatedEntries.OrganizationBPName1 AS OrganizationBPName1,
  AggregatedEntries.OrganizationBPName2 AS OrganizationBPName2,
  AggregatedEntries.OrganizationBPName3 AS OrganizationBPName3,
  AggregatedEntries.OrganizationBPName4 AS OrganizationBPName4,
  AggregatedEntries.IsNaturalPerson AS IsNaturalPerson,
  AggregatedEntries.BusinessPartnerCountry AS BusinessPartnerCountry,
  AggregatedEntries.CompanyCodeCountry AS CompanyCodeCountry,
  AggregatedEntries.CO_DIANCountry AS CO_DIANCountry,
  AggregatedEntries.Region AS Region,
  AggregatedEntries.CityCode AS CityCode,
  AggregatedEntries.CityName AS CityName,
  AggregatedEntries.StreetName AS StreetName,
  AggregatedEntries.TaxNumber1 AS TaxNumber1,
  AggregatedEntries.TaxNumber2 AS TaxNumber2,
  AggregatedEntries.TaxNumber3 AS TaxNumber3,
  AggregatedEntries.TaxNumber4 AS TaxNumber4,
  AggregatedEntries.TaxNumber5 AS TaxNumber5,
  AggregatedEntries.VATRegistration AS VATRegistration,
  AggregatedEntries.ReportingCurrency AS ReportingCurrency,
  cast( sum(AggregatedEntries.DcblGLAcctPaytsAmtInRptgCrcy) as ficodian_paymcred_dcblgl preserving type ) AS DcblGLAcctPaytsAmtInRptgCrcy,
  cast( sum(AggregatedEntries.NonDcblGLAcctPaytAmtInRptgCrcy) as ficodian_paymcred_nondcblgl preserving type ) AS NonDcblGLAcctPaytAmtInRptgCrcy,
  cast( sum(AggregatedEntries.DcblVATIncrdCostInRptgCrcy) as ficodian_incrdcost_dcblvat preserving type ) AS DcblVATIncrdCostInRptgCrcy,
  cast( sum(AggregatedEntries.NonDcblVATIncrdCostInRptgCrcy) as ficodian_incrdcost_nondcblvat preserving type ) AS NonDcblVATIncrdCostInRptgCrcy,
  cast( sum(AggregatedEntries.WhldgTxIncAmtInRptgCurrency) as ficodian_prac_whldg_income preserving type ) AS WhldgTxIncAmtInRptgCurrency,
  cast( sum(AggregatedEntries.TakenWhldgTaxIncAmtInRptgCrcy) as ficodian_taken_whldg_income preserving type ) AS TakenWhldgTaxIncAmtInRptgCrcy,
  cast( sum(AggregatedEntries.WhldgTaxCommonVATAmtInRptgCrcy) as ficodian_whldg_common_vat preserving type ) AS WhldgTaxCommonVATAmtInRptgCrcy,
  cast( sum(AggregatedEntries.TknWhldgSimpfdVATAmtInRptgCrcy) as ficodian_tkn_whldg_spfd_vat preserving type ) AS TknWhldgSimpfdVATAmtInRptgCrcy,
  cast( sum(AggregatedEntries.WhldgTxForeignVATAmtInRptgCrcy) as ficodian_prac_wht_foreign_vat preserving type ) AS WhldgTxForeignVATAmtInRptgCrcy,
  cast( sum(AggregatedEntries.CO_WhldgCREEAmtInRptgCurrency) as ficodian_prac_wht_cree preserving type ) AS CO_WhldgCREEAmtInRptgCurrency,
  cast( sum(AggregatedEntries.CO_TknWhldgCREEAmtInRptgCrcy) as ficodian_tkn_wht_cree preserving type ) AS CO_TknWhldgCREEAmtInRptgCrcy,
  AggregatedEntries._CompanyCode AS _CompanyCode,
  AggregatedEntries._CompanyCodeCountryMapping AS _CompanyCodeCountryMapping
FROM P_CO_DIANStRpAggrgFormat1001
;

Depth:

P_CO_DIAN1001ItmTypeBPMinAmt view

P_CO_DIANStRpAggrgFormat1001 view

P_CO_DIAN1001ItmTypeBPMinAmt2 view