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"
|
|
SSCC
|
Edm.String(20)
|
|