SAP-BODS integration using IDOCS By Praveen Addanki, HCL-AXON 1. Introduction: Imagine you want to build a Reorting !olution, not a "ata #are$ou%e in ure term%& !o %omebody oen% t$e balan'e %$eet reort and doe% not like t$e way it look%& !o a booking in !AP i% 'reated to 'orre't it and t$en&&&&$e $a% to wait t$e entire nig$t until t$e "ata #are$ou%e get% re(re%$ed& Anot$er otion would be to 'on(igure !AP %o it %end% all '$ange% to t$e reorting databa%e immediately& immediately& And And t$at i% w$at I"OC% are (or& On t$e down%ide t$oug$, to 'on(igure !AP to a'tually %end '$ange% i% )uite a '$allenge& I( an I"OC i% rovided by !AP already it i% not t$at bad, but i( you want to di%tribute '$ange% (or data !AP never t$oug$t about, you $ave to write your I"OC (rom %'rat'$ and $ook it into every %ingle ali'ation dealing wit$ t$at data& *$e ba%i' roblem i% t$e I"OC de%ign& It i% not like a databa%e trigger% t$at i% indeendent (rom all t$e ali'ation% and (ire% no matter w$o and $o w a '$ange $aened& It i% $aening on ali'ation level, %o t$ere i% a 'ommon ABAP 'all t$at $a% to be done at every %ingle ali'ation& In%ide !AP, a 'oule o( %etting% $ave to be made, t$i% 'on(iguration i% mandatory (or bot$ %ending and re'eiving I"OC%& *$e (ollowing 'on(iguration% %te% are involved to %end I"OC% (rom BO"! to !AP +CC& & "e(ine Logi'al !y%tem% & "e(ine R.C "e%tination /& "e(ining R.C Port0*ran%a'tional R.C1 2& "e(ine Partner Pro(ile Let u% %ee in brie( $ow to 'on(igure t$e above %te%3 2.SAP Configuration settings: 2.1
"e(ine Logi'al !y%tem%3
"e(ining Logi'al %y%tem% i% done in !AP +CC wit$ t$e tran%a'tion 4!AL+5& Note3 Note3 *$i% entire do'umentation re(er% to !AP I"+! %y%tem re(er t$e below %'reen %$ot (or detail&
+nter t$e *ran%a'tion 4!AL+5 to de(ine logi'al %y%tem and it% a%%ignment& A% t$i% 'on(irmation doe%n5t $ave aut$ori6ation we will re)ue%t ba%i% to 'reate it& Hen'e we u%ed t$e (ollowing logi'al %y%tem a% %$own below&
Cli'k on t$e above %$own to de(ine t$e logi'al %y%tem& *$e below ou 'ome 7u%t 'ontinue
*$e Logi'al %y%tem 'reated by ba%i% i% 4I"/CLN*895 a% %$own below&
& "e(ine R.C "e%tination3 +nter t$e tran%a'tion 4SM595 to 'on(igure t$e R.C de%tination in !AP +CC a% %$own below&
Cli'k on *CP:IP 'onne'tion% a% %$own above and t$e 'reate it&
On'e t$e R.C 'reated wit$ Regi%tered !erver Program 0Program I"1 a% 4"I;R.C5 a% %$own $ere& #it$ t$e de(ined rogram I", 'on(igure t$i% (rom BO"! %ide (rom management 'on%ole a% %$own below& Logon on to
R.C %erver 'on(iguration i% done a% %$own below&
*$e 'on(igured %erved need to be %tarted t$e inter(a'e a% %$own below&
Now '$e'k t$e 'onne'tion (rom !AP %ide a% %$own below& Cli'k on t$e 'onne'tion te%t a% %$own&
I( t$e 'onne'tion i% (ine t$en t$e (ollowing %'reen will aear&
& "e(ining R.C Port 0*ran%a'tional R.C13 +nter t$e tran%a'tion 4WE215 to 'reate t$e Port a% %$own& *$e R.C de%tination will be de(ined $ere&
& "e(ine Partner Pro(ile And (inally, we 'an 'on(igure !AP to route all I"OC% o( a given tye to "I by running t$e tran%a'tion =#+9=& >ou 'li'k on =New=, tye in t$e Partner Number 'reated in =:n%ale= 0we 'alled it I"/CLN*891 and it% tye i% =L!=&&&&Logi'al !y%tem& *$en you 'li'k on %ave&
Con(igure t$e Inbound arameter% a% !AP need to re'eive t$e I"OC!& Note3 .rom !AP i( we need to %end t$e I"OC! to BO"! t$en 'on(igure outbound arameter%, vi'e ver%a to re'eive t$e I"OC! 0Inbound1& In t$i% 'a%e it i% 'on%idered to 'reate t$e 'u%tomer w$i'$ 'ome% (rom BO"!? $en'e t$e 'on(iguration %$ould be Inbound& It i% %$own below& Cli'k on Add
+nter t$e me%%age tye @"+B
Note3 *$e (ollowing are t$e I"OC tye%,
Message t!es " I#oc t!es " $API
endor
C%EMAS " C%EMAS&2
Cu%tomer
#E$MAS " #E$MAS&'
Accounting
Message t!es " I#oc t!es " $API
:L a''ount
G(MAS) " G(MAS)&1
Co%t 'enter
C*SMAS " C*SMAS&1
Co%t element
C*E(EM " C*E(EM&1
Co%t 'enter grou
C*G%P1 " C*G%P&1
Co%t element grou
C*G%P1 " C*G%P&1
A'tivity tye
C*AMAS " C*AMAS&1
A'tivity grou
C*G%P1 " C*G%P&1
A'tivity ri'e
C*AC)+ " C*AC)+&1
Pro(it 'enter
P%CMAS " P%CMAS&1
Pro(it 'enter grou
C*G%P1 " C*G%P&1
Pro(it 'enter a''ount grou
C*G%P1 " C*G%P&1
(ogistics
Message t!es " I#oc t!es " $API
Arti'le ma%ter
A%)MAS " %etailMaterial.Clone
Additional
MMA##I " MMA##I&1 %etailMaterial.Sa,eAdditional%e!licas
Produ't 'atalog
P%#CA) " P%#CA)&1
Produ't 'atalog item
P%#P*S " P%#P*S&1
Pri'e li%t
P%ICA) " P%ICA)&1
A%%ortment
ASS*%)MEN) " ASS*%)MEN)&1 Assort-ent.Sa,e%e!lica
!ervi'e ma%ter
S%+MAS " S%+MAS&1
C$ara'teri%ti'
C%MAS " C%MAS&2
Cla%%
C(SMAS " C(SMAS&'
Cla%%i(i'ation
C(/MAS " C(/MAS&1
"o'ument
#*CMAS " #*CMAS&0
Pur'$a%ing in(o re'ord
IN/%EC " IN/%EC&1
Condition%
C*N#A " C*N#A&1
Order book
S%C(S) " S%C(S)&1
C$ange ma%ter
ECMMAS " ECMMAS&1
Bill o( material
$*MMA) " $*MMA)&1
"o'ument BO<
$*M#*C " $*M#*C&1
A%)MAS&2
"
"
"
#ork breakdown %tru'ture
Proect " P%*3EC)&1
u-an %esources
Message t!es " I#oc t!es " $API
PA ob7e't tye er%on
%M#A " %M#A&'
P" ob7e't tye%
%M#A " %M#A&'
'& Sending I#*Cs3 !ending an I"OC to !AP i% an a%yn'$ronou% ta%k& One or many I"OC% are o%ted to !AP, 7u%t like in%erting into a databa%e table, and get %tored in t$e !AP databa%e& Later, !AP %tart% to ro'e%% t$e I"OC and e&g& 'reate% t$i% new material re'ord& On'e t$e ro'e%%ing i% done, no matter i( %u''e%%(ul or not, t$e %tatu% o( t$i% I"OC i% udated in t$e !AP table +"I"C& A% a 'on%e)uen'e, unlike wit$ BAPI%, you get no return o( t$e ro'e%%ing& >our only '$oi'e i% to eriodi'ally )uery above %tatu% table and 'oy t$e %tatu% ba'k into t$e %ender% table& I( an immediate return 'ode i% re)uired or t$e a'tual error me%%age you $ave to u%e BAPI%& On t$e 'ounter %ide, I"OC% are %uo%ed to be (a%ter w$ile %till running (ull data 'on%i%ten'y te%t%& Be(ore %ending t$e I"OC% we need to $ave !AP "ata %tore to be 'reated and t$en imort t$e re)uired I"OC& .or our 'a%e to 'reate t$e 'u%tomer 4"+B
*$e data %tore 'reated a% re(erred $ere a% 4!AP;+CC5 %$own above, t$en imort t$e I"OC 4"+B
Cli'k on imort by name and give t$e I"OC name a% %$own below&
*$e (ollowing (lat (ile in(ormation i% re)uired to 'reate t$e 'u%tomer t$roug$ I"OC%& Row generator i% re)uired (or inut t$e 'on(iguration&
.lat (ile in(ormation a% %$own below&
Con(iguration in(ormation a% %$own below&
On'e t$e Eob 'omleted '$e'k t$e generated I"OC by u%ing t$e tran%a'tion 'ode 4#+95&
!tatu% F/ %$ow% I"OC %u''e%%(ully re'eived to !AP (rom BO"!&
Cu%tomer 0/91 got 'reated %u''e%%(ully by '$e'king t$e tran%a'tion 4X"9/5&
