PTRV_CCC SAP (Error Receipts for Credit Card Clearing) Table details
Dictionary Type: Table
Description: Error Receipts for Credit Card Clearing
Description: Error Receipts for Credit Card Clearing
Table field list including key, data, relationships and ABAP select examples
PTRV_CCC is a standard SAP Table which is used to store Error Receipts for Credit Card Clearing data and is available within R/3 SAP systems depending on the version and release level.
The PTRV_CCC table consists of various fields, each holding specific information or linking keys about Error Receipts for Credit Card Clearing data available in SAP. These include GENKEY (Key for Table PTRV_CCC (Sequential Number)), LINETYPE (Line Type in Credit Card File), PERNR (Personnel Number), PNAME (Name of Employee From Credit Card Clearing).. 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 PTRV_CCC 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
GENKEY | Key for Table PTRV_CCC (Sequential Number) | PTRV_CCC_GENKEY | NUMC | 8 | NUMC8 | ||||
LINETYPE | Line Type in Credit Card File | PTRV_CCC_LINETYPE | CHAR | 1 | PTRV_CCC_LINETYPE | ||||
PERNR | Personnel Number | P_PERNR | NUMC | 8 | PERNR | ||||
PNAME | Name of Employee From Credit Card Clearing | PTRV_CCC_NAME | CHAR | 50 | TEXT50 | ||||
CARDNUM | Credit Card Number | C_NUM | CHAR | 19 | TEXT19 | ||||
CARDFLAG | Indicator: Employee Credit Card/ Corporate Credit Card | PTRV_CCC_CARDFLAG | CHAR | 1 | PTRV_CCC_CARDFLAG | ||||
UMSDATUM | Date of Credit Card Transaction | PTRV_CCC_PURCHASE_DATE | DATS | 8 | DATUM | ||||
UMS_ZEIT | Time Of Credit Card Transaction | PTRV_CCC_PURCHASE_TIME | CHAR | 6 | PTRV_CCC_PURCHASE_TIME | ||||
SP_KATEG | Credit Card Transaction Category | PTRV_CCC_CATEGORY | CHAR | 1 | PTRV_CCC_CATEGORY | ||||
SPESTEXT | Transaction Key (Supplied by Credit Card Company) | CEKEY | CHAR | 10 | CEKEY | ||||
S_H_FLAG | Indicator Credit/Debit Credit Card Clearing | PTRV_CCC_DEBIT_CREDIT | CHAR | 1 | PTRV_CCC_DEBIT_CREDIT | ||||
UMSBETRG | Numerical Amount in Original Currency (Credit Card Clearing) | PTRV_CCC_ORG_AMOUNT | NUMC | 10 | NUM10 | ||||
UMSNACHK | Number of Decimal Places For Currency (Credit Card Clearing) | PTRV_CCC_DECIMALS | NUMC | 1 | NUM1 | ||||
UMSWAEHR | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
UMS_LAND | Country Where Credit Card Transaction Took Place (ISO Code) | PTRV_CCC_PURCHASE_COUNTRY | CHAR | 3 | INTCA3 | ||||
UMS_MWST | Value-Added Tax Rate (Amount) in Credit Card Clearing | ABRMWSTS | NUMC | 5 | NUM5 | ||||
UMS_KURS | Numerical Exchange Rate (7 Dec. Places) in Credit Card File | PTRV_CCC_EXCHANGE_RATE | NUMC | 11 | NUM11 | ||||
UMS_HEIM | Nummerical Amount in Accounting Currency (Credit Card Clear) | PTRV_CCC_ACC_AMOUNT | NUMC | 10 | NUM10 | ||||
UMSGEBUR | Nummerical Additional Charges Amount (Credit Card Clearing) | PTRV_CCC_ADD_CHARGE | NUMC | 10 | NUM10 | ||||
UMSTOTAL | Numerical Total Amount (Credit Card Clearing) | PTRV_CCC_TOTAL_AMOUNT | NUMC | 10 | NUM10 | ||||
ADDCOUNT | No. of Additional Information Lines for Credit Card Trans. | PTRV_CCC_ADD_COUNT | NUMC | 2 | NUM2 | ||||
TEXT_LANG | Delivered Description of a Credit Card Transaction | C_TXT | CHAR | 50 | TEXT50 | ||||
UMSDOKNR | Document Number of Credit Card Receipt | C_DOC | CHAR | 20 | TEXT20 | ||||
TRIPNO | Trip Number | REINR | NUMC | 10 | REINR | ||||
DATE_IN | Date in CHAR Format | PTRV_CCC_DATEC | CHAR | 8 | CHAR8 | ||||
DATE_OUT | Date in CHAR Format | PTRV_CCC_DATEC | CHAR | 8 | CHAR8 | ||||
VERSION_NR | Number of Credit Card Accounting Run | PTRV_CCC_RUN | CHAR | 10 | CHAR10 | ||||
E_DESCRIPTION | Error Description for Credit Card Transaction | PTRV_CCC_ERROR_TEXT | CHAR | 132 | TEXT132 | ||||
CARDCOMP | Code of Payment Card Company | CCOMP | CHAR | 2 | Assigned to domain | CCOMP | |||
COMPCODE | Company ID for Credit Card Clearing | COMPCODE | CHAR | 10 | CHAR10 | ||||
ABRWAEHR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
ABRNACHK | Number of Decimal Places For Currency (Credit Card Clearing) | PTRV_CCC_DECIMALS | NUMC | 1 | NUM1 | ||||
CARDNUM_GUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | SYSUUID | ||||
IMAGE_LINK | Contains the UUID for a Document on the Archive Server | PTRA_IMAGE_LINK | CHAR | 32 | SYSUUID_C | ||||
REVERSE_CHARGE_T | Reverse Charge Tax Indicator (X = Reverse Charge Tax) | REVERSE_CHARGE_TAX | CHAR | 1 | XFELD | ||||
REVERSE_CHARGE_C | Country In Which Reverse Charge Tax Is Paid | REVERSE_CHARGE_COUNTRY | CHAR | 3 | Assigned to domain | LNDGR |
Key field | Non-key field |
How do I retrieve data from SAP table PTRV_CCC using ABAP code
The following ABAP code Example will allow you to do a basic selection on PTRV_CCC to SELECT all data from the tableDATA: WA_PTRV_CCC TYPE PTRV_CCC.
SELECT SINGLE *
FROM PTRV_CCC
INTO CORRESPONDING FIELDS OF WA_PTRV_CCC
WHERE...
How to access SAP table PTRV_CCC
Within an ECC or HANA version of SAP you can also view further information about PTRV_CCC and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects