|
|
API CIN17
CIN17 - Correction Invoice - Bin Allocation Data Table
A/R Correction Invoice OCIN SQL Table
Brazil String Indexer OBSI SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | OCIN A/R Correction Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Bin Allocation Sequence | Int | 11 | |||||
| LogInstanc | Line Number | Int | 11 | 0 | ||||
| ObjectType | Subline Number | nVarChar | 20 | ADP1 Object Settings - History | 132 | |||
| ImpDocType | SnB Type | VarChar | 1 | OBSI Brazil String Indexer | ||||
| ImpDocNum | SnB Master Data Internal Number | nVarChar | 10 | |||||
| DateOfReg | Bin Internal Number | Date | 8 | |||||
| CustClrDat | Quantity | Date | 8 | |||||
| ConcActNum | Item Code | nVarChar | 30 | |||||
| AdditNum | Warehouse Code | nVarChar | 30 | |||||
| AddItmDV | Object Type | Num | 20 | |||||
| tpVTransp | Overland Transport Route | Int | 1) Maritime 2) Waterway 3) Lakeside 4) Air 5) Post 6) Train 7) Road 8) Network Transmission 9) Own Means 10) Input/Output Fictitious | 6 |
Table relationship map
SELECT statement
SELECT
CIN17.DocEntry AS 'Internal Number',
CIN17.LineNum AS 'Bin Allocation Sequence',
CIN17.LogInstanc AS 'Line Number',
CIN17.ObjectType AS 'Subline Number',
CIN17.ImpDocType AS 'SnB Type',
CIN17.ImpDocNum AS 'SnB Master Data Internal Number',
CIN17.DateOfReg AS 'Bin Internal Number',
CIN17.CustClrDat AS 'Quantity',
CIN17.ConcActNum AS 'Item Code',
CIN17.AdditNum AS 'Warehouse Code',
CIN17.AddItmDV AS 'Object Type',
CIN17.tpVTransp AS 'Overland Transport Route'
FROM CIN17 AS CIN17
Related information
A/R Correction Invoice OCIN SQL Table
Brazil String Indexer OBSI SQL Table
Object Settings - History ADP1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
