Please help me out
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.
John Treweeks replied
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!)