cancel
Showing results for 
Search instead for 
Did you mean: 

#COE #BA01 Referencing Clearing Status in a CDS view

RyanMuller
Participant
0 Kudos

Hello,

Is there a discrete field in a CDS view that gives the Open or Cleared status for a GL line item or is this only derived by whether the Cleared JE or Cleared date fields are populated? We're trying to understand whether we need to add logic to our management reporting integration or can drive off of a specific field in an available CDS view.

Thanks,

Ryan

OwenLiu
Product and Topic Expert
Product and Topic Expert
0 Kudos

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

Accepted Solutions (1)

Accepted Solutions (1)

Cora_Phelan
Product and Topic Expert
Product and Topic Expert

All information are available in our ACDOCA views:

C_JournalEntryItemBrowser


I_JournalEntryItemBrowser


I_JournalEntryItem


I_GLAccountLineItemRawData

But only in C_JournalEntryItemBrowser it is made “visible” (bold). This is done in the UI.

You can make this in all in own views or custom CDS.

The 5 possible cases you see at the end of C_JournalEntryItemBrowser.

We have not only “cleared vs open”, we have “cleared vs open AT KEYDATE”

The easy case

OPEN , if ClearingDate = '00000000' <<<< this is very easy (independent of date)

CLEARED , ClearingDate = is filled <<<< here the user wants more information

Today Cleared , but 5 days ago it was open

where

(

( ClearingStatusSelection = '1' ) // All Items

or

( ( ClearingStatusSelection = '2' ) // Open Items 4 OIM

and ( PostingDate <= :P_KeyDate )

and ( ( ClearingDate > :P_KeyDate ) or ( ClearingDate = '00000000' ) )

and ( IsOpenItemManaged = 'X' )

) or

( ( ClearingStatusSelection = '3' ) // Open Items 4 All

and ( PostingDate <= :P_KeyDate )

and ( ( ClearingDate > :P_KeyDate ) or ( ClearingDate = '00000000' ) )

) or

( ( ClearingStatusSelection = '4' )

and ( PostingDate <= :P_KeyDate )

and ( ClearingDate > :P_KeyDate )

) or

( ( ClearingStatusSelection = '5' )

and ( ClearingDate <> '00000000' )

)

Answers (1)

Answers (1)

Cora_Phelan
Product and Topic Expert
Product and Topic Expert

In app Display Line Items in General Ledger (App ID F2217) you can add the column Item Cleared in settings. This will have value True or False for line item.

In help.sap.com documentation App Extensibility: Display Line Items in General Ledger (Key User)

The following is stated:

"The app uses the top CDS view C_JournalEntryItemBrowser, and if you want to use fields from the underlying view, you have to choose the Journal Entry Item Browser (I_JournalEntryItemBrowser) CDS view"

In app View Browser for cds view C_JournalEntryItemBrowser

Definition:

The Column Name: IsCleared

Description: Item cleared

RyanMuller
Participant
0 Kudos

Thanks cora.phelan ,

I've tried joining this to the I_GLLineItemRawData main source table and found that the CDS view above (I_JournalEntryItemBrowser) requires a parameter entry to define which clearing status you want to see which doesn't align with the use case. We're looking for the status of all GL Line Items for reporting, not just cleared or open.

I'm a bit perplexed as well as to why this status isn't available in the I_GLLineItem or I_AccountingDocumentItem views or their associated joins.

Thanks,

Ryan