What is P_CO_DIANStRpJournalEntryItm2 in SAP S/4HANA?

P_CO_DIANStRpJournalEntryItm2 is a consumption CDS view in SAP S/4HANA. G/L Formats - BP Logic for Journal Entry It contains 106 fields.

Which tables does P_CO_DIANStRpJournalEntryItm2 read from?

P_CO_DIANStRpJournalEntryItm2 reads data from: P_CO_DIANStRpJournalEntryItemC.

What VDM layer is P_CO_DIANStRpJournalEntryItm2?

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

P_CO_DIANStRpJournalEntryItm2

DDL: P_CO_DIANSTRPJOURNALENTRYITM2 Type: view CONSUMPTION Package: GLO_FIN_IS_CO_GL

106 Fields 1 Data Sources 7 Associations

G/L Formats - BP Logic for Journal Entry

P_CO_DIANStRpJournalEntryItm2 is a Consumption CDS View that provides data about "G/L Formats - BP Logic for Journal Entry" in SAP S/4HANA. It reads from 1 data source (P_CO_DIANStRpJournalEntryItemC) and exposes 106 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, Ledger, SourceLedger. It has 7 associations to related views. Part of development package GLO_FIN_IS_CO_GL.

Data Sources (1)

Source	Alias	Join Type
P_CO_DIANStRpJournalEntryItemC	P_CO_DIANStRpJournalEntryItemC	from

Parameters (3)

Name	Type	Default
P_FromPostingDate	fis_budat_from
P_ToPostingDate	fis_budat_to
P_Ledger	fins_ledger

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	I_CO_DIANTaxNumberTypeMapping	_CO_DIANTaxMapping	`$projection.TaxNumberType = _CO_DIANTaxMapping.TaxNumberType`
[0..1]	I_CO_DIANCountryMapping	_CO_DIANCountryMapping	`$projection.BusinessPartnerCountry = _CO_DIANCountryMapping.Country`
[0..1]	C_CO_DIANCityCode	_CO_DIANCityCode	`$projection.BusinessPartnerCountry = _CO_DIANCityCode.Country and $projection.Region = _CO_DIANCityCode.Region and $projection.CityName = _CO_DIANCityCode.CityName`
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`
[0..1]	I_Currency	_ReportingCurrency	`$projection.ReportingCurrency = _ReportingCurrency.Currency`
[0..1]	I_CO_DIANCountryMapping	_CompanyCodeCountryMapping	`_CompanyCodeCountryMapping.Country = $projection.CompanyCodeCountry`

Annotations (10)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	PCOSTRPJEITM2	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	G/L Formats - BP Logic for Journal Entry	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#P	view
ObjectModel.usageType.sizeCategory	#XXL	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view

Fields (106)

Key	Field	Source Table	Source Field	Description
KEY	StatryRptgEntity	JournalEntryItem	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	JournalEntryItem	StatryRptCategory	Report ID
KEY	StatryRptRunID	JournalEntryItem	StatryRptRunID	Report Run ID
KEY	Ledger	JournalEntryItem	Ledger	Ledger
KEY	SourceLedger	JournalEntryItem	SourceLedger	Source Ledger
KEY	CompanyCode	JournalEntryItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	JournalEntryItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	JournalEntryItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	JournalEntryItem	LedgerGLLineItem	Journal Entry Item
KEY	CO_DIANReportFormat	JournalEntryItem	CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType	JournalEntryItem	CO_DIANReportItemType	Item Type
	CO_DIANAmountClassification	JournalEntryItem	CO_DIANAmountClassification
	CO_DIANBPTaxLongNumber	JournalEntryItem	CO_DIANBPTaxLongNumber
	Reference1IDByBusinessPartner	JournalEntryItem	Reference1IDByBusinessPartner	Reference Key 1
	Reference3IDByBusinessPartner	JournalEntryItem	Reference3IDByBusinessPartner	Reference Key 3
	Supplier	JournalEntryItem	Supplier	Supplier
	Customer	JournalEntryItem	Customer	Sold-to Party
	SupplierName	_Supplier	BPSupplierName	Supplier Name
	CustomerName	_Customer	BPCustomerName	Name of Customer
	BusinessPlace	JournalEntryItem	BusinessPlace	Business place
	IsNaturalPerson
	TaxNumber2
	TaxNumber3
	TaxNumber4
	TaxNumber5
	VATRegistration
	BusinessPartnerCategory
	BusinessPartner
	BusinessPartnerCountry
	Region
	CityCode
	CityName
	StreetName
	GLAccount	JournalEntryItem	GLAccount	General Ledger
	GLAccountType	JournalEntryItem	GLAccountType	G/L Account Type
	AlternativeGLAccount	JournalEntryItem	AlternativeGLAccount	Group Account
	SpecialGLCode	JournalEntryItem	SpecialGLCode	Special G/L Ind
	ChartOfAccounts	JournalEntryItem	ChartOfAccounts	Node Class
	CountryChartOfAccounts	JournalEntryItem	CountryChartOfAccounts	Chart of Accts
	FinancialAccountType	JournalEntryItem	FinancialAccountType	Fin. Account Type
	DebitCreditCode	JournalEntryItem	DebitCreditCode	Single-Character Flag
	TaxCode	JournalEntryItem	TaxCode	Tax Code
	AccountingDocumentItem	JournalEntryItem	AccountingDocumentItem	Posting View Item
	AccountingDocumentType	JournalEntryItem	AccountingDocumentType	Journal Entry Type
	ReferenceDocument	JournalEntryItem	ReferenceDocument	Reference Document
	ReferenceDocumentItem	JournalEntryItem	ReferenceDocumentItem	Reference item
	IsReversal	JournalEntryItem	IsReversal	Reversal doc.
	IsReversed	JournalEntryItem	IsReversed	Reversed?
	CostCenter	JournalEntryItem	CostCenter	Cost Center
	ProfitCenter	JournalEntryItem	ProfitCenter	Profit Center
	TransactionTypeDetermination	JournalEntryItem	TransactionTypeDetermination	Transaction Key
	FiscalPeriod	JournalEntryItem	FiscalPeriod	Tax period
	PostingDate	JournalEntryItem	PostingDate	Posting Date for GR
	DocumentDate	JournalEntryItem	DocumentDate	Journal Entry Date
	ClearingDate	JournalEntryItem	ClearingDate	Clearing Date
	AccountingDocCreatedByUser	JournalEntryItem	AccountingDocCreatedByUser	User which created overhead document
	CompanyCodeCountry
	ReportingCurrency	JournalEntryItem	ReportingCurrency	Currency
	BalanceTransactionCurrency	JournalEntryItem	BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy	JournalEntryItem	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	TransactionCurrency	JournalEntryItem	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	JournalEntryItem	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	JournalEntryItem	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	JournalEntryItem	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	JournalEntryItem	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	JournalEntryItem	AmountInGlobalCurrency	Amount in Global Currency
	FreeDefinedCurrency1	JournalEntryItem	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	JournalEntryItem	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	JournalEntryItem	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	JournalEntryItem	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	JournalEntryItem	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	JournalEntryItem	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	JournalEntryItem	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	JournalEntryItem	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	JournalEntryItem	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	JournalEntryItem	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	JournalEntryItem	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	JournalEntryItem	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	JournalEntryItem	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	JournalEntryItem	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	JournalEntryItem	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	JournalEntryItem	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	_BalanceTransactionCurrency	JournalEntryItem	_BalanceTransactionCurrency
	_CompanyCode	JournalEntryItem	_CompanyCode
	_CompanyCodeCountryMapping		_CompanyCodeCountryMapping
	_CompanyCodeCurrency	JournalEntryItem	_CompanyCodeCurrency
	_Customer		_Customer
	_DebitCreditCode	JournalEntryItem	_DebitCreditCode
	_FinancialAccountType	JournalEntryItem	_FinancialAccountType
	_FreeDefinedCurrency1	JournalEntryItem	_FreeDefinedCurrency1
	_FreeDefinedCurrency2	JournalEntryItem	_FreeDefinedCurrency2
	_FreeDefinedCurrency3	JournalEntryItem	_FreeDefinedCurrency3
	_FreeDefinedCurrency4	JournalEntryItem	_FreeDefinedCurrency4
	_FreeDefinedCurrency5	JournalEntryItem	_FreeDefinedCurrency5
	_FreeDefinedCurrency6	JournalEntryItem	_FreeDefinedCurrency6
	_FreeDefinedCurrency7	JournalEntryItem	_FreeDefinedCurrency7
	_FreeDefinedCurrency8	JournalEntryItem	_FreeDefinedCurrency8
	_GLAccountInChartOfAccounts	JournalEntryItem	_GLAccountInChartOfAccounts
	_GlobalCurrency	JournalEntryItem	_GlobalCurrency
	_Supplier		_Supplier
	_TransactionCurrency	JournalEntryItem	_TransactionCurrency
	_ReportingCurrency		_ReportingCurrency
	_OneTimeAccountBP		_OneTimeAccountBP
	_CO_DIANTaxMapping		_CO_DIANTaxMapping
	_CO_DIANCountryMapping		_CO_DIANCountryMapping
	_CO_DIANCityCode		_CO_DIANCityCode

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_DIANStRpJournalEntryItm2.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_Ledger : fins_ledger

CREATE VIEW P_CO_DIANStRpJournalEntryItm2 AS
SELECT
  JournalEntryItem.StatryRptgEntity AS StatryRptgEntity,
  JournalEntryItem.StatryRptCategory AS StatryRptCategory,
  JournalEntryItem.StatryRptRunID AS StatryRptRunID,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.CO_DIANReportFormat AS CO_DIANReportFormat,
  JournalEntryItem.CO_DIANReportItemType AS CO_DIANReportItemType,
  JournalEntryItem.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  JournalEntryItem.CO_DIANBPTaxLongNumber AS CO_DIANBPTaxLongNumber,
  JournalEntryItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  JournalEntryItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.Customer AS Customer,
  _Supplier.BPSupplierName AS SupplierName,
  _Customer.BPCustomerName AS CustomerName,
  JournalEntryItem.BusinessPlace AS BusinessPlace,
  cast( coalesce(coalesce(_OneTimeAccountBP.IsNaturalPerson , _Supplier.IsNaturalPerson), _Customer.NFPartnerIsNaturalPerson ) as stkzn preserving type ) AS IsNaturalPerson,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID2 ,_Supplier.TaxNumber2), _Customer.TaxNumber2 ) as stcd2 preserving type ) AS TaxNumber2,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID3 ,_Supplier.TaxNumber3), _Customer.TaxNumber3 ) as stcd3 preserving type ) AS TaxNumber3,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID4 ,_Supplier.TaxNumber4), _Customer.TaxNumber4 ) as stcd4 preserving type ) AS TaxNumber4,
  cast( coalesce(coalesce(_OneTimeAccountBP.TaxID5 ,_Supplier.TaxNumber5), _Customer.TaxNumber5 ) as stcd5 preserving type ) AS TaxNumber5,
  cast( coalesce(_Supplier.VATRegistration, _Customer.VATRegistration) as stceg preserving type ) AS VATRegistration,
  cast( coalesce( _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerCategory, _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerCategory ) as bu_type preserving type ) AS BusinessPartnerCategory,
  cast( coalesce( _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner, _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner ) as bu_partner preserving type ) AS BusinessPartner,
  cast( coalesce(coalesce(_OneTimeAccountBP.Country,_Supplier._AddressRepresentation.Country), _Customer._AddressRepresentation.Country ) as land1 preserving type ) AS BusinessPartnerCountry,
  cast( coalesce(coalesce(_OneTimeAccountBP.Region,_Supplier._AddressRepresentation.Region), _Customer._AddressRepresentation.Region ) as regio preserving type ) AS Region,
  cast( coalesce(coalesce(_OneTimeAccountBP._Address.CityCode,_Supplier._AddressRepresentation.CityNumber), _Customer._AddressRepresentation.CityNumber) as ad_citynum preserving type ) AS CityCode,
  cast( coalesce(coalesce(_OneTimeAccountBP.CityName,_Supplier._AddressRepresentation.CityName), _Customer._AddressRepresentation.CityName ) as ad_city1 preserving type ) AS CityName,
  cast( coalesce(coalesce(_OneTimeAccountBP.StreetAddressName,_Supplier._AddressRepresentation.StreetName), _Customer._AddressRepresentation.StreetName ) as ad_street preserving type ) AS StreetName,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.GLAccountType AS GLAccountType,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  JournalEntryItem.SpecialGLCode AS SpecialGLCode,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem.TaxCode AS TaxCode,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  JournalEntryItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.IsReversed AS IsReversed,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.ProfitCenter AS ProfitCenter,
  JournalEntryItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  JournalEntryItem.FiscalPeriod AS FiscalPeriod,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.DocumentDate AS DocumentDate,
  JournalEntryItem.ClearingDate AS ClearingDate,
  JournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _CompanyCode._Address.Country AS CompanyCodeCountry,
  JournalEntryItem.ReportingCurrency AS ReportingCurrency,
  JournalEntryItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  JournalEntryItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntryItem.GlobalCurrency AS GlobalCurrency,
  JournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  JournalEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  JournalEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  JournalEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  JournalEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  JournalEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  JournalEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  JournalEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  JournalEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  JournalEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  JournalEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  JournalEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  JournalEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  JournalEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  JournalEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  JournalEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  JournalEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  JournalEntryItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  JournalEntryItem._CompanyCode AS _CompanyCode,
  JournalEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JournalEntryItem._DebitCreditCode AS _DebitCreditCode,
  JournalEntryItem._FinancialAccountType AS _FinancialAccountType,
  JournalEntryItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  JournalEntryItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  JournalEntryItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  JournalEntryItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  JournalEntryItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  JournalEntryItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  JournalEntryItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  JournalEntryItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  JournalEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  JournalEntryItem._GlobalCurrency AS _GlobalCurrency,
  JournalEntryItem._TransactionCurrency AS _TransactionCurrency
FROM P_CO_DIANStRpJournalEntryItemC
LEFT OUTER JOIN I_CO_DIANTaxNumberTypeMapping AS _CO_DIANTaxMapping ON TaxNumberType = _CO_DIANTaxMapping.TaxNumberType  -- association [0..1]
LEFT OUTER JOIN I_CO_DIANCountryMapping AS _CO_DIANCountryMapping ON BusinessPartnerCountry = _CO_DIANCountryMapping.Country  -- association [0..1]
LEFT OUTER JOIN C_CO_DIANCityCode AS _CO_DIANCityCode ON BusinessPartnerCountry = _CO_DIANCityCode.Country AND Region = _CO_DIANCityCode.Region AND CityName = _CO_DIANCityCode.CityName  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CO_DIANCountryMapping AS _CompanyCodeCountryMapping ON _CompanyCodeCountryMapping.Country = CompanyCodeCountry  -- association [0..1]
;

Depth:

P_CO_DIANStRpJournalEntryItm2 view

P_CO_DIANStRpJournalEntryItemC view

C_CO_DIANStRpJournalEntryItemC view