functional inputs on STO

[former_member208541]

Hi all,

i have to give functional inputs for a customised report. The report will have colums for STO no, Plant, outbound delivery for STO and the invoice created with respect to the said outbound delivery.

my question is how to relate that for a particluar STO, what is the delivery no and what is the invoice no. what functaional inputs (table and fields to be given so that the out delivery wrt STO and invoice number wrt to such out delivery gets refelcted in the report, i mean how to co-relate all the things.)

awaiting replies

regards

sachin

[Former Member]

Hi Sachin,

The tables would be

1. EKKO - Purchase document Header

2. EKPO- Purchase document Item

3. LIKP - Delivery Header

4. LIPS - delievry Item

5. VBRK - Billing HEader

6. VBRP - Billing Item

Choose the fields what you want from these tables. In case you want specific details you can go Open any one of the documents either a Delivery/billing Document and go to Document Flow and then Select a particulat field and then Press F1 and go to Technical Information, This will display the Table and the Field name.

Revert back if you want anyfurther Info

REWARD IF IT HELPS

Regards

Srini

[former_member208541]

hi, thanks for the info.

but if i want to tell to abaper to pick up deliveries and invoices for a particluar STO, how to co-relate that between different tables.

regards

sachin

[Former Member]

Hi sachin,

you give fields and tables to the aber and he/she will make a report. in the report they will give use some ALV grid control etc to pick up data from data base and this is for output of report. In the input screen they can give selection criteria ie., PO's from and TO and also Date (from & To) PO Doc type (From & To ) etc.

report wopuld be based on the selection screen inputs. these can be made as mandetory / optional. this abaper can do. You don't need to worry about the other things.

AS far as FS is conserned you need to give them

1. what are the input fields and tables data

2. Whether input fields are optional / mendetory

3. how the output report screen should look like i.e, PO No, PO Value, Delievry qty etc what ever you want. here again you need to give them the particular Table and filed names only.

Hope this Helps. give me your mail Id i will send in some sample FS.

REWARD POINTS IF IT HELPS

Regards

Srini

[Former Member]

Check the table VBFA as this table gives the document flow

i.e., the previous and the precceding documents.

Regards,

Gauravjit.

Reward points if the solution is helpful

[Former Member]

hi

1. Purchase order oo Purchase scheling document

2.Delivery type ( NL or NLCC) in LIKP table and Item In LIPS.

3.Billing type ( JEX -excise india invoice ) in VBRK and item in VBRP

Rewards point it helps

[Former Member]

hi

sto are of two type 1. intra sto between plants and 2. inter between plant of two different company codes.

i thinks yours is intra sto between plants

exactly i dont no the fields , let u give the clear picture

1. purcharse order is created. (me21n). mm setting

2. Delivery with respect to purchase order (vl10b) sd setting.(likp table)

3. invoice the delivery (vf01) (vbrk)

so i think u can get more information

i will provide u

thanks and regards

K.Gopal Krishna