updating transparent table

[Former Member]

hi

how we can update the sap supplied transparent table by abap program

urgent

regards

sudhakar

[Former Member]

if you want to change the standard transparent tables, you should look for standard BAPI's provided. if you cant find any BAPI's, another possible way is to make a BDC.

while it is possible to update these standard tables using open sql queries, it is highly discouraged. this is because one update in a standard table might also need updates in a lot of related tables to make sure of consistency. hope this answers your question.

[Former Member]

use

MODIFY ITAB FROM WA_ITAB <condition>

UPDATE <table> FROM TABLE ITAB..

ex: 2

MODIFY ekko TRANSPORTING angnr WHERE ebeln = wa_tble-ebeln.

[paruchuri_nagesh]

hi

u can update database tables

by using BDC , BAPI, Modulepool programs

reward for use ful points

regards

Nagesh.Paruchuri

[Former Member]

Hi there are three statements avilable for that...

1)Insert - Will only insert a new record.

2)Update - Will only update an existing record.

3)Modify - Will update the record if existing otherwise it will insert it as a new one.

[Former Member]

Do not Update the SAP DB Table using your own logic, coz it will cause inconsistency in SAP coz a SAP table is not a single entity, its related to other tables too. Instead you should use BDC, LSMW, BAPI's to create data for example vendor or customer master.

Reward points if useful, get back in case of query...

Cheers!!!