Solved: scenario for exercise

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

Former Member · ‎2006 Feb 15

Can u plz tell me which material table has the fields u mentioned & what is language 1 ?

Former Member · ‎2006 Feb 15

Hi,

for material master you can see MARA, MAKT, MARC, MARD tables.

MAKT is the text table for MARA there you can find the language key.

regards

vijay

Former Member · ‎2006 Feb 15

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.