What is P_CO_DIANStRpJournalEntryItemC in SAP S/4HANA?

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

Which tables does P_CO_DIANStRpJournalEntryItemC read from?

P_CO_DIANStRpJournalEntryItemC reads data from: P_CO_DIANGeneralLedgerAccount, I_StRpJournalEntryLog.

What VDM layer is P_CO_DIANStRpJournalEntryItemC?

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

P_CO_DIANStRpJournalEntryItemC

DDL: P_CO_DIANSTRPJOURNALENTRYITEMC Type: view CONSUMPTION Package: GLO_FIN_IS_CO_GL

86 Fields 2 Data Sources 1 Associations

G/L Formats - BP Logic for Journal Entry

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

Data Sources (2)

Source	Alias	Join Type
P_CO_DIANGeneralLedgerAccount	P_CO_DIANGeneralLedgerAccount	inner
I_StRpJournalEntryLog	ReportedItemLog	inner

Parameters (3)

Name	Type	Default
P_FromPostingDate	fis_budat_from
P_ToPostingDate	fis_budat_to
P_Ledger	fins_ledger

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	P_CO_DIANOneTimeAccountBP	_OneTimeAccountBP	`_OneTimeAccountBP.CompanyCode = $projection.CompanyCode and _OneTimeAccountBP.AccountingDocument = $projection.AccountingDocument and _OneTimeAccountBP.FiscalYear = $projection.FiscalYear`

Annotations (13)

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

Fields (86)

Key	Field	Source Table	Source Field	Description
KEY	StatryRptgEntity	I_StRpJournalEntryLog	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	I_StRpJournalEntryLog	StatryRptCategory	Report ID
KEY	StatryRptRunID	I_StRpJournalEntryLog	StatryRptRunID	Report Run ID
KEY	Ledger	OperationalJournalEntryItem	Ledger	Ledger
KEY	SourceLedger	OperationalJournalEntryItem	SourceLedger	Source Ledger
KEY	CompanyCode	OperationalJournalEntryItem	CompanyCode	Receiver Company Code
KEY	FiscalYear
KEY	AccountingDocument	OperationalJournalEntryItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	OperationalJournalEntryItem	LedgerGLLineItem	Journal Entry Item
KEY	CO_DIANReportFormat	DIANGLAccount	CO_DIANReportFormat	Report Format
KEY	CO_DIANReportItemType	DIANGLAccount	CO_DIANReportItemType	Item Type
	CO_DIANAmountClassification	DIANGLAccount	CO_DIANAmountClassification
	BusinessPlace	OperationalJournalEntryItem	BusinessPlace	Business place
	Supplier
	ReportingCurrency
	GLAccount	OperationalJournalEntryItem	GLAccount	General Ledger
	GLAccountType	OperationalJournalEntryItem	GLAccountType	G/L Account Type
	AlternativeGLAccount	OperationalJournalEntryItem	AlternativeGLAccount	Group Account
	SpecialGLCode	OperationalJournalEntryItem	SpecialGLCode	Special G/L Ind
	ChartOfAccounts	OperationalJournalEntryItem	ChartOfAccounts	Node Class
	CountryChartOfAccounts	OperationalJournalEntryItem	CountryChartOfAccounts	Chart of Accts
	FinancialAccountType	OperationalJournalEntryItem	FinancialAccountType	Fin. Account Type
	DebitCreditCode	OperationalJournalEntryItem	DebitCreditCode	Single-Character Flag
	TaxCode	OperationalJournalEntryItem	TaxCode	Tax Code
	OffsettingAccount	OperationalJournalEntryItem	OffsettingAccount	Offsetting Acct
	OffsettingAccountType	OperationalJournalEntryItem	OffsettingAccountType	Offset Acct Type
	CO_DIANBPTaxLongNumber
	Reference1IDByBusinessPartner	OperationalAcctgDocItem	Reference1IDByBusinessPartner	Reference Key 1
	Reference3IDByBusinessPartner	OperationalAcctgDocItem	Reference3IDByBusinessPartner	Reference Key 3
	AccountingDocumentItem	OperationalJournalEntryItem	AccountingDocumentItem	Posting View Item
	AccountingDocumentType	OperationalJournalEntryItem	AccountingDocumentType	Journal Entry Type
	IsReversal	OperationalJournalEntryItem	IsReversal	Reversal doc.
	IsReversed	OperationalJournalEntryItem	IsReversed	Reversed?
	CostCenter	OperationalJournalEntryItem	CostCenter	Cost Center
	ProfitCenter	OperationalJournalEntryItem	ProfitCenter	Profit Center
	TransactionTypeDetermination	OperationalJournalEntryItem	TransactionTypeDetermination	Transaction Key
	FiscalPeriod	OperationalJournalEntryItem	FiscalPeriod	Tax period
	PostingDate	OperationalJournalEntryItem	PostingDate	Posting Date for GR
	DocumentDate	OperationalJournalEntryItem	DocumentDate	Journal Entry Date
	ClearingDate	OperationalJournalEntryItem	ClearingDate	Clearing Date
	AccountingDocCreatedByUser	OperationalJournalEntryItem	AccountingDocCreatedByUser	User which created overhead document
	ReferenceDocumentType	OperationalJournalEntryItem	ReferenceDocumentType	Reference Document Type
	ReferenceDocument	OperationalJournalEntryItem	ReferenceDocument	Reference Document
	ReferenceDocumentItem	OperationalJournalEntryItem	ReferenceDocumentItem	Reference item
	PurchasingDocument	OperationalJournalEntryItem	PurchasingDocument	Purchasing Document
	BalanceTransactionCurrency	OperationalJournalEntryItem	BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy	OperationalJournalEntryItem	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	TransactionCurrency	OperationalJournalEntryItem	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	OperationalJournalEntryItem	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	OperationalJournalEntryItem	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	OperationalJournalEntryItem	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	OperationalJournalEntryItem	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	OperationalJournalEntryItem	AmountInGlobalCurrency	Amount in Global Currency
	FreeDefinedCurrency1	OperationalJournalEntryItem	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	OperationalJournalEntryItem	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	OperationalJournalEntryItem	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	OperationalJournalEntryItem	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	OperationalJournalEntryItem	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	OperationalJournalEntryItem	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	OperationalJournalEntryItem	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	OperationalJournalEntryItem	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	OperationalJournalEntryItem	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	OperationalJournalEntryItem	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	OperationalJournalEntryItem	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	OperationalJournalEntryItem	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	OperationalJournalEntryItem	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	OperationalJournalEntryItem	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	OperationalJournalEntryItem	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	OperationalJournalEntryItem	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	_BalanceTransactionCurrency	OperationalJournalEntryItem	_BalanceTransactionCurrency
	_CompanyCode	OperationalJournalEntryItem	_CompanyCode
	_CompanyCodeCurrency	OperationalJournalEntryItem	_CompanyCodeCurrency
	_DebitCreditCode	OperationalJournalEntryItem	_DebitCreditCode
	_FinancialAccountType	OperationalJournalEntryItem	_FinancialAccountType
	_FreeDefinedCurrency1	OperationalJournalEntryItem	_FreeDefinedCurrency1
	_FreeDefinedCurrency2	OperationalJournalEntryItem	_FreeDefinedCurrency2
	_FreeDefinedCurrency3	OperationalJournalEntryItem	_FreeDefinedCurrency3
	_FreeDefinedCurrency4	OperationalJournalEntryItem	_FreeDefinedCurrency4
	_FreeDefinedCurrency5	OperationalJournalEntryItem	_FreeDefinedCurrency5
	_FreeDefinedCurrency6	OperationalJournalEntryItem	_FreeDefinedCurrency6
	_FreeDefinedCurrency7	OperationalJournalEntryItem	_FreeDefinedCurrency7
	_FreeDefinedCurrency8	OperationalJournalEntryItem	_FreeDefinedCurrency8
	_GLAccountInChartOfAccounts	OperationalJournalEntryItem	_GLAccountInChartOfAccounts
	_GlobalCurrency	OperationalJournalEntryItem	_GlobalCurrency
	_TransactionCurrency	OperationalJournalEntryItem	_TransactionCurrency
	_OneTimeAccountBP		_OneTimeAccountBP

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_DIANStRpJournalEntryItemC.
-- 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_DIANStRpJournalEntryItemC AS
SELECT
  ReportedItemLog.StatryRptgEntity AS StatryRptgEntity,
  ReportedItemLog.StatryRptCategory AS StatryRptCategory,
  ReportedItemLog.StatryRptRunID AS StatryRptRunID,
  OperationalJournalEntryItem.Ledger AS Ledger,
  OperationalJournalEntryItem.SourceLedger AS SourceLedger,
  OperationalJournalEntryItem.CompanyCode AS CompanyCode,
  cast( OperationalJournalEntryItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  OperationalJournalEntryItem.AccountingDocument AS AccountingDocument,
  OperationalJournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  DIANGLAccount.CO_DIANReportFormat AS CO_DIANReportFormat,
  DIANGLAccount.CO_DIANReportItemType AS CO_DIANReportItemType,
  DIANGLAccount.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  OperationalJournalEntryItem.BusinessPlace AS BusinessPlace,
  cast( '' as lifnr ) AS Supplier,
  cast( 'COP' as ficodian_reporting_currency ) AS ReportingCurrency,
  OperationalJournalEntryItem.GLAccount AS GLAccount,
  OperationalJournalEntryItem.GLAccountType AS GLAccountType,
  OperationalJournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  OperationalJournalEntryItem.SpecialGLCode AS SpecialGLCode,
  OperationalJournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  OperationalJournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  OperationalJournalEntryItem.FinancialAccountType AS FinancialAccountType,
  OperationalJournalEntryItem.DebitCreditCode AS DebitCreditCode,
  OperationalJournalEntryItem.TaxCode AS TaxCode,
  OperationalJournalEntryItem.OffsettingAccount AS OffsettingAccount,
  OperationalJournalEntryItem.OffsettingAccountType AS OffsettingAccountType,
  cast ( OperationalAcctgDocItem.OplAcctgDocItmCntrySpcfcRef1 as ficodian_bp_tax_long_number ) AS CO_DIANBPTaxLongNumber,
  OperationalAcctgDocItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  OperationalAcctgDocItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  OperationalJournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  OperationalJournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  OperationalJournalEntryItem.IsReversal AS IsReversal,
  OperationalJournalEntryItem.IsReversed AS IsReversed,
  OperationalJournalEntryItem.CostCenter AS CostCenter,
  OperationalJournalEntryItem.ProfitCenter AS ProfitCenter,
  OperationalJournalEntryItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  OperationalJournalEntryItem.FiscalPeriod AS FiscalPeriod,
  OperationalJournalEntryItem.PostingDate AS PostingDate,
  OperationalJournalEntryItem.DocumentDate AS DocumentDate,
  OperationalJournalEntryItem.ClearingDate AS ClearingDate,
  OperationalJournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  OperationalJournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  OperationalJournalEntryItem.ReferenceDocument AS ReferenceDocument,
  OperationalJournalEntryItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  OperationalJournalEntryItem.PurchasingDocument AS PurchasingDocument,
  OperationalJournalEntryItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  OperationalJournalEntryItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  OperationalJournalEntryItem.TransactionCurrency AS TransactionCurrency,
  OperationalJournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  OperationalJournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  OperationalJournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OperationalJournalEntryItem.GlobalCurrency AS GlobalCurrency,
  OperationalJournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  OperationalJournalEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  OperationalJournalEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  OperationalJournalEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  OperationalJournalEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  OperationalJournalEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  OperationalJournalEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  OperationalJournalEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  OperationalJournalEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  OperationalJournalEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  OperationalJournalEntryItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  OperationalJournalEntryItem._CompanyCode AS _CompanyCode,
  OperationalJournalEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  OperationalJournalEntryItem._DebitCreditCode AS _DebitCreditCode,
  OperationalJournalEntryItem._FinancialAccountType AS _FinancialAccountType,
  OperationalJournalEntryItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  OperationalJournalEntryItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  OperationalJournalEntryItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  OperationalJournalEntryItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  OperationalJournalEntryItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  OperationalJournalEntryItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  OperationalJournalEntryItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  OperationalJournalEntryItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  OperationalJournalEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  OperationalJournalEntryItem._GlobalCurrency AS _GlobalCurrency,
  OperationalJournalEntryItem._TransactionCurrency AS _TransactionCurrency
INNER JOIN I_StRpJournalEntryLog AS ReportedItemLog ON /* join condition not captured in parsed metadata */
INNER JOIN P_CO_DIANGeneralLedgerAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CO_DIANOneTimeAccountBP AS _OneTimeAccountBP ON _OneTimeAccountBP.CompanyCode = CompanyCode AND _OneTimeAccountBP.AccountingDocument = AccountingDocument AND _OneTimeAccountBP.FiscalYear = FiscalYear  -- association [0..1]
;

Depth:

P_CO_DIANStRpJournalEntryItemC view

I_StRpJournalEntryLog view
P_CO_DIANGeneralLedgerAccount view

P_CO_DIANStRpJournalEntryItm2 view
P_CO_DIANStRpJrnlEntriesWthPO view