SAP ABAP Table PTRV_CCC (Error Receipts for Credit Card Clearing)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA (Package) Travel Expenses Application Dev. (R/3 Enterprise Core)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PTRV_CCC	Table Relationship Diagram
Short Description	Error Receipts for Credit Card Clearing

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GENKEY	☑	PTRV_CCC_GENKEY	NUMC8	NUMC	8	0	Key for Table PTRV_CCC (Sequential Number)
3	.INCLUDE	☐				0	0	Main Structure for Travel Credit Card Clearing
4	LINETYPE	☐	PTRV_CCC_LINETYPE	PTRV_CCC_LINETYPE	CHAR	1	0	Line Type in Credit Card File
5	PERNR	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
6	PNAME	☐	PTRV_CCC_NAME	TEXT50	CHAR	50	0	Name of Employee From Credit Card Clearing
7	CARDNUM	☐	C_NUM	TEXT19	CHAR	19	0	Credit Card Number
8	CARDFLAG	☐	PTRV_CCC_CARDFLAG	PTRV_CCC_CARDFLAG	CHAR	1	0	Indicator: Employee Credit Card/ Corporate Credit Card
9	UMSDATUM	☐	PTRV_CCC_PURCHASE_DATE	DATUM	DATS	8	0	Date of Credit Card Transaction
10	UMS_ZEIT	☐	PTRV_CCC_PURCHASE_TIME	PTRV_CCC_PURCHASE_TIME	CHAR	6	0	Time Of Credit Card Transaction
11	SP_KATEG	☐	PTRV_CCC_CATEGORY	PTRV_CCC_CATEGORY	CHAR	1	0	Credit Card Transaction Category
12	SPESTEXT	☐	CEKEY	CEKEY	CHAR	10	0	Transaction Key (Supplied by Credit Card Company)
13	S_H_FLAG	☐	PTRV_CCC_DEBIT_CREDIT	PTRV_CCC_DEBIT_CREDIT	CHAR	1	0	Indicator Credit/Debit Credit Card Clearing
14	UMSBETRG	☐	PTRV_CCC_ORG_AMOUNT	NUM10	NUMC	10	0	Numerical Amount in Original Currency (Credit Card Clearing)
15	UMSNACHK	☐	PTRV_CCC_DECIMALS	NUM1	NUMC	1	0	Number of Decimal Places For Currency (Credit Card Clearing)
16	UMSWAEHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	UMS_LAND	☐	PTRV_CCC_PURCHASE_COUNTRY	INTCA3	CHAR	3	0	Country Where Credit Card Transaction Took Place (ISO Code)
18	UMS_MWST	☐	ABRMWSTS	NUM5	NUMC	5	0	Value-Added Tax Rate (Amount) in Credit Card Clearing
19	UMS_KURS	☐	PTRV_CCC_EXCHANGE_RATE	NUM11	NUMC	11	0	Numerical Exchange Rate (7 Dec. Places) in Credit Card File
20	UMS_HEIM	☐	PTRV_CCC_ACC_AMOUNT	NUM10	NUMC	10	0	Nummerical Amount in Accounting Currency (Credit Card Clear)
21	UMSGEBUR	☐	PTRV_CCC_ADD_CHARGE	NUM10	NUMC	10	0	Nummerical Additional Charges Amount (Credit Card Clearing)
22	UMSTOTAL	☐	PTRV_CCC_TOTAL_AMOUNT	NUM10	NUMC	10	0	Numerical Total Amount (Credit Card Clearing)
23	ADDCOUNT	☐	PTRV_CCC_ADD_COUNT	NUM2	NUMC	2	0	No. of Additional Information Lines for Credit Card Trans.
24	TEXT_LANG	☐	C_TXT	TEXT50	CHAR	50	0	Delivered Description of a Credit Card Transaction
25	UMSDOKNR	☐	C_DOC	TEXT20	CHAR	20	0	Document Number of Credit Card Receipt
26	TRIPNO	☐	REINR	REINR	NUMC	10	0	Trip Number
27	DATE_IN	☐	PTRV_CCC_DATEC	CHAR8	CHAR	8	0	Date in CHAR Format
28	DATE_OUT	☐	PTRV_CCC_DATEC	CHAR8	CHAR	8	0	Date in CHAR Format
29	VERSION_NR	☐	PTRV_CCC_RUN	CHAR10	CHAR	10	0	Number of Credit Card Accounting Run
30	E_DESCRIPTION	☐	PTRV_CCC_ERROR_TEXT	TEXT132	CHAR	132	0	Error Description for Credit Card Transaction
31	CARDCOMP	☐	CCOMP	CCOMP	CHAR	2	0	Code of Payment Card Company	*
32	COMPCODE	☐	COMPCODE	CHAR10	CHAR	10	0	Company ID for Credit Card Clearing
33	ABRWAEHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
34	ABRNACHK	☐	PTRV_CCC_DECIMALS	NUM1	NUMC	1	0	Number of Decimal Places For Currency (Credit Card Clearing)
35	CARDNUM_GUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
36	IMAGE_LINK	☐	PTRA_IMAGE_LINK	SYSUUID_C	CHAR	32	0	Contains the UUID of a Document on the Archive Server
37	REVERSE_CHARGE_T	☐	REVERSE_CHARGE_TAX	XFELD	CHAR	1	0	Indicator for Reverse Charge Tax (X = Reverse Charge Tax)
38	REVERSE_CHARGE_C	☐	REVERSE_CHARGE_COUNTRY	LNDGR	CHAR	3	0	Country in Which Reverse Charge Tax Is to Be Paid	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PTRV_CCC	UMSWAEHR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C