topic Re: scenario for exercise in Application Development and Automation Discussions

scenario for exercise

Former Member — Wed, 15 Feb 2006 07:33:44 GMT

hi all,

I would be grateful to anybody who could provide me with a descriptive scenario for abap practice assignment .

Thanks in advance. Points would be rewarded.

Re: scenario for exercise

Former Member — Wed, 15 Feb 2006 07:39:06 GMT

Selection screen for Material Master Extract:

Parameters: Plant LIKE MARC-WERKS

File Path for Material Master like RLGRAP-FILENAME

PC File Check Box

Selection screen for Customer Master:

Parameters: COUNTRY LIKE KNA1-LAND1

File Path for Customer Master like RLGRAP-FILENAME

PC File Check Box

Logic For Material Master:

Get all the materials, weights, and material description of the materials for the languages ‘E’ (only till ‘;’) and languages ‘1’ for the given plant & download these details in the specified path on the local PC or application network

Logic For Customer Master:

Get all the customers and their address for the given country code.

We need to get all both the ship to party and sold to party address for all the Customers in a

particular Country. The following fields are required

Customer Number

Customer Name - Company Name

Address Types: Sold to Party and Ship To Party

Street,

City

Country

Post Code

File Download Process:

Create an outbound file for downloading in the specified path given.

If the PC File indicator is checked we need to download the file on the local PC - Presentation server,

else it will need to download the file on the application server.

Message was edited by: chandu

Re: scenario for exercise

Former Member — Wed, 15 Feb 2006 07:43:37 GMT

Table Fields Data Type Length Key

Employee

Employee Id Number 7 Key

Employee Name Char 40

Join date Date

Resignation Date Date

Base Location Code Char 4

Total Experience (in months) Number 3

IT Experience (in months) Number 3

SAP Experience (in months) Number 3

Project

Project Code Char 10 Key

Start Date Date Key

End Date Date Key

Project Base Location Code Char 4

TM's Employee Id Number 7

PM's Employee Id Number 7

Project Description Char 40

Specialization

Specialization Code Char 4 Key

Specialization Description Char 40

Location

Location Code Char 4 Key

Location Description Char 20

EmpProj

Employee Id Number 7 Key

Project Code Char 10 Key

Specialization Code Char 4 Key

Start Date Date Key

End Date Date Key

Location Code Char 4

EmpSpec

Employee Id Number 7 Key

Specialization Code Char 4 Key

Certified Yes/No

EmpLoc

Employee Id Number 7 Key

stdate Date Key

endate Date Key

Base Location Code Char 4

Create Tables as per naming convention

Use C1 ,C2…For identification while naming the objects

Create the relationship among tables - foreign key

Create search help where ever required

each table should have table maintainence

and create a simple report to pull out data from 2 or 3 tables to display some meaningful report for a given employee no and given date eg..Project details etc.

It should contain atleast 8 fields with all important fields like employee id project.