|
|
API AQR1
AQR1 - Inventory Posting - Rows Table
Bin Location OBIN SQL Table
Business Partner OCRD SQL Table
G/L Accounts OACT SQL Table
Manufacturers OMRC SQL Table
Items OITM SQL Table
UoM Master Data OUOM SQL Table
Distribution Rule OOCR 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 | Document Internal ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocLineNum | Row Number in Document | Int | 11 | |||||
| ItemCode KEY | Item No. | nVarChar | 20 | OITM Items | ITEM_CODE | No | ||
| ItemName | Item Description | nVarChar | 100 | |||||
| InvntryUom | Inventory UoM | nVarChar | 100 | |||||
| OnHandBef | Quantity Stored in Warehouse | Num | 20 | |||||
| Price | Price | Num | 20 | |||||
| Quantity | Quantity - Delta | Num | 20 | |||||
| Currency | Price Currency | nVarChar | 3 | |||||
| Rate | Currency Price | Num | 20 | |||||
| IOffIncAcc | Inventory Offset Increase Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| DocTotal | Document Total | Num | 20 | |||||
| DocTotalFC | Document Total (FC) | Num | 20 | |||||
| DocTotalSy | Document Total (SC) | Num | 20 | |||||
| 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 | ||||
| ObjType | Object Type | nVarChar | 20 | 10000071 | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| BarCode | Bar Code | nVarChar | 127 | |||||
| InvUoM | Inventory UoM | VarChar | Y) Yes N) No | 1 | Y | |||
| BinEntry | Bin Location Entry | Int | 11 | OBIN Bin Location | ||||
| FirmCode | Manufacturer | Int | 6 | OMRC Manufacturers | ||||
| SuppCatNum | Mfr Catalog No. | nVarChar | 17 | |||||
| CardCode | Preferred Vendor | nVarChar | 15 | OCRD Business Partner | ||||
| CountDate | Count Date | Date | 8 | |||||
| CountTime | Count Time | Int | 11 | |||||
| DiffPercnt | Percentage Difference | Num | 20 | |||||
| BaseRef | Base Document Reference | nVarChar | 16 | |||||
| BaseType | Base Document Type | Int | -1) 1470000065) Inventory Counting | 11 | 1470000065 | |||
| BaseEntry | Base Document Internal ID | Int | 11 | |||||
| BaseLine | Base Row | Int | 11 | |||||
| CountQty | Counted Quantity | Num | 20 | |||||
| Remark | Remarks | nVarChar | 127 | |||||
| LogInstanc | Log Instance - History | Int | 11 | |||||
| CpyCount | Copied Count | Int | 0 1) Inventory Taker One 2) Two Takers - Taker 1 3) Two Takers - Taker 2 4) Two Takers - Items with Zero Difference | 11 | 0 | |||
| BinNegQty | Allow Bin Negative Quantity | VarChar | Y) Yes N) No | 1 | N | |||
| VisOrder | Visual Order | Int | 11 | |||||
| UgpEntry | UoM Group Entry | Int | 11 | OUGP UoM Group | ||||
| IUomEntry | Inventory UoM Entry | nVarChar | 20 | OUOM UoM Master Data | ||||
| UomCode | UoM Code for DI | nVarChar | 20 | |||||
| ItmsPerUnt | Items per Unit for DI | Num | 20 | |||||
| UomQty | UoM Counted Qty for DI | Num | 20 | |||||
| ActPrice | Actual Price | Num | 20 | |||||
| PostValueL | Posted Value LC | Num | 20 | |||||
| PostValueS | Posted Value SC | Num | 20 |
Table relationship map
SELECT statement
SELECT
AQR1.DocEntry AS 'Document Internal ID',
AQR1.DocLineNum AS 'Row Number in Document',
AQR1.ItemCode AS 'Item No.',
AQR1.ItemName AS 'Item Description',
AQR1.InvntryUom AS 'Inventory UoM',
AQR1.OnHandBef AS 'Quantity Stored in Warehouse',
AQR1.Price AS 'Price',
AQR1.Quantity AS 'Quantity - Delta',
AQR1.Currency AS 'Price Currency',
AQR1.Rate AS 'Currency Price',
AQR1.IOffIncAcc AS 'Inventory Offset Increase Acct',
AQR1.DOffDecAcc AS 'Inventory Offset Decrease Acct',
AQR1.OcrCode AS 'Distribution Rule',
AQR1.WhsCode AS 'Warehouse Code',
AQR1.DocTotal AS 'Document Total',
AQR1.DocTotalFC AS 'Document Total (FC)',
AQR1.DocTotalSy AS 'Document Total (SC)',
AQR1.OcrCode2 AS 'Distribution Rule 2',
AQR1.OcrCode3 AS 'Distribution Rule 3',
AQR1.OcrCode4 AS 'Distribution Rule 4',
AQR1.OcrCode5 AS 'Distribution Rule 5',
AQR1.ObjType AS 'Object Type',
AQR1.Project AS 'Project Code',
AQR1.BarCode AS 'Bar Code',
AQR1.InvUoM AS 'Inventory UoM',
AQR1.BinEntry AS 'Bin Location Entry',
AQR1.FirmCode AS 'Manufacturer',
AQR1.SuppCatNum AS 'Mfr Catalog No.',
AQR1.CardCode AS 'Preferred Vendor',
AQR1.CountDate AS 'Count Date',
AQR1.CountTime AS 'Count Time',
AQR1.DiffPercnt AS 'Percentage Difference',
AQR1.BaseRef AS 'Base Document Reference',
AQR1.BaseType AS 'Base Document Type',
AQR1.BaseEntry AS 'Base Document Internal ID',
AQR1.BaseLine AS 'Base Row',
AQR1.CountQty AS 'Counted Quantity',
AQR1.Remark AS 'Remarks',
AQR1.LogInstanc AS 'Log Instance - History',
AQR1.CpyCount AS 'Copied Count',
AQR1.BinNegQty AS 'Allow Bin Negative Quantity',
AQR1.VisOrder AS 'Visual Order',
AQR1.UgpEntry AS 'UoM Group Entry',
AQR1.IUomEntry AS 'Inventory UoM Entry',
AQR1.UomCode AS 'UoM Code for DI',
AQR1.ItmsPerUnt AS 'Items per Unit for DI',
AQR1.UomQty AS 'UoM Counted Qty for DI',
AQR1.ActPrice AS 'Actual Price',
AQR1.PostValueL AS 'Posted Value LC',
AQR1.PostValueS AS 'Posted Value SC'
FROM AQR1 AS AQR1
Related information
Bin Location OBIN SQL Table
Business Partner OCRD SQL Table
G/L Accounts OACT SQL Table
Manufacturers OMRC SQL Table
Items OITM SQL Table
UoM Master Data OUOM SQL Table
Distribution Rule OOCR 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
