topic Re: Creating Customer Table in Application Development and Automation Discussions

Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:18:09 GMT

I need to create a table ZInvoiceOut. It will contain KUNNR, VBELN, ERDAT, ERZET, FLAG

VBELN is VBRK-VBELN

What is the delivery class going to be? I am using this as a temporary table to store data that I will use in a batch transfer

How to set the VBELN to VBRK-VBELN

Thank you

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:24:12 GMT

Hello Megan,

So u r going to update the table thro code then use the Delivery class <b>A</b>

Size catagory - 0

Data Class APP0.

Regards,

Vasanth

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:31:03 GMT

shouldnt the data class be APPL1 since its transaction data. I am using this table as a staging area. It will be updated everytime we get an invoice

APPL0 is Master Data. What is the difference between Master Data and Transaction Data

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:31:37 GMT

hi megan,

delivery class must be A. data class should be APPL1 and size category depends on the number of records u r going to store, chose as per ur requirement.

Regards...

Arun.

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:34:52 GMT

megan,

master data is the one which is frequently accessed but rarely changed, but transaction data which contains day to day business transactions carried out in the system. Transaction data is frequently changed.

Regards...

Arun.

Reward points if useful.

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:36:24 GMT

Hi Arun

I am debating whether I should set the Delivery Class as A (Application Table) or L (Table for storing temporary data)

Class A is supposed to be client specific. Should this be client specific?

Also I dont think it should be temporary data, this table will keep getting accumulated. Please help. Should I add MANDT to my fields and keep it A or leave out MANDT and set it as Application Table

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:40:10 GMT

Hi Megan,

Besides all the technical details mentioned here, depending on your company/customer, you might want to check on any kind of standards or policies on data dictionary objects. Data Governance is gaining more and more importance and some companies have really strict rules on how to define tables (speaking about recent experience where I had to go over dozens of tables and change attributes before we could move them to PRD).

Guenther

Re: Creating Customer Table

former_member194669 — Mon, 12 Mar 2007 19:44:06 GMT

Other points taken during creaiton

1. Key field

2. Null indicator

3. Check table

4. Search Help

5. Data Class

6. Size

7. Buffering

8. Secondary Indexes

aRs

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:45:30 GMT

megan,

for custom tables, v usually give it is as A. For ur case also give it as A.

If u really need MANDT field, u can also add that one as the first field( if u want to make that table as client dependent).

Regards....

Arun.

Reward points if useful.

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:45:31 GMT

Also what should the Data Browser/ Table View Maint be

Allowed with Restrictions or just

Allowed

Also should I add a client or its not neccesary. The table will be added to everytime we receive an invoice

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:46:24 GMT

Thanks Arun

Appreciate your help

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:48:34 GMT

megan,

u have to give simply allowed.

Regards...

Arun.

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:48:54 GMT

Additional Query

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:49:44 GMT

What package should I select. Right now I have it in $TMP. I am not sure if thats correct

Re: Creating Customer Table

former_member194669 — Mon, 12 Mar 2007 19:50:23 GMT

I think you are updating this table thru your program , then you can make

"Display/manitenance Not allowed"

aRs

Re: Creating Customer Table

former_member194669 — Mon, 12 Mar 2007 19:51:35 GMT

For package you need to consult with your BASIS team?

$TMP packages are not transportable

Whether your company have naming convetion for package creation?

aRs

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 19:53:12 GMT

create ur own package in se80 and create a request, if u r going to transport that object. if u r storing it as $tmp(local object), u can't transport that object.

Regards....

Arun.

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 20:06:16 GMT

I found out that I have to put it into the Z001 package

What should I fill in the Transport Layer ?

Re: Creating Customer Table

former_member194669 — Mon, 12 Mar 2007 20:24:48 GMT

If u r the owner of the package, then it is HOME - Customer Developments...

Transport Layer: is the transport layer defined by BASIS

aRs

Re: Creating Customer Table

Former Member — Mon, 12 Mar 2007 20:35:22 GMT

The options available to me are

Layer TransTarget Text

SAP QA1 Transport target for SAP std objects

ZDA1 QA1 Transport layer ZDA1

ZBAD Transport Layer ZBAD

I am thinking it is ZDA1 but am not sure. Please help