Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Customer Table

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

21 REPLIES 21

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Thanks Arun

Appreciate your help

Former Member
0 Kudos

megan,

u have to give simply allowed.

Regards...

Arun.

Former Member
0 Kudos

Additional Query

Former Member
0 Kudos

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

0 Kudos

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
Active Contributor
0 Kudos

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

"Display/manitenance Not allowed"

aRs

former_member194669
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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

What should I fill in the Transport Layer ?

former_member194669
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

Answered