The ATPA table in SAP ERP or S/4HANA stores Treasury: Product Type Supplements data. There are total 35 fields in ATPA table. The Treasury: Product Type Supplements table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ATPA table. It is in R/3 appl. development for Treasury money,forex,forward gen (FTA) ABAP package and is part of the Transaction Manager (FIN-FSCM-TRM-TM) module.
SAP ATPA Table Fields
Following is the list of fields that are available in SAP ATPA table. The primary key fields of the table are MANDT (Client), SGSART (Product Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| SGSART | Product Type | VVSART | TZPA | CHAR (3) |
| USGSART | Product type of underlying | TB_USGSART | TZPA | CHAR (3) |
| USFHAART | Transaction Type of Underlying | TB_USFHAAR | AT10 | CHAR (3) |
| NUMKR | Number range | NUMKR | CHAR (2) | |
| UNUMBER | Number of Underlyings | TB_UNUMBER | DEC (4) | |
| SETTLFL | Settlement Indicator | TI_SETTLFL | CHAR (1) | |
| SCAPFLOOR | Cap/Floor Indicator | TI_SCAPFLO | NUMC (1) | |
| NOTTYPE | Quotation type option/future | TI_NOTTYPE | CHAR (1) | |
| SABRMET | Settlement Method Option | TI_SABRMET | CHAR (1) | |
| SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC (1) | |
| OPTTYP | Original Option Category (on Closing) | TV_OPTTYP | ATO1 | NUMC (3) |
| JWSWAP | Indicator: Currency Swap | TI_JWSWAP | CHAR (1) | |
| BCURVE | Bid valuation curve type for mark-to-market | TB_BCURVE | NUMC (4) | |
| BCURVEB | Ask Valuation Curve: Mark-to-Market | TB_BCURVEB | NUMC (4) | |
| ROFNUMKR | Number Range Master Data – Listed Options and Futures | TI_ROFNUMK | CHAR (2) | |
| FRA_AUSTRALIA | Discount FRA | TB_FRA_AUSTRAL | CHAR (1) | |
| SOFTYP | Options/futures category | TI_SOFTYP | NUMC (2) | |
| SWP_AUSTALIA | Discount Swap | TB_SWP_AUSTRAL | CHAR (1) | |
| SREPOCAT | Repo Category | TB_REPO_CAT | CHAR (1) | |
| RATE_TYPE_MARGIN | Rate Type for Variation Margin | TPM_RATE_TYPE_MARGIN | TW56 | CHAR (2) |
| SFLAT | Indicator ‘Traded flat’,i.e.no accrued interest calculation | VVSFLAT | CHAR (1) | |
| ULTYP | Underlying Category | TB_ULTYP | NUMC (3) | |
| SECLEND_FIXED | Indicator: Fixed-Term/Open-Ended Securities Lending | TB_SECLEND_FIXED_TERM | INT1 (3) | |
| FACILITY_CAT | Facility Category | TB_FACILITY_CAT | CHAR (1) | |
| UTIL_FEE_CALC | Fee Calculation for a Syndicated Facility | TB_UTIL_FEE_CALC_CAT | CHAR (1) | |
| CALCTYP_SEFFMETH | Type of Effective Interest Calculation | TB_CALCTYP_SEFFMETH | CHAR (1) | |
| RATE_TYPE_OVM | Rate Type for Overnight Variation Margin | TPM_RATE_TYPE_OVERNIGHT_MARGIN | TW56 | CHAR (2) |
| FIR_EFLOWS_KEEP | Generate Zero Flows Based on Fixed Interest Rate | TB_FIR_EFLOWS_KEEP | CHAR (1) | |
| IDX_ON | Indicator: Index calculation can be used | TB_INDEX_ON | CHAR (1) | |
| IDX_PRORATA | Indicator regarding whether calculation is made pro rata | TB_PRORATA | CHAR (1) | |
| COMS_PRICING | Determines Price Determination for Commodity Swaps | FTR_COMS_PRICING | CHAR (1) | |
| CASH_FLOW_CALC | Cash Flow Calculation | TB_CASH_FLOW_CALC | CHAR (2) | |
| TF_CAT | Trade Finance Category | FTR_TF_CAT | CHAR (1) | |
| TERM_CAT | Term Category | TB_TERM_CAT | CHAR (1) |
