basics

[Former Member]

A field containg currecncy amounts(data type CURR) must be assigned to a reference table and a reference field. Explain

What is the significance of delivery class in database tables?

How can an internal table with header line and one without header line be distinguised when passed to a subroutine?

[Former Member]

Hi,

As a reference table, a system table containing all the valid currencies is assigned or any other table which contains a field with the currency key format. This field is called as reference field. The assignment of the field containing currency amounts to the reference field is made at runtime. The value in the reference field determines the currency of the amount.

-

---

The delivery class controls the degree to which the SAP or the customer is responsible for table maintenance

- whether SAP provides the table with or without contents.

- determines the table type. - determines how the table behaves when it is first installed, at upgrade, when it is transported, and when a client copy is performed.

-

---

if you declare itab[] in subroutine,

it indicates internal table with hearder line.

if you declare itab in subroutine,

it indicates internal table with out header line.

*******please reward points if the information is helpful to you*********

[Former Member]

hi,

The <u><b><i>reference field</i></b></u> is used for the output, the output/input format of a currency field depends on the value of its reference field.

For example if you create a screen using the field KONV-KBETR :

the reference field is RV61A-AWEI1:

if you set RV61A-AWEI1 = 3

the value in KONV-KBETR is beeing shown with 3 decimals

So you could see 3,000 but this value is automatically stored as 30.00

if you set RV61A-AWEI1 = 2

the value in KONV-KBETR is beeing shown with 2 decimals

All this convertions are automatically made in according to the value setted in reference field.

You can see this using the statament WRITE with options CURRENCY, try this:

PARAMETERS P_KBETR LIKE KONV-KBETR.

WRITE: P_KBETR CURRENCY '3'.

WRITE: / P_KBETR CURRENCY '2'.

WRITE: / P_KBETR CURRENCY '1'.

<u><i><b>Delivery class:</b></i></u>

A Application table includes the master and transaction data

C Customizing table

L Table for storing temporary data

G Customizing table. It is protected against SAP Update

E Control table

S System table. They are only maintained by SAP

W System table. Contents transportable via separate TR objects

http://help.sap.com/saphelp_erp2005/helpdata/en/43/45860774b711d2959700a0c929b3c3/frameset.htm

Regards

Reshma

[Former Member]

hi,

<b> Delivery Class Field</b>

The value in the Delivery Class field identifies the "owner" of the data in this table. The owner is responsible for maintaining the table contents. In customer tables, you always enter an A here, which indicates that the table contains application data owned by the customer only. Other values entered in the field are useful only to SAP, and indicate that either SAP owns the data or both SAP and the customer jointly own the data.

<b>Rewards point</b>