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

110 columns | Print definition?ERP 6.0  | HVORG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_CD2_CCD Posting: GL item settings6HVORGMain Transaction for Line Itemnvarchar40
2/GSINS/INH_CD3_CCD Posting: BP item settings5HVORGMain Transaction for Line Itemnvarchar40
3DFKKSAFTINV_3PCSAF-T source document extraction rules for Third Party10HVORGMain Transaction for Line Itemnvarchar40
4DFKKSAFTINV_3PVSAF-T Third Party Business Partner Assignment10HVORGMain Transaction for Line Itemnvarchar40
5DFKK_BIT_TESTTest Data for BITs16HVORGMain Transaction for Line Itemnvarchar40
6FKKID_EXP_HDR_ACr.Mem.&Exp.Conf.: Export Confirmation Header9HVORGMain Transaction for Line Itemnvarchar40
7TFK036VDifferent Planning Levels By Transactions4HVORGMain Transaction for Line Itemnvarchar40
8T7PIQSINGLEFEESDefine Attributes for Individual Fees10HVORGMain Transaction for Line Itemnvarchar40
9T7PIQ_NL_COBJMaintain Contract Object Types for Fee Calculation4HVORGMain Transaction for Line Itemnvarchar40
10TCMAC06DDerivation of ISR Scenario Related Data11HVORGMain Transaction for Line Itemnvarchar40
11TCMACFAINT04Financial Aid Relevant Main and Sub-transaction2HVORGMain Transaction for Line Itemnvarchar40
TOPBilling in Contract Accounts Receivable and Payable
12TFK8008ATransaction Determination for Billing Rate Item6HVORGMain Transaction for Line Itemnvarchar40
TOPCollectionsDisbursements
13BROK_SALD_CUSTBalance Key Assignment - Transactions3HVORGMain Transaction for Line Itemnvarchar40
14ITAGCYCOMMPLANAgency Coll.: Main/Sub-Transactns f.Commission in PlndPrincp2HVORGMain Transaction for Line Itemnvarchar40
15ITAGCYSUBCOMMCommission to Subagencies (Main and Subtransactions)2HVORGMain Transaction for Line Itemnvarchar40
16TIBRCLARREASClarification Codes for Broker Report9HVORGMain Trans. for New Created Open Items from Broker Reportnvarchar40
17TIBRDEFAULTSBroker Collections - Default Values for Broker Report10HVORGMain Trans. for New Created Open Items from Broker Reportnvarchar40
18TKKVHVTVFS-CD Transactions3HVORGMain Transaction for Line Itemnvarchar40
19TKKVHVTVTFS-CD Transactions: Texts4HVORGMain Transaction for Line Itemnvarchar40
20TKKVIVVAssign Internal Sub-Transactions to External Transactions5HVORGMain Transaction for Line Itemnvarchar40
21VVKKCFRECCash Receipts to be Transferred to Claims System14HVORGMain Transaction for Line Itemnvarchar40
22VVKKFOPSingle Doc in Posting Data Interface7HVORGMain Transaction for Line Itemnvarchar40
23VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP7HVORGMain Transaction for Line Itemnvarchar40
24VVKK_COINS_PLPRCoinsurance Reporting: Transactions for Debt Procedure3HVORGMain Transaction for Line Itemnvarchar40
25VVSCITEMBill Scheduling: Scheduling Document32HVORGMain Transaction for Line Itemnvarchar40
26VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change32HVORGMain Transaction for Line Itemnvarchar40
27VVSCPOSPayment Plan Item54HVORGMain Transaction for Line Itemnvarchar40
TOPContract Accounts Receivable and Payable
28DFKCRPOClarification Worklist Credit11HVORGMain Transaction for Line Itemnvarchar40
29DFKK10991099 Statutory Reporting Data19HVORGMain Transaction for Line Itemnvarchar40
30DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment25HVORGMain Transaction for Line Itemnvarchar40
31DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse13HVORGMain Transaction for Line Itemnvarchar40
32DFKKMOPItems in contract account document21HVORGMain Transaction for Line Itemnvarchar40
33DFKKOPItems in contract account document21HVORGMain Transaction for Line Itemnvarchar40
34DFKKOPCOLLCollection: Log of Receivables Submitted16HVORGMain Transaction for Line Itemnvarchar40
35DFKKOP_REPOpen Items from FPO425HVORGMain Transaction for Line Itemnvarchar40
36DFKKOP_SHORTPartner Items for FI-CA Document - Extracts17HVORGMain Transaction for Line Itemnvarchar40
37DFKKORDERPOSRequests: Items9HVORGMain Transaction for Line Itemnvarchar40
38DFKKORDERPOS_SRequest Templates: Items9HVORGMain Transaction for Line Itemnvarchar40
39DFKKRDIRevenue Distribution18HVORGMain Transaction for Distribution Line Itemnvarchar40
40DFKKRDI_AGGRF_CAuxiliary Table for Aggregated Distribution Information4HVORGMain Transaction for Line Itemnvarchar40
41DFKKTHITransfer Records for Invoice Issue by Third Party23HVORGMain Transaction for Line Itemnvarchar40
42DFKKTHI_SUMAggregated Transfer Records for Invoicing14HVORGMain Transaction for Line Itemnvarchar40
43DFKKTHPTransfer Records for Billing on Behalf of 3rd Party26HVORGMain Transaction for Line Itemnvarchar40
44DFKKTRANSKEY_TRTurkey: Transaction Key -Combination of Main and Sub Trans.3HVORGMain Transaction for Line Itemnvarchar40
45TE305Transactions for Company Code and Division5HVORGMain Transaction for Line Itemnvarchar40
46TE305TTransactions for Company Code and Division (Texts)6HVORGMain Transaction for Line Itemnvarchar40
47TE514Invoicing: Item Selection for Account Maintenance5HVORGMain Transaction for Line Itemnvarchar40
48TECODIS-U: CO account assignment key / allocation7HVORGMain Transaction for Line Itemnvarchar40
49TEIVV(DON'T FILL/RE AD!!!Alloc. of Intern. Transacts to Trans.5HVORGMain Transaction for Line Itemnvarchar40
50TFK047KCharge Categories Per Schedule4HVORGMain Transaction for Line Itemnvarchar40
51TFK056AInterest Key Table for FI-CA10HVORGNot Used (Main Transaction for Interest Keys)nvarchar40
52TFK059QVTransaction-Specific Withholding Tax Code4HVORGMain Transaction for Line Itemnvarchar40
53TFK063ACharge Categories for Installment Plan Surcharges5HVORGMain Transaction for Line Itemnvarchar40
54TFK113FClearing: Due Date Intervals for OI Selection5HVORGMain Transaction for Line Itemnvarchar40
55TFK113GClearing: Write-Off Statistical Items6HVORGMain Transaction for Line Itemnvarchar40
56TFKBA_TRANSAssignment of Transactions to Balances Categories3HVORGMain Transaction for Line Itemnvarchar40
57TFKHHVOMain Transactions for Credit Postings in FI-CA3HVORGMain Transaction for Credit Posting for Line Itemnvarchar40
58TFKHVOMain transactions in contract accts receivable and payable3HVORGMain Transaction for Line Itemnvarchar40
59TFKHVOTMain transactions in contract accts receivable and payable4HVORGMain Transaction for Line Itemnvarchar40
60TFKIVVAssignment of Internal Transactions to External Transactions5HVORGMain Transaction for Line Itemnvarchar40
61TFKRDI_DISGRP_RLTransactions Summarized for Distribution Group3HVORGMain Transaction for Line Itemnvarchar40
62TFKSHVOMain Transactions for Debit Postings in FI-CA3HVORGMain Transaction for Debit Posting for Line Itemnvarchar40
63TFKTVOSub-transactions in Contract Accounts Receivable and Payable3HVORGMain Transaction for Line Itemnvarchar40
64TFKTVOTSub-transactions in Contract Accounts Receivable and Payable4HVORGMain Transaction for Line Itemnvarchar40
65TFKZWEXExceptiions for Doubtful Entries/Individual Value Adjustment3HVORGMain Transaction for Line Itemnvarchar40
66TFK_CRPOCredit Processing: Customizing ID Credit4HVORGMain Transaction for Line Itemnvarchar40
67TFK_EXTDOC_AR3Determination of Report Classification6HVORGMain Transaction for Line Itemnvarchar40
68TFK_EXTDOC_OPTransactions for Official Document Number2HVORGMain Transaction for Line Itemnvarchar40
69TFK_PAYMENTREL_NFICA: Customizing Payment Release Disbursements - New3HVORGMain Transaction for Line Itemnvarchar40
TOPContract Billing
70ERCHBilling Doc. Data18HVORGMain Transaction for Line Itemnvarchar40
71ERCH_SHORTHeader Data for Billing Document - Extract12HVORGMain Transaction for Line Itemnvarchar40
72TEPREPAYCustomizing Settings for Prepayment Meter16HVORGMain Transaction for Line Itemnvarchar40
TOPFinancial Services Localization
73/GSINS/REU_TSBTRInsurance ETL Customizing Table4HVORGMain Transaction for Line Itemnvarchar40
74/GSINS/UPR_DEFREUPR - Calculation of unearned insurance premium reserve11HVORGMain Transaction for Line Itemnvarchar40
TOPGeneral Application Functions
75TFIS010FSCM: Bill Transactions3HVORGMain Transaction for Line Itemnvarchar40
TOPGeneric Contract Accounts Receivable and Payable
76TFSCHVTVTransactions for Company Code and Division5HVORGMain Transaction for Line Itemnvarchar40
77TFSCHVTVTTransactions for Company Code and Division (Texts)6HVORGMain Transaction for Line Itemnvarchar40
TOPIncentive and Commission Management ICM
78CACSCD_ACRCDAccount Assignments of Remun.Types for FS-CD Stt.System5HVORGMain Transaction for Document Itemnvarchar40
79CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items11HVORGMain Transaction for Document Itemnvarchar40
TOPIntercompany Data Exchange
80EDEREG_SIDPROINTInterpretation of Internal ID3HVORGMain Transaction for Line Itemnvarchar40
81TEFKTVOSTax Table: Relevant Transactions in Convergent Billing2HVORGMain Transaction for Line Itemnvarchar40
82TEFKTVOSBILLContract A/R and A/P items to be transfered for IDoc bill2HVORGMain Transaction for Line Itemnvarchar40
83TEFKTVOSBILLTText for contract A/R and A/P items in IDoc bill2HVORGMain Transaction for Line Itemnvarchar40
84TINV_INV_TRANSFTransfer Table for Bill Data to FI-CA39HVORGMain Transaction for Line Itemnvarchar40
85TINV_TRNSF_SHORTExtract of Bill Receipt (Eval. System): FI-CA Transfer Data23HVORGMain Transaction for Line Itemnvarchar40
TOPInvoicing
86DBERDLPrint Document Line Items29HVORGMain Transaction for Line Itemnvarchar40
87DBERDLBReference of a Print Doc. Line Item to a Bill.Doc. Line Item6HVORGMain Transaction for Line Itemnvarchar40
88DBERDZDB Table: Individ. Lines - Print Document11HVORGMain Transaction for Line Itemnvarchar40
89DEABPSCustomer change table: Logical view of BB amounts16HVORGMain Transaction for Line Itemnvarchar40
90EABPLSample Lines for Budget Billing Plan9HVORGMain Transaction for Line Itemnvarchar40
91ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data25HVORGMain Transaction for Line Itemnvarchar40
92TE529Item Selection for Bill Display4HVORGMain Transaction for Line Itemnvarchar40
93TEABSTVORDefine Debit/Credit ID for BB Amount Subtransactions3HVORGMain Transaction for Line Itemnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
94DFKKINVBILL_IBilling Document Items24HVORGMain Transaction for Line Itemnvarchar40
95DFKKINVDOC_IItems of Invoicing Document13HVORGMain Transaction for Line Itemnvarchar40
96TFK2617Charges/Discounts6HVORGMain Transaction for Line Itemnvarchar40
TOPLease Accounting
97/LSIERP/COND_MAPAssign FI-CA Transactions to CRM Conditions3HVORGMain Transaction for Line Itemnvarchar40
98/LSIERP/EXCL_NATransactions Not Assigned a Non-Accrual Status4HVORGMain Transaction for Line Itemnvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
99DFMCA_BRF150Text Parameters for Billing Line11HVORGBRF: Expressionnvarchar200
100DFMCA_BRF152BRF: Parameters for Calculation Line Items11HVORGMain Transaction for Line Itemnvarchar40
101DFMCA_BRF730BRF: Read Tax Liabilities11HVORGBRF: Expressionnvarchar200
102PS4SC_STATUS_RULSocial Services: Status - Message Document Rules3HVORGMain Transaction for Line Itemnvarchar40
103TFMCA004Parameters for Main/Sub-Transactions3HVORGMain Transaction for Line Itemnvarchar40
104TFMCA008Company Code-Dependent Indicator for Subtransactions3HVORGMain Transaction for Line Itemnvarchar40
105TFMCA_BRF221BRF: Parameters for Calculation Line Items12HVORGMain Transaction for Line Itemnvarchar40
106TFMCA_PREPAYMain and Subtransaction for Open Items4HVORGMain Transaction for Line Itemnvarchar40
107TFMCA_REFUNDMain/Subtransaction for Refund Items5HVORGMain Transaction for Line Itemnvarchar40
108TFMCA_REVTYPERevenue Types4HVORGMain Transaction for Line Itemnvarchar40
TOPSAP Utilities
109TE014_COMP_INDComponents for LPC, PPI, Interest5HVORGMain Transaction for Line Itemnvarchar40
110TE872_COMP_INDSecurity Deposit Revisions : Relevant Billing Components5HVORGMain Transaction for Line Itemnvarchar40