GSFINCSILD_CCLOG

Transparent Table Application Table
38 Fields 1 CDS Views

Cash Credit Card Interface Log

GSFINCSILD_CCLOG is an SAP database table in S/4HANA. Cash Credit Card Interface Log. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_IL_CrdtCardTransacLogRaw view_entity from BASIC IL Credit Card Transaction Log Raw Data

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reference_num gsfincsil_ref_num Reference Number
kunnr kunnr Customer
lifnr lifnr Supplier
hkont hkont G/L Acct
transacation_date datum Date
trn_user usnam User Name
time cputm Entered at
terminal_number gsfincsil_terminal_num Terminal Number
transaction_number gsfincsil_tran_num Transaction Number
status gsfincsil_trn_status Transaction Status
success_indicator gsfincsil_success_ind Success Indicator
cc_number gsfincsil_ccnum Credit card number
cc_brand gsfincsil_cc_brand Cr.Cd. Brand
cc_clearid gsfincsil_cc_clearid Clear.Cr.Cd
jparameter gsfincsil_parameter Parameter J
validity_date gsfincsil_valid_date validity Date (YYMM)
amount gsfincsil_amount Amount
cash_num gsfincsil_csnum Cash Number
club_points gsfincsil_star_amount Star Amount
transaction_type gsfincsil_trn_type Credit Type
currency currency Currency Key
deal_type gsfincsil_deal_type Deal Type
club_member gsfincsil_club_member Club membership Numb
acknowledge_by gsfincsil_acknow_by Acknowledge by
acknowledge_number gsfincsil_acknow_num Acknowledge Number
first_payment gsfincsil_first_mpt First Payment Amount
rest_payment gsfincsil_rest_mpt Rest Payment Amount
payments_number gsfincsil_pmt_num Number of Payments
file_number1 gsfincsil_file_num1 File Number 1
file_number2 gsfincsil_file_num2 File Number 2
file_number3 gsfincsil_file_num3 File Number 3
tourist gsfincsil_turist Tourist Credit Card
extension1 gsfincsil_extension1 Extension Field 1
extension2 gsfincsil_extension2 Extension Field 2
extension3 gsfincsil_extension3 Extension Field 3
extension4 gsfincsil_extension4 Extension Field 4
extension5 gsfincsil_extension5 Extension Field 5

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.

-- Cash Credit Card Interface Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSFINCSILD_CCLOG (
    MANDT,               -- Client [mandt]
    REFERENCE_NUM,       -- Reference Number [gsfincsil_ref_num]
    KUNNR,               -- Customer [kunnr]
    LIFNR,               -- Supplier [lifnr]
    HKONT,               -- G/L Acct [hkont]
    TRANSACATION_DATE,   -- Date [datum]
    TRN_USER,            -- User Name [usnam]
    TIME,                -- Entered at [cputm]
    TERMINAL_NUMBER,     -- Terminal Number [gsfincsil_terminal_num]
    TRANSACTION_NUMBER,  -- Transaction Number [gsfincsil_tran_num]
    STATUS,              -- Transaction Status [gsfincsil_trn_status]
    SUCCESS_INDICATOR,   -- Success Indicator [gsfincsil_success_ind]
    CC_NUMBER,           -- Credit card number [gsfincsil_ccnum]
    CC_BRAND,            -- Cr.Cd. Brand [gsfincsil_cc_brand]
    CC_CLEARID,          -- Clear.Cr.Cd [gsfincsil_cc_clearid]
    JPARAMETER,          -- Parameter J [gsfincsil_parameter]
    VALIDITY_DATE,       -- validity Date (YYMM) [gsfincsil_valid_date]
    AMOUNT,              -- Amount [gsfincsil_amount]
    CASH_NUM,            -- Cash Number [gsfincsil_csnum]
    CLUB_POINTS,         -- Star Amount [gsfincsil_star_amount]
    TRANSACTION_TYPE,    -- Credit Type [gsfincsil_trn_type]
    CURRENCY,            -- Currency Key [currency]
    DEAL_TYPE,           -- Deal Type [gsfincsil_deal_type]
    CLUB_MEMBER,         -- Club membership Numb [gsfincsil_club_member]
    ACKNOWLEDGE_BY,      -- Acknowledge by [gsfincsil_acknow_by]
    ACKNOWLEDGE_NUMBER,  -- Acknowledge Number [gsfincsil_acknow_num]
    FIRST_PAYMENT,       -- First Payment Amount [gsfincsil_first_mpt]
    REST_PAYMENT,        -- Rest Payment Amount [gsfincsil_rest_mpt]
    PAYMENTS_NUMBER,     -- Number of Payments [gsfincsil_pmt_num]
    FILE_NUMBER1,        -- File Number 1 [gsfincsil_file_num1]
    FILE_NUMBER2,        -- File Number 2 [gsfincsil_file_num2]
    FILE_NUMBER3,        -- File Number 3 [gsfincsil_file_num3]
    TOURIST,             -- Tourist Credit Card [gsfincsil_turist]
    EXTENSION1,          -- Extension Field 1 [gsfincsil_extension1]
    EXTENSION2,          -- Extension Field 2 [gsfincsil_extension2]
    EXTENSION3,          -- Extension Field 3 [gsfincsil_extension3]
    EXTENSION4,          -- Extension Field 4 [gsfincsil_extension4]
    EXTENSION5,          -- Extension Field 5 [gsfincsil_extension5]
    PRIMARY KEY (MANDT, REFERENCE_NUM)
);

Learn More