Welcome to the Efficient eLearning S A P training series. In this video we'll be looking at
identifying the tables and fields for a QuickView reporting on vendor master deletion flags.
And this is the breakdown of the topics. First we'll review the reporting requirement.
We'll then display a vendor in transaction XK03 and locate the tables and fields for the deletion
flags. And finally we'll analyze the relevant vendor master data tables using the data browser
(transaction SE16) to identify the remaining fields for the QuickView.
Let's review the reporting requirement.
In this example we wish to report on vendor master
records flagged for deletion at both general level and company code level.
The report must include all vendors regardless
of whether the vendor has been extended to company code level.
Additionally, the report must include the central deletion flag
and the deletion flag at company code level.
Here's the mock-up of the report output created in Excel.
The following fields are required on both the selection criteria screen and the report output:
the vendor code,
the vendor name,
the central deletion flag, the company code and the deletion flag at company code level.
As previously mentioned we'll source the tables and fields
for the deletion flags using the display vendor transaction
(XK03) and then use the data browser (transaction SE16) to identify the remaining fields.
Let's now display one of the vendors and identify the tables and fields for the deletion flags.
If you're new to S A P it's worth noting where the display vendor transaction
(XK03) resides in the S A P standard menu. Start with the "Accounting" folder. To expand the folder
click on the triangular icon to the left of the folder name.
Then "Financial Accounting",
"Accounts Payable",
"Master Records", "Maintain Centrally".
Double-click on the entry for "XK03 - Display".
Enter the vendor code and company code and then click the "Select All" button.
Then click the ENTER button to display the vendor.
Press the ENTER key on the keyboard to bypass the warning message.
Click on the "Extras" menu and choose "Deletion Flags".
These are the two fields that will form the basis of our QuickView.
Click on the check box to the left of "All Areas" and press the F1 button on the keyboard.
Click on the "Technical Information" button.
Thankfully, the table name and the field name are listed and we can use this information to build
our QuickView. However, please note this method of finding the table name and field name won't
work in all transactions. Note the table name and the field name for this central deletion flag.
Click the "Cancel" button
and click the "Close" button.
Now click on the checkbox to the left of "Selected
Company Code" and press the F1 button on the keyboard.
Click on the "Technical Information" button.
Note the table name and field name for this deletion flag for selected company code
then click the "Cancel" button and click the "Close" button.
This exercise has provided us with the tables that contain all the fields required for our QuickView
namely table LFA1 (Vendor Master General Section) and table LFB1 (Vendor Master Company Code).
We can now view the relevant entries in those tables using the data browser
(transaction SE16) to identify the remaining fields for our report.
Click the "Back" arrow three times to return to the S A P main menu.
Click the "S A P Menu" button to collapse the menu.
Let's now execute the data browser transaction (transaction SE16)
and analyze the tables to find the relevant fields. Start with the "Tools" folder,
then "ABAP Workbench"
and "Overview".
Double click on the entry for "SE16 - Data Browser".
As you can see it defaults to the last table name that was used.
Enter the first table name (LFA1) and then click the ENTER button.
I've set up a range of vendors specifically for this video so
I'll just type in that range of vendor numbers and then click the "Execute" button.
I can then select a vendor and click the "Display" button.
Now click in the "Vendor" field and press the F1 button on the keyboard.
Click on the "Technical Information" button.
Note the table name and the field name.
Click the "Cancel" button
and then click the "Close" button.
Now click in the "Name" field and press the F1 button on the keyboard.
Click on the "Technical Information" button.
Again note the table name and the field name.
Click the "Cancel" button and then click the "Close" button.
We now have all of the field names from table LFA1. Click the "Back" arrow three times.
Now enter the second table name (LFB1) and click the ENTER button.
Again, I'll simply type in the range of vendor numbers that I created for this video and click
the "Execute" button. I can then select a vendor and click the "Display" button.
Now click in the "Company Code" field and press the F1 button on the keyboard.
Click on the "Technical Information" button
and note the table name and the field name.
Click the "Cancel" button then click the "Close" button.
We now have all of the field names from table LFB1
so we can click the "Back" arrow four times to return to the S A P main menu.
This is the revised mock-up of the report with the table and field names included.
We now have all of the information required to create the QuickView in S A P.
That's all of the content for this video. Remember to give it a "Like" and subscribe
if you'd like to be notified when new videos are uploaded. Thanks for watching.