ATPA

Transparent Table Customizing Table
36 Fields 3 CDS Views

Treasury: Product Type Supplements

ATPA is an SAP database table in S/4HANA. Treasury: Product Type Supplements. It contains 36 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_FinInstrProdTypeSuplmnt view from BASIC Product Type Supplements
P_FXTransactionNominal view left_outer BASIC Nominal of a FX Transaction
TOE_CDS_TRM_DEALS view_entity left_outer cds view for deal nominals in TOENE

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sgsart vvsart Product Type
usgsart tb_usgsart Product Type
usfhaart tb_usfhaar Transactn Type
numkr numkr Number Range
unumber tb_unumber No. Underlyings
settlfl ti_settlfl Settlement
scapfloor ti_scapflo Cap/Floor
nottype ti_nottype Quotation type
sabrmet ti_sabrmet Sett.method
soptaus soptaus Exercise Type
opttyp tv_opttyp Option Category
jwswap ti_jwswap Currency Swap
bcurve tb_bcurve Bid
bcurveb tb_bcurveb Ask
rofnumkr ti_rofnumk No.Range M.Data
fra_australia tb_fra_austral Discount FRA
softyp ti_softyp Opt./fut. cat.
swp_austalia tb_swp_austral Discount Swap
srepocat tb_repo_cat Repo Category
rate_type_margin tpm_rate_type_margin RateTypeVM
sflat vvsflat Traded flat
ultyp tb_ultyp UL Category
seclend_fixed tb_seclend_fixed_term FixedTerm Lendg
facility_cat tb_facility_cat Facility Cat.
util_fee_calc tb_util_fee_calc_cat Fee Calc. Base
util_neg_used_pf_adj_cat tb_util_neg_used_pf_adj_cat NegUtilizedAmtAdjCat
calctyp_seffmeth tb_calctyp_seffmeth Calculatn Type
rate_type_ovm tpm_rate_type_overnight_margin RateTypeOVM
fir_eflows_keep tb_fir_eflows_keep Zero Flows
idx_on tb_index_on Index Calculation
idx_prorata tb_prorata Pro Rata
coms_pricing ftr_coms_pricing DCS Pricing
cash_flow_calc tb_cash_flow_calc CF Calculation
tf_cat ftr_tf_cat Trade Finance Cat.
term_cat tb_term_cat Term Category

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Treasury: Product Type Supplements
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATPA (
    MANDT,                     -- Client [mandt]
    SGSART,                    -- Product Type [vvsart]
    USGSART,                   -- Product Type [tb_usgsart]
    USFHAART,                  -- Transactn Type [tb_usfhaar]
    NUMKR,                     -- Number Range [numkr]
    UNUMBER,                   -- No. Underlyings [tb_unumber]
    SETTLFL,                   -- Settlement [ti_settlfl]
    SCAPFLOOR,                 -- Cap/Floor [ti_scapflo]
    NOTTYPE,                   -- Quotation type [ti_nottype]
    SABRMET,                   -- Sett.method [ti_sabrmet]
    SOPTAUS,                   -- Exercise Type [soptaus]
    OPTTYP,                    -- Option Category [tv_opttyp]
    JWSWAP,                    -- Currency Swap [ti_jwswap]
    BCURVE,                    -- Bid [tb_bcurve]
    BCURVEB,                   -- Ask [tb_bcurveb]
    ROFNUMKR,                  -- No.Range M.Data [ti_rofnumk]
    FRA_AUSTRALIA,             -- Discount FRA [tb_fra_austral]
    SOFTYP,                    -- Opt./fut. cat. [ti_softyp]
    SWP_AUSTALIA,              -- Discount Swap [tb_swp_austral]
    SREPOCAT,                  -- Repo Category [tb_repo_cat]
    RATE_TYPE_MARGIN,          -- RateTypeVM [tpm_rate_type_margin]
    SFLAT,                     -- Traded flat [vvsflat]
    ULTYP,                     -- UL Category [tb_ultyp]
    SECLEND_FIXED,             -- FixedTerm Lendg [tb_seclend_fixed_term]
    FACILITY_CAT,              -- Facility Cat. [tb_facility_cat]
    UTIL_FEE_CALC,             -- Fee Calc. Base [tb_util_fee_calc_cat]
    UTIL_NEG_USED_PF_ADJ_CAT,  -- NegUtilizedAmtAdjCat [tb_util_neg_used_pf_adj_cat]
    CALCTYP_SEFFMETH,          -- Calculatn Type [tb_calctyp_seffmeth]
    RATE_TYPE_OVM,             -- RateTypeOVM [tpm_rate_type_overnight_margin]
    FIR_EFLOWS_KEEP,           -- Zero Flows [tb_fir_eflows_keep]
    IDX_ON,                    -- Index Calculation [tb_index_on]
    IDX_PRORATA,               -- Pro Rata [tb_prorata]
    COMS_PRICING,              -- DCS Pricing [ftr_coms_pricing]
    CASH_FLOW_CALC,            -- CF Calculation [tb_cash_flow_calc]
    TF_CAT,                    -- Trade Finance Cat. [ftr_tf_cat]
    TERM_CAT,                  -- Term Category [tb_term_cat]
    PRIMARY KEY (MANDT, SGSART)
);

Learn More