SIS, LIS etc tables for VBRK and VBRP tables

[Former Member]

Dear gurus,

I am looking for SIS or LIS etc. tables for VBRK and VBRP fields.

Can anyone tell methese tables?

[Former Member · Accepted solution]

http://www.scribd.com/doc/23491525/How-to-Work-With-SIS-Structures

Try this

[Former Member]

hi,

please elobarate your question please.

regards,

balajia

[Former Member]

Edited

Edited by: Fsmehmet on Nov 2, 2010 11:57 AM

[Former Member]

I prepeared a spec for sales report.

I used fields below.

itab-vkorg=vbrk-vkorg

itab-vkorg_text

itab-vtweg=vbrk-vtweg

itab-vtveg_text

itab-kunrg=vbrk-kunrg

itab-kunrg_text

itab-vkgrp=vbrp-vkgrp

itab-vkgrp_text

itab-vkbur=vbrp-vkbur

itab-vkbur_text

itab-matnr=vbrp-matnr

itab-matnr_text

itab-fklmg(01) (cumulated fklmg by week of fkdat)

itab-fklmg(02) (cumulated fklmg by week of fkdat)

itab-fklmg(03) (cumulated fklmg by week of fkdat)

itab-fklmg(04) (cumulated fklmg by week of fkdat)

itab-fklmg(05) (cumulated fklmg by week of fkdat)

u2026..

itab-fklmg(n) (cumulated fklmg by week of fkdat)

itab-diff = will be calculated as itab-fkimg(n)u2013itab-fkimg(n-1)

itab-vrkme=vbrp-vrkme

itab-total =will be calculated.

But project leader wants me to use SIS tables. However when I check SIS tables, these are related with VBAK, VBAP etc.

But i need VBRK VBRP table- fields in SIS, LIS tables.

Is it possible to?

[Former Member]

Hello Mehmet

What your project leader may be implying is to use SIS reports and not SIS tables. But if you want to use the SIS tables, you have Standard SIS tables S001- S005 with some fields that may be useful to you.

For example Standard Infostructure S001 has Key figures like Invoiced sls: gross, Net invoiced sls 1 and Net invoiced sls 2 which are brought in from the communication structure MCVBRP ( Billing Item data). These MCXXXX tables are shadow tables to standard tables (VBAP/VBRP etc.) and are meant for SIS purposes.

Hope this helps.

[Former Member]

hi

if you want VBR and VBRP table fields in infostructure then you can create a new info structure and proceed further.

if and only if in standard info structures lie s001 to s.... in not there and if they are also its not satisfying yout requriment.

then you can go new infostructure creation according to your requriment and create it and seeit.

regards

balajia