|
|
DTW Inventory / Price Lists / Price Lists
API OPLN / Price Lists
OPLN - Price Lists Table
Price Lists PriceLists Object· Table: OPLN
Price Lists OPLN SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ListNum KEY UNIQUE | Price List No. | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ListName KEY UNIQUE | Price List Name | nVarChar | 32 | LIST_NAME | Yes | |||
| BASE_NUM | Base Price List | Int | 6 | OPLN Price Lists | ||||
| Factor | Factor | Num | 20 | |||||
| RoundSys | Rounding Method | Int | 0 1) Round to Full Decimal Amount 2) Round to Full Amount 3) Round to Full Tens Amount 4) Fixed Ending 5) Fixed Interval | 6 | 0 | |||
| GroupCode | Group No. | Int | 1) Group 1 2) Group 2 3) Group 3 4) Group 4 | 6 | 1 | |||
| 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 | |||
| SPPCounter | SPP Counter | Int | 11 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| IsGrossPrc | Gross Price? | VarChar | Y) Yes N) No | 1 | N | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| ValidFor | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| ValidFrom | Active From | Date | 8 | |||||
| ValidTo | Active To | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| PrimCurr | Primary Default Currency | nVarChar | 3 | |||||
| AddCurr1 | Additional Default Currency 1 | nVarChar | 3 | |||||
| AddCurr2 | Additional Default Currency 2 | nVarChar | 3 | |||||
| RoundRule | Rounding Rule | VarChar | R) Round to Closest C) Round Up F) Round Down | 1 | R | |||
| ExtAmount | Fixed Amount (Ending/Interval) | Num | 20 | |||||
| RndFrmtInt | Ending/Interval - Integer Part | nVarChar | 10 | |||||
| RndFrmtDec | Ending/Interval - Decimal Part | nVarChar | 10 |
Table relationship map
SELECT statement
SELECT
OPLN.ListNum AS 'Price List No.',
OPLN.ListName AS 'Price List Name',
OPLN.BASE_NUM AS 'Base Price List',
OPLN.Factor AS 'Factor',
OPLN.RoundSys AS 'Rounding Method',
OPLN.GroupCode AS 'Group No.',
OPLN.DataSource AS 'Data Source',
OPLN.SPPCounter AS 'SPP Counter',
OPLN.UserSign AS 'User Signature',
OPLN.IsGrossPrc AS 'Gross Price?',
OPLN.LogInstanc AS 'Log Instance',
OPLN.UserSign2 AS 'Updating User',
OPLN.UpdateDate AS 'Update Date',
OPLN.ValidFor AS 'Active',
OPLN.ValidFrom AS 'Active From',
OPLN.ValidTo AS 'Active To',
OPLN.CreateDate AS 'Creation Date',
OPLN.PrimCurr AS 'Primary Default Currency',
OPLN.AddCurr1 AS 'Additional Default Currency 1',
OPLN.AddCurr2 AS 'Additional Default Currency 2',
OPLN.RoundRule AS 'Rounding Rule',
OPLN.ExtAmount AS 'Fixed Amount (Ending/Interval)',
OPLN.RndFrmtInt AS 'Ending/Interval - Integer Part',
OPLN.RndFrmtDec AS 'Ending/Interval - Decimal Part'
FROM OPLN AS OPLN
Related information
Price Lists PriceLists Object· Table: OPLN
PriceLists is a business object that represents the management of price lists in the Inventory module. A price list is used by Items_Prices object to set the item prices. An item can have several prices, with each based on a different price list,...
Price Lists OPLN SQL Table
Users OUSR SQL Table
PriceLists
Enumeration
Method
Property
BasePriceList
DTW DB
Factor
DTW DB
GroupNum
DTW DB
PriceListName
DTW DB
PriceListNo
DTW DB
RoundingMethod
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
