SAP Table BAPITRVCTC

Credit card transactions in buffer; Interface HR-CCC

BAPITRVCTC (Credit card transactions in buffer; Interface HR-CCC) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPITRVCTC to other SAP tables.

BAPITRVCTC table fields

Field Data element Checktable Datatype Length Decimals
PERNR Personnel Number PERNR_D NUMC 8 0
KATEG Credit Card Transaction Category PTRV_CCC_CATEGORY CHAR 1 0
A Accommodations
C Travel Costs, Car
M Meals
P Flight
T Rail Travel
R Car Rental
K Telephone, Communication
O Other
SPKZL Travel Expense Type SPKZL CHAR 4 0
BETRG Character Length 11 CHAR11 CHAR 11 0
WAERS Currency Key WAERS CUKY 5 0
BKURS Exchange Rate for Credit Card Transaction CRATE CHAR 10 0
MWSKZ Version Number Component CHAR2 CHAR 2 0
BDATU Receipt Date BELDT DATS 8 0
BZEIT Time UZEIT TIMS 6 0
BTEXT Short Receipt Information TXBEL CHAR 10 0
ANZFR Version Number Component CHAR2 CHAR 2 0
LNDFR Country of Receipt LNDFR CHAR 3 0
REGIO Trip Country/Trip Country Group/Trip Region RGION CHAR 5 0
C_DOC Document Number of Credit Card Receipt C_DOC CHAR 20 0
TODO Further Processing with Credit Card Transactions TODOF NUMC 2 0
10 Store Transaction in Document Pool
14 Ignore Transaction
20 Include Transaction in Trip, Status <= Trip Completed/Open
30 Include Transaction in Trip, Status <= Trip Compl/To Be Acct
40 Include Transaction in Trip, Status <= Trip Approved
50 Include Transaction in Request, Status <= Req. Recorded/Open
55 Include Transaction in Req., Status <= Recorded/To Be Acctd
60 Include Transaction in Request, Status <= Request Approved
70 Include Trans. in Req and Trip, Status Record. or Compl/Open
75 Include Trans. in Req and Trip, Status Rec. or Comp/ToBeAcct
80 Include Trans. in Req and Trip, Status Req or Trip Approved
CCOMP Code of Payment Card Company CCOMP CHAR 2 0
C_TXT Delivered Description of a Credit Card Transaction C_TXT CHAR 50 0
FRONT Single-Character Indicator CHAR1 CHAR 1 0
CCARD Credit Card Number C_NUM CHAR 19 0
CRUN Number of Credit Card Accounting Run PTRV_CCC_RUN CHAR 10 0
PAYOT Service Provider PAYOT CHAR 2 0
LOC_AMOUNT Receipt amount in local currency PTRV_LOC_AMOUNT CURR 13 2
LOC_CURR Accounting Currency in Credit Card File PTRV_CCC_ACC_CURKEY TCURC CUKY 5 0
CEKEY Transaction Key (Supplied by Credit Card Company) CEKEY CHAR 10 0
FIRMA Paid by Company BEZFA CHAR 1 0
X Yes
NULL No
GUID_CCC GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
CCARD_GUID GUID of a Payment Card CARD_GUID RAW 16 0
REVERSE_CHARGE_TAX Reverse Charge Tax Indicator (X = Reverse Charge Tax) REVERSE_CHARGE_TAX CHAR 1 0
X Yes
NULL No
REVERSE_CHARGE_COUNTRY Country In Which Reverse Charge Tax Is Paid REVERSE_CHARGE_COUNTRY CHAR 3 0
AIR_DEPARTURE IATA - Airport Location AIR_LOCATION CHAR 3 0
AIR_ARRIVAL IATA - Airport Location AIR_LOCATION CHAR 3 0
AIRLINE Airline AIRLINE CHAR 3 0
AIR_CABIN_CLASS Cabin Class AIR_CABIN_CLASS CHAR 1 0
S Supersonic
F First
B Business
E Economy
AIR_TICKET_NUMBER_OBSOLET Ticket Number TICKET_NUMBER NUMC 15 0
CAR_ODOMETER_READING Odometer Mileage CAR_ODOMETER_READING NUMC 8 0
SE_NAME Name 1 AD_NAME1 CHAR 40 0
SE_STREET Street AD_STREET CHAR 60 0
SE_CITY City AD_CITY1 CHAR 40 0
SE_STATE_PROVINCE District (US: County) SE_STATE_PROVINCE CHAR 40 0
SE_COUNTRY Country of Vendor SE_COUNTRY CHAR 3 0
SE_POSTAL_CODE City postal code AD_PSTCD1 CHAR 10 0
SE_CUSTOMER_SERVICE_PHONE Customer Service Telephone No. of Vendor SE_CUSTOMER_SERVICE_PHONE CHAR 30 0
IMAGE_LINK Contains the UUID for a Document on the Archive Server PTRA_IMAGE_LINK CHAR 32 0
FROM_CCC Credit Card Receipt PTRA_FROM_CCC CHAR 1 0
X Yes
NULL No
FROM_PLAN Planning Receipt PTRA_FROM_PLAN CHAR 1 0
X Yes
NULL No
FROM_MOBILE Receipt from Mobile Application PTRA_FROM_MOBILE CHAR 1 0
X Yes
NULL No
AIR_TICKET_NUMBER Ticket Number PTRV_TICKET_NUMBER CHAR 15 0
LFDNUM Number of Credit Card Accounting Run PTRV_CCC_RUN CHAR 10 0

BAPITRVCTC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPITRVCTC LOC_CURR SYST MANDT TCURC Currency Codes MANDT
BAPITRVCTC LOC_CURR BAPITRVCTC LOC_CURR TCURC Currency Codes WAERS