What is P_CO_DIANStRpFormat1001 in SAP S/4HANA?

P_CO_DIANStRpFormat1001 is a consumption CDS view in SAP S/4HANA. Format 1001 - Payment in Account It contains 60 fields.

Which tables does P_CO_DIANStRpFormat1001 read from?

P_CO_DIANStRpFormat1001 reads data from: P_CO_DIANStRpAggrgFormat1001.

What VDM layer is P_CO_DIANStRpFormat1001?

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

P_CO_DIANStRpFormat1001

DDL: P_CO_DIANSTRPFORMAT1001 Type: view CONSUMPTION Package: GLO_FIN_IS_CO_FORMAT_1001

60 Fields 1 Data Sources

Format 1001 - Payment in Account

P_CO_DIANStRpFormat1001 is a Consumption CDS View that provides data about "Format 1001 - Payment in Account" in SAP S/4HANA. It reads from 1 data source (P_CO_DIANStRpAggrgFormat1001) and exposes 60 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem, StatryRptgEntity. Part of development package GLO_FIN_IS_CO_FORMAT_1001.

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.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	PCODIANSTFMT1001	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Format 1001 - Payment in Account	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#P	view
ObjectModel.usageType.sizeCategory	#XXL	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view

Fields (60)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	AggregatedItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	AggregatedItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AggregatedItem	AccountingDocument	Journal Entry
KEY	AccountingDocumentItem	AggregatedItem	AccountingDocumentItem	Posting View Item
KEY	StatryRptgEntity	AggregatedItem	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	AggregatedItem	StatryRptCategory	Report ID
KEY	StatryRptRunID	AggregatedItem	StatryRptRunID	Report Run ID
KEY	CO_DIANReportFormat	AggregatedItem	CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType	AggregatedItem	CO_DIANReportItemType	Item Type
KEY	ReportedTaxNumber	AggregatedItem	ReportedTaxNumber
	TaxNumberType	AggregatedItem	TaxNumberType	Tax number type
	Customer	AggregatedItem	Customer	Sold-to Party
	Supplier	AggregatedItem	Supplier	Supplier
	PurchasingDocument	AggregatedItem	PurchasingDocument	Purchasing Document
	TaxNumber1	AggregatedItem	TaxNumber1	VAT Reg. No.
	TaxNumber2	AggregatedItem	TaxNumber2	Tax Number 2
	TaxNumber3	AggregatedItem	TaxNumber3
	TaxNumber4	AggregatedItem	TaxNumber4
	TaxNumber5	AggregatedItem	TaxNumber5
	VATRegistration	AggregatedItem	VATRegistration	VAT Registration No.
	CO_DIANBPTaxLongNumber	AggregatedItem	CO_DIANBPTaxLongNumber
	BusinessPlace	AggregatedItem	BusinessPlace	Business place
	AccountingDocumentType	AggregatedItem	AccountingDocumentType	Journal Entry Type
	BusinessPartnerCategory	AggregatedItem	BusinessPartnerCategory	Partner Cat.
	BusinessPartner	AggregatedItem	BusinessPartner	Issuing Authority
	CO_DIANTaxNumberType	AggregatedItem	CO_DIANTaxNumberType	DIAN Doc. Type
	FirstName	AggregatedItem	FirstName	First Name
	MiddleName	AggregatedItem	MiddleName	Middle Name
	LastName	AggregatedItem	LastName	Last Name
	AdditionalLastName	AggregatedItem	AdditionalLastName	Other Last Name
	OrganizationBPName1	AggregatedItem	OrganizationBPName1	Name 1
	OrganizationBPName2	AggregatedItem	OrganizationBPName2	Name 2
	OrganizationBPName3	AggregatedItem	OrganizationBPName3	Name 3
	OrganizationBPName4	AggregatedItem	OrganizationBPName4	Name 4
	IsNaturalPerson	AggregatedItem	IsNaturalPerson	Natural person
	BusinessPartnerCountry	AggregatedItem	BusinessPartnerCountry	BP Ctry/Reg.
	CO_DIANCountry	AggregatedItem	CO_DIANCountry
	CityName	AggregatedItem	CityName	Name
	RegionendasRegion
	CityCodeendasCityCode
	StreetNameendasStreetName
	Reference1IDByBusinessPartner	AggregatedItem	Reference1IDByBusinessPartner	Reference Key 1
	Reference3IDByBusinessPartner	AggregatedItem	Reference3IDByBusinessPartner	Reference Key 3
	PostingDate	AggregatedItem	PostingDate	Posting Date for GR
	CreationUTCDateTime	AggregatedItem	CreationUTCDateTime	Time Stamp
	GLAccount
	GLAccountName	GLAccountText	GLAccountName	Short Text
	AlternativeGLAccount
	ReportingCurrency	AggregatedItem	ReportingCurrency	Currency
	DcblGLAcctPaytsAmtInRptgCrcy	AggregatedItem	DcblGLAcctPaytsAmtInRptgCrcy
	NonDcblGLAcctPaytAmtInRptgCrcy	AggregatedItem	NonDcblGLAcctPaytAmtInRptgCrcy
	DcblVATIncrdCostInRptgCrcy	AggregatedItem	DcblVATIncrdCostInRptgCrcy
	NonDcblVATIncrdCostInRptgCrcy	AggregatedItem	NonDcblVATIncrdCostInRptgCrcy
	WhldgTxIncAmtInRptgCurrency	AggregatedItem	WhldgTxIncAmtInRptgCurrency
	TakenWhldgTaxIncAmtInRptgCrcy	AggregatedItem	TakenWhldgTaxIncAmtInRptgCrcy
	WhldgTaxCommonVATAmtInRptgCrcy	AggregatedItem	WhldgTaxCommonVATAmtInRptgCrcy
	TknWhldgSimpfdVATAmtInRptgCrcy	AggregatedItem	TknWhldgSimpfdVATAmtInRptgCrcy
	WhldgTxForeignVATAmtInRptgCrcy	AggregatedItem	WhldgTxForeignVATAmtInRptgCrcy
	CO_WhldgCREEAmtInRptgCurrency	AggregatedItem	CO_WhldgCREEAmtInRptgCurrency
	CO_TknWhldgCREEAmtInRptgCrcy	AggregatedItem	CO_TknWhldgCREEAmtInRptgCrcy

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_DIANStRpFormat1001.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_CO_DIANStRpFormat1001 AS
SELECT
  AggregatedItem.CompanyCode AS CompanyCode,
  AggregatedItem.FiscalYear AS FiscalYear,
  AggregatedItem.AccountingDocument AS AccountingDocument,
  AggregatedItem.AccountingDocumentItem AS AccountingDocumentItem,
  AggregatedItem.StatryRptgEntity AS StatryRptgEntity,
  AggregatedItem.StatryRptCategory AS StatryRptCategory,
  AggregatedItem.StatryRptRunID AS StatryRptRunID,
  AggregatedItem.CO_DIANReportFormat AS CO_DIANReportFormat,
  AggregatedItem.CO_DIANReportItemType AS CO_DIANReportItemType,
  AggregatedItem.ReportedTaxNumber AS ReportedTaxNumber,
  AggregatedItem.TaxNumberType AS TaxNumberType,
  AggregatedItem.Customer AS Customer,
  AggregatedItem.Supplier AS Supplier,
  AggregatedItem.PurchasingDocument AS PurchasingDocument,
  AggregatedItem.TaxNumber1 AS TaxNumber1,
  AggregatedItem.TaxNumber2 AS TaxNumber2,
  AggregatedItem.TaxNumber3 AS TaxNumber3,
  AggregatedItem.TaxNumber4 AS TaxNumber4,
  AggregatedItem.TaxNumber5 AS TaxNumber5,
  AggregatedItem.VATRegistration AS VATRegistration,
  AggregatedItem.CO_DIANBPTaxLongNumber AS CO_DIANBPTaxLongNumber,
  AggregatedItem.BusinessPlace AS BusinessPlace,
  AggregatedItem.AccountingDocumentType AS AccountingDocumentType,
  AggregatedItem.BusinessPartnerCategory AS BusinessPartnerCategory,
  AggregatedItem.BusinessPartner AS BusinessPartner,
  AggregatedItem.CO_DIANTaxNumberType AS CO_DIANTaxNumberType,
  AggregatedItem.FirstName AS FirstName,
  AggregatedItem.MiddleName AS MiddleName,
  AggregatedItem.LastName AS LastName,
  AggregatedItem.AdditionalLastName AS AdditionalLastName,
  AggregatedItem.OrganizationBPName1 AS OrganizationBPName1,
  AggregatedItem.OrganizationBPName2 AS OrganizationBPName2,
  AggregatedItem.OrganizationBPName3 AS OrganizationBPName3,
  AggregatedItem.OrganizationBPName4 AS OrganizationBPName4,
  AggregatedItem.IsNaturalPerson AS IsNaturalPerson,
  AggregatedItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  AggregatedItem.CO_DIANCountry AS CO_DIANCountry,
  AggregatedItem.CityName AS CityName,
  case when AggregatedItem.BusinessPartnerCountry = 'CO' then AggregatedItem.Region end as Region AS RegionendasRegion,
  case when AggregatedItem.BusinessPartnerCountry = 'CO' then AggregatedItem.CityCode end as CityCode AS CityCodeendasCityCode,
  case when AggregatedItem.BusinessPartnerCountry = 'CO' then AggregatedItem.StreetName end as StreetName AS StreetNameendasStreetName,
  AggregatedItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  AggregatedItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  AggregatedItem.PostingDate AS PostingDate,
  AggregatedItem.CreationUTCDateTime AS CreationUTCDateTime,
  cast( AggregatedItem.GLAccount as fis_racct preserving type ) AS GLAccount,
  GLAccountText.GLAccountName AS GLAccountName,
  cast( AggregatedItem.AlternativeGLAccount as fis_altkt_skb1 preserving type ) AS AlternativeGLAccount,
  AggregatedItem.ReportingCurrency AS ReportingCurrency,
  AggregatedItem.DcblGLAcctPaytsAmtInRptgCrcy AS DcblGLAcctPaytsAmtInRptgCrcy,
  AggregatedItem.NonDcblGLAcctPaytAmtInRptgCrcy AS NonDcblGLAcctPaytAmtInRptgCrcy,
  AggregatedItem.DcblVATIncrdCostInRptgCrcy AS DcblVATIncrdCostInRptgCrcy,
  AggregatedItem.NonDcblVATIncrdCostInRptgCrcy AS NonDcblVATIncrdCostInRptgCrcy,
  AggregatedItem.WhldgTxIncAmtInRptgCurrency AS WhldgTxIncAmtInRptgCurrency,
  AggregatedItem.TakenWhldgTaxIncAmtInRptgCrcy AS TakenWhldgTaxIncAmtInRptgCrcy,
  AggregatedItem.WhldgTaxCommonVATAmtInRptgCrcy AS WhldgTaxCommonVATAmtInRptgCrcy,
  AggregatedItem.TknWhldgSimpfdVATAmtInRptgCrcy AS TknWhldgSimpfdVATAmtInRptgCrcy,
  AggregatedItem.WhldgTxForeignVATAmtInRptgCrcy AS WhldgTxForeignVATAmtInRptgCrcy,
  AggregatedItem.CO_WhldgCREEAmtInRptgCurrency AS CO_WhldgCREEAmtInRptgCurrency,
  AggregatedItem.CO_TknWhldgCREEAmtInRptgCrcy AS CO_TknWhldgCREEAmtInRptgCrcy
FROM P_CO_DIANStRpAggrgFormat1001
;

Depth:

P_CO_DIANStRpFormat1001 view

P_CO_DIANStRpAggrgFormat1001 view

C_CO_DIANStRpFormat1001Cube view