ATPA SAP (Treasury: Product Type Supplements) Table details

Dictionary Type: Table
Description: Treasury: Product Type Supplements




ABAP Code to SELECT data from ATPA
Related tables to ATPA
Access table ATPA




Table field list including key, data, relationships and ABAP select examples

ATPA is a standard SAP Table which is used to store Treasury: Product Type Supplements data and is available within R/3 SAP systems depending on the version and release level.

The ATPA table consists of various fields, each holding specific information or linking keys about Treasury: Product Type Supplements data available in SAP. These include SGSART (Product Type), USGSART (Product type of underlying), USFHAART (Transaction Type of Underlying), NUMKR (Number range).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ATPA table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
USGSARTProduct type of underlying TB_USGSARTCHAR3TZPAVVSART
USFHAARTTransaction Type of Underlying TB_USFHAARCHAR3AT10T_SFHAART
NUMKRNumber range NUMKRCHAR2CHAR2
UNUMBERNumber of underlyings TB_UNUMBERDEC4T_UNUMBER
SETTLFLSettlement indicator TI_SETTLFLCHAR1T_SETTLFL
SCAPFLOORCap/Floor indicator TI_SCAPFLONUMC1T_SCAPFLO
NOTTYPEQuotation type option/future TI_NOTTYPECHAR1T_NOTTYPE
SABRMETSettlement Method Option TI_SABRMETCHAR1T_SABRMET
SOPTAUSExercise Type (American or European) SOPTAUSNUMC1SOPTAUS
OPTTYPOriginal option category (on closing) TV_OPTTYPNUMC3ATO1T_OPTTYP
JWSWAPIndicator: Currency swap TI_JWSWAPCHAR1XFELD
BCURVEBid valuation curve type for mark-to-market TB_BCURVENUMC4Assigned to domainJBSZKART
BCURVEBAsk Valuation Curve: Mark-to-Market TB_BCURVEBNUMC4Assigned to domainJBSZKART
ROFNUMKRNumber range master data - traded options and futures TI_ROFNUMKCHAR2CHAR2
FRA_AUSTRALIADiscount FRA TB_FRA_AUSTRALCHAR1XFELD
SOFTYPOptions/futures category TI_SOFTYPNUMC2T_SOFTYP
SWP_AUSTALIADiscount Swap TB_SWP_AUSTRALCHAR1XFELD
SREPOCATRepo Category TB_REPO_CATCHAR1T_REPO_CAT
RATE_TYPE_MARGINRate Type for Variation Margin TPM_RATE_TYPE_MARGINCHAR2TW56VVSKURSARTRATETYPE_F4
SFLATIndicator 'Traded flat',i.e.no accrued interest calculation VVSFLATCHAR1XFELD
ULTYPUnderlying Category TB_ULTYPNUMC3T_ULTYP
SECLEND_FIXEDIndicator: Fixed-Term/Open-Ended Securities Lending TB_SECLEND_FIXED_TERMINT13T_SECLEND_FIXED_TERM
FACILITY_CATFacility Category TB_FACILITY_CATCHAR1T_FACILITY_CAT
UTIL_FEE_CALCFee Calculation for a Syndicated Facility TB_UTIL_FEE_CALC_CATCHAR1TB_UTIL_FEE_CALC_CAT
CALCTYP_SEFFMETHType of Effective Interest Calculation TB_CALCTYP_SEFFMETHCHAR1T_CALCTYP_SEFFMETH
RATE_TYPE_OVMRate Type for Overnight Variation Margin TPM_RATE_TYPE_OVERNIGHT_MARGINCHAR2TW56VVSKURSARTRATETYPE_F4
FIR_EFLOWS_KEEPGenerate Zero Flows Based on Fixed Interest Rate TB_FIR_EFLOWS_KEEPCHAR1XFELD
IDX_ONIndicator: Index calculation can be used TB_INDEX_ONCHAR1TB_INDEX_ON
IDX_PRORATAIndicator as to whether calculation should be made pro rata TB_PRORATACHAR1TB_PRORATA
COMS_PRICINGDetermines Price Determination for Commodity Swaps FTR_COMS_PRICINGCHAR1FTR_COMS_PRICING

Key field Non-key field



How do I retrieve data from SAP table ATPA using ABAP code

The following ABAP code Example will allow you to do a basic selection on ATPA to SELECT all data from the table
DATA: WA_ATPA TYPE ATPA.

SELECT SINGLE *
FROM ATPA
INTO CORRESPONDING FIELDS OF WA_ATPA
WHERE...

How to access SAP table ATPA

Within an ECC or HANA version of SAP you can also view further information about ATPA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!