doubt on structure

[Former Member]

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?

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

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

Raghunath.S

[Former Member]

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

[Former Member]

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/

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

thanks,

i used both bsik and bsak,

there is a mismatch in Belnr.

[Former Member]

Hi,

Yes .

Table - ICRCS

Field - KEYDT is key date.

Regards,

Bhupal

[Former Member]

its telling this table doesnt exist.