SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

1OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

80 columns | Print definition?ERP 6.0  | CCNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FUDT_VDOCBKPFVerification Document Header100CCNUMPayment cards: Card numbernvarchar250
2FUDT_VDOCBKPFHVerification Document Header(History)100CCNUMPayment cards: Card numbernvarchar250
3GLPOS_C_CTFI Document: Entry View79CCNUMPayment cards: Card numbernvarchar250
4GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items79CCNUMPayment cards: Card numbernvarchar250
5GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items79CCNUMPayment cards: Card numbernvarchar250
6GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items79CCNUMPayment cards: Card numbernvarchar250
7GLPOS_N_CTNew General Ledger: Line Item with Currency Type79CCNUMPayment cards: Card numbernvarchar250
8GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type79CCNUMPayment cards: Card numbernvarchar250
TOPAccounting Interface
9GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)294CCNUMPayment cards: Card numbernvarchar250
10GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)294CCNUMPayment cards: Card numbernvarchar250
TOPAccounts Receivable Accounting Process Integration
11EBPPPCBiller Direct Data for the Payment Cards5CCNUMPayment cards: Card numbernvarchar250
TOPAdvertising Management
12JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order57CCNUMPayment cards: Card numbernvarchar250
13JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header46CCNUMPayment cards: Card numbernvarchar250
14JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet68CCNUMPayment cards: Card numbernvarchar250
15AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics36CCNUMCurrency Translation Numbernvarchar30
TOPBank Accounting
16BSEGCDocument: Data on Payment Card Payments7CCNUMPayment cards: Card numbernvarchar250
17ITAGCYPM_CCPayment Methods: Credit Card5CCNUMPayment cards: Card numbernvarchar250
18TF90FActive Field Catalog, Consolidation36CCNUMCurrency Translation Numbernvarchar30
19TF90SBasis Field Catalog Consolidation (Fixed Fields)36CCNUMCurrency Translation Numbernvarchar30
20TF91FField Catalog, Consolidation36CCNUMCurrency Translation Numbernvarchar30
TOPContract Accounts Receivable and Payable
21DFKKEXC_PAYINFOInformation for Payment Medium8CCNUMPayment cards: Card numbernvarchar250
22DFKKIP_GRPPayment Specification: Header Data44CCNUMPayment cards: Card numbernvarchar250
23DFKKIP_GRPHPayment Specification: Payment Data (History)46CCNUMPayment cards: Card numbernvarchar250
24DFKKOPCCard Data Supplement for Business Partner Item5CCNUMPayment cards: Card numbernvarchar250
25DFKKOPKCCard Data Appendix for FICA Document5CCNUMPayment cards: Card numbernvarchar250
26DFKKPPD_PAYPromise to Pay Debit Memo Amounts per Date14CCNUMPayment cards: Card numbernvarchar250
27DFKKPPD_PAY_HISPromise to Pay Debit Memo Amounts per Date13CCNUMPayment cards: Card numbernvarchar250
28DFKKZPPayment lot: Data for payment57CCNUMPayment cards: Card numbernvarchar250
29DFKK_PCARDCard Data Supplement4CCNUMPayment cards: Card numbernvarchar250
30DPAYHPayment program - data for payment85CCNUMPayment cards: Card numbernvarchar250
31FKKPREPACCMaster Data for Prepaid Account20CCNUMPayment cards: Card numbernvarchar250
32FKK_GPSHADData Extract: Business Partner Data (Faster Access)39CCNUMPayment cards: Card numbernvarchar250
TOPData Collection
33S117Receipt/article35CCNUMPayment cards: Card numbernvarchar250
34S119Transaction Number (Till Receipt)22CCNUMPayment cards: Card numbernvarchar250
35S120Sales as per receipts39CCNUMPayment cards: Card numbernvarchar250
36S120BIW1S120BIW1 * Sales as Per Receipts39CCNUMPayment cards: Card numbernvarchar250
37S120BIW2S120BIW2 * Sales as Per Receipts39CCNUMPayment cards: Card numbernvarchar250
38S953BW Vorl.für BON/Artikel S11735CCNUMZahlungskarten: Kartennummernvarchar250
39S954BW Vorl.für BON S11922CCNUMZahlungskarten: Kartennummernvarchar250
40TKAFField catalog for Accounting37CCNUMCurrency Translation Numbernvarchar30
41TKCFSAP-EIS Field Catalog36CCNUMCurrency Translation Numbernvarchar30
42TKCKKey figures11CCNUMCurrency Translation Numbernvarchar30
43TKCSBasic field catalog SAP-EIS (fixed fields)36CCNUMCurrency Translation Numbernvarchar30
TOPFinancial Accounting
44BKPFAccounting Document Header102CCNUMPayment cards: Card numbernvarchar250
45VBKPFDocument Header for Document Parking89CCNUMPayment cards: Card numbernvarchar250
TOPFunds Management
46KBLKDocument Header: Manual Document Entry52CCNUMPayment cards: Card numbernvarchar250
TOPFunds Management-Specific Postings
47PSOKPFRecurring Request Document Header82CCNUMPayment cards: Card numbernvarchar250
TOPIncentive and Commission Management ICM
48TCACSFCommissions: Field Catalog Search37CCNUMCurrency Translation Numbernvarchar30
TOPInvestment Programs
49TAIFIM Drilldown: Characteristic Catalog37CCNUMCurrency Translation Numbernvarchar30
50IDHUBILLINGOUTDefine Additional Billing Data for Hungary3CCNUMNumber of Carbon Copiesnvarchar30
TOPMedia Sales and Distribution
51/NAM/PAY_CCWorkload for Credit Card Payment13CCNUMPayment cards: Card numbernvarchar250
52ECAMIOPRPCIS-U Parking Document: Payment Cards6CCNUMPayment cards: Card numbernvarchar250
TOPPayment Cards
53CCARDPayment Card Master3CCNUMPayment cards: Card numbernvarchar250
54CCARD_COPYPayment Card Master3CCNUMPayment cards: Card numbernvarchar250
55CCSEC_LOGLogging of Access to Payment Card Numbers8CCNUMPayment cards: Card numbernvarchar250
56FPLTCPayment cards: Transaction data - SD5CCNUMPayment cards: Card numbernvarchar250
57VCKUNAssign customer-credit card4CCNUMPayment cards: Card numbernvarchar250
58VCNUMCredit card master3CCNUMPayment cards: Card numbernvarchar250
TOPPayment Transactions
59CRACCPayment Cards: Account Assignments in Card Master Record3CCNUMPayment cards: Card numbernvarchar250
60CRFILEPOSPayment Card File: Individual Records11CCNUMPayment cards: Card numbernvarchar250
61CRFILESTATPayment Card File: Status Information for Individual Records14CCNUMPayment cards: Card numbernvarchar250
62CRNUMPayment cards: Card master record3CCNUMPayment cards: Card numbernvarchar250
TOPPeriodical Sales and Distribution
63JFRKCCIS-M/SD: Billing - Payment Card Data5CCNUMPayment cards: Card numbernvarchar250
64JKAPCCSales Order: Payment Card Data6CCNUMPayment cards: Card numbernvarchar250
65JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet94CCNUMPayment cards: Card numbernvarchar250
66JKWWWTEMP_PAYIS-M: Temporary Internet Table: Payment Data Change20CCNUMPayment cards: Card numbernvarchar250
TOPProfitability Analysis
67TJBFField Catalog IS-B-PA36CCNUMCurrency Translation Numbernvarchar30
68TJBSBase Field Catalog IS-B-PA (Fixed Fields)36CCNUMCurrency Translation Numbernvarchar30
69TKEFCO-PA field catalog36CCNUMCurrency Translation Numbernvarchar30
70TKESCO-PA Basis Field Catalog (fixed fields)36CCNUMCurrency Translation Numbernvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
71DFMCA_BRF640BRF: Check Card Number7CCNUMBRF: Expressionnvarchar200
72DFMCA_BRF810BRF: Create/Update Card ID9CCNUMBRF: Expressionnvarchar200
TOPRisk Analysis
73JBRRMTKEFRM: Copy of CO-PA Field Catalog36CCNUMCurrency Translation Numbernvarchar30
74JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures36CCNUMCurrency Translation Numbernvarchar30
TOPService Station Retailing
75OIRESPCRSSR PC: Splitting criteria11CCNUMPayment cards: Card numbernvarchar250
76OIREUPLKXXXXSSR PC: Template for generated DTF tables (header)13CCNUMSSR PC: Payment card numbernvarchar250
77OIRE_RECON_DETDetailed reconciliation data6CCNUMSSR PC: Payment card numbernvarchar250
78TTMRFField catalog for Risk Management36CCNUMCurrency Translation Numbernvarchar30
79TTMRSBasis field catalog Risk Management (fixed fields)36CCNUMCurrency Translation Numbernvarchar30
TOPUse AP-MD-BP Components
80BUT0CCBP: Payment Cards5CCNUMPayment Cards: Card Numbernvarchar250