CRFILESTAT SAP (Payment Card File: Status Information for Individual Records) Table details

Dictionary Type: Table
Description: Payment Card File: Status Information for Individual Records




ABAP Code to SELECT data from CRFILESTAT
Related tables to CRFILESTAT
Access table CRFILESTAT




Table field list including key, data, relationships and ABAP select examples

CRFILESTAT is a standard SAP Table which is used to store Payment Card File: Status Information for Individual Records data and is available within R/3 SAP systems depending on the version and release level.

The CRFILESTAT table consists of various fields, each holding specific information or linking keys about Payment Card File: Status Information for Individual Records data available in SAP. These include CRYEAR (Year of Issue of Payment Card File), CRPERIOD (Fiscal Month of Payment Card File), CCINS (Payment cards: Card type), CRFILENO (Payment Cards: Payment Card File Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRFILESTAT table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
CRYEARYear of Issue of Payment Card File CRYEARNUMC4GJAHRGJAHRGJR
CRPERIODFiscal Month of Payment Card File CRPERIODNUMC2MONAT
CCINSPayment cards: Card type CCINS_30FCHAR4Assigned to domainCCINS_30FCIN
CRFILENOPayment Cards: Payment Card File Number CRFILENONUMC5NUM05
CRRECNOPayment Cards: Number of Data Records CRRECNONUMC10NUMC10
DATUMDate DATUMDATS8DATUM
UZEITTime UZEITTIMS6UZEIT
UNAMEUser Name UNAMECHAR12UNAME
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BSTATDocument Status BSTAT_DCHAR1BSTAT
CCNUMPayment cards: Card number CCNUM_30FCHAR25CCNUM_30FCNO
CRCLASSPayment Cards: Main Card CRCLASSCHAR1CRCLASS
KBLNRDocument Number: Card Document KBLNR_PCCHAR10Assigned to domainALPHAKBLNRKBL
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
TRDATPayment Cards: Transaction Date CRTRDATDATS8DATUM
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
TRHWBTPayment Cards: Local Currency Amount of Transaction CRTRHWBTCURR15(2) WERT8
FWAERForeign Currency FWAER_CURDCUKY5Assigned to domainWAERSFWS
TRFWBTPayment Cards: Transaction Foreign Currency Amount CRTRFWBTCURR15(2) WERT8
CRDSCODEPayment Cards: Selection Code CRDSCODECHAR20Assigned to domainCRDSCODECSC
ZEILELine number MSGZEILECHAR22CHAR22
MSGTYMessage type (E, I, W, ...) MSGTY_COCHAR1MSGTY_CO
TEXTMessage Text NATXTCHAR73NATXT
ARBGBApplication Area ARBGBCHAR20Assigned to domainARBGBMAG
TXTNRMessage number MSGNRCHAR3Assigned to domainMSGNR
MSGV1Message Variable SYMSGVCHAR50SYCHAR50
MSGV2Message Variable SYMSGVCHAR50SYCHAR50
MSGV3Message Variable SYMSGVCHAR50SYCHAR50
MSGV4Message Variable SYMSGVCHAR50SYCHAR50
LANGULanguage Key SYLANGULANG1ISOLASYLANGU

Key field Non-key field



How do I retrieve data from SAP table CRFILESTAT using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRFILESTAT to SELECT all data from the table
DATA: WA_CRFILESTAT TYPE CRFILESTAT.

SELECT SINGLE *
FROM CRFILESTAT
INTO CORRESPONDING FIELDS OF WA_CRFILESTAT
WHERE...

How to access SAP table CRFILESTAT

Within an ECC or HANA version of SAP you can also view further information about CRFILESTAT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!