customer hierarchy upload_v1.0

7/21/2019 Customer Hierarchy Upload_v1.0

http://slidepdf.com/reader/full/customer-hierarchy-uploadv10 1/12

SAP Implementation at PIL Conversion- Functional Specification

Functional Specification - ConversionCustomer hierarchy Upload

Document Reference: !D"ersion: "#$%Document Status: Si&ned 'ff

Author: S(ati )u*hopadhyay

Last Revision Date: +%,##,+%%Date Created: +%,##,+%%Date Printed: +%,##,+%%

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e " of "2#



SAP Implementation at PIL Conversion - Functional Specification

Document Control

!usiness Area S$

.AP ID %&$

FS Definition Form ID %&$

ype of development Conversion

SAP R,/ "ersion 'CC (.0

.lo0al , )ar*et %&$

Approval and Distri0ution

Approved 0y 1ame Role Si&nature Daterocess %eam

)ead

%&$ %&$ %&$ %&$

$evelopment%eam )ead

%&$ %&$ %&$ %&$

Document 2istory

"ersion Reason for chan&e Date".0 *nitial $esi!n 20+""+2006"."

".2".,

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e 2 of "2 #




a0le of Contents

" 'N' /) *NF 1/%* N ..............................................................................................................2 &US*N'SS N ''$S 3 '4U* '1'N%S .........................................................................................(, * SSU'S ......................................................................................................................................(

S ')'C%* N S C ''N $ '%/*)S 5 *F / )*C/&)' ...........................................................................(( S %/ %*N C N$*%* N .................................................................................................................66 / SSU1 %* NS ............................................................................................................................67 &US*N'SS U)'S .......................................................................................................................68 $ /%/ C )'/NS*N '4U* '1'N%S ..............................................................................................69 ' :% /C% ) *C .........................................................................................................................6"0 C U 'NC; /N$ UN*%S F 1 '/SU ' ..........................................................................................7"" ) /N U/ ' F %':%S .................................................................................................................7"2 F *)' ) /; U% 5*N S'4U'NC' ......................................................................................................7", $ /%/ 1 / *N 1 /% *: ..............................................................................................................8

",." F &$C+C /)) % /NS/C%* N ...........................................................................................8",.2 F /)'+*$ C.................................................................................................................8",., F &/ *.........................................................................................................................8

" )S1 S 'C*F*C *NF 1/%* N ..................................................................................................9"( S 'CU *%; + / U%H *=/%* N '4U* '1'N%S ............................................................................."0"6 ' H /N$)*N > 1 N*% *N > 'C NC*)*/%* N ..................................................................."0

"7 $ ' 'N$'NC*'S ........................................................................................................................"0"8 % 'S%*N S C'N/ * S ................................................................................................................"0"9 / 'N$*C'S ............................................................................................................................"0

"9." / 'N$*: "? C US% 1 % /&)' ? <%/&)' N/1'#..............................................................."""9.2 ' % ) /; U% ..............................................................................................................""

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e , of "2 #




# .eneral Information

Area 3SAP System components4: SD Date: 20+""+2006

Re5uested 0y: %&$

Author: S@ati 1uAhopadhyay el no: %&$

Pro&ram ransaction code: =U )$BCUS%H*'

as* ID: %&$

Pro6ect 1ame: S/ *mplementation at *)

itle: Customer Hierarchy Upload

Short description: Customer Hierarchy Upload

Pro&ram type: &atch input nline transaction call $irect input

thers 5specify ? &/ *

Priority: Hi!h+mandatory 1edium+recommended )o@+optional

Comple7ity: Hi!h 1edium )o@

"olume of data: )edium

)ode: nline &acA!round

Fre5uency: $aily eeAly 1onthly &i@eeAly thers 5Specify ?

echnical information:". 4uality of le!acy data?2. Comple ity of le!acy data?,. Comple ity of manual input?

. NumDer of screens?

ood /vera!e oor Simple /vera!e Comple Eery comple Simple /vera!e Comple

"

.eneral information:Results if no conversions arecreated:

)e!al re uirements not fulfilled )acA of essential Dusiness information )acA of functions compared to le!acy system

thers 5Specify ?Is there an alternative in thestandard system8 ;es No

Description of alternative:

Reasons (hy alternative is notaccepta0le:

erformance proDlems Comple ity thers 5Specify ?

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e of "2 #




+ !usiness 1eeds 9 Re5uirementso@er *ndia )imited started its operation in the year "96(. From its humDle De!innin! in a small

to@n of 1aharashtra called anGan!aon *) has achieved several milestones and today it is oneof the lar!est manufactures of stora!e Datteries in *ndia. Currently the company is havin! sevenproduction facilities in *ndia namely anGan!aon> une> NashiA> Chennai> Hosur> ur!aon and$ur!apur respectively.

o@er *ndia )imited> the fla!ship company of the scar !roup is the marAet leader in thestora!e Dattery industry. *t manufactures @ide ran!e of Datteries from 2 /h capacities to "0(00

/h to cover the Droadest spectrum of applications.

%he S/ *mplementation at o@er *ndia )imited 5 *) @ill achieve the follo@in!?". Standardi e and streamline the Dusiness process2. 'staDlishin! an *nte!rated information repository,. *mprovement in the area of lannin!Complete visiDility of stocA

%he customer hierarchy in S/ is a fle iDle structure consistin! of customer masters. 'achcustomer @ith the e ception of the uppermost @ill refer to another customer in the hierachy.%he customer hierarchy @ill De used to represent the customerIs or!ani ational entity. /llcustomers @ill De part of the customer hierarchy. %he relationships Det@een the customers @illhave a validity reriod.

%here @ill De one customer hierarchy type.

/ Issues

None

Issue Issueo(ner

DateRaised

Issue Description Issue Resolution Resolved!y 9 Date

; Selection Screen Details 3 if applica0le 4

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e ( of "2 #




1ame a0le-Field ,Chec* !o7 ,

Radio !utton <(ith &roup

Parameter 3P4 , Select-option 3S4

Comments 3Ran&e=Sin&le,)ultiple

selection= Patterns=)andatory etc$4

Default "alue

Salesr!ani ation

JNEE-EJ 1andatory

$ivision JNEE-S / % 1andatory$istriDutionChannel

JNEE-E% ' 1andatory

%est un ChecA Do

File Name rl!rap-filename 1andatory

Desired screen desi&n 3selection possi0ilities4:5use attachment if necessary ?

> Startin& Condition%his pro!ram @ill run on demand Dasis.

Assumptions

/s the customer hierarchy consists of customer masters. %he customer masters is createdfirst.

/ccess to transaction E$H"N is availaDle.

? !usiness rulesNone

@ Data Cleansin& Re5uirements%o De completed Dy le!acy analysis team.

B7tract Lo&ic

Upload the file content into the !loDal internal taDle.*f upload is successful Dut internal taDle is empty !enerate error and stop processin!.)oop thru the aDove internal taDle.Upload the records in a structore of type DapiAna"BAnvhBprocess and pass it to &/ * functionmodule &/ *BCUS% 1' BH*' / CH*'B*NS.





*f return taDle is empty then increase a counter of success record.'lse increase a counter for error record.

/ppend all the parent customer>customer @ith error>messa!e type and >messa!e from &/ *return taDle in to a error taDle.'ndloop*f test run fla! is not set$isplay a popup for user confirmation. *f confirmed commit the &/ * transaction else stopprocessin!.if %'S% UN fla! is set then.

rite the information K%est un. $ata &ase Not updatedL in a popup Do .$splay the lo!.

rite arent Customer> Customer> 'rror %ype and 'rror messa!es for each record in theinternal taDle in different line.

rite total count for successful upload and total count of error records.

#% Currency and Units of )easureNone

## Lan&ua&e of te7ts%he te ts for the report should De displayed in UserLs lo!on lan!ua!e. *f translation is notmaintained in userLs lo!on lan!ua!e> he+she should De displayed @ith 'n!lish te ts.

#+ File Layout 3in se5uence4

Input , 'utput File 1ame

File ype e7t file

Location of the File Presentation Server Ref$ Field 1ame Field ype Startin&

PositionLen&th Decimal Format )andatory 3)4 ,

'ptional 3'4

1. PARENT_CUSTO MER

; 0 "0 N/ All these fieldswill beretrieved from

the file as fixed length recordsand internaltable fields willget populatedaccordingly.

2. VALID_FROM N "0 8 N/ ;;;;11$$

$o

,. CUSTOMER ; "8 "0 N/ $o

. VALID_TO N 28 8 N/ ;;;;11$$

$o




SAP Implementation at PIL Conversion-Functional Specification

#/ Data )appin& )atri7

#/$# For !DC,Call ransaction

1A

#/$+ For ALB,ID'C: 1A

#/$/ For !API1on-SAP SAP < !API Specific Information

Ref 1o

Field 1ame Position Len&th FieldDescription

Re5 d$3 ,14

ConversionRule , Lo&ic

!API 1ame Structure,Internal

a0le1ame

Field 1ameand

Description

Format Len&th Comments

&/ *BCUS% 1' BH*' / CH*'

B*NS

&/ *JN/" BJNEHB

C'SS

Customer From file

Sales r! Screen input

$ivision Screen input

EalidBfrom From file

CustHi%yp K/L

arentBCustomer

From file

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e 8 of "2#




1on-SAP SAP < !API Specific Information

Ref 1o

Field 1ame Position Len&th FieldDescription

Re5 d$3 ,14

ConversionRule , Lo&ic

!API 1ame Structure,Internal

a0le1ame

Field 1ameand

Description

Format Len&th Comments

arentBSales B r! Screen input

arentB$istrB Chan

Screen input

arentB$ivision

Screen input

EalidBto From file

#; LS)E Specific Information

None





#> Security , Authori ation Re5uirements /ccess to transaction E$H"N

# Brror 2andlin&= )onitorin&= Reconciliation• Standard 'rror handlin! Dy the system for re uired fields.

• *f file does not e ist or file is empty there @ill De and error messa!e.

• %here @ill De and error lo! Dased on the return messa!e of the &/ * function module.

• /n error list all customer masters that failed to De added to the customer hierarchy.

#? Dependencies

Customer 1asters must De loaded Defore the customer hierarchy can De completed

#@ estin& Scenarios

1ormal Functionality - test cases that ensure the conversion re5uirement as it should$

ID Description" checA the Sales r!> $ist channel and $iv of the customers !iven in test file from JNEE

and !ive the input on screen accordin!ly>test".t t is for successful upload and test2.t t isfor error

2 %est for successful upload.

, %est @hen the upload fails due to error.

B7ception - special lo&ic or e7ceptions

(6 Brror 2andlin& - functionality in case of errors

78

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e "0 of "2#




Sample est Files:

test1. txt test2. txt

# Appendices

# $# Appendi7 #: Custom a0le: G A!LB 1A)BH

None

a0le 1ameShort te7tSi e cate&ory

a0le maintenanceallo(edData class!ufferin&

a0le maintenance&enerationAuthori ation .roup

Field1ame Data Blement Domain ype Len&th Chec* a0le-Field

eyField Forei&ney Description

Comments

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e "" of "2 #




# $+ Report Layout

Customer Hierarchy Upload.doc 20-Nov-2006 < a!e "2 of "2 #

customer hierarchy upload_v1.0

Documents