Z Table - Enhancement category

[Former Member]

Hi,

I am creating a Z table in SE11 and after including the fields when i try to activate it it says " Enhancement Category missing"

Please help what i have to do to activate?

Also

1. The Z tables identifies external length or internal length bacause i have total of 700 fields of type INT4. So will it take 4 bytes or 10 length?

2. I have to load data from PSA table into fields of this Z table. Please tell me wher i have to write the program?

Regards

Zabi

[Former Member]

Hi Syed,

Here you are trying to load a data from PSA to Z table.below are the instructions.,

First Find out the PSA table name exactly. If you are not able to find it here is the way.

Goto RSA1-datsources-rightclick on your datsource and click on Manage screen, it will show you the all the request loaded from R/3 till date. ( there are other ways to see ur PSA records , bust just told u the base method)

or

simply try to display your PSA records in whatever mean you want

Click one of the request and try to display the PSA data, there try to click the column in one fo the fields other that status, datapacket or DataRec, and press F1 you will get the technical details screen showing only the data element. Make a note of it.

Try to go to se11-paste that value in Data type value and use where use list and search only for table fields, it iwll display you the list of tables where this data element is used, and check for the description of table whcih contains your datasource name

Eg: If Your Data source is 0customer_attr, then try to look in for 'Transfer Structure Application 0CUSTOMER_ATTR'*.

Note: all the PSA table will have the description starting with 'Transfer Structure Application' & datsource name.

So now you have found the PSA table name.

You have to write a code thry abap program or thru Functionmodule which is simple now...

Declare an internal table same your PSA table and Z table.

Eg:

DATA: it_psa type standard table of /BIC/B0000291000,(PSA table name of 0customer_attr)

it_ztab type standard table of Ztable ( this must be your table name),

wa_psa type /BIC/B0000291000,

wa_table type ztable.

Select * from /BIC/B0000291000 into table it_psa.

or

you can select based on where condition also,

if the Ztable is same structure has PSA, then you can directly modify the Ztable from the internal table, else you need to loop at the it_psa and populate the needed fields thru work area , and we need to populate the Ztable.

Eg: considering Ztable is same as psa table.

Modify Ztable from table it_psa.

Eg: Considering noth ur psa table and Ztable are not having same structures then.

loop at it_psa into wa_psa.

wa_table-field1 = wa_psa-0customer.

wa_table-field2 = wa_psa-description.

....

....

wa_table-fieldn = .

append wa_table to it_ztab.

clear: wa_table,wa_psa.

endloop.

Modify Ztable from table it_ztab.

I hope it helps you..

Edited by: Nanda.S on Oct 18, 2011 12:02 PM

[Former Member]

Hi,

Go to Table in edit mode select Extras->Enhancement Category-> here select Can be enhanced (char type or numeric type)

If you don't want to enhance them at all choose Cannot be Enhanced.

Regards,

Geeta

[Former Member]

Hi Geeta,

I have to load data from PSA table into fields of this Z table. Please tell me wher i have to write the program?

Regards

Zabi

[Former Member]

Hi,

Since its a Z table and not an BI Data target. You need to write an ABAP program to load data into Z table.

Regards,

Geeta

[Former Member]

Hi Geeta,

Can you let me know little in detail please?

If i write ABAP program then how will it recognise the PSA table and Z table?

Just qrite code and execute?

Regards

Syed

[Former Member]

Hi,

I require little more info. Are you deleting the PSA requests before extraction from source system and then triggering the load?

If Yes, then to get the PSA table details look out the following thread -

You can write the program or a Function Module to load the data from PSA table to Z table. ABAP team can help you better in developing the Program or FM.

Assign the points if its helpful.

Regards,

Geeta

Edited by: PGeeta on Oct 18, 2011 2:12 PM