Hi,
I am connecting to SAP using LCLSX. I need data from two fileds to be pushed to SAP. Each field has 6 values. I want first the 6 values of field1 should go to the 1st cloumn in SAP in such way that each value gets populated in each row, i;e 6 values in 6 rows and then it should commit. And then same for the next field.
Note: It can not commit before all 6 values have entered.
Pls help.
Subject: LCLSX - Multiple Records in a single column at one go.
If I am correct…
SAP is a relational DB, so it does ont have the concept of Multi-valure fields. I am assuming the 2 fields in your docuemnt, contain “ordered” data, e.g. Field1=joe, Sue, John,… Field2=34, 23,54,… where joe=34, sue=23, John=54.
So you actually have 6 records in SQL parlance. You therefore need to iterate over the values in the fields and INSERT those into SAP…if that’s how you are doing it…maybe you are using a stored procedure.
Subject: RE: LCLSX - Multiple Records in a single column at one go.
Thanks,
What I am trying is that When Field 1 gets pushed to SAP, then it will insert joe , Sue, John in 3 different rows of the 1st column in SAP table and then 34,23,54 in the next coulumn of the SAP table. Then it will commit.
Can you help?