topic Re: sales order in Application Development and Automation Discussions

sales order

Former Member — Tue, 19 Sep 2006 13:34:52 GMT

i was asked to create a simple report to make sure the person who created the sales order did not release the sales order for billing.

for this i was asked to output

the order no

user id of the person who created the order

last name,first name of person who created the order

billing document no related to order

created by user id

last name,first name of the person associated with the billing document.

I dont know where i can get the user ids and the billing document no associated with a sales order.

I appreciate your help.

Re: sales order

Former Member — Tue, 19 Sep 2006 13:36:58 GMT

Try looking at VBAK, VBFA.

Maybe try looking into yourself before asking people to do your job aswell.

Re: sales order

Former Member — Tue, 19 Sep 2006 13:36:59 GMT

User ID of the person who created the sales order is VBAK-ERNAM.

Re: sales order

Former Member — Tue, 19 Sep 2006 13:37:33 GMT

Hai,

The field in VBAK contains the user id, the field is ERNAM.

Re: sales order

Former Member — Tue, 19 Sep 2006 13:38:08 GMT

U would get the Order information from VBAK table while the user details from USR03. ..The link for sales order and invoice in VBFA table OR you can use VBRP even (aubel field)

Re: sales order

Former Member — Tue, 19 Sep 2006 13:38:55 GMT

Field <b>VBAK-ERNAM</b> gives you Name of Person who Created the Sales Order.

Similarly, VBRK-ERNAM gives Name of Person who Created the Billing Document.

Regards,

Raj

Re: sales order

Former Member — Tue, 19 Sep 2006 13:38:59 GMT

sales order number: VBAK-VBELN

CReated by: ERNAM

first name and last name: table usr03-NAME1

NAME2

NAME3

NAME4 pass the ernam to usr03

billing document no related to order

VBRK-VBELN

created by user id : VBRK-ERNAM

last name,first name of the person associated with the billing document.

table usr03-NAME1

NAME2

NAME3

NAME4 pass the ernam to usr03

REgards,

Ravi

Re: sales order

former_member404244 — Tue, 19 Sep 2006 13:40:13 GMT

Hi priyanka,

the billing doucment number and sales order number are related by fields vbrk-vbeln to vbak-vgbel.and the userid u can get by VBAK-ERNAM.

Regards,

Nagaraj

Re: sales order

Former Member — Tue, 19 Sep 2006 14:28:15 GMT

Hi,

vbak-kunnr = kan1-kunnr ->kna1-name1

vbrk-aubel = vbak-vbeln.->vbrk-vbeln(billing document)

Regards

Amole

Re: sales order

former_member404244 — Tue, 19 Sep 2006 14:44:00 GMT

Hi Priyanka,

sorry for the early reply .

The billing doucment number and sales order number are related by fields VBRP-AUBEL to VBAK-VBELN.and the userid u can get by VBRP-ERNAM.

Regards,

Nagaraj