LEFT SHIFT ASSIGNMENT SAP PART 1
- Create database table with the following requirements: (Using Direct Data Type)
| Field Name | Data type | Length | Field Description | |
| LIFNR | CHAR | 10 | Vendor Number | Primery Key |
| NAME1 | CHAR | 35 | Vendor Name | |
| ORT01 | CHAR | 35 | Vendor City | |
| ORT02 | CHAR | 35 | District | |
| STRAS | CHAR | 30 | Street |
- Create above table using domain and data element.
- Create a search help for field LIFNR form above table and add at table level.
- Create a secondary index of the above table with ORT01 and ORT02 fields.
- Create a table maintenance generator for the above table.
- Create a database view for the database tables KNA1, KNBI.
- Create a classic ALV report using table VBAK, VBAP and KNA1 table with top-of-page event.
- Selection Screen
Select Option: Sales Order Number
Select Option: Creation Date
| Creation Date (VBAK-BUDAT) | Sales Order (VBAK-VBELN) | Customer Number (VBAK-KUNAG) | Customer Name (KNA1-NAME1) | Item Number (VBAP-POSNR) | Material (VBAP-MATNR | Quantity (VBAP-MENGE) |
- ALV template
- TOP of PAGE
Name of Report
Date and Time
- In the above report sort, the final table with date and add sub total row with total quantity of that date (use control break statement to achieve that).
- Write an ABAP program to display username, date, time, and sum by providing two inputs.
Get expert help for LEFT SHIFT ASSIGNMENT SAP and many more. 24X7 help, plag free solution. Order online now!
