topic insert data to table vbrk in Application Development and Automation Discussions

insert data to table vbrk

Former Member — Tue, 07 Aug 2007 10:40:49 GMT

HALLOW

how i insert data to table in se11 like table vbrk.

Regards

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 10:42:07 GMT

HEllo,

You can't do it.

These table are SAP standard tables where u can add data to the table through transaction only.

Vasanth

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 10:43:38 GMT

Hi,

if you want to add some records to vbrk table

use this

modify vbrk from table itab ( which is having same structure as of vbrk)

but see to that it should not effect the functionality

you have to get the confirmation from functional consultant

that if we add records to std table then also there should not be

any descrepencies

then only use this statement

other wise use some std tcodes which will update the table

thanks & regards,

venkatesh

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 10:46:54 GMT

hi Vasanth M

i which trasction i can do that?

Regards

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 10:47:49 GMT

DATA message_wa TYPE t100.

message_wa-sprsl = 'EN'.

message_wa-arbgb = 'MYMSGCLASS'.

message_wa-msgnr = '100'.

message_wa-text = 'Some new message ...'.

MODIFY t100 FROM message_wa.

Regards,

Pavan.

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 10:48:54 GMT

It's is a report program.

GOTO SE38...

You can use

MODIFY <dbtab> ... FROM TABLE itab .

Regards,

Pavan

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 10:51:42 GMT

then you have to write the program to fill the internal table

like this by appending the data inside the program or by having the flat file

using gui_upload to your internal table like bdc program .... here i am giving the sample code for one record inserting which is hardcoded.

Inserting a new airline company in the database table SCARR.


report  ztest .

tables  :  scarr .
DATA scarr_wa TYPE scarr. 

scarr_wa-carrid   = 'FF'. 
scarr_wa-carrname = 'Funny Flyers'. 
scarr_wa-currcode = 'EUR'. 
scarr_wa-url      = 'http://www.funnyfly.com'. 

append  scarr_wa .
scarr_wa-carrid   = 'FD'. 
scarr_wa-carrname = 'Bunny Flyers'. 
scarr_wa-currcode = 'INR'. 
scarr_wa-url      = 'http://www.funnyfly.com'. 
append  scarr_wa .

INSERT INTO scarr VALUES scarr_wa.

reward points if it is usefull ....

Girish

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 11:13:38 GMT

Hello,

Create a Invoice for the sales order through <b>VF01</b>

Thanks !!!

Vasanth

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 11:27:43 GMT

SAP does not re-commend to tamper any standard SAP table table data. Even though you can use the update/modify table it would be highky risky as it might create in-consistent data if not handled correclty. So I would recommend you top create a Sales Invoice using VF01 / Use a BDC recordign of VF01 / a BAPI.

Hope it helps. Reward points if useful.

- Irudayaraj Peter

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 11:42:44 GMT

Hi,

Pls check this thread and then decide on whether to go ahead updating the VBRK table.

- Irudayaraj Peter

Re: insert data to table vbrk

Former Member — Tue, 07 Aug 2007 11:46:36 GMT

The INSERT statement creates new rows in a table.

Syntax

<insert_statement> ::=

INSERT [INTO] <table_name> [(<column_name>,...)] VALUES (<insert_expression>,...) [<duplicates_clause>]

| INSERT [INTO] <table_name> [(<column_name>,...)] <query_expression> [<duplicates_clause>]

| INSERT [INTO] <table_name> SET <set_insert_clause>,... [<duplicates_clause>]

<insert_expression> ::= <extended_expression> | <subquery>

also refer,

http://www.sapdb.org/htmhelp/34/ee7fb7293911d3a97d00a0c9449261/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c4/93d942f7ca45b69dfdfd424c38332e/content.htm

regards,

srinivas

<b>*reward for useful answeers*</b>