topic Re: Reg: Creating table in Application Development and Automation Discussions

Reg: Creating table

Former Member — Tue, 09 Oct 2007 03:35:51 GMT

Hi Experts,

I want to craete Ztable like this .... its having more than 100 fileds...(Requirement like same)

while creating the ZTable ZDC8DT_L_PSITEM is too long (>4030)...

so that i can not activating the table...

Please suggest... if any body..

Its urgent,

Rewards if useful..

MANDT X MANDT Client

TF X Z_AC_PROG_TF

TA X ZTA_CONF

CSN X ADSPC_CSN CHAR 13

PN CHAR15

BINCOD CHAR4

REF_ITEM ADSPC_CSN CHAR 13

UD CHAR8

UD_TYPE CHAR1

VAR CHAR2

SVAR CHAR2

WEFF CHAR1

CONF TYPE CHAR1

NB CRIT Integer

CRITERIA 1 CHAR50

CRITERIA 2 CHAR50

CRITERIA 3 CHAR50

CRITERIA 4 CHAR50

CRITERIA 5 CHAR50

…

CRITERIA … CHAR50

CRITERIA 100 CHAR50

Re: Reg: Creating table

Former Member — Tue, 09 Oct 2007 03:43:11 GMT

Hi,

Why can't you split your fields in two tables. Create two Z tables with the same key fields.

So while updating update both the tables at the same time.

Regards,

Atish

Re: Reg: Creating table

Former Member — Tue, 09 Oct 2007 03:58:31 GMT

Hi,

I am not aware of your business, but there is some thing wrong in your design....

1. What is the objective of having CRITERIA field from (1,2.. to 100)???

2. How do you populate these fields???

3. If you need to store some field text or display text, create your own text ID and store your text in the format you want to or use SAP standard text ID "ST".

If you could explain your business need, we could find out few hints for you....

Regards,

Prabhu Rajesh

Re: Reg: Creating table

Former Member — Mon, 29 Oct 2007 06:21:55 GMT