Skip to Content
0
Former Member
Apr 08, 2009 at 03:31 AM

Need billing item(POSNR) in order to Enhance 2LIS_13_VDITM?

108 Views

I want to enhance 2LIS_13_VDITM by using table BSEG. The logic is to extract HKONT and DMBTR from BSEG to 2LIS_13_VDITM based on Billing doc. nr. Now,I have one DSO "ZAAA" in BI system, which use 2LIS_13_VDITM, Key field: 0BILL_NUM, 0BILL_ITEM in DSO. I need to design one query to display billing nr (BELNR), G/L account(HKONT), Netsales(NETWR), Tax amount(MWSBP), Amount in local currency(DMBTR). Only need to display total amount of one billing doc, don't need to show item level.

The question is about field:BUZEI(Number of Line Item Within Accounting Document) in table BSEG. This field is not related billing item(POSNR). so, how to enhance 2LIS_13_VDITM? BSEG is the right table? Should I create a DB view, and including billing item(POSNR) into DB view? If yes, how to do it and which table should I join together?

Need to display in Query after enhancement

BUKRS;BELNR;HKONT;DMBTR;WERKS;FKART;NETWR;MWSBP;DMBTR

5000; 0656390987; 6330290; 6100; DFSA; 0,00; 117.028,00; 1.817.028,00

Reference informatiom

Table: BSEG

BUKRS;BELNR;BUZEI;BSCHL;DMBTR;HKONT;WERKS;FKBER

5000; 0656390987; 007; 50; 878.215,00; 0006330290; 6100; 0100

5000; 0656390987; 012; 50; 717.533,00; 0006330290; 6100; 0100

5000; 0656390987; 002; 50; 221.280,00; 0006330290; 6100; 0100

DSO "ZAAA" (Key field: 0BILL_NUM, 0BILL_ITEM) use Datasource 2LIS_13_VDITM

- Data display for DSO "ZAAA"

BUKRS;BELNR;POSNR;WERKS;FKART;NETWR;MWSBP

5000; 0656390987; 10; 6100; DFSA; 78.215,00; 0,00;

5000; 0656390987; 20; 6100; DFSA; 17.533,00; 0,00;

5000; 0656390987; 30; 6100; DFSA; 21.280,00; 0,00;

Thanks