ATPA is a standard SAP table in SAP ERP (or) S/4HANA which stores Treasury: Product Type Supplements data. There are total 35 fields in ATPA table.This blog post provides key technical details of SAP table ATPA, including its availability across SAP S/4HANA versions and the list of CDS views for ATPA table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Single entries of table were buffered |
| Package | R/3 appl. development for Treasury money,forex,forward gen (FTA) |
| Technical Component | Transaction Manager (FIN-FSCM-TRM-TM) |
SAP ATPA Table Fields
The following is the list of fields that are available in SAP ATPA table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| SGSART | Product Type | VVSART | VVSART | TZPA | CHAR (3) |
| USGSART | Product type of underlying | TB_USGSART | VVSART | TZPA | CHAR (3) |
| USFHAART | Transaction Type of Underlying | TB_USFHAAR | T_SFHAART | AT10 | CHAR (3) |
| NUMKR | Number range | NUMKR | CHAR2 | CHAR (2) | |
| UNUMBER | Number of Underlyings | TB_UNUMBER | T_UNUMBER | DEC (4) | |
| SETTLFL | Settlement Indicator | TI_SETTLFL | T_SETTLFL | CHAR (1) | |
| SCAPFLOOR | Cap/Floor Indicator | TI_SCAPFLO | T_SCAPFLO | NUMC (1) | |
| NOTTYPE | Quotation type option/future | TI_NOTTYPE | T_NOTTYPE | CHAR (1) | |
| SABRMET | Settlement Method Option | TI_SABRMET | T_SABRMET | CHAR (1) | |
| SOPTAUS | Exercise Type (American or European) | SOPTAUS | SOPTAUS | NUMC (1) | |
| OPTTYP | Original Option Category (on Closing) | TV_OPTTYP | T_OPTTYP | ATO1 | NUMC (3) |
| JWSWAP | Indicator: Currency Swap | TI_JWSWAP | XFELD | CHAR (1) | |
| BCURVE | Bid valuation curve type for mark-to-market | TB_BCURVE | JBSZKART | NUMC (4) | |
| BCURVEB | Ask Valuation Curve: Mark-to-Market | TB_BCURVEB | JBSZKART | NUMC (4) | |
| ROFNUMKR | Number Range Master Data – Listed Options and Futures | TI_ROFNUMK | CHAR2 | CHAR (2) | |
| FRA_AUSTRALIA | Discount FRA | TB_FRA_AUSTRAL | XFELD | CHAR (1) | |
| SOFTYP | Options/futures category | TI_SOFTYP | T_SOFTYP | NUMC (2) | |
| SWP_AUSTALIA | Discount Swap | TB_SWP_AUSTRAL | XFELD | CHAR (1) | |
| SREPOCAT | Repo Category | TB_REPO_CAT | T_REPO_CAT | CHAR (1) | |
| RATE_TYPE_MARGIN | Rate Type for Variation Margin | TPM_RATE_TYPE_MARGIN | VVSKURSART | TW56 | CHAR (2) |
| SFLAT | Indicator ‘Traded flat’,i.e.no accrued interest calculation | VVSFLAT | XFELD | CHAR (1) | |
| ULTYP | Underlying Category | TB_ULTYP | T_ULTYP | NUMC (3) | |
| SECLEND_FIXED | Indicator: Fixed-Term/Open-Ended Securities Lending | TB_SECLEND_FIXED_TERM | T_SECLEND_FIXED_TERM | INT1 (3) | |
| FACILITY_CAT | Facility Category | TB_FACILITY_CAT | T_FACILITY_CAT | CHAR (1) | |
| UTIL_FEE_CALC | Fee Calculation for a Syndicated Facility | TB_UTIL_FEE_CALC_CAT | TB_UTIL_FEE_CALC_CAT | CHAR (1) | |
| CALCTYP_SEFFMETH | Type of Effective Interest Calculation | TB_CALCTYP_SEFFMETH | T_CALCTYP_SEFFMETH | CHAR (1) | |
| RATE_TYPE_OVM | Rate Type for Overnight Variation Margin | TPM_RATE_TYPE_OVERNIGHT_MARGIN | VVSKURSART | TW56 | CHAR (2) |
| FIR_EFLOWS_KEEP | Generate Zero Flows Based on Fixed Interest Rate | TB_FIR_EFLOWS_KEEP | XFELD | CHAR (1) | |
| IDX_ON | Indicator: Index calculation can be used | TB_INDEX_ON | TB_INDEX_ON | CHAR (1) | |
| IDX_PRORATA | Indicator regarding whether calculation is made pro rata | TB_PRORATA | TB_PRORATA | CHAR (1) | |
| COMS_PRICING | Determines Price Determination for Commodity Swaps | FTR_COMS_PRICING | FTR_COMS_PRICING | CHAR (1) | |
| CASH_FLOW_CALC | Cash Flow Calculation | TB_CASH_FLOW_CALC | TB_CASH_FLOW_CALC | CHAR (2) | |
| TF_CAT | Trade Finance Category | FTR_TF_CAT | FTR_TF_CAT | CHAR (1) | |
| TERM_CAT | Term Category | TB_TERM_CAT | T_TERM_CAT | CHAR (1) |
Availability
The SAP table ATPA is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ATPA table
The following is the list of ATPA CDS views, which can also be used instead of ATPA table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| P_FXTRANSACTIONNOMINAL | BASIC | Nominal of a FX Transaction |
| I_FXFINTRANSACTIONNOMINAL | COMPOSITE | Nom of a FX Financial Transaction |
| C_FXFORWARDNOMINAL | CONSUMPTION | Nominal Of FX Forward Transactions |
| C_FXOPTIONNOMINAL | CONSUMPTION | Nominal of a FX Option |
| C_NONDELIVERABLEFWDNOMINAL | CONSUMPTION | Nominal of a Non-Deliverable Fwd Trans |
