|
|
API OIPD
OIPD - Inventory Posting Draft Table
Inventory Posting Draft OIPD SQL Table
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Journal Entry OJDT SQL Table
Documents Numbering - Series NNM1 SQL Table
Users OUSR 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 |
|---|---|---|---|---|---|---|---|---|
| CreateDate KEY | Creation Date | Date | 8 | CREATEDATE | No | |||
| DocTime | Generation Time | Int | 6 | |||||
| IOffIncAcc | Inventory Offset Increase Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DocDate KEY | Posting Date | Date | 8 | DOC_DATE | No | |||
| Reference | Reference | nVarChar | 11 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| DataSource | Data Source | VarChar | 1 | N | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| JdtNum | Journal Number | Int | 11 | OJDT Journal Entry | ||||
| Reference2 | Reference 2 | nVarChar | 11 | |||||
| ObjType | Object Type | nVarChar | 20 | 10000071 | ||||
| DocNum | Document Number | Int | 11 | |||||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| PriceSrc | Price Source | Int | 1) By Price List 2) Last Evaluated Price 3) Item Cost | 11 | 3 | |||
| PriceList | Price List | Int | 11 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| Status | Status | VarChar | O) Open C) Close | 1 | O | |||
| LogIns | Log Instance - History | Int | 11 | |||||
| UserSign2 | Updating User - History | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update - History | Date | 8 | |||||
| CountDate | Date of Counting | Date | 8 | |||||
| CountTime | Time of Counting | Int | 11 | |||||
| WddStatus | Authorization Status | VarChar | -) Without W) Pending Y) Approved N) Rejected P) Generated A) Generated by Authorizer C) Canceled | 1 | ||||
| DraftKey | Draft Document Internal ID | Int | 11 | OIPD Inventory Posting Draft | -1 | |||
| Printed | Printed | VarChar | 1 | N | ||||
| DocTotal | Document Total | Num | 20 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| UpdateTS | Update Full Time | Int | 11 | |||||
| CopyOption | DI Copy from Option | VarChar | 0 1) Individual 1 2) Individual 2 3) Individual 3 4) Individual 4 5) Individual 5 6) Team Counted Quantity | 1 | 0 | |||
| BaseEntry | Base Counting Doc. Entry | Int | 11 | |||||
| PIndicator | Period Indicator | nVarChar | 10 | ' ' | ||||
| FinncPriod | Posting Period | Int | 11 |
Table relationship map
SELECT statement
SELECT
OIPD.DocEntry AS 'Document Internal ID',
OIPD.CreateDate AS 'Creation Date',
OIPD.DocTime AS 'Generation Time',
OIPD.IOffIncAcc AS 'Inventory Offset Increase Acct',
OIPD.DOffDecAcc AS 'Inventory Offset Decrease Acct',
OIPD.DocDate AS 'Posting Date',
OIPD.Reference AS 'Reference',
OIPD.Comments AS 'Remarks',
OIPD.DocDueDate AS 'Due Date',
OIPD.DataSource AS 'Data Source',
OIPD.UserSign AS 'User Signature',
OIPD.VersionNum AS 'Version Number',
OIPD.JdtNum AS 'Journal Number',
OIPD.Reference2 AS 'Reference 2',
OIPD.ObjType AS 'Object Type',
OIPD.DocNum AS 'Document Number',
OIPD.Series AS 'Series',
OIPD.PriceSrc AS 'Price Source',
OIPD.PriceList AS 'Price List',
OIPD.JrnlMemo AS 'Journal Remarks',
OIPD.Status AS 'Status',
OIPD.LogIns AS 'Log Instance - History',
OIPD.UserSign2 AS 'Updating User - History',
OIPD.UpdateDate AS 'Date of Update - History',
OIPD.CountDate AS 'Date of Counting',
OIPD.CountTime AS 'Time of Counting',
OIPD.WddStatus AS 'Authorization Status',
OIPD.DraftKey AS 'Draft Document Internal ID',
OIPD.Printed AS 'Printed',
OIPD.DocTotal AS 'Document Total',
OIPD.BPLId AS 'Branch',
OIPD.BPLName AS 'Branch Name',
OIPD.UpdateTS AS 'Update Full Time',
OIPD.CopyOption AS 'DI Copy from Option',
OIPD.BaseEntry AS 'Base Counting Doc. Entry',
OIPD.PIndicator AS 'Period Indicator',
OIPD.FinncPriod AS 'Posting Period'
FROM OIPD AS OIPD
Related information
Inventory Posting Draft OIPD SQL Table
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Journal Entry OJDT SQL Table
Documents Numbering - Series NNM1 SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
