11-12-2007 6:32 AM
hi
This is an urgent requirement. Please help me out ASAP.
I have developed a BDC code for Infotype 22. I have certain checks to be performed on it before upload.
the checks are :
The certificate field (SLABS) depends on Educational establishment (SLART) and the combination of SLABS and SLART need to be checked in T517A table
Branch of study (SLTP1) depends on Educational establishment (SLART) and the combination of SLTP1 and SLART need to be checked in table T517Z table
If Educational establishment is not found, throw error Educational Establishment not found .
If Edu establishment found, and no corresponding SLABS found for that SLART, error should be Certificate not found. Similarly for SLTP1.
In addition, the country key need to be checked against T005 table for the correctness of the code..
Can you please tell me how to do it as im new to HR.
Thanks and Regards
Swarna Arunachalam
11-12-2007 6:39 AM
Hi
Before processing the BDC data write the validations to check the fields as per your requirements with the respective tables and then process the data if that validation is OK. otherwise don't process
Why can't you use HR_INFOTYPE_OPERATION for BDC data upload instead of BDC.
Regards
Anji
11-12-2007 6:50 AM
My client wants only BDC to be writen. can you give a code snippet how to do the checks in code.
Thanks
11-12-2007 7:11 AM
Hi Swarna,
Can u send ur BDC CODE?
Education establishment, Certificate & Branch of study1/2 are related with each other.
Regards
Srimanta
11-12-2007 11:30 AM
11-13-2007 5:15 PM
Hi ill tell the login how i did . Please give some suggestions on it
(this is not the exact syntax just the logic)
select land1 from t005 into table it_t005.
select slart abart from t517a into table it_t517a
select slart faart from t517z for all entries in t517a where slart = it-t517a into an internal table.
Creat a another int table for checking values(it_check)
loop at my flAT FILE.
read table it_t005 with key land1 = flatfile-land.
it_check-land1 = it-t005-land1.
if sy-subrc <> 0
ERROR message
ELSE.
READ TABLE IT_T517A WITH KEY SLART AND ABART
if sy-subrc <> 0
ERROR message
ELSE.
READ TABLE IT_T517Z WITH KEY SLART AND FAART
if sy-subrc <> 0
ERROR message
ELSE.
PERFORM BDC.
This throws error properly. But i dont want this way.I need all the errrors to be accumulated and shown as report and bdc to continue and not stop.Can you suggest a different way for validation too?