Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Please help me out

Hi,

I am very much new to SAP b1.

i wanted to know tcodes used in sap b1. Also is there a way i can find the tables related to sales order like the table SE11 in SAP R/3 gives information of all the tables.

Former Member
replied

No Problem.

By using the query generator, you select first the table, then the fields you want. this then builds the query for you.

all you then need to know are the tables and fields of where the data you want is stored. To do this, use the View System Information, and hover over the fields that i spoke of earlier. Does this make sense and does it work? can you do the following:

1. Load a sales order

2. click view> system information

3. hover over the following fields:

a) BP code

b) Item code

c) Item Description

d) document number

e) posting date

4. after each hover select the info found on the status bar on the query generator

5. click execute

If you struggle with any part of this example please post where you struggled and i will explain where you are going wrong (hopefully!)

John

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question