ABAP Code help please

[Former Member]

• Iam developing an ABAP program in a central R/3system, to check the compliance our of 20 local R/3 affiliates settings (distributed worldwide) against some standard R/3 settngs located in Ztables (Z tables are in central R/3 system.)

• The program has a selection screen ,(user can select particular site, partcular company code, Operating concern what ever he needs to check the compliace).

• The selection screen invokes the RFC, with RFC I Retrieved all the required fields (to be checked ) data from the tables of affliliate local sites, in the form of internal tables to the central system. (for eg.gt-tablename)

• In the meantime I have retrived all the z tables(located in central system) into the internal tables (for eg gt-refd_a)

• Now I have to operate on these two types of internal tables to write some compliance check logic to check the complance .

Can anyone help me with the compliance check logic for the following checks.

• 1.I want to check wether there is a field (( KNA1-KONZS) )for global Master is set up in the local site.. If there is s field then the local site is complant other wise not compliant

• 2.Check in KNA1 table of local site that each customer number has a country code. If it has a country code(land1) then it is compliant otherwise it is not compliant.

• 3.Check in table CE1XXXX that wether the WWRET and WWREV values are correctly maintained for the last month. ( xxxx is operating concern (we will select this operating concern in the selection screen),.....if value for WWRET(receiver type) is 10, then the WWREV(Reciever Value) should be Country code.(then it is compliant otherwise it is not compliant.

)

if value for WWRET is 10, or 20 or 30, then the WWREV should be Company code(bukrs). (then it is compliant otherwise it is not compliant.

)

[ChristianFi]

Your information is to vague to provide some code but if you do not mind I have some remarks on the intended PA-checks.

By their nature ce1 tables are huge, and I do not know if you intend to check every line item in the systems but it may take a while.

But depending on the szenario you could do following.

a) Do not check against ce1 but ce4 (provided your characteristics are part of the profitibility segment) - ce4 tables can become huge too (depending on the number of characteristics being used in your operating concern.

b) Create a summarization level on just these 2 characteristics (K8...) Tables. And try to read this table.

Of course this makes only sense if you want to know that and not which item are different.

Do not try to create an index on ce3 or ce4 for that purpose - cardinality is rather bad and would just slow down the insert processes.

Just my 2 cts.

Christian