Creating Customer Table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[former_member194669]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks Arun

Appreciate your help

[Former Member]

megan,

u have to give simply allowed.

Regards...

Arun.

[Former Member]

Additional Query

[Former Member]

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

[Former Member]

You can not use the $TMP Package, if you use this then it is not transportable. So you can ask the client what package you can use to save your work. Client will set up the Packages so that we will make use in our developments.

Reward if it helps for you.

Thanks ,

SRK

[former_member194669]

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

"Display/manitenance Not allowed"

aRs

[former_member194669]

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

[Former Member]

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.

[Former Member]

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

What should I fill in the Transport Layer ?

[former_member194669]

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

Transport Layer: is the transport layer defined by BASIS

aRs

[Former Member]

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

[Former Member]

Answered