TLCT_ACTIVITY

Transparent Table Application Table
81 Fields 2 CDS Views

Transaction Activity of Letter of Credit

TLCT_ACTIVITY is an SAP database table in S/4HANA. Transaction Activity of Letter of Credit. It contains 81 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FinTransActivity view left_outer BASIC Financial Transaction Activity
I_LetterOfCredit view from BASIC Letter of Credit

Fields (81)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY rfha tb_rfha Transaction
KEY rfhazu tb_rfhazu Activity
lc_number ftr_lc_number L/C Number
benficiary ftr_beneficiary Beneficiary
advising_bank ftr_advising_bank Advising Bank
issuing_bank ftr_issue_bank Issuing Bank
applicant ftr_applicant Applicant
general_cond ftr_gen_con Gen. Conditions
credit_amt ftr_credit_amt Credit Amount
cre_amt_cur ftr_cre_amt_cur Amt Currency
tolerance_pos ftr_pos_tol Pos. Tolerance
tolerance_neg ftr_nag_tol Neg. Tolerance
max_credit_amt ftr_max_cre_amt Max. Credit Amt
partial_ship ftr_partial_ship Partial Shipmt
pres_place ftr_pre_place Present. Place
deferred_days ftr_defer_days Deferred Days
ship_method ftr_ship_method Shipping Meth.
charge_place ftr_pos_charge Place of Deliv.
load_place ftr_load_loc Port of Loading
dest_place ftr_dis_loc Port of Dschrg.
final_dest ftr_fin_dest Plc. of Recpt
tranship_allow ftr_transship_allow Tranship.Allwd
charge_paid_by ftr_char_paid_by Charge Paid By
payment_at ftr_payment_at Draft At
note_flag ftr_notef Note Indicator
mol_type ftr_mol_type MoreOrLess Type
inco1 inco1 Incoterms
inco2 inco2 Incoterms 2
sfhazba tb_sfhazba Flow Type
man_benficiary ftr_man_ben_indicator ManlBeneficiary
man_advising_bank ftr_man_adv_indicator ManlAdvising Bk
man_applicant ftr_man_app_indicator Man. Applicant
man_issuing_bank ftr_man_iss_indicator Man.Issuing Bk
man_comp_name ftr_man_comp_name Manual Company Name
man_comp_addr ftr_man_comp_addr Manual Comp. Address
man_comp_fax ftr_ad_faxnmbr1 Fax
man_comp_cnt_per tb_gsppart Contact Person
man_comp_cnt_num ftr_xakt Contact Number
man_bank_name banka Bank Name
man_bank_addr ftr_man_bank_addr Manual Bank Address
man_bank_fax ftr_ad_faxnmbr1 Fax
man_bank_cnt_per tb_gsppart Contact Person
man_bank_cnt_num ftr_xakt Contact Number
man_bank_swift swift SWIFT/BIC
time_zone ad_tzone Time Zone
confirm_instr ftr_confirm_instr Confirm. Instr.
mol_term boolean Boolean Variable (X = True, - = False, Space = Unknown)
ship_per_from dlavo Term from
ship_per_to dlabi Term to
present_day ftr_present_day PresPeriod
present_per_con_id ftr_period_con_id Condition
nominated_bank ftr_nomi_bank_type Nominated Bank
payment_term ftr_cre_avail CreditAvailable
usance ftr_usance Usance
payment_per_con_id ftr_period_con_id Condition
confirming_bank ftr_confirm_bank Confirm. Bank
bg_number ftr_bg_number BG Number
bg_type ftr_bg_type BG Type
bg_form ftr_bg_form Guarantee Form
guaranteed_percent ftr_bg_percent BG percent
contract_number ftr_contract_num Un. Contr No.
contract_date ftr_contract_date Un. Contr Dte
contract_amount ftr_contract_amount Underl.ContrAmt
underlying_trans_id ftr_underlying_trans_id Und. Tra. ID
man_bp_flag ftr_man_bp_flag Man. BP Ind.
auto_ext_notice_days ftr_slc_ext_notice_days Nonext. Notice Days
auto_ext_period ftr_slc_ext_period Auto Ext. Period
auto_ext_period_type ftr_slc_ext_period_type Auto Ext. Perd Type
auto_ext_fin_expiry_date ftr_slc_ext_expiry_date Ext. Expiry Date
draw_mode ftr_slc_draw_mode Drawing Mode
man_bank_country banks Bank Ctry/Reg.
man_comp_country land1_gp Country/Region Key
man_bank_xblck ftr_man_bank_xblck Bank Data Blocked
man_comp_xblck ftr_man_comp_xblck Company Data Blocked
incov incov Inco. Version
man_bank_name_ext ftr_man_bank_name_ext Bank Name Extended
man_comp_name_ext ftr_man_comp_name_ext Man. Comp. Name Ext.
man_bank_addr_ext ftr_man_bank_addr_ext Man. Bank Addr. Ext.
man_comp_addr_ext ftr_man_comp_addr_ext Man. Comp.Addr. Ext.

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.

-- Transaction Activity of Letter of Credit
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TLCT_ACTIVITY (
    MANDT,                     -- Client [mandt]
    BUKRS,                     -- Company Code [bukrs]
    RFHA,                      -- Transaction [tb_rfha]
    RFHAZU,                    -- Activity [tb_rfhazu]
    LC_NUMBER,                 -- L/C Number [ftr_lc_number]
    BENFICIARY,                -- Beneficiary [ftr_beneficiary]
    ADVISING_BANK,             -- Advising Bank [ftr_advising_bank]
    ISSUING_BANK,              -- Issuing Bank [ftr_issue_bank]
    APPLICANT,                 -- Applicant [ftr_applicant]
    GENERAL_COND,              -- Gen. Conditions [ftr_gen_con]
    CREDIT_AMT,                -- Credit Amount [ftr_credit_amt]
    CRE_AMT_CUR,               -- Amt Currency [ftr_cre_amt_cur]
    TOLERANCE_POS,             -- Pos. Tolerance [ftr_pos_tol]
    TOLERANCE_NEG,             -- Neg. Tolerance [ftr_nag_tol]
    MAX_CREDIT_AMT,            -- Max. Credit Amt [ftr_max_cre_amt]
    PARTIAL_SHIP,              -- Partial Shipmt [ftr_partial_ship]
    PRES_PLACE,                -- Present. Place [ftr_pre_place]
    DEFERRED_DAYS,             -- Deferred Days [ftr_defer_days]
    SHIP_METHOD,               -- Shipping Meth. [ftr_ship_method]
    CHARGE_PLACE,              -- Place of Deliv. [ftr_pos_charge]
    LOAD_PLACE,                -- Port of Loading [ftr_load_loc]
    DEST_PLACE,                -- Port of Dschrg. [ftr_dis_loc]
    FINAL_DEST,                -- Plc. of Recpt [ftr_fin_dest]
    TRANSHIP_ALLOW,            -- Tranship.Allwd [ftr_transship_allow]
    CHARGE_PAID_BY,            -- Charge Paid By [ftr_char_paid_by]
    PAYMENT_AT,                -- Draft At [ftr_payment_at]
    NOTE_FLAG,                 -- Note Indicator [ftr_notef]
    MOL_TYPE,                  -- MoreOrLess Type [ftr_mol_type]
    INCO1,                     -- Incoterms [inco1]
    INCO2,                     -- Incoterms 2 [inco2]
    SFHAZBA,                   -- Flow Type [tb_sfhazba]
    MAN_BENFICIARY,            -- ManlBeneficiary [ftr_man_ben_indicator]
    MAN_ADVISING_BANK,         -- ManlAdvising Bk [ftr_man_adv_indicator]
    MAN_APPLICANT,             -- Man. Applicant [ftr_man_app_indicator]
    MAN_ISSUING_BANK,          -- Man.Issuing Bk [ftr_man_iss_indicator]
    MAN_COMP_NAME,             -- Manual Company Name [ftr_man_comp_name]
    MAN_COMP_ADDR,             -- Manual Comp. Address [ftr_man_comp_addr]
    MAN_COMP_FAX,              -- Fax [ftr_ad_faxnmbr1]
    MAN_COMP_CNT_PER,          -- Contact Person [tb_gsppart]
    MAN_COMP_CNT_NUM,          -- Contact Number [ftr_xakt]
    MAN_BANK_NAME,             -- Bank Name [banka]
    MAN_BANK_ADDR,             -- Manual Bank Address [ftr_man_bank_addr]
    MAN_BANK_FAX,              -- Fax [ftr_ad_faxnmbr1]
    MAN_BANK_CNT_PER,          -- Contact Person [tb_gsppart]
    MAN_BANK_CNT_NUM,          -- Contact Number [ftr_xakt]
    MAN_BANK_SWIFT,            -- SWIFT/BIC [swift]
    TIME_ZONE,                 -- Time Zone [ad_tzone]
    CONFIRM_INSTR,             -- Confirm. Instr. [ftr_confirm_instr]
    MOL_TERM,                  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    SHIP_PER_FROM,             -- Term from [dlavo]
    SHIP_PER_TO,               -- Term to [dlabi]
    PRESENT_DAY,               -- PresPeriod [ftr_present_day]
    PRESENT_PER_CON_ID,        -- Condition [ftr_period_con_id]
    NOMINATED_BANK,            -- Nominated Bank [ftr_nomi_bank_type]
    PAYMENT_TERM,              -- CreditAvailable [ftr_cre_avail]
    USANCE,                    -- Usance [ftr_usance]
    PAYMENT_PER_CON_ID,        -- Condition [ftr_period_con_id]
    CONFIRMING_BANK,           -- Confirm. Bank [ftr_confirm_bank]
    BG_NUMBER,                 -- BG Number [ftr_bg_number]
    BG_TYPE,                   -- BG Type [ftr_bg_type]
    BG_FORM,                   -- Guarantee Form [ftr_bg_form]
    GUARANTEED_PERCENT,        -- BG percent [ftr_bg_percent]
    CONTRACT_NUMBER,           -- Un. Contr No. [ftr_contract_num]
    CONTRACT_DATE,             -- Un. Contr Dte [ftr_contract_date]
    CONTRACT_AMOUNT,           -- Underl.ContrAmt [ftr_contract_amount]
    UNDERLYING_TRANS_ID,       -- Und. Tra. ID [ftr_underlying_trans_id]
    MAN_BP_FLAG,               -- Man. BP Ind. [ftr_man_bp_flag]
    AUTO_EXT_NOTICE_DAYS,      -- Nonext. Notice Days [ftr_slc_ext_notice_days]
    AUTO_EXT_PERIOD,           -- Auto Ext. Period [ftr_slc_ext_period]
    AUTO_EXT_PERIOD_TYPE,      -- Auto Ext. Perd Type [ftr_slc_ext_period_type]
    AUTO_EXT_FIN_EXPIRY_DATE,  -- Ext. Expiry Date [ftr_slc_ext_expiry_date]
    DRAW_MODE,                 -- Drawing Mode [ftr_slc_draw_mode]
    MAN_BANK_COUNTRY,          -- Bank Ctry/Reg. [banks]
    MAN_COMP_COUNTRY,          -- Country/Region Key [land1_gp]
    MAN_BANK_XBLCK,            -- Bank Data Blocked [ftr_man_bank_xblck]
    MAN_COMP_XBLCK,            -- Company Data Blocked [ftr_man_comp_xblck]
    INCOV,                     -- Inco. Version [incov]
    MAN_BANK_NAME_EXT,         -- Bank Name Extended [ftr_man_bank_name_ext]
    MAN_COMP_NAME_EXT,         -- Man. Comp. Name Ext. [ftr_man_comp_name_ext]
    MAN_BANK_ADDR_EXT,         -- Man. Bank Addr. Ext. [ftr_man_bank_addr_ext]
    MAN_COMP_ADDR_EXT,         -- Man. Comp.Addr. Ext. [ftr_man_comp_addr_ext]
    PRIMARY KEY (MANDT, BUKRS, RFHA, RFHAZU)
);

Learn More