PTRV_CCC SAP table for – Error Receipts for Credit Card Clearing

Here we would like to draw your attention to PTRV_CCC table in SAP. As we know it is being mainly used with the SAP FI-TV (Travel Management in FI) component which is coming under FI module (Financial Accounting). PTRV_CCC is a SAP standard transp table used for storing Error Receipts for Credit Card Clearing related data in SAP. It comes under the package PTRA.

SAP PTRV_CCC table

Table PTRV_CCC technical data

TablePTRV_CCC
Data storingError Receipts for Credit Card Clearing
ModuleFI
Sub ModuleFI-TV-COS
SAP PackagePTRA
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP PTRV_CCC Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in PTRV_CCC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GENKEY : Key for Table PTRV_CCC (Sequential Number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • .INCLUDE : Main Structure for Travel Credit Card Clearing
  • LINETYPE : Line Type in Credit Card File
    Its data type is CHAR (Character String) with field length 1
  • PERNR : Personnel Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PNAME : Name of Employee From Credit Card Clearing
    Its data type is CHAR (Character String) with field length 50
  • CARDNUM : Credit Card Number
    Its data type is CHAR (Character String) with field length 19
  • CARDFLAG : Indicator: Employee Credit Card/ Corporate Credit Card
    Its data type is CHAR (Character String) with field length 1
  • UMSDATUM : Date of Credit Card Transaction
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UMS_ZEIT : Time Of Credit Card Transaction
    Its data type is CHAR (Character String) with field length 6
  • SP_KATEG : Credit Card Transaction Category
    Its data type is CHAR (Character String) with field length 1
  • SPESTEXT : Transaction Key (Supplied by Credit Card Company)
    Its data type is CHAR (Character String) with field length 10
  • S_H_FLAG : Indicator Credit/Debit Credit Card Clearing
    Its data type is CHAR (Character String) with field length 1
  • UMSBETRG : Numerical Amount in Original Currency (Credit Card Clearing)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • UMSNACHK : Number of Decimal Places For Currency (Credit Card Clearing)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • UMSWAEHR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • UMS_LAND : Country Where Credit Card Transaction Took Place (ISO Code)
    Its data type is CHAR (Character String) with field length 3
  • UMS_MWST : Value-Added Tax Rate (Amount) in Credit Card Clearing
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • UMS_KURS : Numerical Exchange Rate (7 Dec. Places) in Credit Card File
    Its data type is NUMC (Character String with Digits Only) with field length 11
  • UMS_HEIM : Nummerical Amount in Accounting Currency (Credit Card Clear)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • UMSGEBUR : Nummerical Additional Charges Amount (Credit Card Clearing)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • UMSTOTAL : Numerical Total Amount (Credit Card Clearing)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ADDCOUNT : No. of Additional Information Lines for Credit Card Trans.
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TEXT_LANG : Delivered Description of a Credit Card Transaction
    Its data type is CHAR (Character String) with field length 50
  • UMSDOKNR : Document Number of Credit Card Receipt
    Its data type is CHAR (Character String) with field length 20
  • TRIPNO : Trip Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • DATE_IN : Date in CHAR Format
    Its data type is CHAR (Character String) with field length 8
  • DATE_OUT : Date in CHAR Format
    Its data type is CHAR (Character String) with field length 8
  • VERSION_NR : Number of Credit Card Accounting Run
    Its data type is CHAR (Character String) with field length 10
  • E_DESCRIPTION : Error Description for Credit Card Transaction
    Its data type is CHAR (Character String) with field length 132
  • CARDCOMP : Code of Payment Card Company
    Its data type is CHAR (Character String) with field length 2
  • COMPCODE : Company ID for Credit Card Clearing
    Its data type is CHAR (Character String) with field length 10
  • ABRWAEHR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ABRNACHK : Number of Decimal Places For Currency (Credit Card Clearing)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CARDNUM_GUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • IMAGE_LINK : Contains the UUID of a Document on the Archive Server
    Its data type is CHAR (Character String) with field length 32
  • REVERSE_CHARGE_T : Indicator for Reverse Charge Tax (X = Reverse Charge Tax)
    Its data type is CHAR (Character String) with field length 1
  • REVERSE_CHARGE_C : Country in Which Reverse Charge Tax Is to Be Paid
    Its data type is CHAR (Character String) with field length 3