SAP ABAP Table PTRV_CCCMAIN (Main Structure for Travel 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	INTTAB	Structure
Structure	PTRV_CCCMAIN	Table Relationship Diagram
Short Description	Main Structure for Travel Credit Card Clearing

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	LINETYPE	☐	PTRV_CCC_LINETYPE	PTRV_CCC_LINETYPE	CHAR	1	0	Line Type in Credit Card File
2	PERNR	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
3	PNAME	☐	PTRV_CCC_NAME	TEXT50	CHAR	50	0	Name of Employee From Credit Card Clearing
4	CARDNUM	☐	C_NUM	TEXT19	CHAR	19	0	Credit Card Number
5	CARDFLAG	☐	PTRV_CCC_CARDFLAG	PTRV_CCC_CARDFLAG	CHAR	1	0	Indicator: Employee Credit Card/ Corporate Credit Card
6	UMSDATUM	☐	PTRV_CCC_PURCHASE_DATE	DATUM	DATS	8	0	Date of Credit Card Transaction
7	UMS_ZEIT	☐	PTRV_CCC_PURCHASE_TIME	PTRV_CCC_PURCHASE_TIME	CHAR	6	0	Time Of Credit Card Transaction
8	SP_KATEG	☐	PTRV_CCC_CATEGORY	PTRV_CCC_CATEGORY	CHAR	1	0	Credit Card Transaction Category
9	SPESTEXT	☐	CEKEY	CEKEY	CHAR	10	0	Transaction Key (Supplied by Credit Card Company)
10	S_H_FLAG	☐	PTRV_CCC_DEBIT_CREDIT	PTRV_CCC_DEBIT_CREDIT	CHAR	1	0	Indicator Credit/Debit Credit Card Clearing
11	UMSBETRG	☐	PTRV_CCC_ORG_AMOUNT	NUM10	NUMC	10	0	Numerical Amount in Original Currency (Credit Card Clearing)
12	UMSNACHK	☐	PTRV_CCC_DECIMALS	NUM1	NUMC	1	0	Number of Decimal Places For Currency (Credit Card Clearing)
13	UMSWAEHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	UMS_LAND	☐	PTRV_CCC_PURCHASE_COUNTRY	INTCA3	CHAR	3	0	Country Where Credit Card Transaction Took Place (ISO Code)
15	UMS_MWST	☐	ABRMWSTS	NUM5	NUMC	5	0	Value-Added Tax Rate (Amount) in Credit Card Clearing
16	UMS_KURS	☐	PTRV_CCC_EXCHANGE_RATE	NUM11	NUMC	11	0	Numerical Exchange Rate (7 Dec. Places) in Credit Card File
17	UMS_HEIM	☐	PTRV_CCC_ACC_AMOUNT	NUM10	NUMC	10	0	Nummerical Amount in Accounting Currency (Credit Card Clear)
18	UMSGEBUR	☐	PTRV_CCC_ADD_CHARGE	NUM10	NUMC	10	0	Nummerical Additional Charges Amount (Credit Card Clearing)
19	UMSTOTAL	☐	PTRV_CCC_TOTAL_AMOUNT	NUM10	NUMC	10	0	Numerical Total Amount (Credit Card Clearing)
20	ADDCOUNT	☐	PTRV_CCC_ADD_COUNT	NUM2	NUMC	2	0	No. of Additional Information Lines for Credit Card Trans.
21	TEXT_LANG	☐	C_TXT	TEXT50	CHAR	50	0	Delivered Description of a Credit Card Transaction
22	UMSDOKNR	☐	C_DOC	TEXT20	CHAR	20	0	Document Number of Credit Card Receipt
23	TRIPNO	☐	REINR	REINR	NUMC	10	0	Trip Number

Foreign Keys

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

History

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