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

113 columns | Print definition?ERP 6.0  | TVORG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_CD2_CCD Posting: GL item settings7TVORGSubtransaction for Document Itemnvarchar40
2/GSINS/INH_CD3_CCD Posting: BP item settings6TVORGSubtransaction for Document Itemnvarchar40
3DFKKSAFTINV_3PCSAF-T source document extraction rules for Third Party11TVORGSubtransaction for Document Itemnvarchar40
4DFKKSAFTINV_3PVSAF-T Third Party Business Partner Assignment11TVORGSubtransaction for Document Itemnvarchar40
5DFKK_BIT_TESTTest Data for BITs17TVORGSubtransaction for Document Itemnvarchar40
6FKKID_EXP_HDR_ACr.Mem.&Exp.Conf.: Export Confirmation Header10TVORGSubtransaction for Document Itemnvarchar40
7TFK036VDifferent Planning Levels By Transactions5TVORGSubtransaction for Document Itemnvarchar40
8T7PIQSINGLEFEESDefine Attributes for Individual Fees11TVORGSubtransaction for Document Itemnvarchar40
9T7PIQ_NL_COBJMaintain Contract Object Types for Fee Calculation5TVORGSubtransaction for Document Itemnvarchar40
10TCMAC06DDerivation of ISR Scenario Related Data12TVORGSubtransaction for Document Itemnvarchar40
11TCMACFAINT04Financial Aid Relevant Main and Sub-transaction3TVORGSubtransaction for Document Itemnvarchar40
TOPBilling in Contract Accounts Receivable and Payable
12TFK8008ATransaction Determination for Billing Rate Item7TVORGSubtransaction for Document Itemnvarchar40
TOPCollectionsDisbursements
13BROK_SALD_CUSTBalance Key Assignment - Transactions4TVORGSubtransaction for Document Itemnvarchar40
14ITAGCYCOMMPLANAgency Coll.: Main/Sub-Transactns f.Commission in PlndPrincp3TVORGSubtransaction for Document Itemnvarchar40
15ITAGCYSUBCOMMCommission to Subagencies (Main and Subtransactions)3TVORGSubtransaction for Document Itemnvarchar40
16TIBRCLARREASClarification Codes for Broker Report10TVORGSubtrans. for New Created Open Items from Broker Reportnvarchar40
17TIBRDEFAULTSBroker Collections - Default Values for Broker Report11TVORGSubtrans. for New Created Open Items from Broker Reportnvarchar40
18TKKVHVTVFS-CD Transactions4TVORGSubtransaction for Document Itemnvarchar40
19TKKVHVTVTFS-CD Transactions: Texts5TVORGSubtransaction for Document Itemnvarchar40
20TKKVIVVAssign Internal Sub-Transactions to External Transactions6TVORGSubtransaction for Document Itemnvarchar40
21VVKKCFRECCash Receipts to be Transferred to Claims System15TVORGSubtransaction for Document Itemnvarchar40
22VVKKFOPSingle Doc in Posting Data Interface8TVORGSubtransaction for Document Itemnvarchar40
23VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP8TVORGSubtransaction for Document Itemnvarchar40
24VVKK_COINS_PLPRCoinsurance Reporting: Transactions for Debt Procedure4TVORGSubtransaction for Document Itemnvarchar40
25VVSCITEMBill Scheduling: Scheduling Document33TVORGSubtransaction for Document Itemnvarchar40
26VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change33TVORGSubtransaction for Document Itemnvarchar40
27VVSCLOCKAMTScheduling: Premium Lock Period Share Already Transferred9TVORGSubtransaction for Document Itemnvarchar40
28VVSCPOSPayment Plan Item55TVORGSubtransaction for Document Itemnvarchar40
TOPContract Accounts Receivable and Payable
29DFKCRPOClarification Worklist Credit12TVORGSubtransaction for Document Itemnvarchar40
30DFKK10991099 Statutory Reporting Data20TVORGSubtransaction for Document Itemnvarchar40
31DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment26TVORGSubtransaction for Document Itemnvarchar40
32DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse14TVORGSubtransaction for Document Itemnvarchar40
33DFKKMOPItems in contract account document22TVORGSubtransaction for Document Itemnvarchar40
34DFKKOPItems in contract account document22TVORGSubtransaction for Document Itemnvarchar40
35DFKKOPCOLLCollection: Log of Receivables Submitted17TVORGSubtransaction for Document Itemnvarchar40
36DFKKOP_REPOpen Items from FPO426TVORGSubtransaction for Document Itemnvarchar40
37DFKKOP_SHORTPartner Items for FI-CA Document - Extracts18TVORGSubtransaction for Document Itemnvarchar40
38DFKKORDERPOSRequests: Items10TVORGSubtransaction for Document Itemnvarchar40
39DFKKORDERPOS_SRequest Templates: Items10TVORGSubtransaction for Document Itemnvarchar40
40DFKKRDIRevenue Distribution19TVORGSubtransaction for Distribution Document Itemnvarchar40
41DFKKRDI_AGGRF_CAuxiliary Table for Aggregated Distribution Information5TVORGSubtransaction for Document Itemnvarchar40
42DFKKTHITransfer Records for Invoice Issue by Third Party24TVORGSubtransaction for Document Itemnvarchar40
43DFKKTHI_SUMAggregated Transfer Records for Invoicing15TVORGSubtransaction for Document Itemnvarchar40
44DFKKTHPTransfer Records for Billing on Behalf of 3rd Party27TVORGSubtransaction for Document Itemnvarchar40
45DFKKTRANSKEY_TRTurkey: Transaction Key -Combination of Main and Sub Trans.4TVORGSubtransaction for Document Itemnvarchar40
46TE305Transactions for Company Code and Division6TVORGSubtransaction for Document Itemnvarchar40
47TE305TTransactions for Company Code and Division (Texts)7TVORGSubtransaction for Document Itemnvarchar40
48TE514Invoicing: Item Selection for Account Maintenance6TVORGSubtransaction for Document Itemnvarchar40
49TECODIS-U: CO account assignment key / allocation8TVORGSubtransaction for Document Itemnvarchar40
50TEIVV(DON'T FILL/RE AD!!!Alloc. of Intern. Transacts to Trans.6TVORGSubtransaction for Document Itemnvarchar40
51TEK060ALoan Categories8TVORGSub-transaction for items due in return payment plannvarchar40
52TFK047KCharge Categories Per Schedule5TVORGSubtransaction for Document Itemnvarchar40
53TFK056AInterest Key Table for FI-CA11TVORGNot Used (Subtransaction for Interest Keys)nvarchar40
54TFK059QVTransaction-Specific Withholding Tax Code5TVORGSubtransaction for Document Itemnvarchar40
55TFK060AInstall.Plan Proposal Cats13TVORGAlternative Sub-Transaction For Installment Plannvarchar40
56TFK063ACharge Categories for Installment Plan Surcharges6TVORGSubtransaction for Document Itemnvarchar40
57TFK113FClearing: Due Date Intervals for OI Selection6TVORGSubtransaction for Document Itemnvarchar40
58TFK113GClearing: Write-Off Statistical Items7TVORGSubtransaction for Document Itemnvarchar40
59TFKBA_TRANSAssignment of Transactions to Balances Categories4TVORGSubtransaction for Document Itemnvarchar40
60TFKIVVAssignment of Internal Transactions to External Transactions6TVORGSubtransaction for Document Itemnvarchar40
61TFKRDI_DISGRP_RLTransactions Summarized for Distribution Group4TVORGSubtransaction for Document Itemnvarchar40
62TFKTVOSub-transactions in Contract Accounts Receivable and Payable4TVORGSubtransaction for Document Itemnvarchar40
63TFKTVOTSub-transactions in Contract Accounts Receivable and Payable5TVORGSubtransaction for Document Itemnvarchar40
64TFKZWEXExceptiions for Doubtful Entries/Individual Value Adjustment4TVORGSubtransaction for Document Itemnvarchar40
65TFK_CRPOCredit Processing: Customizing ID Credit5TVORGSubtransaction for Document Itemnvarchar40
66TFK_EXTDOC_AR3Determination of Report Classification7TVORGSubtransaction for Document Itemnvarchar40
67TFK_EXTDOC_OPTransactions for Official Document Number3TVORGSubtransaction for Document Itemnvarchar40
68TFK_PAYMENTREL_NFICA: Customizing Payment Release Disbursements - New4TVORGSubtransaction for Document Itemnvarchar40
TOPContract Billing
69DBERCHZIndividual Line Items17TVORGSubtransaction for Document Itemnvarchar40
70DBERCHZ1Individual line items16TVORGSubtransaction for Document Itemnvarchar40
71DBERCHZ5Individual line items (unimportant rows)16TVORGSubtransaction for Document Itemnvarchar40
72ERCHZ_SHORTBilling Document Individual Lines Extract15TVORGSubtransaction for Document Itemnvarchar40
73TEPREPAYCustomizing Settings for Prepayment Meter17TVORGSubtransaction for Document Itemnvarchar40
TOPFinancial Services Localization
74/GSINS/REU_TSBTRInsurance ETL Customizing Table5TVORGSubtransaction for Document Itemnvarchar40
75/GSINS/UPR_DEFREUPR - Calculation of unearned insurance premium reserve12TVORGSubtransaction for Document Itemnvarchar40
TOPGeneral Application Functions
76TFIS010FSCM: Bill Transactions4TVORGSubtransaction for Document Itemnvarchar40
TOPGeneric Contract Accounts Receivable and Payable
77TFSCHVTVTransactions for Company Code and Division6TVORGSubtransaction for Document Itemnvarchar40
78TFSCHVTVTTransactions for Company Code and Division (Texts)7TVORGSubtransaction for Document Itemnvarchar40
TOPIncentive and Commission Management ICM
79CACSCD_ACRCDAccount Assignments of Remun.Types for FS-CD Stt.System6TVORGSubtransaction for Document Itemnvarchar40
80CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items12TVORGSubtransaction for Document Itemnvarchar40
TOPIntercompany Data Exchange
81EDEREG_SIDPROINTInterpretation of Internal ID4TVORGSubtransaction for Document Itemnvarchar40
82EINLITYPETRANSAllocation of Document Line Items9TVORGSubtransaction for Document Itemnvarchar40
83TEFKTVOSTax Table: Relevant Transactions in Convergent Billing3TVORGSubtransaction for Document Itemnvarchar40
84TEFKTVOSBILLContract A/R and A/P items to be transfered for IDoc bill3TVORGSubtransaction for Document Itemnvarchar40
85TEFKTVOSBILLTText for contract A/R and A/P items in IDoc bill3TVORGSubtransaction for Document Itemnvarchar40
86TINV_INV_TRANSFTransfer Table for Bill Data to FI-CA40TVORGSubtransaction for Document Itemnvarchar40
87TINV_TRNSF_SHORTExtract of Bill Receipt (Eval. System): FI-CA Transfer Data24TVORGSubtransaction for Document Itemnvarchar40
TOPInvoicing
88DBERDLPrint Document Line Items30TVORGSubtransaction for Document Itemnvarchar40
89DBERDZDB Table: Individ. Lines - Print Document43TVORGSubtransaction for Document Itemnvarchar40
90DEABPSCustomer change table: Logical view of BB amounts17TVORGSubtransaction for Document Itemnvarchar40
91EABPLSample Lines for Budget Billing Plan10TVORGSubtransaction for Document Itemnvarchar40
92EABPS_CORRSub Budget Billing Plan for Correspondence Print8TVORGSubtransaction for Document Itemnvarchar40
93ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data26TVORGSubtransaction for Document Itemnvarchar40
94TE306Budget Billing Procedures: Debit/Credit Indicators2TVORGSubtransaction for Document Itemnvarchar40
95TE529Item Selection for Bill Display5TVORGSubtransaction for Document Itemnvarchar40
96TEABSTVORDefine Debit/Credit ID for BB Amount Subtransactions4TVORGSubtransaction for Document Itemnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
97DFKKINVBILL_IBilling Document Items25TVORGSubtransaction for Document Itemnvarchar40
98DFKKINVDOC_IItems of Invoicing Document14TVORGSubtransaction for Document Itemnvarchar40
99TFK2617Charges/Discounts7TVORGSubtransaction for Document Itemnvarchar40
TOPLease Accounting
100/LSIERP/COND_MAPAssign FI-CA Transactions to CRM Conditions4TVORGSubtransaction for Document Itemnvarchar40
101/LSIERP/EXCL_NATransactions Not Assigned a Non-Accrual Status5TVORGSubtransaction for Document Itemnvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
102DFMCA_BRF150Text Parameters for Billing Line14TVORGBRF: Expressionnvarchar200
103DFMCA_BRF152BRF: Parameters for Calculation Line Items12TVORGSubtransaction for Document Itemnvarchar40
104DFMCA_BRF730BRF: Read Tax Liabilities12TVORGBRF: Expressionnvarchar200
105PS4SC_STATUS_RULSocial Services: Status - Message Document Rules4TVORGSubtransaction for Document Itemnvarchar40
106TFMCA004Parameters for Main/Sub-Transactions4TVORGSubtransaction for Document Itemnvarchar40
107TFMCA008Company Code-Dependent Indicator for Subtransactions4TVORGSubtransaction for Document Itemnvarchar40
108TFMCA_BRF221BRF: Parameters for Calculation Line Items13TVORGSubtransaction for Document Itemnvarchar40
109TFMCA_PREPAYMain and Subtransaction for Open Items5TVORGSubtransaction for Document Itemnvarchar40
110TFMCA_REFUNDMain/Subtransaction for Refund Items6TVORGSubtransaction for Document Itemnvarchar40
111TFMCA_REVTYPERevenue Types5TVORGSubtransaction for Document Itemnvarchar40
TOPSAP Utilities
112TE014_COMP_INDComponents for LPC, PPI, Interest6TVORGSubtransaction for Document Itemnvarchar40
113TE872_COMP_INDSecurity Deposit Revisions : Relevant Billing Components6TVORGSubtransaction for Document Itemnvarchar40