insert data to table vbrk

[Former Member]

HALLOW

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

Regards

[Former Member]

HEllo,

You can't do it.

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

Vasanth

[Former Member]

hi Vasanth M

i which trasction i can do that?

Regards

[Former Member]

It's is a report program.

GOTO SE38...

You can use

MODIFY <dbtab> ... FROM TABLE itab .

Regards,

Pavan

[Former Member]

Hello,

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

Thanks !!!

Vasanth

[Former Member]

Hi

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

[Former Member]

Hi,

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

- Irudayaraj Peter

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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>