topic Re: doubt on structure in Application Development and Automation Discussions

doubt on structure

Former Member — Tue, 19 Aug 2008 10:26:38 GMT

hi,

i want to match a standard report and a zreport with its output,

in standard report the field is a structure where as in zreport it is a table.

so can i use the same structure in this z report?

Re: doubt on structure

Former Member — Tue, 19 Aug 2008 10:29:15 GMT

Normally in SAP screens fields are shown as Structure fields. But in actual case, the data held by these fields are been stored in tables. Structures can't hold data.

So, you need to use table field while writing a report.

Re: doubt on structure

Former Member — Tue, 19 Aug 2008 11:24:14 GMT

thanks, can u tell me in FBL1n transaction, they are using a field of open item key date.

which is the table here and the field.

i m not understanding this

Re: doubt on structure

Former Member — Tue, 19 Aug 2008 12:17:44 GMT

Hi,

ICRCS this is the table and the field is KEYDT Open Items at Key Date..

Raghunath.S

Re: doubt on structure

Former Member — Tue, 19 Aug 2008 12:29:34 GMT

Hi,

Yes .

Table - ICRCS

Field - KEYDT is key date.

Regards,

Bhupal

Re: doubt on structure

Former Member — Tue, 19 Aug 2008 12:36:21 GMT

its telling this table doesnt exist.

Re: doubt on structure

Former Member — Tue, 19 Aug 2008 12:40:29 GMT

Hi Poonam Naik .,

Transaction FBL1n is for standard report to display vendor Line Items .

open item key date is an 'Select Option Only ' .

Based on the date the report will fetch data and displays .

If you want to get simillar data Use BSIK(Accounting: Secondary Index for Vendors)

and BSAK (Accounting: Secondary Index for Vendors (Cleared Items))

tables to get open And Cleared items .

From these tables You can Fetch Data based on the Document Date Eq ( Or not equal or Less than ..etc) Itme Key date .

Hope This Helps You .

But i dont think You can data in ICRCS (ICRC: Status of Data Procurement ) .

thanks

Sreenivas

Re: doubt on structure

Former Member — Wed, 20 Aug 2008 06:35:28 GMT

thanks,

so you mean to say if i use BSAK table i can get all the items both open as well as leared right?

now suppose my key date is 31st march and some vendors have clearing date as 5 april,

then will this vendor be displayed for this key date?

kindly help me in this issue/

Re: doubt on structure

Former Member — Wed, 20 Aug 2008 08:47:48 GMT

Hi Poonam Naik

"so you mean to say if i use BSAK table i can get all the items both open as well as leared right?"

It is not correct . BSIK Contains All Open Items the standard report will fetch data from BSIK if you select "OPEN ITEMS" radio button and give 31st march . then it will fetch all documents whos document date is less than 31st march .

if you choose Cleared radio button it fetch same data from BSAK ( CLeared items table) .

Hope this is clear .. pl let me know if not .

thanks

Sreenivas Reddy

Re: doubt on structure

Former Member — Wed, 20 Aug 2008 09:42:22 GMT

i have one z report and i executed for key date 31st march,

the total is less

and in standard report it is more,

when i tried to check the difference between the two i found that one vendor is missing in zreport.

but when i give todays date as key date the totals are matching

Re: doubt on structure

Former Member — Wed, 20 Aug 2008 10:27:03 GMT

Check Why that vendor is missing in the debugging mode .

take the Accounting Document Numern ( BelNR) and Go to BSIK and BSAK tables compare the Document date / Posting date / clearing date ...

there might be mismatch at this level .

thanks

sreenivas Reddy

Re: doubt on structure

Former Member — Thu, 21 Aug 2008 07:28:39 GMT

thanks,

i used both bsik and bsak,

there is a mismatch in Belnr.