‎2008 Mar 19 11:00 AM
hi
how to create the structure in SAP-DD.
How to insert the currency (amount) and quantity field in structure.
gaurav
‎2008 Mar 19 11:26 AM
hi,
go to SE11->datatype->structure.
create a strucure with the needed fields.
for quantity and currency fields,
click on currency/quantityfields and we need to give the reference table and reference field here.
rewards points if useful.
regards
sandhya
‎2008 Mar 19 11:27 AM
To create a structure,
In se11 ,in meny bar->Extras -> Change table category->chosse (Rado button) Structure.
For currency key :
You must specify a reference table for fields containing quantities (data type QUAN) or currency
amounts (data type CURR).
This reference table must contain a field with the format for the currency key (data type CUKY) or
unit of measure (data type UNIT). This field is called the reference field of the output field. The
reference field can also reside in the table itself.
A field is only assigned to the reference field at program runtime. For example, if a field is filled
with currency amounts, the corresponding currency is determined from the assigned reference
field, that is the value entered in this field at the moment defines the currency.
Table SBOOK in the flight model contains all the flight bookings made by
customers. Field FORCURAM contains the price of the booking in the customers
currency. Field FORCURKEY of table SBOOK contains the corresponding currency
key for this price. SBOOK is therefore the reference table for field FORCURAM and
FORCURKEY is the reference field for field FORCURAM.
Award Points if its worthful
Edited by: nivas kumar on Mar 19, 2008 12:28 PM
‎2008 Mar 20 6:19 AM
Hi,
To create a structure follow the below steps.
1. Use transaction SE11 & select Datatype radibutton
2. Specify the name of the strcuture you want to create
3. Click on create tab & select structure.
4. Add the fields you want. In case of including quantity/currency fields e.g., curr you have to specify the reference table & field. So against the field curr, select the quantity/currency fields tab & specify relevant reference table & field.
5. Specify the enhancement category.
6. Save & activate.
Reward if useful.
Once your question is answered, award points & close the thread as answered.
Regards
Sayee
‎2008 Mar 20 7:48 AM
Hi,
Suppose your structure ZTEST1 has the following fields
VBELN -> sales order
AMOUNT --> amount
CURR ---> currency
In the Currency/Quantity Fields tab, for the AMOUNT field add the reference table as ZTEST1 and field as CURR.
Hope this helps.
Thanks,
Balaji
‎2008 Mar 20 8:06 AM
To create a structure,
hi,
In se11 ,in meny bar->Extras -> Change table category->chosse (Rado button) Structure.
For currency key :
You must specify a reference table for fields containing quantities (data type QUAN) or currency
amounts (data type CURR).
This reference table must contain a field with the format for the currency key (data type CUKY) or
unit of measure (data type UNIT). This field is called the reference field of the output field. The
reference field can also reside in the table itself.
A field is only assigned to the reference field at program runtime. For example, if a field is filled
with currency amounts, the corresponding currency is determined from the assigned reference
field, that is the value entered in this field at the moment defines the currency
pankaj
‎2008 Mar 20 11:48 AM
Hi,
To create a structure we can go for include or append
By using Include go for the following steps:
1. Use transaction SE11 & select Datatype radibutton
2. Specify the name of the strcuture you want to create
3. Click on create tab & select structure.
4. Add the fields you want. In case of including quantity/currency fields e.g., curr you have to specify the reference table & field. So against the field curr, select the quantity/currency fields tab & specify relevant reference table & field.
5. Specify the enhancement category.
6. Save & activate
_By using append go for the following steps:
After createing table, we have an APPEND tab using this we can append a structure to the table.
The difference is we can use the structure created by include in any table but append can not.
Regards,
kavitha
‎2008 Mar 21 5:14 AM
hi,
To create a structure:
Go to se11 >select the radio button Data Type>provide the structure nameand then select the radio button structure and press Enter.
and then provide the short description for the structure.
to insert a currency and quantity field in structute:
provide the name for the field and click on Curency/quantity button now provide the reference field name for the currency/quantity field.
Regards,
vineela.