| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FUDT_VDOCBKPF | Verification Document Header | 100 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
2 | FUDT_VDOCBKPFH | Verification Document Header(History) | 100 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
3 | GLPOS_C_CT | FI Document: Entry View | 79 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
4 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 79 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
5 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 79 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
6 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 79 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
7 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 79 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
8 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 79 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPAccounting Interface |
9 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 294 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
10 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 294 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
11 | EBPPPC | Biller Direct Data for the Payment Cards | 5 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPAdvertising Management |
12 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 57 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
13 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 46 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
14 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 68 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPAnalyzer |
15 | AFWCH_FCAT_SAMP | AFW: Sample Customizing Characteristics | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPBank Accounting |
16 | BSEGC | Document: Data on Payment Card Payments | 7 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPCollectionsDisbursements |
17 | ITAGCYPM_CC | Payment Methods: Credit Card | 5 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPConsolidation |
18 | TF90F | Active Field Catalog, Consolidation | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
19 | TF90S | Basis Field Catalog Consolidation (Fixed Fields) | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
20 | TF91F | Field Catalog, Consolidation | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
21 | DFKKEXC_PAYINFO | Information for Payment Medium | 8 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
22 | DFKKIP_GRP | Payment Specification: Header Data | 44 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
23 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 46 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
24 | DFKKOPC | Card Data Supplement for Business Partner Item | 5 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
25 | DFKKOPKC | Card Data Appendix for FICA Document | 5 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
26 | DFKKPPD_PAY | Promise to Pay Debit Memo Amounts per Date | 14 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
27 | DFKKPPD_PAY_HIS | Promise to Pay Debit Memo Amounts per Date | 13 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
28 | DFKKZP | Payment lot: Data for payment | 57 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
29 | DFKK_PCARD | Card Data Supplement | 4 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
30 | DPAYH | Payment program - data for payment | 85 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
31 | FKKPREPACC | Master Data for Prepaid Account | 20 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
32 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 39 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPData Collection |
33 | S117 | Receipt/article | 35 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
34 | S119 | Transaction Number (Till Receipt) | 22 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
35 | S120 | Sales as per receipts | 39 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
36 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 39 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
37 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 39 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
38 | S953 | BW Vorl.für BON/Artikel S117 | 35 | CCNUM | Zahlungskarten: Kartennummer | nvarchar | 25 | 0 | | |
39 | S954 | BW Vorl.für BON S119 | 22 | CCNUM | Zahlungskarten: Kartennummer | nvarchar | 25 | 0 | | |
40 | TKAF | Field catalog for Accounting | 37 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
41 | TKCF | SAP-EIS Field Catalog | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
42 | TKCK | Key figures | 11 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
43 | TKCS | Basic field catalog SAP-EIS (fixed fields) | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
44 | BKPF | Accounting Document Header | 102 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
45 | VBKPF | Document Header for Document Parking | 89 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPFunds Management |
46 | KBLK | Document Header: Manual Document Entry | 52 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPFunds Management-Specific Postings |
47 | PSOKPF | Recurring Request Document Header | 82 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPIncentive and Commission Management ICM |
48 | TCACSF | Commissions: Field Catalog Search | 37 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPInvestment Programs |
49 | TAIF | IM Drilldown: Characteristic Catalog | 37 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPLocalization |
50 | IDHUBILLINGOUT | Define Additional Billing Data for Hungary | 3 | CCNUM | Number of Carbon Copies | nvarchar | 3 | 0 | | |
TOPMedia Sales and Distribution |
51 | /NAM/PAY_CC | Workload for Credit Card Payment | 13 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPMove-InOut |
52 | ECAMIOPRPC | IS-U Parking Document: Payment Cards | 6 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPPayment Cards |
53 | CCARD | Payment Card Master | 3 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
54 | CCARD_COPY | Payment Card Master | 3 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
55 | CCSEC_LOG | Logging of Access to Payment Card Numbers | 8 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
56 | FPLTC | Payment cards: Transaction data - SD | 5 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
57 | VCKUN | Assign customer-credit card | 4 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
58 | VCNUM | Credit card master | 3 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPPayment Transactions |
59 | CRACC | Payment Cards: Account Assignments in Card Master Record | 3 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
60 | CRFILEPOS | Payment Card File: Individual Records | 11 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
61 | CRFILESTAT | Payment Card File: Status Information for Individual Records | 14 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
62 | CRNUM | Payment cards: Card master record | 3 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPPeriodical Sales and Distribution |
63 | JFRKCC | IS-M/SD: Billing - Payment Card Data | 5 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
64 | JKAPCC | Sales Order: Payment Card Data | 6 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
65 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 94 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
66 | JKWWWTEMP_PAY | IS-M: Temporary Internet Table: Payment Data Change | 20 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
TOPProfitability Analysis |
67 | TJBF | Field Catalog IS-B-PA | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
68 | TJBS | Base Field Catalog IS-B-PA (Fixed Fields) | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
69 | TKEF | CO-PA field catalog | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
70 | TKES | CO-PA Basis Field Catalog (fixed fields) | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
71 | DFMCA_BRF640 | BRF: Check Card Number | 7 | CCNUM | BRF: Expression | nvarchar | 20 | 0 | | |
72 | DFMCA_BRF810 | BRF: Create/Update Card ID | 9 | CCNUM | BRF: Expression | nvarchar | 20 | 0 | | |
TOPRisk Analysis |
73 | JBRRMTKEF | RM: Copy of CO-PA Field Catalog | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
74 | JBRRMTKES | RM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPService Station Retailing |
75 | OIRESPCR | SSR PC: Splitting criteria | 11 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | |
76 | OIREUPLKXXXX | SSR PC: Template for generated DTF tables (header) | 13 | CCNUM | SSR PC: Payment card number | nvarchar | 25 | 0 | | |
77 | OIRE_RECON_DET | Detailed reconciliation data | 6 | CCNUM | SSR PC: Payment card number | nvarchar | 25 | 0 | | |
TOPTreasury |
78 | TTMRF | Field catalog for Risk Management | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
79 | TTMRS | Basis field catalog Risk Management (fixed fields) | 36 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | | |
TOPUse AP-MD-BP Components |
80 | BUT0CC | BP: Payment Cards | 5 | CCNUM | Payment Cards: Card Number | nvarchar | 25 | 0 | | |