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