alv-inventory transaction report

7/23/2019 ALV-Inventory Transaction Report

http://slidepdf.com/reader/full/alv-inventory-transaction-report 1/12

SAP Implementation at PIL

ALV Report - Functional Specification

Note: As this is a case study that simulates a real life development object, some fields will be marked as TBD

and highlighted in Blue. These fields should be having real values, in customer development specifications.

Functional Specification - ReportInventory Transaction Report

Document Reference: TBD Version: 1.0Document Status: Sine! "ff

Aut#or: A!itya $umar Pattnaya%

Last Revision Date: &0'(ov')00*Date +reate!: &0'(ov')00*Date Printe!: &0'(ov')00*

ALV-Material Master Report.doc 30-Nov-2006 <a!e " of "2#



SAP Implementation at PIL ALV Report - Functional Specification

Document +ontrol

Business Area $rder Man!e%ent

,AP ID &'(

-S Definition -orm ID &'(

SAP R& Version )** +.0

,lo/al ar%et &'(

Approval an! Distri/ution

Approve! /y (ame Role Sinature Date

rocess &ea%Lead

&'( &'( &'( &'(

(evelop%ent&ea% Lead

&'( &'( &'( &'(

Document istory

Version Reason for c#ane Date

".0 ,nitial Version 30-Nov-2006

"."

".2

".3

ALV-Material Master Report.doc 30-Nov-2006 <a!e 2 of "2 #




Ta/le of +ontents

". )N)RAL ,NF$RMA&,$N..............................................................................................................

2. '/S,N)SS N))(S R)1/,R)M)N&S..........................................................................................+

3. ,SS/)S......................................................................................................................................+

. S)L)*&,$N S*R))N ()&A,LS.....................................................................................................+

+. */RR)N& F/N*&,$NAL,&..........................................................................................................6

6. ()S,R)( F/N*&,$NAL,&...........................................................................................................6

. &)*4N,*AL ()&A,LS...................................................................................................................6

.".)5&RA*& ( A&A R)LA&,$NS4, (,ARAM.....................................................................................

. S&AR&,N *$N(,&,$NS...............................................................................................................

7. S)*/R,& R)1/,R)M)N&S8 A/&4$R,9A&,$N ()&A,LS..................................................................

"0. ( A&A M A,N & A'L)S..............................................................................................................

"0.". ()S,R)( R)$R& ()S,N8L A$/&:................................................................................."0"0.2. R)$R& )5AML):.........................................................................................................."0

"". */S&$M & A'L)S8S&R/*&/R) ,N SA.......................................................................................""

"2. R)*$V)R AN( R)S&AR&.........................................................................................................""

"3. L AN/A) $F &)5&S................................................................................................................""

". */RR)N* AN( /N,&S $F M)AS/R)........................................................................................""

"+. ASS/M&,$NS..........................................................................................................................""

"6. )RR$R 4 AN(L,N...................................................................................................................."2

". &)S&,N S*)NAR,$S................................................................................................................"2





1. ,eneral Information

Area 2SAP System components3: $RM Date: 30-Nov-2006

S#ort !escription: ,nventor; &ransaction Report

Re4ueste! /y: &'( Tel no: &'(

Aut#or: Adit;a u%ar attna;a Tel no: &'(

Proram Transaction co!e: &'(

Tas% IDDeman! (um/er: &'(

Pro5ect (ame: SA ,%ple%entation at ,L

Priority: 4i!=8%andator; Mediu%8reco%%ended

Lo>8optional

+omple6ity: 4i!= Mediu% Lo>

Volume of !ata: Mediu% ( A&) AVA,LA'L) FR$M: &'(

o!e: $nline 'ac!round

-re4uency: (ail; ?eel; Mont=l; 'i>eel;

$t=ers @Specif; : N8A

Tec#nical information:

". Report created usin!:

2. *=aracteristics reBuired:

Report ainter Report ?riter SA 1uer;

A'A pro!ra% ,nfo s;ste%

R83 '? *r;stal Reports

(rilldo>n 'uttons Sort

ALV rid ALV List

)ntr; file $t=ers: *all &ransaction

,eneral information:

". Results if no Reports arecreated:

Le!al reBuire%ents not fulfilled

Lac of essential Cusiness infor%ation

Lac of functions co%pared to le!ac; s;ste%

$t=ers @Specif;:

D7RATI"( "- D8V8L"P8(T 9"R$

2I( A('DAS3:"0 da;s @*odin!D(ocu%entationD&estin!

Is t#ere an alternative in t#estan!ar! system;

es No

Description of alternative:

Reasons <#y alternative is not

accepta/le:

erfor%ance proCle%s *o%pleEit;

$t=ers @Specif; :

ALV-Material Master Report.doc 30-Nov-2006 <a!e of "2 #




). Business (ee!s = Re4uirements

&=is is t=e standard M'+" (ocu%ent Report >it= t=e addition of five ne> fields. ,ts purpose is to s=o> priortransactions fro% =istor; to enaCle t=e user to do Bualit; c=ecs @,.e. c=ec correctness of put >a;G inventor;%ovesG etc. s=o> lostG scrappedG etc.

&. Issues

None

Issue>

Issueo<ner

DateRaise!

Issue Description Issue Resolution Resolve!By = Date

?. Selection Screen Details-iel! (ame Selection

Te6tDescription

Type of -iel!2c#ec% /o6@ra!io /[email protected]

List ofVali!ValuesRe4uir e!2(3

Vali!ationRe4uire!2(3

DefaultValue

+omments2rane@ patterns@sinlemultipleselection@man!atory@ etc.3

MS)-MA&NR Material Select-$ption $ptional

MS)-?)RHS lant Select-$ption $ptional

MS)-L$R& Stora!eLocation

Select-$ption $ptional

MS)-*4AR 'atc= Select-$ption $ptional

MS)-L,FNR Vendor Select-$ption $ptional

MS)-H/NNR *usto%er Select-$ption $ptional

MS)-'?AR& Move%ent&;pe


MS)-S$'H9 Special Stoc Select-$ption $ptional

ALV-Material Master Report.doc 30-Nov-2006 <a!e + of "2 #




-iel! (ame SelectionTe6tDescription

Type of -iel!2c#ec% /o6@ra!io /utton@

etc.3

List ofVali!Values

Re4uir e!2(3

Vali!ationRe4uire!2(3

DefaultValue

+omments2rane@ patterns@sinlemultiple

selection@man!atory@ etc.3

MHF-'/(A& ostin! date Select-$ption S;ste% Validated $ptional

MHF-/SNAM /ser Na%e Select-$ption $ptional

MHF-VAR& &rans.8 )vent&;pe


MHF-5'LNR Reference Select-$ption N N $ptional

Desire! screen !esin 2selection possi/ilities3:@/se attac=%ent if necessar;:

. +urrent -unctionality*urrentl; SA does not =ave t=e four eEtra fields.

*. Desire! -unctionality

&=is is t=e standard M'+" (ocu%ent Report >it= t=e addition of four ne> fields. ,ts purpose is to s=o>prior transactions fro% =istor; to enaCle t=e user to do Bualit; c=ecs @,.e. c=ec correctness of puta>a;G inventor; %ovesG etc. s=o> lostG scrappedG etc.

. Tec#nical Details

&=e Report >ill Ce a =ierarc=ical ALV List Report.

&=e processin! lo!ic s=ould Ce as follo>s:





Start

,s data foundIenerate )rror Messa!e

JNo data foundJ

Retrieve lantNa%e@NAM)"

fro% taCle &00"?for all entries in&KMA&K(A&A

>=erelant@?)RHS &KMA&K(A&A-

?)RHS.

Retrieve $Cect listnu%Cer@$'HNR fro%

taCle S)R03 for allentries in &KMA&K(A&A

>=ere Nu%Cer of Material (ocu%ent

@M'LNR

&KMA&K(A&A-M'LNRand Material (ocu%ent

ear @MA4R &KMA&K(A&A-MA4R

and ,te% in Material(ocu%ent @9),L)

&KMA&K(A&A-9),L).

Retrieve SerialNu%Cer@S)RNRfro% taCle $'H>=ere $Cect list

nu%Cer@$'HNRS)R03-$'HNR.

Retrieve &ransaction (escri@'&)5& fro% taCle &"+6&

all entries in &KMA&K(A&>=ere SRAS S-LAN

and Move%ent &;pe @'?AR

&KMA&K(A&A-'?AR&and Special Stoc ,ndicat@S$'H9 &KMA&K(A&

S$'H9and Move%ent ,ndicator

@H9')? &KMA&K(A&

H9')?and Receipt indicator @H99/

&KMA&K(A&A-H99/and *onsu%ption postin

@H9V'R &KMA&K(A&AH9V'R.

Move t=e =eader data and ite% data to

t>o separate internal &aCles for output in ALV For%at.

$utput report in ALV for%at usin! function%odule

OR)/S)KALVK4,)RS)1KL,S&K(,SLAO.

No

es

Retrieve fields M'LNR@Nu%Cer of Material (ocu%entG

MA4R @Material (ocu%ent

earG '/(A& @ostin! (ate int=e (ocu%ent fro% taCle MHF

into an internal taCle&KMA&K(A&A for user input in t=e

selection screen.

Retrieve fields 9),L) @,te% in Material(ocu%entG'?AR&@Move%ent &;peG

MA&NR @Material Nu%CerG?)RHS@lantGL$R&@Stora!e LocationG*4AR@'atc= No G

S$'H9@Special Stoc ,ndicatorG)RFM@1uantit; inunit of entr; G )RFM)@/nit of entr;G

H9')?@Move%ent ,ndicatorG H9V'R@*onsu%ption postin!G H99/ @Receipt indicator G

S4H9 @(eCit8*redit ,ndicator fro% taCle MS)

into an internal taCle &KMA&K(A&A for user input int=e selection screen.

,nner oin

Retrieve ',SM& @$ldMaterial Nu%Cerfro% taCle MARAfor all entries in

&KMA&K(A&A >=ereMaterial

Nu%Cer@MA&NR &KMA&K(A&A-MA&NR

Retrieve Material(escription@MAH&5

fro% taCle MAH& for allentries in

&KMA&K(A&A >=ereMaterial Nu%Cer

@MA&NR &KMA&K(A&A-MA&NR

and

Lan!ua!e He;@SRAS

S-LAN/

,nner oin ,nner oin





.1. 86tract Data Relations#ip Diaram

C. Startin +on!itions

&o run t=is reportG t=ere are no dependenciesG as it directl; eEtracts data fro% %aterial %aster

taCles.

&=is report >ill Ce run on de%and and once per >ee.

. Security Re4uirements Aut#oriEation Details

None

10. Data appin Ta/les

-iel! (ame -iel! Description Lent#

-ormat

Sort -iel! +alculation+omments

MS)-MA&NR Material "8Left &=is field is displa;ed in t=e 4eader

MARA-',SMA& $ld Material Nu%Cer "8Left &=is field =as Ceen added to t=estandard M'+" report and isdispla;ed in t=e 4eader.

MAH&-MAH&5 Material (escription 08Left &=is field is displa;ed in t=e 4eader

MS)-?)RHS lant 8Left &=is field is displa;ed in t=e 4eader

&00"?-NAM)" lant Na%e 308Left &=is field is displa;ed in t=e 4eader

MS)-L$R& Stora!e Location 8Left





-iel! (ame -iel! Description Lent# -ormat

Sort -iel! +alculation+omments

MS)-'?AR& Move%ent &;pe 38Left

MHF-M'LNR Material (ocu%ent "08Left

MS)-*4AR 'atc= "08Left &=is field =as Ceen added to t=estandard M'+" Report.

$'H-S)RNR Serial Nu%Cer "8Left &=is field =as Ceen added to t=estandard M'+" Report.

MS)-9),L) ,te% 8Left

MHF-'/(A& ostin! (ate 8Left

MS)-)RFM 1uantit; "38Ri!=t

MS)-)RFM) /nit of Measure%ent 38Ri!=t

&"+6&-'&)5& &ransaction (escription 208Left &=is field =as Ceen added to t=estandard M'+" Report.





10.1. Desire! Report DesinLayout: &=e default seBuence of output fields s=ould Ce as per data %appin! taCle.

10.). Report 86ample:

@use attac=%ent if necessar;:Attac# Sample ere

"RDD0069output.doc"

@&ransaction M'+"

Narrative Flo>

P" $ld Material Nu%Cer or roduct Nu%Cer. &=is colu%n needs to Ce to t=e i%%ediate left of QMaterial colu%n.

P2. 'atc=P s=ould Ce placed to t=e i%%ediate ri!=t of QMaterial (ocu%ent

P3. SerialP if applicaCle s=ould Ce placed to t=e i%%ediate ri!=t of Q'atc=P. P. 4andlin! unit P and8or Stora!e

unit P @&'( i%%ediatel; to t=e ri!=t of Serial PG 4/ S/ are onl; valid for ?M sites t=at first i%ple%ent in en2G>ill Ce Clan colu%ns for ,M sites.

P+. Move%ent t;pe &eEt >ill Ce t=e last colu%n of t=e report @to t=e ver; ri!=t.

ALV-Material Master Report.doc 30-Nov-2006 <a!e "0 of "2#




11. +ustom Ta/lesStructure in SAP

N8A

Ta/le (ame

S#ort te6t

SiEe cateory

Ta/le maintenanceallo<e!

Data class

Bufferin

Ta/le maintenanceenerator

Aut#oriEation ,roup

-iel!(ame

Data 8lement Domain Type Lent# +#ec%Ta/le'-iel!

$ey-iel!

-orein$ey

Description

+omments

1). Recovery an! Restart

,f t=e pro!ra% fails =alf >a; it >ill not =ave an; i%pact on an; ot=er processes or pro!ra%s. ,ts=ould Ce si%pl; re-started C; t=e user.

1&. Lanuae of te6ts&=e teEts for t=e report s=ould Ce displa;ed in /sers lo!on lan!ua!e. ,f translation is not%aintained in users lo!on lan!ua!eG =e8s=e s=ould Ce displa;ed >it= )n!lis= teEts.

1?. +urrency an! 7nits of easure

N8A

1. Assumptions

Material Master (ata is accuratel; %aintained in t=e s;ste%.

ALV-Material Master Report.doc 30-Nov-2006 <a!e "" of "2 #




1*. 8rror an!lin*=ec validit; of t=e para%eters entered in t=e Selection ScreenG and displa; error %essa!e ifinvalid input are %ade.

(ispla; ,nfor%ation %essa!e and leave processin! t=e listG if no %aterial data could Ce foundaccordin! to t=e selection criteria.

1. Testin Scenarios

Nor%al Functionalit; - test cases t=at ensure t=e report functions as it s=ould.

,( (escription

" ,nventor; transaction report is eEecuted successfull;.

2

3

)Eception - special lo!ic or eEceptions @e.!. report s=ould eEclude certain specific condition

+ ?=en function %odule R)/S)KALVK4,)RS)1KL,S&K(,SLA fails.

6

)rror 4andlin! - functionalit; in case of errors @e.!. )rror Messa!e or )rror Lo!

Validation of Material Nu%Cer

8 Validation of lant

9 Validation of Stora!e Location

"0 Validation of Vendor

"" Validation of *usto%er Nu%Cer"2 Validation of Move%ent &;pe

"3 Validation of Special Stoc

" Validation of /ser Na%e

"+ Validation of &ransaction8 )vent &;pe

"6 Validation of *o%Cination of Material Nu%Cer and 'atc=

" Validation of *o%Cination of Material Nu%Cer and lant

" Validation of *o%Cination of Material Nu%CerG lant and 'atc=

"7 Validation of *o%Cination of Material Nu%CerG lant and Stora!e Location

20 Validation of *o%Cination of Material Nu%CerG lantG 'atc=G Special Stoc ,ndicator and Vendor Nu%Cer

2" Validation of *o%Cination of Material Nu%CerG lantG 'atc=G Special Stoc ,ndicator and *usto%er Nu%Cer

ALV-Material Master Report.doc 30-Nov-2006 <a!e "2 of "2 #

alv-inventory transaction report

Documents