topic Re: Table creation problem in Application Development and Automation Discussions

Table creation problem

Former Member — Wed, 09 May 2007 06:49:50 GMT

Hi Friends,

I have created a table to input in the table the details of PO. When I input details of PO., The PO number should accept more number of times as same PO has differenct invoices, But I am unable to do it. Can any one guide me how to do it.

Regards,

Line

Re: Table creation problem

Former Member — Wed, 09 May 2007 06:52:19 GMT

Hi ,

for creation of table refer this link

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ea0b446011d189700000e8322d00/frameset.htm

Reward points if useful..

Regards

Nilesh

Re: Table creation problem

Former Member — Wed, 09 May 2007 06:53:47 GMT

Hi,

Here in the table I took PO as primary key, I also tried to remove the primary key for PO even though it is not accepting records can any one please tell me how to do it.

Regards,

Line

Re: Table creation problem

kostas_tsioubris — Wed, 09 May 2007 07:01:12 GMT

Hi,

you should set as key in your table another field except the po number, maybe the invoice number.

Kostas

Re: Table creation problem

Former Member — Wed, 09 May 2007 07:05:37 GMT

Hi,

As u said I understood that u have taken PO as the primary key of your custom table. Can u elaborately explain what exactly ur requirement is?

Some tips I am providing u to modify the table:

a.> If u want to want redundant data of PO in ur table, use composite key in your table, ie other than PO, keep another fields as key fields also.

b.> U want to modify the table which contains data, then i should say that remove the data from the table first and make your modifications. After modifying the table, u can again upload the data into the table.

If the tips are helpful, please reward with some points,

Regards,

Pulokesh

Re: Table creation problem

Former Member — Wed, 09 May 2007 07:16:57 GMT

Hi Pulokesh,

I want to enter invoice details into table by using custom defined screen. I kept the PO as the primary key. Here is the sample data what I want to enter.

PO INV AMOUNT

123 001 50000

123 002 50986

124 001 87659

125 002 98675

125 003 45367

But I am able to accept only first PO with the invoice number I need to enter the second invoice also with the same PO. Pls tell me how to do it.

Regards,

Line

Re: Table creation problem

kostas_tsioubris — Wed, 09 May 2007 07:28:45 GMT

Hi Line,

You should set the invoice number as key in your table.

Kostas

Re: Table creation problem

Former Member — Wed, 09 May 2007 07:35:11 GMT

Hi line,

1. Please place both po and invoice no as primary key.So that u can enter unique PO and invoice no in the table.

2. Delete old Table Maintainance.and create a new table maintainance generator.

Regards,

Kalpesh

Re: Table creation problem

Former Member — Wed, 09 May 2007 08:22:01 GMT

Hi Thanx for your reply,

I tried with that also but cannot insert into the database table, these are my fields to be inserted:

PONUMBER

VENDOR_NO

VENDORINV

PODATE

AMOUNT

CURR

VENDOR_DES

TYPEOFMAT

BUYER

GOODRECEI

STATUS

RECEIVEDDATE

AMOUNTCLAIMED

These are the fields in the table, pls tell me what are the primary fileds to be kept here.

Again I need to retrieve the PO number and Amount in other report.

Can any one suggest me,

Regards,

Line.

Re: Table creation problem

Former Member — Wed, 09 May 2007 08:27:33 GMT

can you do one thing like ekpo table you can make your ebeln and ebelp(introduce the new field) and make them key fields . and check the syntax of the table also if there is any error or not i.e. have you created the table properly or not....if it is not satisfy your requirement let us know.

regards

shiba dutta

Re: Table creation problem

Former Member — Wed, 09 May 2007 08:41:09 GMT

Hi,

Thanks for offering points. But still u habve some doubts. So please find some more tips given below:

a.> PONUMBER, VENDOR_NO, VENDORINV should be the key fields of your table

b.> First before modifying the table delete records from the table.

c.> Delete the Table Maintainance generator.

d.> Now make ur modifications as per ur requirement.

e.> Activate the table.

f.> Create a new Table Maintainance Generator for the table so that data can be loaded through SM30.

Regarding retreival of PO data into report, use select query with where condition as PONUMBER. If it is not matching ur purpose please share ur exact requirement, so that i can suggest u with more techniques. Eagerly waiting for your reply.......

Regards,

Pulokesh

Re: Table creation problem

jayanthi_jayaraman — Wed, 09 May 2007 08:54:10 GMT

Hi,

Maintain ponumber,vendor_no,vendorinv as primary key.After activating the table,go to tcode SE14 and give the table name.Click Edit and then click activate and adjust database.