Reservation
beas reservation list
Property
Description
Table
BEAS_RESERVATION_LINE
Primary key
DocEntry/i,LineNumber/i
$transaction
no
$branch
no
$mask
no
Fields
Name
Type
Description
DocEntry
Edm.Int32
Internal Document Number for this reservation line
It's not linked to another document, it's only a internal numbering
Primary key
Database: "BEAS_RESERVATION_LINE"."DocEntry"
LineNumber
Edm.Int32
Internal Document Line Number for this reservation line
It's not linked to another document, it's only a internal numbering
Primary key
Database: "BEAS_RESERVATION_LINE"."LineNum"
DocDate
Edm.DateTimeOffset
Database: "BEAS_RESERVATION_LINE"."DocDate"
ReservationType
Edm.String(1)
Type of Reservation
S=Stock related
P=Planned (Example from Work order)
A=Archived (beas archive reservation, if this is comming from Planned work order)
Describe Reservation Type
Constraints:
Stock reservation=S
Planned reservation=P
Archive=A
Database: "BEAS_RESERVATION_LINE"."RESERVATIONTYPE"
BaseType
Edm.String(2)
This is the Document, for which the Reservation was created
Example for Work order
Type: "wo" for Work order or the SAP Object Id
Database: upper(rtrim("BEAS_RESERVATION_LINE"."BASE_TYPE"))
BaseDocEntry
Edm.Int32
This is the Document, for which the Reservation was created
Example for Work order (Table BEAS_FTHAUPT.BELNR_ID)
Or Sales Order (ORDR.DocEntry)
Assign to document
Workorder (BEAS_FHHAUPT.BELNR_ID) or Document example (ORDR.DocEntry)
Mandatory field
Database: "BEAS_RESERVATION_LINE"."BASE_DOCENTRY"
BaseLineNumber
Edm.Int32
Assign to document line
Workorder (BEAS_FTPOS.BELPOS_ID) or Document example (RDR1.LineNum)
Mandatory field
Database: "BEAS_RESERVATION_LINE"."BASE_LINENUM"
BaseLineNumber2
Edm.Int32
Assign to work order Bill of Material position
Workorder (BEAS_FTSTL.POS_ID)
Mandatory field
Database: "BEAS_RESERVATION_LINE"."BASE_LINENUM2"
LinkType
Edm.String(1)
Second Link, example Pick list
Picklist:
If you work with link to a Picklist, then beas change automatically the picked quantity in the pick list, if you make a reservation
beas use for this the DI API. It don't create a batch reservation or serial number reservation in SAP. It change only the picked quantity
Constraints:
Pick List=picklist
Work order=wo
Database: "BEAS_RESERVATION_LINE"."LINK_TYPE"
LinkDocEntry
Edm.Int32
Database: "BEAS_RESERVATION_LINE"."LINK_DOCENTRY"
LinkLineNumber
Edm.Int32
Database: "BEAS_RESERVATION_LINE"."LINK_LINENUM"
LinkLineNumber2
Edm.Int32
Database: "BEAS_RESERVATION_LINE"."LINK_LINENUM2"
ItemCode
Edm.String(50)
Entity Relation: Item -> ItemCode
Mandatory field
Database: "BEAS_RESERVATION_LINE"."ItemCode"
WhsCode
Edm.String(20)
Mandatory field
Database: "BEAS_RESERVATION_LINE"."WhsCode"
IVersion
Edm.String(20)
Database: coalesce("BEAS_RESERVATION_LINE"."Version",'')
DistNumber
Edm.String(50)
Dist Number from Batch / Serial related item
Database: coalesce("BEAS_RESERVATION_LINE"."DistNumber",'')
SysNumber
Edm.Int32
Database: coalesce(case when "OITM"."ManBtchNum"='Y' then "OBTN"."SysNumber" else "OSRN"."SysNumber" end,0)
BinCode
Edm.String(20)
Database: coalesce("BEAS_RESERVATION_LINE"."BINCODE",'')
RFID
Edm.String(20)
Database: coalesce("BEAS_RESERVATION_LINE"."RFID",'')
Quantity
Edm.Decimal
Mandatory field
Database: "BEAS_RESERVATION_LINE"."Quantity"
UoMStock
Edm.String(1)
Integration hub: Importable
Database: "OITM"."InvntryUom"
SetQuantity
Edm.Decimal
Database: "BEAS_RESERVATION_LINE"."SETQUANTITY"
SupplierBatchNumber
Edm.String(40)
Database: "BEAS_RESERVATION_LINE"."SUPPLIERBATCH"
StationId
Edm.String(50)
Created from Station Id
Not possible to change this
BSL: The name of client
Remote Terminal Server: The current Remote user
Database: "BEAS_RESERVATION_LINE"."STATION_ID"
PersonnelId
Edm.String(20)
The current Personnel Id
It is not possible to define this. The system use always current logged in Personnel Id
Linked table: BEAS_PERS
Linked column: PERS_ID
Database: "BEAS_RESERVATION_LINE"."PERS_ID"
USER_ID
Edm.String(20)
The current SAP User Id
It is not possible to change or define this. Always current User Id will be used
Database: "BEAS_RESERVATION_LINE"."USER_ID"
Relations
Join to Entiy Object
Relation
Item
ItemCode
UoM
UoMCode=UoMStock
Functions
Function
Parameter
Description
UpdateReservationTransferDocument
DocEntry/i
POST Follow example create a reservation for Work order 1014, Work order position 10, Material Position (Pos_id)=20 for Material RM for 5 Pcs on Warehouse 01
(Attention: The system don't check, if stock is available or if Material is reserved)
If you send the reservation the second time, the system add the quantity to first item
ODATA4/Reservation Body
{ "BaseType" : "wo" , "BaseDocEntry" : 1344 , "BaseLineNumber" : 10 , "BaseLineNumber2" : 20 , "ItemCode" : "RM" , "WhsCode" : "01" , "Quantity" : 5 }
ODATA4/Reservation linked to
{ "BaseType" : "wo" , "BaseDocEntry" : 1344 , "BaseLineNumber" : 10 , "BaseLineNumber2" : 20 , "ItemCode" : "RM" , "WhsCode" : "01" , "Quantity" : 5 } { "DocEntry" : 39 , "LineNum" : 1 , "LastLineNum" : 1 , "LifeTime" : "2022/03/07" }
In BaseType you can define the base document. For Sales / PreInvoice you must define the line number in "BaseLineNumber2"
Automatic Reservation
With Property "automatic":true you can create automatically the reservation based on Batch Number / Serial number and Bin Code Priority
{ "Automatic" : true , "BaseType" : "wo" , "BaseDocEntry" : 1344 , "BaseLineNumber" : 10 , "BaseLineNumber2" : 20 , "WhsCode" : "BEAS-BIN" "ItemCode" : "RMB" , "Quantity" : 50 }
Note: Only beas Bin management supported
If you need more then one Batch, then beas create more then one Reservation line, example: 40* Batch 1 and 10*Batch 2
Return value:
{ "DocEntry" : 39 , "LineNum" : 1 , "LastLineNum" : 4 , "LifeTime" : "2022/03/07" }
Working with SAP Pick and Pack List
You can link a reservation with LinkType="picklist", LinkDocEntry=Pick List PKL1.AbsEntry and LinkLineNumber=Pick List PLK1.PickEntry
if you create a reservation, you increment the pick quantity in the pick list.
The system don't insert Batch / Serial information or bin location inside the Pick list. Only the Picked quantity will be changed
Batch and Serial numbers
You can define Batch and Serial numbers with DistNumber or SysNumber. The SysNumber has higher priority
Example Json work with SysNumber or DistNumber
{ "BaseType" : "wo" , "BaseDocEntry" : 1344 , "BaseLineNumber" : 10 , "BaseLineNumber2" : 20 , "ItemCode" : "RM_B" , "WhsCode" : "01" , "SysNumber" : 105 , "Quantity" : 5 } { "BaseType" : "17" , "BaseDocEntry" : 1344 , "BaseLineNumber" : 0 , "BaseLineNumber2" : 1 , "ItemCode" : "RM_B" , "DistNumber" : "A111" , "WhsCode" : "01" , "Quantity" : 5 }
Example with beasScript
instance bsl b #define ls_json { "BaseType" : "wo" , "BaseDocEntry" : 20190406 , "BaseLineNumber" : 10 , "BaseLineNumber2" : 10 , "ItemCode" : "RM" , "WhsCode" : "01" , "Quantity" : 5 } #end b . post = Reservation =< ls_json > //messagebox=<b.ret_code> <b.ret_text> <b.ret_value> destroy = b
Delete
Delete the reservation line
DELETE Rerservation ( DocEntry , LineNumber ) DELETE Reservation ( 1014 , 1 )
201 for ok204 no content, if no entry found
