modify using screens

[Former Member]

is it good practise to modify entries in standard tables using custom screens?if so how can i modify them in customer and vendor tables?is there any link or blog?an example will be much more helpful

[Former Member]

Hi,,,

Generally it's not recomended by SAP,,,,,, But if there is rquirement for modification,,,,,, then it can be done by open SQL statements in ABAP,,, as you are not authorized to make changes in standard table

[Former Member]

requirement is for client who wants a screen which simulates standard one through which he can modify some of customer table fields in single screen.

[Former Member]

hi,

you can do by using module pool programing , and table maintance, but when you are doing for standard tables check whether that standard table has any check tables and value tables, i am sure that standard tables defnetly have linkings with other tables(i mean check tables,value tables).

you can solve ur problem by one way, create module pool program (table controle module pool prg)

and display table the changes which are made in their run bdc program for those internally.

ex: if u need to change custome table kna1 first create pool program which shows the details of kna1 when user make any changes, write bdc code for xd02,when user press save on pool prg the bdc program will run but for user it seems like makeing changes on table it self.

redgs:

rajesh.k

[Former Member]

Hi Add,

Take this as a future suggestion.

Adding to all my friend suggestion in the technical setting of the table for which you are modifying the entries make sure you select the LOG check box, where you can have a clear picture on what entries that you have changed for your future reference.

Cheers!!

VEnk@

[Former Member]

Hi,

It is not recommended by SAP. If you do the chages based on this requirement. It will create problem in related standard transactions and the values will differ in different scenarios. For ex. whenever we are saving PO it will update EKKO,EKPO and other relevant tables also, when u change one table direcly the other one will affect finally it will go to data mismatch and data difference in different scenario.

Regards,

Nandha

[Former Member]

good suggestion.

what i understood is that

its nothing but a bdc which will be initiated by pool program.but if we do bdc for xd02 then how will it modify the values which i have entered on screen that i created.

[Former Member]

Hi,

Another one when u change the table directly sometimes the cluster table values will not update also.

When u do changes in standard transaction it will update the transparant table and cluster table also.

Regards,

Nandha.

[Former Member]

i am using bdc which will not be a problem that is what suggestion given by him/her.is it a good process.but problem is how bdc for xd02 will know the values that i have entered on the screen creted by me

[Former Member]

do the recording for xd02..

when save button is pressed

put ur bdc program here ...

assign ur custom screen details to the bdc program..

[Former Member]

Hi Add,

I think will be populating your records in XD01 using your flat file right then in that case what is the confusion.

Cheers!!

Venk@

[Former Member]

how to assign custom screen details to the bdc program..?

[Former Member]

if i do it by flat file then whts the use of custom screen.this is not mass uploading.client needs a single screen through which he can enter values corresponding to different customer tables

[Former Member]

SAPMF02D 0101 X

BDC_CURSOR RF02D-D0110

BDC_OKCODE /00

RF02D-KUNNR------> assign screen i/o field kunnr of ur screen(ikan1-kunnr)

RF02D-D0110 X

SAPMF02D 0110 X

BDC_CURSOR KNA1-ANRED

BDC_OKCODE UPDA

KNA1-ANRED----->assign ur i/o field Ms.

KNA1-NAME1------>assign ur i/ofield apple

KNA1-SORTL------> APPLE

KNA1-ORT01 coimbatore

KNA1-LAND1 IN

KNA1-REGIO TN

KNA1-SPRAS EN

KNA1-PSTLZ 606107

[Former Member]

if i assign them to my screen fields after recording for xd02.then it will take values from my screen and will update in standard tables.

is it correct shan?

[Former Member]

yes it is correct

follow as below

case sy-ucomm.

when 'SAVE'.

SAPMF02D 0101 X

BDC_CURSOR RF02D-D0110

BDC_OKCODE /00

RF02D-KUNNR------> assign screen i/o field kunnr of ur screen(ikan1-kunnr)

RF02D-D0110 X

SAPMF02D 0110 X

BDC_CURSOR KNA1-ANRED

BDC_OKCODE UPDA

KNA1-ANRED----->assign ur i/o field Ms.

KNA1-NAME1------>assign ur i/ofield apple

KNA1-SORTL------> APPLE

KNA1-ORT01 coimbatore

KNA1-LAND1 IN

KNA1-REGIO TN

KNA1-SPRAS EN

KNA1-PSTLZ 606107

endcase.

[Former Member]

Thanks shan

i am scratching my head from the morning thinking why he need that one perhaps he is not having anywork.there are standard screens through which he can enter but he want a custom screen.