PTRV_CCC

Error Receipts for Credit Card Clearing | #transactional | Component: Travel Expenses
Column Name Description
MANDT Client
GENKEY Key for Table PTRV_CCC (Sequential Number)
Column Name Description
Column Name Description
Column Name Description
UMSDATUM Date of Credit Card Transaction
Column Name Description
LINETYPE Line Type in Credit Card File Show values
CARDFLAG Indicator: Employee Credit Card/ Corporate Credit Card Show values
SP_KATEG Credit Card Transaction Category Show values
S_H_FLAG Indicator Credit/Debit Credit Card Clearing Show values
REVERSE_CHARGE_T Reverse Charge Tax Indicator (X = Reverse Charge Tax) Show values
Column Name Description Domain name
PERNR Personnel Number PERNR
PNAME Name of Employee From Credit Card Clearing TEXT50
CARDNUM Credit Card Number TEXT19
UMS_ZEIT Time Of Credit Card Transaction PTRV_CCC_PURCHASE_TIME
SPESTEXT Transaction Key (Supplied by Credit Card Company) CEKEY
UMSBETRG Numerical Amount in Original Currency (Credit Card Clearing) NUM10
UMSNACHK Number of Decimal Places For Currency (Credit Card Clearing) NUM1
UMS_LAND Country Where Credit Card Transaction Took Place (ISO Code) INTCA3
UMS_MWST Value-Added Tax Rate (Amount) in Credit Card Clearing NUM5
UMS_KURS Numerical Exchange Rate (7 Dec. Places) in Credit Card File NUM11
UMS_HEIM Nummerical Amount in Accounting Currency (Credit Card Clear) NUM10
UMSGEBUR Nummerical Additional Charges Amount (Credit Card Clearing) NUM10
UMSTOTAL Numerical Total Amount (Credit Card Clearing) NUM10
ADDCOUNT No. of Additional Information Lines for Credit Card Trans. NUM2
TEXT_LANG Delivered Description of a Credit Card Transaction TEXT50
UMSDOKNR Document Number of Credit Card Receipt TEXT20
TRIPNO Trip Number REINR
DATE_IN Date in CHAR Format CHAR8
DATE_OUT Date in CHAR Format CHAR8
VERSION_NR Number of Credit Card Accounting Run CHAR10
E_DESCRIPTION Error Description for Credit Card Transaction TEXT132
CARDCOMP Code of Payment Card Company CCOMP
COMPCODE Company ID for Credit Card Clearing CHAR10
ABRNACHK Number of Decimal Places For Currency (Credit Card Clearing) NUM1
CARDNUM_GUID GUID of a Payment Card SYSUUID
IMAGE_LINK Contains the UUID for a Document on the Archive Server SYSUUID_C
REVERSE_CHARGE_C Country In Which Reverse Charge Tax Is Paid LNDGR
Master Data Relations Join Conditions
Currency Key
  • PTRV_CCC.MANDT == TCURC.MANDT
  • PTRV_CCC.UMSWAEHR == TCURC.WAERS