You can create Labels / Documents with RTF text.
It is possible to work with placeholders.
Window webwindow_user_setup.psr
See also extended App Setup.
ollowing variables are available in the Print interface:
(only for apps which create SAP transaction document as receipt, issue, transfer, invoice document)
Variable
|
Description
|
DocNumber
|
Document Number
|
DocEntry
|
Document Entry (internal key)
|
PrimaryObject
|
SAP Object code for generated document
|
PrimaryTable
|
SAP Table for generated document, for example OIGE for Issue document
|
DocumentName
|
Document name in system language
|
This variables are available as PrintObject Variable and instance variable.
Button "Standard"
If you click on the Standard button, Beas inserts an example.
Additional Variables
If you need additional variables, you can define them in tab "Print Script". Beas executes the script before printing the RTF text.
(beas 9.3 PL 3 HF 1)
Example: You want to send ItemCode, ItemName, DistNumber, Quantity and another information
With the following SQL Statement you can read Serial numbers, Bin locations (only Beas), Item Code, ItemName and other information from the generated document:
instance datastore d
// Table Name is in <PrimaryTable>
// We need name of Line table: This is header table from place 2 + 1
// example: OIGN = IGN1
setvar=ls_linetable=<PrimaryTable,mid 2>1
// exceute sql statement. We use Version 2 (v2). In this way the name of columns same as field name
// (without (v2): Header_DocNum, with (v2): DocNum
d.(v2)select Header."DocNum",Header."CardName",Line."VisOrder" +1 as "VisOrder",Line."ItemCode",Line."Dscription",Line."WhsCode",Line."Quantity",&
case when "OITM"."ManSerNum"='Y' then "OSRN"."DistNumber" else "OBTN"."DistNumber" end as "BatchNumber" ,&
"BEAS_WHSBINJOURNAL"."BINCODE" &
from "<ls_linetable>" Line &
inner join "OITM" on "OITM"."ItemCode" = Line."ItemCode" &
inner join "<PrimaryTable>" Header on Header."DocEntry"=Line."DocEntry" &
left outer join "OITL" on "OITL"."DocType"=Line."ObjType" and "OITL"."DocEntry"=Line."DocEntry" and "OITL"."DocLine"=Line."LineNum" &
left outer join "ITL1" on "ITL1"."LogEntry"="OITL"."LogEntry" and "ITL1"."ItemCode"="OITL"."ItemCode" &
left outer join "OBTN" on "OBTN"."SysNumber"="ITL1"."SysNumber" and "OBTN"."ItemCode"="ITL1"."ItemCode" and "OITM"."ManBtchNum"='Y' &
left outer join "OSRN" on "OSRN"."SysNumber"="ITL1"."SysNumber" and "OSRN"."ItemCode"="ITL1"."ItemCode" and "OITM"."ManSerNum"='Y' &
inner join "OIVL" on "OIVL"."TransType"=Line."ObjType" and "OIVL"."CreatedBy"=Line."DocEntry" and "OIVL"."DocLineNum"=Line."LineNum" &
inner join "OIVK" on "OIVK"."TransSeq"="OIVL"."TransSeq" and "OIVK"."LayerID"=0 &
left outer join "BEAS_WHSBINJOURNAL" on "BEAS_WHSBINJOURNAL"."TransNum"="OIVK"."TransNum" and (case when "OITM"."ManSerNum"='Y' then CAST("OSRN"."SysNumber" AS varchar(30)) when "OITM"."ManBtchNum"='Y' then "OBTN"."DistNumber" else '' end) = "BEAS_WHSBINJOURNAL"."BatchNum" &
where Line."DocEntry"=<DocEntry>;
in RTF you can insert all additional placeholders:
|