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

152 columns | Print definition?ERP 6.0  | GSART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RDPT_COND_ACTIVActivate Condition within Redemption Schedule2GSARTProduct Typenvarchar30
2T056ATime-dependent conditions7GSARTBusiness type (interest reference)nvarchar30
3T056FReference interest rates2GSARTBusiness type (interest reference)nvarchar30
4TREAC_EA_POSTDefines in which way flows of an EA should be posted2GSARTProduct Typenvarchar30
5TW15Reference between product type and repayment type2GSARTProduct Typenvarchar30
6TW16References between product type and security classification2GSARTProduct Typenvarchar30
7TZB11Activity-dependent one-time conditions6GSARTProduct Typenvarchar30
8TZD0ADarwin: Customer default values per trans. type for KNA12GSARTProduct Typenvarchar30
9TZD0BDarwin: Customer default values per co.cd/trn.type for KNB13GSARTProduct Typenvarchar30
10TZD37Texts for TZC374GSARTProduct Typenvarchar30
11TZKM1Event-controlled modification of condition items3GSARTProduct Typenvarchar30
12TZM37Transition matrix of internal status3GSARTProduct Typenvarchar30
13TZN01Product type numbers3GSARTProduct Typenvarchar30
14VDAPPOFF_RESResidence Time for Model Calculation Archiving2GSARTProduct Typenvarchar30
15VDCNTL_CASH_FLOWDisplay Interval for Cash Flow2GSARTProduct Typenvarchar30
16VDPL_OBJ_CAT_ASSAssign Insurance Object Category3GSARTProduct Typenvarchar30
17VDPL_SAMPLE_ASSAssign Samples To Types (Policy Loan Integration)3GSARTProduct Typenvarchar30
18VDPL_TRANS_ASSAssign Transactions3GSARTProduct Typenvarchar30
19VDREF_INTCustomizing table for Reference Interest Rate3GSARTProduct Typenvarchar30
20VDSEPA_AUTODEBRecords for new auto debit (SEPA direct debit)18GSARTProduct Typenvarchar30
21VDSEPA_AUTODEB_ORecords for new auto debit (SEPA direct debit) (up to 604)18GSARTProduct Typenvarchar30
TOPAccounting
22TDIOA_BAL_CONDAssignment Condition Type to Flow Type Grouping - IOA Calc.3GSARTProduct Typenvarchar30
23TDIOA_FT_BALANCEAssignment of Flows to Flow Type Grouping - IOA Calculation3GSARTProduct Typenvarchar30
24TDIOA_GSTEERGeneral Control Data for Interest on Arrears Calculation3GSARTProduct Typenvarchar30
25TDIOA_SCHEME_BALAssignment of Product Type to Profile and Flow Type Grouping3GSARTProduct Typenvarchar30
26TDIOA_TEMPLTemplate for Interest On Arrears Calculation3GSARTProduct Typenvarchar30
27TDIOA_TEMPLTXTTemplate Texts for Interest on Arrears Calculation4GSARTProduct Typenvarchar30
28TDIOA_TRIV_AMTTrivial Amount per Currency and Profile IOA Calculation3GSARTProduct Typenvarchar30
TOPBack Office
29TRFC_MRG_FTAssign Update Types for Margin Management2GSARTProduct Typenvarchar30
TOPBasic Functions
30T036VAllocation of planning levels for Financial Assets Mgmt3GSARTProduct Typenvarchar30
TOPFinancial Services
31BWFS_CML_SELECSelection Table for FS-CML4GSARTProduct Typenvarchar30
32VDBIW_DATAExtractor Flow Data - Data of Last Extraction12GSARTProduct Typenvarchar30
TOPGermany
33TZ41Customizing reg. report. fld. ctrl. for prem. res. fund2GSARTProduct Typenvarchar30
TOPInformation System
34FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW8GSARTProduct Typenvarchar30
TOPLoans Management
35TD01Table for collateral keys4GSARTProduct Typenvarchar30
36TD03Assign Loan Type -> Product Type2GSARTProduct Typenvarchar30
37TD07Purpose of loan2GSARTProduct Typenvarchar30
38TD07TPurpose of loan (Texts for table TD07)3GSARTProduct Typenvarchar30
39TDA5Non-Accept.Reason3GSARTProduct Typenvarchar30
40TDA5TReason for non-acceptance (texts for TDA5)4GSARTProduct Typenvarchar30
41TDALE_EXP_LOANALE Export Relevance Per Loan3GSARTProduct Typenvarchar30
42TDB23Activity Type - Control of Requirements3GSARTProduct Typenvarchar30
43TDBO_CONDNStandard Conditions3GSARTProduct Typenvarchar30
44TDCAPTR_GSTEERGeneral Control Data of Capital Transfer3GSARTProduct Typenvarchar30
45TDCAPTR_TEMPLTemplates for Capital Transfer3GSARTProduct Typenvarchar30
46TDCAPTR_TEMPLTXTTexts for Capital Transfer Templates3GSARTProduct Typenvarchar30
47TDCAP_CONDCondition amount for capitalization3GSARTProduct Typenvarchar30
48TDCONDVER_MSGCondition Verification: Update Checks and Define Msge Type2GSARTProduct Typenvarchar30
49TDDEBTTR_GSTEERGeneral Control Data3GSARTProduct Typenvarchar30
50TDDEFPRODControl Dunning Using Product Type3GSARTProduct Typenvarchar30
51TDDEF_CONDCondition amount for deferral3GSARTProduct Typenvarchar30
52TDDEF_LIMITLimit table for deferral interest3GSARTProduct Typenvarchar30
53TDIOA_BO_MGLInterest on Arrears Active in BO for Mortgage/General Loans4GSARTProduct Typenvarchar30
54TDIOA_SCHM_TPLDefault Calculation Profile for New Loan2GSARTProduct Typenvarchar30
55TDKK2Predefine Correspondence Class Assignment for Partner2GSARTProduct Typenvarchar30
56TDLOAN_CPPARTDefault Sttng of Permitted Roles and Roles for Partner Copy3GSARTProduct Typenvarchar30
57TDLOS_CONTROLLoan Origination: Control Parameters2GSARTProduct Typenvarchar30
58TDLOS_PURPOSELoan Origination: Assignment of Loan Purpose4GSARTProduct Typenvarchar30
59TDPAYMLIMITSLimits for Prepayment3GSARTProduct Typenvarchar30
60TDREPAY_GSTEERGeneral Control Data for Payoff and Notice4GSARTProduct Typenvarchar30
61TDREPAY_RECLISTCustomizing for Receivables List3GSARTProduct Typenvarchar30
62TDREPAY_RECLISTTName of Items in Receivables List3GSARTProduct Typenvarchar30
63TDREPAY_RLFLOWSFlow Type Groups for Receivables List for Payoff3GSARTProduct Typenvarchar30
64TDREPAY_RLFLOWSTText Table for TDREPAY_RLFLOWST3GSARTProduct Typenvarchar30
65TDREPAY_TEMPLTable for Payoff and Notice Templates4GSARTProduct Typenvarchar30
66TDREPAY_TEMPLTXTTexts for Payoff Templates5GSARTProduct Typenvarchar30
67TDRP_COND_TYPERepayment schedule: relevant condition types3GSARTProduct Typenvarchar30
68TDRP_FLOW_TYPERepayment schedule: relevant flow types3GSARTProduct Typenvarchar30
69TDTZPA_EXTActivate Country-Specific Functions2GSARTProduct Typenvarchar30
70TRDC_ADMLoan Document Data Summarization: Administration Table5GSARTProduct Typenvarchar30
71TTONFTEXCLOANVom Vergleich ausgeschlossene Darlehen5GSARTProduktartnvarchar30
72TTONFTVDARLTest neue Fima: Grunddaten und VDARL30GSARTProduktartnvarchar30
73TVDSTPosting applications control table3GSARTProduct Typenvarchar30
74TVDSTXPosting applications control table4GSARTProduct Typenvarchar30
75TZB0WAssign Activity Category - Reversal Transaction Grouping3GSARTProduct Typenvarchar30
76TZPAB_ADDONAddon for Financial Assets Management product types3GSARTProduct Typenvarchar30
77VDARC_DOC_ADMAdmin. Table for Reorganization of Loan Document Data7GSARTProduct Typenvarchar30
78VDARLLoans16GSARTProduct Typenvarchar30
79VDARL_RPadContract - Repayment Plan Data27GSARTProduct Typenvarchar30
80VDBEPPFlow Data - Planned Item32GSARTProduct Typenvarchar30
81VDBOBEPPBusiness Operation: Entered and Activated Flow Data32GSARTProduct Typenvarchar30
82VDCHK_GROSS_NETStorage of data for report RFVD_GROSS_TO_NET4GSARTProduct Typenvarchar30
83VDHINTLoans Interested Parties13GSARTProduct Typenvarchar30
84VDKOREFWorklist File for Bal. Sheet Transfer / Acct Assignment Ref.17GSARTProduct Typenvarchar30
85VDORDERBorrower's note loan order data20GSARTProduct Typenvarchar30
86VDPOST_CONTROLData Selection for Debit Position6GSARTProduct Typenvarchar30
87VZFGDRelease data (Informative data for the release procedure)17GSARTProduct Typenvarchar30
88VZFZE_VDBEPPCentral Entry Table for Release Procedure35GSARTProduct Typenvarchar30
89VZFZE_VDNBZECentral Entry Table for Release Procedure11GSARTProduct Typenvarchar30
TOPMaster Data
90TDESC_REASONReason Categories3GSARTProduct Typenvarchar30
91TDESC_REASONTReason Descriptions3GSARTProduct Typenvarchar30
TOPOutgoing Payments
92TDDISB_GSTEERGeneral control data3GSARTProduct Typenvarchar30
93TDDISB_TEMPLDisbursement: Template3GSARTProduct Typenvarchar30
94TDDISB_TEMPLTXTDisbursement: Sample Text3GSARTProduct Typenvarchar30
TOPPortfolio
95TDBILL_PARSettings for Billing2GSARTProduct Typenvarchar30
96TDCAP_CUSTSettings/Preassignments for Capitalization of Overdue Items2GSARTProduct Typenvarchar30
97TDCAP_GSTEERGeneral Control Data3GSARTProduct Typenvarchar30
98TDCHARGE_GSTEERGeneral Control Data3GSARTProduct Typenvarchar30
99TDDEF_CUSTSettings/Preassignments for Deferral2GSARTProduct Typenvarchar30
100TDDEF_GSTEERGeneral Control Data3GSARTProduct Typenvarchar30
101TDREMIT_ZIPAssignment of Remittance Code to Postal Code2GSARTProduct Typenvarchar30
102VDCNCLRescission of Business Operation21GSARTBusiness type (interest reference)nvarchar30
TOPReal Estate Management
103TIV26Real Estate Contract Type (Entities)13GSARTProduct Typenvarchar30
104VIBEPPFlow data - Planned items for real estate management38GSARTProduct Typenvarchar30
105VIMI04Old. replaced in 3.0 with VIMIMV80GSARTProduct Typenvarchar30
106VIMI33Offers for a rental unit (-> VIMIMV)46GSARTProduct Typenvarchar30
107VIMIMVLease-Out60GSARTProduct Typenvarchar30
TOPReceivablesPayment Management
108TDMAZNBCustomizing: Automatic Incoming Payment Postprocessing3GSARTProduct Typenvarchar30
109TDPRODPLANAssignment of Product Type to IP Distribution Plan3GSARTProduct Typenvarchar30
110TZB41Account Clearing: Amount Limits4GSARTProduct Typenvarchar30
111TZB42Account Clearing: Checks at Contract Level4GSARTProduct Typenvarchar30
TOPRegulatory reporting for insurance companies
112TISSR_BPV_ANRECHMeldewesen Schweiz - Anrechnungsfaktor5GSARTProduktartnvarchar30
113TZB2VMelderelevante Produktarten Österreich3GSARTProduktartnvarchar30
114TZC3ASteuerung Großkreditmeldung Ö (Vertrag/Promesse)3GSARTProduktartnvarchar30
TOPRisk Analysis
115CFAFOIACT_DETAILFO Integration: Selection of Details5GSARTProduct Typenvarchar30
TOPTransaction Data Pool
116JBDBSTDSAP Banking: Positions20GSARTProduct Typenvarchar30
117JBDFUNCDEAKTDeactivate Datapool Functions3GSARTProduct Typenvarchar30
118JBDOBJ1Object Table for Financial Transactions, General Part4GSARTProduct Typenvarchar30
119TJBD_FOBJ_ARCH_CObject-Specific Customizing JB_FOBJ3GSARTProduct Typenvarchar30
120TJBD_LOAN_ARCH_CObject-Specific Customizing: JB_LOAN2GSARTProduct Typenvarchar30
TOPTransaction Management
121ATARCHIVE01Archiving: Minimum retention period of transaction in system2GSARTProduct Typenvarchar30
TOPTransaction Manager
122AT200Rules for Determining a Tax Indicator5GSARTProduct Typenvarchar30
123AT210Rules for Determining a Taxes for CFM postings5GSARTProduct Typenvarchar30
124IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts4GSARTProduct Typenvarchar30
125IDCFMSETX_COMPCompensating method for Funds (TRM)3GSARTProduct Typenvarchar30
126IDCFM_BST_CFMCustomizing for Balance Sheet Transfer for Brazil3GSARTProduct Typenvarchar30
127IDCFM_BST_CFMACustomizing for Balance Sheet Transfer with VA (obsolete)4GSARTProduct Typenvarchar30
128IDCFM_BST_CFMAVCustomizing for Balance Sheet Transfer with VA (obsolete)4GSARTProduct Typenvarchar30
129IDCFM_BST_CFMITCustomizing for Balance Sheet Transfer for Brazil (obsolete)3GSARTProduct Typenvarchar30
130IDCFM_BST_CFMIT1Customizing for Balance Sheet Transfer for Brazil (obsolete)3GSARTProduct Typenvarchar30
131IDCFM_BST_CUSACustomizing for Balance Sheet Transfer for Brazil (obsolete)4GSARTProduct Typenvarchar30
132IDCFM_BST_CUSAVCustomizing for Balance Sheet Transfer for Brazil (obsolete)4GSARTProduct Typenvarchar30
133IDCFM_BST_CUSTCustomizing for Balance Sheet Transfer for Brazil3GSARTProduct Typenvarchar30
134IDCFM_BST_CUSTITCustomizing for Balance Sheet Transfer for Brazil3GSARTProduct Typenvarchar30
135IDCFM_FRIM_DATAImpairment Main Data27GSARTProduct Typenvarchar30
136RDPT_SETQuantity of Redemption Schedules4GSARTProduct Typenvarchar30
137TPMA_DERIV_ASSGNAssignment of Derivation Categories4GSARTProduct Typenvarchar30
138TPMB_LAC_INTERVFlexible LAC Calculation3GSARTProduct Typenvarchar30
139TRGC_DERIV_ASSGNTreasury: Assignment of Derivation Categories4GSARTProduct Typenvarchar30
140VWACTCLASSIFCapitalization of Classification for Product Types2GSARTProduct Typenvarchar30
141VWFL_FT_DECFM: Assign Update Type to Flow Type2GSARTProduct Typenvarchar30
142VWT_DEFDEP_PTCFM: Default Value Securities Account per Product Type4GSARTProduct Typenvarchar30
TOPTransfer to Financial Accounting
143TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.9GSARTProduct Typenvarchar30
TOPTreasury
144TZ40Customizing regulatory reporting field control for contract2GSARTProduct Typenvarchar30
145TZBPVControl table for CH regulatory reporting (BPV)2GSARTBusiness type (interest reference)nvarchar30
146TZC37Financial Assets Management status definition3GSARTProduct Typenvarchar30
147TZPAFinancial Assets Management Product Types2GSARTProduct Typenvarchar30
148TZPABFinancial Assets Management product types3GSARTProduct Typenvarchar30
149TZPATFinancial Assets Management product type texts3GSARTProduct Typenvarchar30
150VWPANLAAsset master for securities7GSARTProduct Typenvarchar30
151VWPT_FREE_ATTRFree Security Attributes4GSARTProduct Typenvarchar30
TOPTreasury and Risk Management
152TZRR2Treasury: Valuation Areas at Company Code/Product Type Level3GSARTProduct Typenvarchar30