We have a scenario that need to extract the vendor data from People Soft to SAP by using BODS. We are using IDOC standard job to load into SAP.
In these loads, we have 2 fields Alternate Payee (LNRZB) and Fiscal Address Vendors ( FISKN) which should be updated with the SAP Vendor ids which have alternate payees and fiscal address respectively, but before loading into SAP we won’t be having SAP IDs, so is there anyway we can load data for these 2 fields without running Job twice?? ( first time we load all the records into SAP by keeping these as null and then next time we have to update these fields)
In Informatica, we have dynamic lookup which gets data at run time into lookup table from target table, is there any such thing available in SAP BODS ??