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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

76 columns | Print definition?ERP 6.0  | FAEDN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKBIXPABIT_RELRelease Order for Partner BITs for Billing5FAEDNDue date for net paymentnvarchar80
2DFKKHUREPDSRecording Data for Domestic Sales Hungary23FAEDNDue date for net paymentnvarchar80
3DFKKINVDOC_REVReversal Request for Invoicing Document19FAEDNDue date for net paymentnvarchar80
4DFKKPARTADJTrigger for Adjustment of Partner Billable Items7FAEDNDue date for net paymentnvarchar80
5DFKKPARTRELRelease Order of Partner Items for Partner Settlement8FAEDNDue date for net paymentnvarchar80
6ITAGCYTCBPAgency Collections: Temporary Collections with BP9FAEDNDue date for net paymentnvarchar80
TOPCollectionsDisbursements
7IBROSTMSUMBroker Summary Postings - Restart Information10FAEDNDue date for net paymentnvarchar80
8VINTEGBALANCEDTrigger for Fully Cleared Documents8FAEDNDue date for net paymentnvarchar80
9VKKQUOTSQuotation Monitoring FS-CD Acceptance Status9FAEDNDue date for net paymentnvarchar80
10VVKKCFRECCash Receipts to be Transferred to Claims System20FAEDNDue date for net paymentnvarchar80
11VVKKDRKODunning Printout:Header Items13FAEDNDue date for net paymentnvarchar80
12VVKKDRZEDunning Notice Output: Repetition Items18FAEDNDue date for net paymentnvarchar80
13VVKKEXPTRIGGERTrigger for Expiry Notes9FAEDNDue date for net paymentnvarchar80
14VVKKFOPSingle Doc in Posting Data Interface11FAEDNDue date for net paymentnvarchar80
15VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP11FAEDNDue date for net paymentnvarchar80
16VVKKMAKTExecuted Dunning Activities14FAEDNDue date for net paymentnvarchar80
17VVKKMHISTContract-Related Dunning History36FAEDNDue date for net paymentnvarchar80
18VVKKTAXREPTax Reporting ITA: Data for Tax Report24FAEDNDue date for net paymentnvarchar80
19VVKK_COINSHCoinsurance Shares Header Table11FAEDNDue date for net paymentnvarchar80
20VVSCPOSPayment Plan Item129FAEDNDue date for net paymentnvarchar80
TOPContract Accounts Receivable and Payable
21DFKKCIBWFICA: Extraction of Cleared Items20FAEDNDue date for net paymentnvarchar80
22DFKKCMPManually Issued Checks Lot: Item Data16FAEDNCheck Redeemable/Valid Fromnvarchar80
23DFKKCOMACorrespondence Dunning25FAEDNDue date for net paymentnvarchar80
24DFKKCRRepository For Checks28FAEDNCheck Redeemable/Valid Fromnvarchar80
25DFKKCRDELCR: Deleted Payment Medium / Basic Data31FAEDNCheck Redeemable/Valid Fromnvarchar80
26DFKKDDADebit Memo Notification4FAEDNCollection Datenvarchar80
27DFKKDOUBTD_RET_WBuffer: Printout for Ind.Val.Ad - Return Values (User Event)13FAEDNDue date for net paymentnvarchar80
28DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment19FAEDNDue date for net paymentnvarchar80
29DFKKIPBW_ITEMInstallment Plan Items for Business Warehouse13FAEDNDue date for net paymentnvarchar80
30DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse16FAEDNDue date for net paymentnvarchar80
31DFKKMOPItems in contract account document34FAEDNDue date for net paymentnvarchar80
32DFKKMOPWItems in contract account document11FAEDNDue date for net paymentnvarchar80
33DFKKOPItems in contract account document34FAEDNDue date for net paymentnvarchar80
34DFKKOPBWOI Extraction16FAEDNDue date for net paymentnvarchar80
35DFKKOPCOLLCollection: Log of Receivables Submitted23FAEDNDue date for net paymentnvarchar80
36DFKKOPWItems in contract account document11FAEDNDue date for net paymentnvarchar80
37DFKKOP_REPOpen Items from FPO438FAEDNDue date for net paymentnvarchar80
38DFKKOP_SHORTPartner Items for FI-CA Document - Extracts11FAEDNDue date for net paymentnvarchar80
39DFKKORDERPOSRequests: Items18FAEDNDue date for net paymentnvarchar80
40DFKKORDERPOS_SRequest Templates: Items17FAEDNDue date for net paymentnvarchar80
41DFKKREP06Tax Report Data (Invoicing Time or Triggered)22FAEDNDue date for net paymentnvarchar80
42DFKKREP06_STax Report Data - Shadow Table for Posting Date22FAEDNDue date for net paymentnvarchar80
43DFKKREP07Tax Report Data (Clearing Time)28FAEDNDue date for net paymentnvarchar80
44DFKKREPZMRecording Data for EC Sales List19FAEDNDue date for net paymentnvarchar80
45DFKKREV06Report for Tax on Sales/Purchases (bill. time or triggered)18FAEDNDue date for net paymentnvarchar80
46DFKKREV07Report on Tax on Sales/Purchases (clearing time)24FAEDNDue date for net paymentnvarchar80
47DFKKRP3Returns: Manual Posting Specifications15FAEDNDue date for net paymentnvarchar80
48DFKKRP3HReturns: History for Manual Posting Items11FAEDNDue date for net paymentnvarchar80
49DFKKWLI_ILItem List of Work Item9FAEDNDue date for net paymentnvarchar80
50DFKKZARepayment Request10FAEDNDue date for net paymentnvarchar80
51DFKK_IPL_ITEMSInstallment Plan Key Date Recording (Original Items)7FAEDNDue date for net paymentnvarchar80
52DFKK_IPL_RATESInstallment Plan Key Date Recording (Installments)4FAEDNDue date for net paymentnvarchar80
53FKKMAZEDunning history of line items15FAEDNDue date for net paymentnvarchar80
54FKK_INSTPLN_INVHHistory of Installment Plan Due Dates from Invoicing7FAEDNDue date for net paymentnvarchar80
TOPIncentive and Commission Management ICM
55CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items24FAEDNDatenvarchar80
TOPInvoicing
56DBERDLPrint Document Line Items33FAEDNDue date for net paymentnvarchar80
57DBERDZDB Table: Individ. Lines - Print Document15FAEDNDue date for net paymentnvarchar80
58DEABPSCustomer change table: Logical view of BB amounts29FAEDNDue date for net paymentnvarchar80
59EABPJVL_CORRCorrespondence Print: Bud. Bill. Plan Header and YAP Info.20FAEDNYAP Due Datenvarchar80
60EABPS_CORRSub Budget Billing Plan for Correspondence Print9FAEDNDue date for net paymentnvarchar80
61EITRTemporary Selection Data for IS-U Invoicing15FAEDNDue date for net paymentnvarchar80
62EJVLYearly Advance Payment13FAEDNYAP Due Datenvarchar80
63ERDKPrint Document/Header Data4FAEDNDue date for net paymentnvarchar80
64ERDK_SHORTHeader Data for Print Document - Extract4FAEDNDue date for net paymentnvarchar80
65ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data10FAEDNDue date for net paymentnvarchar80
TOPInvoicing in Contract Accounts Receivable and Payable
66DFKKINVBILL_IBilling Document Items17FAEDNDue date for net paymentnvarchar80
67DFKKINVDOC_HInvoicing Document Header22FAEDNDue date for net paymentnvarchar80
68DFKKINVDOC_IItems of Invoicing Document52FAEDNDue date for net paymentnvarchar80
TOPLease Accounting
69/LSIERP/WLI_ILItem List of Work Item9FAEDNDue date for net paymentnvarchar80
TOPMigration
70TEM_BBP_CBIS-U Mig: Assgt of BB Due Date for Collective Document No.3FAEDNDue date for net paymentnvarchar80
71TEM_BBP_DEREGIS-U Mig.: Budget Billing Request in legacy system (dereg.)3FAEDNDue date for net paymentnvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
72DFMCA_BRF150Text Parameters for Billing Line17FAEDNBRF: Expressionnvarchar200
73DFMCA_BRF152BRF: Parameters for Calculation Line Items13FAEDNExpression for Due Datenvarchar200
74DFMCA_CORRM_ICRTemp table for saving enhanced ICR setting for manual corr.5FAEDNInbound Correspondence Due Datenvarchar80
75TFMCA_BRF221BRF: Parameters for Calculation Line Items14FAEDNExpression for Due Datenvarchar200
76TFMCA_BRF222BRF: Parameters for Refund Line Items9FAEDNExpression for Due Datenvarchar200