SerialNumber

SerialNumber

 

Property

Description

Table

OSRN

Primary key

ItemCode/c,SystemNumber/i

$transaction

no

$branch

no

$mask

For dropdown you can use follow mask definition:
1: Batch,Version,BatchAttribute1,BatchAttribute2
You can define follow filter:
&$filter=ItemCode eq
 

 

Fields

Name

Type

Description

ItemCode

Edm.String(50)

Entity Relation: Item -> ItemCode

Database: "OSRN"."ItemCode"

SystemNumber

Edm.Int32

Database: "OSRN"."SysNumber"

DocEntry

Edm.Int32

Database: "OSRN"."AbsEntry"

Batch

Edm.String(36)

Database: "OSRN"."DistNumber"

BatchAttribute1

Edm.String(36)

Database: "OSRN"."MnfSerial"

BatchAttribute2

Edm.String(36)

Database: "OSRN"."LotNumber"

Version

Edm.String(36)

Database: "OSRN"."U_beas_ver"

Details

Edm.String(8000)

Database: "OSRN"."Notes"

AdmissionDate

Edm.DateTimeOffset

Database: "OSRN"."InDate"

ExpirationDate

Edm.DateTimeOffset

Database: "OSRN"."ExpDate"

ManufacturingDate

Edm.DateTimeOffset

Database: "OSRN"."MnfDate"

WarrantyStart

Edm.DateTimeOffset

Database: "OSRN"."GrntStart"

WarrantyEnd

Edm.DateTimeOffset

Database: "OSRN"."GrntExp"

Status

Edm.String(1)

Database: "OSRN"."Status"

SelfProduction

Edm.Boolean

Database: "OSRN"."U_beas_selfprod"

 

Relations

Join to Entiy Object

Relation

Item

ItemCode

SerialNumberStock

ItemCode,SystemNumber

 

SerialNumber example GET query, that requests the ItemCode and ExpirationDate properties of all SerialNumbers:

/SerialNumber?$select=ItemCode,ExpirationDate

 

Response in JSON format:

{
    "value": [
         {
            "ItemCode": "PROSERMBIN",
            "ExpirationDate": "2011-05-03T00:00Z"
        },
        {
            "ItemCode": "PROSERMBIN",
            "ExpirationDate": "2011-05-03T00:00Z"
        },
        {
            "ItemCode": "PROSERMBIN",
            "ExpirationDate": "2011-05-03T00:00Z"
        },
        {
            "ItemCode": "PROSERMBIN",
            "ExpirationDate": "2011-05-03T00:00Z"
        }
    ]
}

 

 

PUT

With follow code you can change an existing batch number

PUT SerialNumber("ItemCode",SysNumber) 
PUT SerialNumber(DocumentNumber)   // related to OSRN.AbsEntry

 

PUT command support database field names too. You can use same (wrong) field names as described in SAP SDK documentation, same field names in SerialNumber object or the current database field names.

 

beasscript-logo-small

Example beas script

instance bsl b
b.post=SerialNumber("RM_S",10)<tab>{"InternalSerialNumber":"2349494"}
if <b.ret_code> <> 1 then
  messagebox=error$$<b.ret_text>
end if