|
|
DTW Administration / Setup / Banking / Payment Methods / Currency Selection
API Wizard Payment Methods / Currency Restrictions
PYM1 - Currency Selection Table
Currency Restrictions CurrencyRestrictions Object· Table: PYM1
Parent: Wizard Payment Methods WizardPaymentMethods Object· Table: OPYM
Currency Codes OCRN SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | PymCode KEY UNIQUE | Payment Method Code | nVarChar | 15 | OPYM Payment Methods for Payment Wizard | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CurrCode | Currency Code | nVarChar | 3 | OCRN Currency Codes | ||||
| CurrName | Currency Name | nVarChar | 20 | |||||
| Choose | Choose | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
PYM1.PymCode AS 'Payment Method Code',
PYM1.CurrCode AS 'Currency Code',
PYM1.CurrName AS 'Currency Name',
PYM1.Choose AS 'Choose'
FROM PYM1 AS PYM1
Related information
Currency Restrictions CurrencyRestrictions Object· Table: PYM1
The CurrencyRestrictions is a child object of the WizardPaymentMethods object.
This object enables to allow or restrict currencies in the payment method.
Source table: PYM1.
Parent: Wizard Payment Methods WizardPaymentMethods Object· Table: OPYM Currency Codes OCRN SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
WizardPaymentMethods
Object
CurrencyRestrictions
Method
Property
Choose
DTW DB
CurrencyCode
DTW DB
CurrencyName
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
