Tcode vf01 versus Tables / Help on Extraction

[Former Member]

In R3, with the tcode vf01, I entered a billing number and was able to see under Item Details for an Item #20, the Billed Quantity, Net Weight, Gross Freight and Pricing Date.

Also, under the Conditions tab, I saw Profit Margin and, Shipping and Handling.

1. While in R3, is there a way to see the name of the table which contains all the fields mentioned above, the invoice Number, item Number and Material Number.

I suspect this will be EKKO of EKPO but if I did not know this through readings, is there a way to see the particular table while in the tcode vf03?

2. So, for testing purposes on the development system, I want to extract only the above mentioned fields into an ODS in BW. Can you give me the steps in your own words since some documents I have see already from SAP are too detail and I find it difficult to follow.

[Former Member · Accepted solution]

Hi Toylee.

For (2), to get the field name in R/3, simple click on the required field, press F1 and click on the 'Technical Information' button.

For conditions, you will see the structure KOMV and field KBETR. To get the underlying tables for Conditions are a bit more difficult, since they are stored in condition records spread across several tables. For this purpose, SAP has delivered Standard Content to extract Conditions on item Level in 0SD_O05. Use this standard content and you will probably avoid having to extract information from all these tables.

For (1), EKKO and EKPO are tables for purchasing, while VF01 is a Sales and Distribution (SD) transaction. If you are looking at the purchasing information for the material, these are the correct tables. If you want the sales order or billing document details for the material, tables:

VBAP: Sales Doc header

VBAP: Sales Order Item

VBRK: Billing Document: Header Data

VBRP: Billing Document: Item Data

Again, there is standard content for all this information. However, if you need to extract from these tables where SAP does not provide a specific field, you can create a generic datasource and extract from that. The steps are:

1 - Create a view of the required tables with transaction SE11. You will need to add the tables and join fields.

2 - Create the Generic Datasource with transaction RSO2. Select transaction data and enter the required name.

2a - Select the application component, in this case SD, enter the description and then add your table/view.

2b - Create a generic delta for the extract if you plan to do delta loads.

3 - Replcate the datasources in BI.

4 - Create your DSO/Cubes, transformations etc in BI on this generic datasource.

Hope this helps. Let me know if you have more questions.

Please award points if helpful.

L.