SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

81 columns | Print definition?ERP 6.0  | CCINS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FUDT_VDOCBKPFVerification Document Header99CCINSPayment cards: Card typenvarchar40
2FUDT_VDOCBKPFHVerification Document Header(History)99CCINSPayment cards: Card typenvarchar40
3GLPOS_C_CTFI Document: Entry View78CCINSPayment cards: Card typenvarchar40
4GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items78CCINSPayment cards: Card typenvarchar40
5GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items78CCINSPayment cards: Card typenvarchar40
6GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items78CCINSPayment cards: Card typenvarchar40
7GLPOS_N_CTNew General Ledger: Line Item with Currency Type78CCINSPayment cards: Card typenvarchar40
8GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type78CCINSPayment cards: Card typenvarchar40
TOPAccounting Interface
9GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)293CCINSPayment cards: Card typenvarchar40
10GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)293CCINSPayment cards: Card typenvarchar40
TOPAccounts Receivable Accounting Process Integration
11EBPPPCBiller Direct Data for the Payment Cards4CCINSPayment cards: Card typenvarchar40
12T042ICCAccount Determination Payment Cards in Payment Program3CCINSPayment cards: Card typenvarchar40
TOPAdvertising Management
13JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order56CCINSPayment cards: Card typenvarchar40
14JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header45CCINSPayment cards: Card typenvarchar40
15JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet67CCINSPayment cards: Card typenvarchar40
TOPBank Accounting
16BSEGCDocument: Data on Payment Card Payments6CCINSPayment cards: Card typenvarchar40
TOPBasic Functions
17TVCINPayment cards: Type2CCINSPayment cards: Card typenvarchar40
18TVCINTDescription of payment card type3CCINSPayment cards: Card typenvarchar40
TOPCollectionsDisbursements
19ITAGCYPM_CCPayment Methods: Credit Card4CCINSPayment card typenvarchar40
TOPConditions
20C006SlsOrg/Card cat.6CCINSPayment cards: Card typenvarchar40
TOPContract Accounts Receivable and Payable
21DFKKEXC_PAYINFOInformation for Payment Medium7CCINSPayment card typenvarchar40
22DFKKIP_GRPPayment Specification: Header Data43CCINSPayment card typenvarchar40
23DFKKIP_GRPHPayment Specification: Payment Data (History)45CCINSPayment card typenvarchar40
24DFKKOPCCard Data Supplement for Business Partner Item4CCINSPayment card typenvarchar40
25DFKKOPKCCard Data Appendix for FICA Document4CCINSPayment card typenvarchar40
26DFKKPC_LOGIPayment Cards: Billing Log (Paid Items)3CCINSPayment card typenvarchar40
27DFKKPC_LOGPPayment Cards: Billing Log (Payments)3CCINSPayment card typenvarchar40
28DFKKPPD_PAYPromise to Pay Debit Memo Amounts per Date13CCINSPayment card typenvarchar40
29DFKKPPD_PAY_HISPromise to Pay Debit Memo Amounts per Date12CCINSPayment card typenvarchar40
30DFKKZPPayment lot: Data for payment56CCINSPayment card typenvarchar40
31DFKK_PCARDCard Data Supplement3CCINSPayment card typenvarchar40
32DPAYHPayment program - data for payment84CCINSPayment card typenvarchar40
33FKKPREPACCMaster Data for Prepaid Account19CCINSPayment card typenvarchar40
34FKK_GPSHADData Extract: Business Partner Data (Faster Access)38CCINSPayment card typenvarchar40
TOPData Collection
35S120Sales as per receipts38CCINSPayment cards: Card typenvarchar40
36S120BIW1S120BIW1 * Sales as Per Receipts38CCINSPayment cards: Card typenvarchar40
37S120BIW2S120BIW2 * Sales as Per Receipts38CCINSPayment cards: Card typenvarchar40
TOPFinancial Accounting
38BKPFAccounting Document Header101CCINSPayment cards: Card typenvarchar40
39VBKPFDocument Header for Document Parking88CCINSPayment cards: Card typenvarchar40
TOPFunds Management
40KBLKDocument Header: Manual Document Entry51CCINSPayment cards: Card typenvarchar40
TOPFunds Management-Specific Postings
41PSOKPFRecurring Request Document Header81CCINSPayment cards: Card typenvarchar40
TOPMaster Data Synchronization
42CVIC_CCID_LINKLink Payment Cards ID (BP <--> Customer)3CCINSPayment cards: Card typenvarchar40
TOPMedia Sales and Distribution
43/NAM/PAY_CCWorkload for Credit Card Payment12CCINSPayment cards: Card typenvarchar40
TOPMove-InOut
44ECAMIOPRPCIS-U Parking Document: Payment Cards5CCINSPayment card typenvarchar40
TOPPayment Cards
45CCARDPayment Card Master2CCINSPayment card typenvarchar40
46CCARDEC_CUSTEncryption of Payment Card Type2CCINSPayment cards: Card typenvarchar40
47CCARD_COPYPayment Card Master2CCINSPayment card typenvarchar40
48FPLTCPayment cards: Transaction data - SD4CCINSPayment cards: Card typenvarchar40
49TB033CATAssign Payment Card Category to Payment Card Type2CCINSPayment card typenvarchar40
50TB033TBP Payment Cards: Texts Card Types3CCINSPayment card typenvarchar40
51TB033TYPAssign Payment Card Category to Payment Card Type2CCINSPayment card typenvarchar40
52TVCTDPayment Cards: Determine Categories2CCINSPayment cards: Card typenvarchar40
53VCKUNAssign customer-credit card3CCINSPayment cards: Card typenvarchar40
54VCNUMCredit card master2CCINSPayment cards: Card typenvarchar40
TOPPayment Transactions
55CRACCPayment Cards: Account Assignments in Card Master Record2CCINSPayment cards: Card typenvarchar40
56CRFILEHDPayment Card File: Header4CCINSPayment cards: Card typenvarchar40
57CRFILEPOSPayment Card File: Individual Records4CCINSPayment cards: Card typenvarchar40
58CRFILESTATPayment Card File: Status Information for Individual Records4CCINSPayment cards: Card typenvarchar40
59CRNUMPayment cards: Card master record2CCINSPayment cards: Card typenvarchar40
60TCRINPayment Cards: Card Types2CCINSPayment cards: Card typenvarchar40
61TCRINTPayment Cards: Texts for Card Types3CCINSPayment cards: Card typenvarchar40
TOPPeriodical Sales and Distribution
62JFRKCCIS-M/SD: Billing - Payment Card Data4CCINSPayment cards: Card typenvarchar40
63JKAPCCSales Order: Payment Card Data5CCINSPayment cards: Card typenvarchar40
64JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet93CCINSPayment cards: Card typenvarchar40
65JKWWWTEMP_PAYIS-M: Temporary Internet Table: Payment Data Change19CCINSPayment cards: Card typenvarchar40
66TJVCINUPayment Cards: Type2CCINSPayment cards: Card typenvarchar40
TOPPlant Master
67WRF5Plant / Merchant ID of Credit Card Company3CCINSPayment cards: Card typenvarchar40
TOPPOS Interface
68TWPDZAssignment of credit card institute to customer2CCINSPayment cards: Card typenvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
69DFMCA_BRF640BRF: Check Card Number6CCINSBRF: Expressionnvarchar200
70DFMCA_BRF810BRF: Create/Update Card ID8CCINSBRF: Expressionnvarchar200
TOPService Station Retailing
71C011Company Code/Payment card type/Splitting result6CCINSPayment cards: Card typenvarchar40
72C012Sales Org / Card type / split result6CCINSPayment cards: Card typenvarchar40
73C013Company Code / card type6CCINSPayment cards: Card typenvarchar40
74C014Card Type5CCINSPayment cards: Card typenvarchar40
75OIREDTF_INFOSCRNAssignment of infoscreen for SAPMOIREDTF3CCINSSSR PC: Payment card typenvarchar40
76OIRE_RECON_AGGAggregated reconciliation data5CCINSSSR PC: Payment card typenvarchar40
77OIRE_RECON_DETDetailed reconciliation data5CCINSSSR PC: Payment card typenvarchar40
78OIRE_RECON_RUNReconciliation run results10CCINSSSR PC: Payment card typenvarchar40
TOPTravel Expenses
79T706_CCOMPCredit Card Companies3CCINSPayment card typenvarchar40
TOPUse AP-MD-BP Components
80BUT0CCBP: Payment Cards4CCINSPayment card typenvarchar40
81TB033Payment Cards: Type2CCINSPayment card typenvarchar40