BSEGC

Transparent Table Application Table
48 Fields 6 CDS Views

Document: Data on Payment Card Payments

BSEGC is an SAP database table in S/4HANA. Document: Data on Payment Card Payments. It contains 48 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FOP_AUTH_CANCEL view from
FOP_SETTLEDCHARGES view from
FOP_SETTLEDREFUNDS view from
FOP_UNSETTLEDREFUNDS view from
I_AcctgDocPaymentCardData view from BASIC AcctgDoc: Data on Payment Card Payments
P_PaymentCardRefundable view_entity from COMPOSITE

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
KEY rfzei RFZEI_CC Payt Card Item
ccins CCINS Card type
ccnum CCNUM Card number
ccfol CCFOL Suffix
datab DATAB_CC Valid from
datbi DATBI_CC Exp.date
ccname CCNAME Cardholder
csour CSOUR Entry mode
autwr AUTWR Authorized Amt
ccwae WAERS Currency
settl SETTL Settled
aunum AUNUM Auth. Number
autra AUTRA Auth. Ref. Code
audat AUDAT_CC Auth. Date
autim AUTIM Auth. Time
merch MERCH Merchant ID
locid LOCID_CC PointOfReceipt
trmid TRMID Terminal
ccbtc CCBTC Settlement
cctyp CCTYP Card Category
ccard_guid CCARDEC_GUID Reference to Encrypted Payment Card Data
payment_amount WRBTR Amount
dp_token DP_TOKEN Token
dp_psp DP_PAYMENT_SERVICE_PROVIDER Paymnt Serv. Provid.
dp_payid DP_PAYID Payment ID
dp_psp_transid DP_PSP_TRANS_ID PSP Transaction ID
dp_trans_id DP_TRANSID Transaction/Payt ID
dp_merchant_alias DP_MERCHANT_ALIAS Merchant Alias
dp_auth_rel_id FAR_DP_AUTH_REL_ID Auth. Rel. ID
dp_fraud_risk DP_FRAUD_RISK_CODE Fraud Risk Code
dp_charge_trans_id DP_TRANSID Transaction/Payt ID
setra SETRA_CC Reference No.
rcavr RCAVR_CC Address Result
rcava RCAVA_CC Address Check
rcavz RCAVZ_CC ZIP Code Check
rcrsp RCRSP_CC Card check
rtext RTEXT_CC Text
react REACT_CC Response
kunnr KUNNR Customer
opbel OPBEL_CC Reopen
dp_advref DP_ADVICE_REFERENCE DP Adv.Ref.
_dataaging DATA_TEMPERATURE Data Aging
dp_rtext_long DP_RTEXT_LONG Text
dp_l2l3_sent DP_L2L3_SENT L2/L3 data sent

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.

-- Document: Data on Payment Card Payments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSEGC (
    MANDT,               -- Client [MANDT]
    BUKRS,               -- Company Code [BUKRS]
    BELNR,               -- Document Number [BELNR_D]
    GJAHR,               -- Fiscal Year [GJAHR]
    RFZEI,               -- Payt Card Item [RFZEI_CC]
    CCINS,               -- Card type [CCINS]
    CCNUM,               -- Card number [CCNUM]
    CCFOL,               -- Suffix [CCFOL]
    DATAB,               -- Valid from [DATAB_CC]
    DATBI,               -- Exp.date [DATBI_CC]
    CCNAME,              -- Cardholder [CCNAME]
    CSOUR,               -- Entry mode [CSOUR]
    AUTWR,               -- Authorized Amt [AUTWR]
    CCWAE,               -- Currency [WAERS]
    SETTL,               -- Settled [SETTL]
    AUNUM,               -- Auth. Number [AUNUM]
    AUTRA,               -- Auth. Ref. Code [AUTRA]
    AUDAT,               -- Auth. Date [AUDAT_CC]
    AUTIM,               -- Auth. Time [AUTIM]
    MERCH,               -- Merchant ID [MERCH]
    LOCID,               -- PointOfReceipt [LOCID_CC]
    TRMID,               -- Terminal [TRMID]
    CCBTC,               -- Settlement [CCBTC]
    CCTYP,               -- Card Category [CCTYP]
    CCARD_GUID,          -- Reference to Encrypted Payment Card Data [CCARDEC_GUID]
    PAYMENT_AMOUNT,      -- Amount [WRBTR]
    DP_TOKEN,            -- Token [DP_TOKEN]
    DP_PSP,              -- Paymnt Serv. Provid. [DP_PAYMENT_SERVICE_PROVIDER]
    DP_PAYID,            -- Payment ID [DP_PAYID]
    DP_PSP_TRANSID,      -- PSP Transaction ID [DP_PSP_TRANS_ID]
    DP_TRANS_ID,         -- Transaction/Payt ID [DP_TRANSID]
    DP_MERCHANT_ALIAS,   -- Merchant Alias [DP_MERCHANT_ALIAS]
    DP_AUTH_REL_ID,      -- Auth. Rel. ID [FAR_DP_AUTH_REL_ID]
    DP_FRAUD_RISK,       -- Fraud Risk Code [DP_FRAUD_RISK_CODE]
    DP_CHARGE_TRANS_ID,  -- Transaction/Payt ID [DP_TRANSID]
    SETRA,               -- Reference No. [SETRA_CC]
    RCAVR,               -- Address Result [RCAVR_CC]
    RCAVA,               -- Address Check [RCAVA_CC]
    RCAVZ,               -- ZIP Code Check [RCAVZ_CC]
    RCRSP,               -- Card check [RCRSP_CC]
    RTEXT,               -- Text [RTEXT_CC]
    REACT,               -- Response [REACT_CC]
    KUNNR,               -- Customer [KUNNR]
    OPBEL,               -- Reopen [OPBEL_CC]
    DP_ADVREF,           -- DP Adv.Ref. [DP_ADVICE_REFERENCE]
    _DATAAGING,          -- Data Aging [DATA_TEMPERATURE]
    DP_RTEXT_LONG,       -- Text [DP_RTEXT_LONG]
    DP_L2L3_SENT,        -- L2/L3 data sent [DP_L2L3_SENT]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, RFZEI)
);

Learn More