SAP ABAP Table VCNUM (Credit card master)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-BIL-IV-PC (Application Component) Payment Cards
     ⤷ VFC (Package) Application development R/3 billing docs.: Payment cards

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VCNUM	Table Relationship Diagram
Short Description	Credit card master

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	CCINS	☑	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
3	CCNUM	☑	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number
4	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
5	DATAB	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
6	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
7	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	TVCTY
8	CCLOCK	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	TVCLK
9	ISSBANK	☐	CC_ISSBANK	TEXT40	CHAR	40	0	Payment cards: Issuing bank
10	AUSGDAT	☐	CC_AUSGDAT	DATUM	DATS	8	0	Payment Cards: Date of Issue
11	CCNUM_MASK	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
12	CCARD_GUID	☐	CCARDEC_GUID	SYSUUID_C	CHAR	32	0	Reference to Encrypted Payment Card Data
13	CCARD_ID	☐	BU_CCID	CHAR6	CHAR	6	0	Payment Card ID
14	CCACCNAME	☐	BU_CREDITCNAME	BU_BKCCNAME	CHAR	40	0	Description of Credit Card Details

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VCNUM	CCINS	TVCIN	CCINS	KEY	1	CN
2	VCNUM	CCLOCK	TVCLK	CCLOCK	REF	1	CN
3	VCNUM	CCTYP	TVCTY	CCTYP	REF	1	CN
4	VCNUM	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in