SAP table BSEGC (Document: Data on Payment Card Payments)

SAP table BSEGC has 5 primary key fields being MANDT,BUKRS,BELNR,GJAHR,RFZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
RFZEI Payment Card Item NUMC 3 0 RFZEI_CC
CCINS Payment cards: Card type CHAR 4 0 TVCIN CCINS
CCNUM Payment cards: Card number CHAR 25 0 * CCNUM
CCFOL Payment cards: Payment card suffix CHAR 10 0 CCFOL
DATAB Payment cards: Valid from DATS 8 0 DATAB_CC
DATBI Payment Cards: Valid To DATS 8 0 DATBI_CC
CCNAME Payment cards: Name of cardholder CHAR 40 0 CCNAME
CSOUR Payment cards: Entry mode CHAR 1 0 CSOUR
Manual input
A Card reader
AUTWR Payment cards: Authorized amount CURR 15 2 AUTWR
CCWAE Currency Key CUKY 5 0 TCURC WAERS
SETTL Payment cards: Settlement carried out CHAR 1 0 SETTL
AUNUM Payment cards: Authorization number CHAR 10 0 AUNUM
AUTRA Payment cards: Authorizat. reference code of clearing house CHAR 15 0 AUTRA
AUDAT Payment cards: Authorization date DATS 8 0 AUDAT_CC
AUTIM Payment cards: Authorization time TIMS 6 0 AUTIM
MERCH Payment cards: Merchant ID at the clearing house CHAR 15 0 TCCM MERCH
LOCID Payment cards: Point of receipt for the transaction CHAR 10 0 TCCL LOCID_CC
TRMID Payment cards: Terminal CHAR 10 0 TRMID
CCBTC Payment cards: Settlement run CHAR 10 0 CCBTC
CCTYP Payment cards: Card category CHAR 2 0 TVCTY CCTYP
CCARD_GUID Reference to Encrypted Payment Card Data CHAR 32 0 CCARDEC_GUID
PAYMENT_AMOUNT Amount in document currency CURR 23 2 WRBTR
DP_TOKEN Token for Digital Payment Integration in SD CHAR 25 0 * DP_TOKEN
DP_PSP Payment Service Provider for Digital Payments CHAR 4 0 DP_PAYMENT_SERVICE_PROVIDER
DP_PAYID Digital Payments: Payment ID from Payment Service Provider CHAR 40 0 DP_PAYID
DP_PSP_TRANSID SAP Digital Payments: Transaction ID of PSP CHAR 40 0 DP_PSP_TRANS_ID
DP_TRANS_ID Transaction/Payment ID of SAP Digital Payments CHAR 44 0 DP_TRANSID
DP_MERCHANT_ALIAS SAP Digital Payments Add-On: Merchant Alias CHAR 15 0 DP_MERCHANT_ALIAS
DP_AUTH_REL_ID Unique identifier of a previous successful authorization CHAR 44 0 FAR_DP_AUTH_REL_ID
DP_FRAUD_RISK Code of Fraud Risk CHAR 15 0 DP_FRAUD_RISK_CODE
SETRA Payment Cards: Settlement Reference No. of Clearing House CHAR 15 0 SETRA_CC
RCAVR Payment Cards: Result of Address Check (Address Result) CHAR 4 0 TCCRC RCAVR_CC
RCAVA Payment Cards: Result of Address Check (Address Approval) CHAR 4 0 TCCRC RCAVA_CC
RCAVZ Payment Cards: Result of Address Check (ZIP Code Result) CHAR 4 0 TCCRC RCAVZ_CC
RCRSP Payment cards: Result of card check (response code) CHAR 4 0 TCCRC RCRSP_CC
RTEXT Payment cards: Result text CHAR 40 0 RTEXT_CC
REACT Payment Cards: Response to Settlement Result CHAR 1 0 REACT_CC
Everything OK
A Line item rejected, debit customer
L Line item rejected, further attempts (try later)
KUNNR Customer Number CHAR 10 0 KUNNR
OPBEL Payment Cards: Document Number of Reopened Receivable CHAR 10 0 OPBEL_CC
DP_ADVREF Digital Payments Advice Reference CHAR 50 0 DP_ADVICE_REFERENCE
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DP_RTEXT_LONG Payment Cards: Detailed result text CHAR 255 0 DP_RTEXT_LONG
DP_L2L3_SENT Indicator: L2/L3 payment card data were transmitted CHAR 1 0 DP_L2L3_SENT

BSEGC foreign key relationships

Table Field Check Table Check Field
0 BSEGC BUKRS T001 Company Codes BUKRS
1 BSEGC CCINS TVCIN Payment cards: Type MANDT
1 BSEGC CCINS TVCIN Payment cards: Type CCINS
0 BSEGC CCTYP TVCTY Payment card category MANDT
0 BSEGC CCTYP TVCTY Payment card category CCTYP
1 BSEGC CCWAE TCURC Currency Codes WAERS
0 BSEGC LOCID TCCL Payment cards: Point of receipt for the transaction MANDT
0 BSEGC LOCID TCCL Payment cards: Point of receipt for the transaction LOCID
1 BSEGC MANDT T000 Clients MANDT
0 BSEGC MERCH TCCM Payment cards: Merchant ID MANDT
1 BSEGC RCAVA TCCRC Payment Cards: Check Results MANDT
1 BSEGC RCAVA TCCRC Payment Cards: Check Results RCATG
1 BSEGC RCAVA TCCRC Payment Cards: Check Results RCODE
0 BSEGC RCAVR TCCRC Payment Cards: Check Results MANDT
0 BSEGC RCAVR TCCRC Payment Cards: Check Results RCATG
0 BSEGC RCAVR TCCRC Payment Cards: Check Results RCODE
1 BSEGC RCAVZ TCCRC Payment Cards: Check Results MANDT
1 BSEGC RCAVZ TCCRC Payment Cards: Check Results RCATG
1 BSEGC RCAVZ TCCRC Payment Cards: Check Results RCODE
0 BSEGC RCRSP TCCRC Payment Cards: Check Results MANDT
0 BSEGC RCRSP TCCRC Payment Cards: Check Results RCATG
0 BSEGC RCRSP TCCRC Payment Cards: Check Results RCODE