|
|
API ICD1
ICD1 - Inventory Counting Draft - Rows Table
Bin Location OBIN SQL Table
Inventory Counting Draft OICD SQL Table
Manufacturers OMRC SQL Table
Items OITM SQL Table
UoM Master Data OUOM SQL Table
Distribution Rule OOCR SQL Table
Business Partner OCRD SQL Table
Project Codes OPRJ SQL Table
UoM Group OUGP SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | OICD Inventory Counting Draft | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| ItemDesc | Item Description | nVarChar | 100 | |||||
| Freeze | Item Freeze Status | VarChar | Y) Yes N) No | 1 | N | |||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| InWhsQty | In-Whse Qty on Count Date | Num | 20 | |||||
| Counted | Counted | VarChar | Y) Yes N) No | 1 | N | |||
| CountQty | Counted Quantity | Num | 20 | |||||
| CountQtyT1 | Counter 1 - Counted Quantity | Num | 20 | |||||
| CountQtyT2 | Num | 20 | ||||||
| Remark | Remarks | nVarChar | 127 | |||||
| BarCode | Bar Code | nVarChar | 127 | |||||
| InvUoM | Inventory UoM | VarChar | Y) Yes N) No | 1 | Y | |||
| Difference | Difference | Num | 20 | |||||
| DiffPercen | Difference % | Num | 20 | |||||
| CountDate | Count Date | Date | 8 | |||||
| CountTime | Count Time | Int | 11 | |||||
| TargetRef | Target Document Reference | nVarChar | 16 | |||||
| TargetType | Target Document Type | Int | -1) 0 10000071) Inventory Posting | 11 | -1 | |||
| TargetEntr | Target Document Internal ID | Int | 11 | |||||
| TargetLine | Target Document Row | Int | 11 | |||||
| ProjCode | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| OcrCode | Distribution Rule Code | nVarChar | 8 | OOCR Distribution Rule | ||||
| LineStatus | Row Status | VarChar | O) Open C) Closed | 1 | O | |||
| BinEntry | Bin Location Entry | Int | 11 | OBIN Bin Location | ||||
| VisOrder | Visual Order | Int | 11 | |||||
| OcrCode2 | Distribution Rule 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| FirmCode | Manufacturer | Int | 6 | OMRC Manufacturers | ||||
| SuppCatNum | Mfr Catalog No. | nVarChar | 17 | |||||
| PrefVendor | Preferred Vendor | nVarChar | 15 | OCRD Business Partner | ||||
| LogIns | Log Instance - History | Int | 11 | |||||
| UgpEntry | UoM Group Entry | Int | 11 | OUGP UoM Group | ||||
| IUomEntry | Inventory UoM Entry | nVarChar | 20 | OUOM UoM Master Data | ||||
| CountDiff | Counters' Diff. | Num | 20 | |||||
| CountDiffP | Counters' Diff. (%) | Num | 20 | |||||
| UomCode | UoM Code for DI | nVarChar | 20 | |||||
| UomQty | UoM Counted Qty for DI | Num | 20 |
Table relationship map
SELECT statement
SELECT
ICD1.DocEntry AS 'Internal Number',
ICD1.LineNum AS 'Row Number',
ICD1.ItemCode AS 'Item Code',
ICD1.ItemDesc AS 'Item Description',
ICD1.Freeze AS 'Item Freeze Status',
ICD1.WhsCode AS 'Warehouse Code',
ICD1.InWhsQty AS 'In-Whse Qty on Count Date',
ICD1.Counted AS 'Counted',
ICD1.CountQty AS 'Counted Quantity',
ICD1.CountQtyT1 AS 'Counter 1 - Counted Quantity',
ICD1.CountQtyT2 AS '',
ICD1.Remark AS 'Remarks',
ICD1.BarCode AS 'Bar Code',
ICD1.InvUoM AS 'Inventory UoM',
ICD1.Difference AS 'Difference',
ICD1.DiffPercen AS 'Difference %',
ICD1.CountDate AS 'Count Date',
ICD1.CountTime AS 'Count Time',
ICD1.TargetRef AS 'Target Document Reference',
ICD1.TargetType AS 'Target Document Type',
ICD1.TargetEntr AS 'Target Document Internal ID',
ICD1.TargetLine AS 'Target Document Row',
ICD1.ProjCode AS 'Project Code',
ICD1.OcrCode AS 'Distribution Rule Code',
ICD1.LineStatus AS 'Row Status',
ICD1.BinEntry AS 'Bin Location Entry',
ICD1.VisOrder AS 'Visual Order',
ICD1.OcrCode2 AS 'Distribution Rule 2',
ICD1.OcrCode3 AS 'Distribution Rule 3',
ICD1.OcrCode4 AS 'Distribution Rule 4',
ICD1.OcrCode5 AS 'Distribution Rule 5',
ICD1.FirmCode AS 'Manufacturer',
ICD1.SuppCatNum AS 'Mfr Catalog No.',
ICD1.PrefVendor AS 'Preferred Vendor',
ICD1.LogIns AS 'Log Instance - History',
ICD1.UgpEntry AS 'UoM Group Entry',
ICD1.IUomEntry AS 'Inventory UoM Entry',
ICD1.CountDiff AS 'Counters' Diff.',
ICD1.CountDiffP AS 'Counters' Diff. (%)',
ICD1.UomCode AS 'UoM Code for DI',
ICD1.UomQty AS 'UoM Counted Qty for DI'
FROM ICD1 AS ICD1
Related information
Bin Location OBIN SQL Table
Inventory Counting Draft OICD SQL Table
Manufacturers OMRC SQL Table
Items OITM SQL Table
UoM Master Data OUOM SQL Table
Distribution Rule OOCR SQL Table
Business Partner OCRD SQL Table
Project Codes OPRJ SQL Table
UoM Group OUGP SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
