topic Re: Re : update the table based on validation in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051098#M1501984 <HTML><HEAD></HEAD><BODY><P>What do you mean by this. What exactly you want?</P></BODY></HTML> Wed, 07 Jul 2010 16:46:52 GMT Former Member 2010-07-07T16:46:52Z Re : update the table based on validation https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051097#M1501983 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P></P><P> Can anybody help out me the folloing lind is custom field as load indicator. here data is coming from internal table</P><P></P><P>-. Create a FM u2018and call the FM to Update the data to Z Table as per below logic.</P><P>-. Validation will be done against the check table for the Vendor (LIFNR with LFA1 table), date (DATS for the valid date in YYYYMMDD format), time (UZEIT for valid time in HHMMSS format) and quantity (MENGE for valid quantity) fields.</P><P>-. IF LIND = u201800u2019.</P><P>-. Delete all the records for the Vendor (LIFNR) and Vendor Part Number (IDNLF) coming in the IDOC from the Z table and insert the new record to the Z table u2018ZTPTP_INV_B2Bu2019.</P><P>-. IF LIND = u201804u2019.</P><P>-. It will be a delta load. The Z Table will be just updated with the data coming in from the IDOC. No deletion of the prior record will happen. The new record will either update the prior record or will get inserted into the Z table u2018ZTPTP_INV_B2Bu2019 in case of new records.</P><P>-. Any errors during the IDoc processing should result in an error Idoc with an error status (Status = u201851u2019).</P><P>a. Possible error scenario would be,</P><P>i. Data validation failures.</P><P>ii. Table Updation failures.</P><P>b. Message class u2018ZPTPu2019 should be used for any error message.</P><P>-. Success IDOCu2019s will be created with the status = u201853u2019 if the data insert or update into Z table is successful</P><P></P><P>Thank you &amp; advance.</P><P>srinivas</P></BODY></HTML> Wed, 07 Jul 2010 16:44:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051097#M1501983 Former Member 2010-07-07T16:44:38Z Re: Re : update the table based on validation https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051098#M1501984 <HTML><HEAD></HEAD><BODY><P>What do you mean by this. What exactly you want?</P></BODY></HTML> Wed, 07 Jul 2010 16:46:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051098#M1501984 Former Member 2010-07-07T16:46:52Z Re: Re : update the table based on validation https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051099#M1501985 <HTML><HEAD></HEAD><BODY><P>Hi friend ,</P><P></P><P>i want just sample code for the above mentioned points so could you define me.</P><P></P><P>Thanks for advance,</P><P>srinivas</P></BODY></HTML> Wed, 07 Jul 2010 17:32:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051099#M1501985 Former Member 2010-07-07T17:32:11Z Re: Re : update the table based on validation https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051100#M1501986 <HTML><HEAD></HEAD><BODY><P>Please don't just dump your specifications here, work yourself on it first and only post specific problems here if necessary.</P><P>Thread locked.</P><P>Thomas</P></BODY></HTML> Wed, 07 Jul 2010 21:32:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/re-update-the-table-based-on-validation/m-p/7051100#M1501986 ThomasZloch 2010-07-07T21:32:06Z