|
|
DTW Inventory / Bar Codes / Bar Code Master Data
API Bar Codes Service / Bar Code
OBCD - Bar Code Master Data Table
Bar Code BarCode Object· Table: OBCD
Parent: Bar Codes Service BarCodesService Service· Table: OBCD
Bar Codes Service BarCodesService Service· Table: OBCD
OBCD SQL Table
Items OITM SQL Table
UoM Master Data OUOM SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BcdEntry KEY UNIQUE | Bar Code Abs. Entry | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BcdCode KEY | Bar Code - Code | nVarChar | 127 | BCD_CODE | No | |||
| BcdName | Bar Code Name | nVarChar | 100 | |||||
| ItemCode KEY UNIQUE | Item No. | nVarChar | 20 | OITM Items | ITEM | Yes | ||
| UomEntry | UoM Abs. Entry | Int | 11 | OUOM UoM Master Data | ||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
OBCD.BcdEntry AS 'Bar Code Abs. Entry',
OBCD.BcdCode AS 'Bar Code - Code',
OBCD.BcdName AS 'Bar Code Name',
OBCD.ItemCode AS 'Item No.',
OBCD.UomEntry AS 'UoM Abs. Entry',
OBCD.DataSource AS 'Data Source',
OBCD.UserSign AS 'User Signature',
OBCD.LogInstanc AS 'Log Instance',
OBCD.UserSign2 AS 'Updating User',
OBCD.UpdateDate AS 'Date of Update',
OBCD.CreateDate AS 'Creation Date'
FROM OBCD AS OBCD
Related information
Bar Code BarCode Object· Table: OBCD
The bar codes for your items. Multiple bar codes are allowed for each single UoM of an item.
Source table: OBCD.
Parent: Bar Codes Service BarCodesService Service· Table: OBCD Bar Codes Service BarCodesService Service· Table: OBCD
The BarCodesService service enables you to add, look up, update, and remove bar codes.
Source table: OBCD.
OBCD SQL Table
Items OITM SQL Table
UoM Master Data OUOM SQL Table
Users OUSR SQL Table
BarCodesService
Object
BarCode
Method
Property
AbsEntry
DTW DB
BarCode
DTW DB
FreeText
DTW DB
ItemNo
DTW DB
UoMEntry
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates