hi

[Former Member]

i want some functional specification in script

[Former Member]

Hi,

i think u cant uderstand this functional specification. but i am sending this fs.

please reward points these r necessary for me.

Invoice*(1)

xxxxxx.(2)

Dodací list č (10): Value del note no(11)

Order No : (15)xxxxx(16) Delivery Note No: (21) xxxx(22)

Purchase Order No: (17) xxxx(18) Invoice date: (23) xxxx(24)

Customer reference: (19) xxxx(20) Payment Due date : (25) xxxx(26)

Delivery date : (27) xxxx(28)

Stock Id Description Commodity code Quant Unit price Disc% Disc Val Tot Net VAT%VAT Gross value

(29) (30) (31) (32) (33) (34) (35) (36) (37) (38) (39)

Material No. Item Description Commod Code# Qty Unit rat % Disc Net value VAT % VAT Gross Val (40) (41) (42) (43) (44) (45) (46) (47) (48) (49) (50)

NET Total(51) ValDisc(52) Valnet(53) ValVAT(54) ValGr(55)

VAT(56) ValVAT(57)

TOTAL(58) ValCurr(59) Val Gr(60)

Page No:((62) xx/xx(63) Copies(64) xx/xx(65)

Footer Details(66)

Output Type : ZD52

Program Name :

Layout Name :

Languages : Domestic –Hungarian

Export Invoices-English & Hungarian

The invoice will be printed in Landscape format/A4 size

First whether the texts are to be in Hungarian only or English&Hungarian will be determined based on the country of sales organisation and the country of Customer.

Header Details

(1)Invoice Type:

Invoice Type: Determine the correct type based on the Billing type and the country code of the Sold to party.

- Use the following combination –

If the sales order type != (ZADR or ZACR)

then If Billing type ZOF2 =>”Számla”; ZOG2 => “Jóváírás”; ZOF8 => “Proforma”

Endif

Else If the Sales Order type !=(ZADR or ZACR)

then If ZEF2 => “Invoice/Számla”; ZOEC => “Credit memo/Jóváírás”; ZOF8 => “Proforma”

Endif

(2) Value Invoice No

Read “VBDKR-VBELN”.

(3) Supplier

Domestic “Szállító”

Export “Supplier/ Szállító”

(4) BMS address

Read address from Sales org

(5) Tax Reg No

Domestic “Adóig. Szám”

Export “Tax Reg No./ Adóig. Szám”

(6) Tax Reg No

Read “VBDKR-STCEG”

(7) Bank account No

Domestic” Bankszámla szám”

Export”Bank Account No./ Bankszámla szám”

(8) Value Bank account No

Read “KNBK-BANKN”

(9) ValueBank Name

Read “BAKA-BANKA”

(10)Customer

Domestic “Vevő”

Export “Customer/ Vevő”

(11) Value Customer No

Read “VBKDR-KUNAG”

(12) Value Customer address

Select from KNA1 where KNA1-KUNNR=VBDKR-KUNAG to get KNA1-NAME,KNA1-STRAS,KNA1-ORTO1,KNA1-LAND1,KNA1-PSTLZ

(13) Tax Reg No of Customer

Domestic” Adóigazgatási szám”

E xport” Tax Registration No./ Adóigazgatási szám”

(14) Value Tax reg No

Read “VBKDR-STCD1_RE”

(15)Sales order No.

Domestic” Megrendelés szám”

Export “Order Number/ Megrendelés szám”

(16) Value sales order No

Read “VBDKR-VBELN-VAUF”

(17) Purchase order No

Domestic” Beszerzési rendelésszám”

Export”Purchase Order No/ Beszerzési rendelésszám”

(18) Value Purchase order No.

Read “VBDKR-BSTNK”

(19) Customer reference No

Domestic” Vevő referencia”

Export” Customer reference / Vevő referencia”

(20) Value Customer reference No.

Read “VBDKR-IHREZ”

(21)Delivery Note No

Domestic” Szállítólevél szám”

Export” Delivery note/ Szállítólevél szám “

(22)Value Del Note No

Read “VBDKR-VBELN_VL”

(23) Invoice Date

Domestic” Számla kelte”

Export”Invoice date/ Számla kelte”

(24) Value Invoice Date

Read “VBDKR-FKDAT_RL””

(25) Payment Due Date

Domestic “Számla esedékessége”

Export”Due date/ Számla esedékessége”

(26) Value of Payment Due date

Refer to program “ZVADINEX” Form “ZVINVOICE_EXPORT” for payment due date calculation

(27) Delivery Date

Domestic “Teljesítés időpontja”

Export “Delivery Date / Teljesítés időpontja””

(28) Value delivery date

Read “VBDKR-LFDAT”

Headings for item description

(29) Stock Id

Domestic” Cikkszám”

Export” Stock Id

Cikkszám”

(30) Description

Domestic” Megnevezés”

Export”Description

Megnevezés”

(31)Commodity Code

Domestic” VTSZ”

Export”Commodity code

VTSZ”

(32) Qty

Domestic” Menny.”

Export”Quantity

Menny”

(33) Unit price

Domestic” Egységár”

Export”Unit price

Egységár”

(34) Discount %

Domestic” Kedvezmény %”

Export”Discount %

Kedvezmény %”

(35)Discount value

Domestic” Ked. Összege”

Export”Disc. Val

Ked. Összege”

(36) Net Value

Domestic” Nettó ár

Export”” Net Value

Nettó ár”

(37) VAT %

Domestic” ÁFA %”

Export”VAT %

ÁFA %”

(38) Vat value

Domestic” ÁFA összege”

Export VAT Value

ÁFA összege”

(39)Gross Value

Domestic” Bruttó érték

Export”” Gross Amt

Bruttó érték

ITEM DETAILS :

(40) Value Material No :

Read “VBDPR-MATNR”

(41) Value Material desc

Read MAKT-MAKTX key = VBDPR-MATNR, VBDKR-SPRAS

(42) Value Commodity code

Read “VBDPR-STAWN” OR “MARC-STAWN”

(43) Value Quantity

Read “VBDPR-FKIMG”

(44) Value Unit rate

Read KOMP-CMPRE

Print flags in the Pricing Procedure

(45) Value Discount Percentage

Add percentages of condition types ZDCH and ZMDS in pricing procedure

(46)Value Discount :

Read “KOMP-KZW14”(Discount total in pricing procedure)

(47) Value Net

Read “VBRP-NETWR”

(48) Value Vat Percentage

Read “KOMV-KBETR”

Print flags in the Pricing Procedure

(49)Value VAT :

Read “KOMV-KWERT”

Print flags in the Pricing Procedure

(50) Value gross

Add ( 49) and (51)

(51) Net Total

Domestic” Nettó ár”

Export “ Net Total/ Nettó ár”

(52) Value Total disc value

Sum of (48)

(53) Value total Net value

Sum of (49)

(54) Value total VAT value

Sum of (51)

(55) Value Total gross

Sum of (52)

(56) VAT

Domestic” ÁFA “ Value “KOMV-KBETR”

Export” VAT/ ÁFA “Value “KOMV-KBETR”

(57)Value total VAT

Same as (56)

(58) Grand total

Domestic” Fizetendó összege”

Export”Total Amt/ Fizetendó összege”

(59) Value currency

Read “VBDKR-WAERK”

(60) value total Gross

Same as (57)

(61) Header Text

(62) Page No.

Domestic” Oldalszám”

Export “Page No/Oldalszám”

(63) ValuePage Number

System generated

(64) Copy

Domestic”masolat”

Export “Copy/masolat”

(65) Value Copy No

System generated

(66) Sales org Footer text

Kérjük teljesítéskor a számlaszámot és az ügyfélkódot feltüntetni

SAP 4.6C

Output determination criteria

Domestic

Domestic Order (Order Type) – ZDOM; Delivery related billing – Z0F2; Order related billing – Z0F8; Inter Company Billing – IV;

Domestic Returns (Order Type) – ZRET; Delivery related billing (Credit) - ZOG2; Order Related Billing (Credit) - ZOG2

Credit Memo Request-OTC (Order Type) – ZCMR; Order Related Billing (Credit) - ZOG2

Debit Memo Request-OTC (Order Type) – ZDMR; Order Related billing – ZOL2

Sample Order-OTC (Order Type) – ZSAM/ZELF; Delivery related billing – ZOF8

Output determination procedure for all billing types in Hungary – Z00002

Domestic/Cr-Db Memo/Samples Output Type = ZD52

Access Sequence – Z003

AcNo Tab Description Requirement Exclusive

10 991 Sales Org/Bill To/Billing Type Y

20 11 Sales Organization/Billing Type Y

[Former Member]

>

please reward points these r necessary for me.

>

necessary ??

For the t-shirts ?

Is it cold over there

Regards,

Dirk.

[Former Member]

Hi this may be of some help for u.

Function Modules Used in Script:

In the Driver Program we must use all or some of the function modules that are listed below to transfer the data.

• Open_Form

• Close_Form

• Start_Form

• Write_Form

• Write_Form_Lines

• End_Form

• Control_Form

• Read_Form_elements

• Read_Form_Lines

Any driver program must contain Open_Form, Close_Form and Write_Form. Other function modules are optional.

OPEN_FORM: This function module opens layout set printing. One must call this function module before he uses any of other layout set function modules like Write_Form, Start_Form, Control_Form etc., You need specify a layout set name in the export parameters of this function module. If nothing is passed to Open_Form then one should use Start_Form function module to open layout set before starting the output. The layout set opened by Open_Form should be closed by Close_Form function module, other wise output doesn’t appear. We can use any number of Open_Form, Close_Form functions in one single program. But Close_Form must be there for every Open_Form in the program.

Some of the important export parameters we have to pass to Open_Form function module.

Form: Enter the Layout set name here, which then controls the output formatting. If nothing is specified then we must use Start_Form for opening layout set.

Language: Layout sets are Language dependent. Enter the desired language here. If the entered layout set is not in that language, then the function tries to open the Form entered in its original language. The default value is SY-LANGU.

Device: SAP Script can format a text on different device types. The device can be ‘PRINTER’ or ‘TELEX’, ‘TELEFAX’, ’ABAP’ and ‘SCREEN’.

Dialog: Use parameter DIALOG to determine whether to display a dialog box before printing, in which the user can set several spool parameters for print formatting. Possible values: SPACE displays no print parameter screen. 'X' display print parameter screen. Default value: 'X'

Options: Use parameter OPTIONS to set several options for print formatting. The parameter has the structure ITCPO. The user can change some of the defined settings on the print control screen. The default value for Options is ‘ ‘. We will discuss about ITCPO structure in detail later.

Other Export, Import and Exceptions are self-explanatory.

Close_Form: The function module closes the layout set opened using OPEN_FORM. The system executes any terminating processing steps for the last opened layout set. No Export parameters for this Function Module.

Start_Form: In-between the function modules OPEN_FORM and CLOSE_FORM, we can use different layout sets. This allows us to combine several different layout sets into one print output. However, we can combine only those layout sets that have the same page format. To switch layout sets, use the function module START_FORM. If another layout set is still open, we must close it first using END_FORM. If we specify no layout set name when calling START_FORM, the system restarts the last open layout set. If after OPEN_FORM no layout set was activated yet, the system leaves the function module with the exception UNUSED. Some of the important export parameters for this function module are

Form: The parameter contains the name of the layout set you want to use for printing. If you specify no layout set here, the system restarts the last active layout set.

Language: Layout sets are language-dependent. Enter the desired language here. If the layout set does not exist in this language, the system tries to call the layout set in its original language. If the parameter LANGUAGE is empty, the system uses the language of the last active layout set.

Startpage: Usually, SAP script starts with the page specified as start page in the layout set definition. If we want to start output with another layout set page, enter the name of the desired layout set page here. If the desired page is not defined, the system uses the start page defined in the layout set.

Program: To replace program symbols, SAP script must know which active program contains the work areas for the values to be passed. If we omit the parameter, the system searches for the field values in the program that was specified in the parameter OPTIONS (field TDPROGRAM) of OPEN_FORM. If we enter a program name, the system replaces the program symbols with the values from this program up to the next END_FORM.

Exceptions and other Export, Import parameters are self-explanatory.

Write_Form: The system outputs the layout set element specified in parameter ELEMENT into the currently opened layout set. In the parameter WINDOW we can specify the name of a window for the output. Remember that the layout set element must be defined in this window. The parameter FUNCTION specifies how to merge the text lines to be output with any existing contents in the window. In this case, there are differences between the different window types or areas. Some of the important export parameters used in Write_Form.

Element: Specify the name of the text element you want to output into the layout set window specified in the parameter WINDOW. The element must be defined in that layout set window. If you specify no element, the system uses the default element, if one is defined in the layout set.

Window: Specify the name of the window into which you want to output the layout set element specified in the parameter ELEMENT. Default value for Window is ‘MAIN’.

Function: The parameter determines how to output the text element into the respective window. The output type depends on the window type and area:

Window Type: MAIN Area: BODY

SET/APPEND: Appends to previous output.

Window Type: Main Area: Top/Bottom and

Window Type: Other than Main and all areas

SET : Delete the old element contents and prints the new elements

APPEND: Appends the new content to existing elements.

Type: The system interprets this parameter only for output to the main window. The parameter determines the area of the main window into which we want to output the element. Possible values: 'TOP' header area

'BODY' main area

'BOTTOM' footer area

Default value: 'BODY'

Write_Form_Lines: This function module outputs the text lines in table LINES into the specified layout set window. The text lines must have the SAP script ITF format. From the data in the text header, the system uses only the field TDSTYLE to apply the formatting attributes defined in the specified style for this text. If the field is empty, the system uses the identically named formatting attributes (character and paragraph formats) of the layout set.

Use parameter WINDOW to specify into which of the windows defined in the layout set we want to output the text. We can specify any window used in the layout set. The parameter FUNCTION determines how to merge the text lines to be output with any existing contents in the window. There are differences between the different window types or areas.

Header: This parameter contains the header of the text module we want to output in the current layout set. For the formatting process, the system uses only the entries in the header fields TDSTYLE and TDFORM. Structure: THEAD

WINDOW: Enter the name of the window into which we want to output the layout set element specified in parameter ELEMENT. Default value: 'MAIN'

FUNCTION: This parameter determines how to output the text element into the respective window. The output type depends on the window type and area: Window type MAIN, area BODY: 'SET' append to previous output 'APPEND' same as SET. DELETE' no effect. Window type MAIN, areas TOP and BOTTOM; all other windows: 'SET' delete old window or area contents and output the element 'APPEND' append the element to the existing elements 'DELETE' no effect Default value: 'SET'

TYPE: The system interprets this parameter only for output to the main window. The parameter determines the area of the main window into which you want to output the element. Possible values: 'TOP' header area 'BODY' main area 'BOTTOM' footer area Default value: 'BODY'

END_FORM: END_FORM ends the currently open layout set and executes the required termination processing. After calling this function module, no more layout set is active. For further output, we must start a new layout set using START_FORM. No Export parameters.

CONTROL_FORM: Use this function module to pass SAP Script Control Commands to the layout set. The Control command is passed through the export parameter ‘COMMAND’ in quotes.

READ_FORM_ELEMENTS: This function module fills a table with all text elements that appear in one layout set. If we specify no layout set name, the system includes all elements of the currently open layout set. If we specify a layout set, the system uses the information about the active version of the layout set, retrieved from the database. Here we have two export parameters, Form and Language and a table parameter Elements.

READ_FORM_LINES: Use this function module to transfer the lines of a layout set element into an internal table. If we specify no layout set name, the system transfers the text lines of the currently open layout set. If we specify a layout set, the system uses the text lines of the active version of the layout set from the database. The Export parameters are Form, Language, Window and Element. If we pass these 4 parameters the function module returns a table with the lines from layout set.

with regards,

Hema Sundara.

pls reward if u find it helpful.