The CRFILEPOS table in SAP ERP or S/4HANA stores Payment Card File: Individual Records data. There are total 29 fields in CRFILEPOS table. The Payment Card File: Individual Records table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRFILEPOS table. It is in Payment Card (FCRD) ABAP package and is part of the Payment Progam / Payment transfer (DE, JP, US) (FI-AP-AP-B) module.
SAP CRFILEPOS Table Fields
Following is the list of fields that are available in SAP CRFILEPOS table. The primary key fields of the table are MANDT (Client), 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), CRRECNO (Payment Cards: Number of Data Records).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| CRYEAR | Year of Issue of Payment Card File | CRYEAR | NUMC (4) | |
| CRPERIOD | Fiscal Month of Payment Card File | CRPERIOD | NUMC (2) | |
| CCINS | Payment cards: Card type | CCINS_30F | CHAR (4) | |
| CRFILENO | Payment Cards: Payment Card File Number | CRFILENO | NUMC (5) | |
| CRRECNO | Payment Cards: Number of Data Records | CRRECNO | NUMC (10) | |
| DATUM | Date | DATUM | DATS (8) | |
| UZEIT | Time | UZEIT | TIMS (6) | |
| UNAME | User Name | UNAME | CHAR (12) | |
| RECTYP | Payment Card File: Record Type | DND_RECTYP | CHAR (1) | |
| CCNUM | Payment cards: Card number | CCNUM_30F | CHAR (25) | |
| HWAER | Local Currency | HWAER | * | CUKY (5) |
| TRHWBT | Payment Cards: Local Currency Amount of Transaction | CRTRHWBT | CURR (23) | |
| TRHWSTE | Payment Cards: Tax Amount of Transaction in Local Currency | CRTRHWSTE | CURR (23) | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| BUDAT | Payment Cards: Posting Date | CRBUDAT | DATS (8) | |
| TRDAT | Payment Cards: Transaction Date | CRTRDAT | DATS (8) | |
| STDAT | Payment Cards: Settlement Date (Statement Date) | CRSTDAT | DATS (8) | |
| AUNUM | Payment Cards: Authorization Number | CRAUNUM | CHAR (15) | |
| FWAER | Foreign Currency | FWAER_CURD | * | CUKY (5) |
| TRFWBT | Payment Cards: Transaction Foreign Currency Amount | CRTRFWBT | CURR (23) | |
| TRFWSTE | Payment Cards: Tax Amount of Transaction | CRTRFWSTE | CURR (23) | |
| SUPNAM | Payment Cards: Name and Address of Vendor | CRSUPNAM | CHAR (60) | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| MERCAT | Payment Card Data File: Vendor Category | DND_MERCAT | CHAR (4) | |
| CRDSCODE | Payment Cards: Selection Code | CRDSCODE | * | CHAR (20) |
| XBLNR | Reference Document Number | XBLNR1 | CHAR (16) | |
| BKTXT | Document Header Text | BKTXT | CHAR (25) | |
| SGTXT | Item Text | SGTXT | CHAR (50) |
