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

111 columns | Print definition?ERP 6.0  | SANLF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECI_HDRBD ECF - Import Table Header Data6SANLFRBD: Product Categorynvarchar30
2/IBS/TRB_ECM_HDRBD ECF: Manual Contract Management - Header Data7SANLFRBD: Product Categorynvarchar30
3TDA10Alloc. of trans.codes to ok-codes and screen overview3SANLF3-Byte fieldnvarchar30
4TDA11Allocation of OK-codes to the trans.codes2SANLF3-Byte fieldnvarchar30
5TVROAAllocation of roles to partner / screen control4SANLFProduct Categorynvarchar30
6TZT01Derivation rules for tax flows3SANLFProduct Categorynvarchar30
7VDMODELCALC_RESResidence Time for Model Calculation Archiving2SANLFProduct Categorynvarchar30
8VDSEPA_AUTODEBRecords for new auto debit (SEPA direct debit)17SANLFProduct Categorynvarchar30
9VDSEPA_AUTODEB_ORecords for new auto debit (SEPA direct debit) (up to 604)17SANLFProduct Categorynvarchar30
10VTIULUnderlying Objects3SANLFProduct Categorynvarchar30
TOPAssetLiability Management
11JBNIPLALM Non Interest Profit and Loss6SANLFProduct Categorynvarchar30
TOPBank Components
12JBDMKSECUAddition to Req./Opt.Control for Security Class Data1SANLFProduct Categorynvarchar30
TOPBusiness Partner
13VTBSTA1Allocation of Payment Details as Standing Instructions6SANLFProduct Categorynvarchar30
14VTBSTA2Standing Instructions for Correspondence5SANLFProduct Categorynvarchar30
15VTBSTA3SI for Business Partner: Transaction Authorizations5SANLFProduct Categorynvarchar30
16VTBSTA4SI for Business Partner: Derived Flows5SANLFProduct Categorynvarchar30
TOPGermany
17TZ28_ARCHIVAsset Type According to Regulatory Accounting Requirements2SANLFProduct Categorynvarchar30
18TZ28_UMSUmsetzungstab. Gesetzesänderung BAV 20022SANLFProdukttypnvarchar30
19TZR96Circular R5/97 Control Table for Report Program RFVZBR009SANLFProduct Categorynvarchar30
TOPLoans Management
20TDCONDVER_ACPCondition Verification: Permitted Condition Constellation1SANLFProduct Categorynvarchar30
21TDCONDVER_FCCondition Verification: Define Field Properties1SANLFProduct Categorynvarchar30
22TDCONDVER_FPCondition Verfier: Field Item Customizing1SANLFProduct Categorynvarchar30
23TDCONDVER_FVCondition Verification: Define Permitted Field Values1SANLFProduct Categorynvarchar30
24TDCONDVER_SBFIMACondition Verification: Permitted Flow Categories1SANLFProduct Categorynvarchar30
25TDCONDVER_SBZITICondition Verfication: Permitted Calculation Categories1SANLFProduct Categorynvarchar30
26TDRP_COND_TYPERepayment schedule: relevant condition types2SANLFProduct Categorynvarchar30
27TDRP_FLOW_TYPERepayment schedule: relevant flow types2SANLFProduct Categorynvarchar30
28TRDC_ADMLoan Document Data Summarization: Administration Table4SANLFProduct Categorynvarchar30
29TTONFTEXCLOANVom Vergleich ausgeschlossene Darlehen6SANLFProdukttypnvarchar30
30TTONFTVDARLTest neue Fima: Grunddaten und VDARL29SANLFProdukttypnvarchar30
31TTONFTVZZKOKOTest neue FIMA: VZZKOKO4SANLFProdukttypnvarchar30
32VDARC_DOC_ADMAdmin. Table for Reorganization of Loan Document Data6SANLFProduct Categorynvarchar30
33VDARLLoans15SANLFProduct Categorynvarchar30
34VDARL_RPadContract - Repayment Plan Data28SANLFProduct Categorynvarchar30
35VDAUSZDrawings on Disbursement17SANLFProduct Categorynvarchar30
36VDBEKIFlow Data: Document Header for Actual Record4SANLFProduct Categorynvarchar30
37VDBEKI_SHADOWShadow Table for VDBEKI (Restrictions)4SANLFProduct Categorynvarchar30
38VDBEPPFlow Data - Planned Item28SANLFProduct Categorynvarchar30
39VDBOBEPPBusiness Operation: Entered and Activated Flow Data28SANLFProduct Categorynvarchar30
40VDCHK_GROSS_NETStorage of data for report RFVD_GROSS_TO_NET3SANLFProduct Categorynvarchar30
41VDHINTLoans Interested Parties12SANLFProduct Categorynvarchar30
42VDKOKO_EUCondition Header Data Before EURO Conversion (Loans)3SANLFProduct Categorynvarchar30
43VDKOPO_EUCondition Item Data Before EURO Conversion (Loans)3SANLFProduct Categorynvarchar30
44VDKOREFWorklist File for Bal. Sheet Transfer / Acct Assignment Ref.16SANLFProduct Categorynvarchar30
45VDORDERBorrower's note loan order data18SANLFProduct Categorynvarchar30
46VZFZE_VDAUSZCentral Entry Table for Release Procedure19SANLFProduct Categorynvarchar30
47VZFZE_VDBEKICentral Entry Table for Release Procedure7SANLFProduct Categorynvarchar30
48VZFZE_VDBEPPCentral Entry Table for Release Procedure31SANLFProduct Categorynvarchar30
TOPMarket Risk Analyzer
49VTVFGKOZUAssignment TR Product Category Risk Management Indicator2SANLFProduct Categorynvarchar30
TOPMaster Data
50VDESCROWKOKO0TEMPORARY USE: Escrow Condition Headers7SANLFProduct Categorynvarchar30
TOPReal Estate Management
51TIVCN06RE Contract: Product Category <-> AcctDet. Application1SANLFProduct Categorynvarchar30
52VIBEPPFlow data - Planned items for real estate management37SANLFProduct Categorynvarchar30
53VIKOKOReal Estate condition header3SANLFProduct Categorynvarchar30
54VZZKOPO_DMAmount fields for VZZKOPO in original currency3SANLFProduct Categorynvarchar30
TOPReceivablesPayment Management
55TDPRODTYPHIERARCAssignment of Product Category to Payment Hierarchy2SANLFProduct Categorynvarchar30
56TZB41Account Clearing: Amount Limits3SANLFProduct Categorynvarchar30
57TZB42Account Clearing: Checks at Contract Level3SANLFProduct Categorynvarchar30
TOPRegulatory reporting for insurance companies
58TISSR_MAP_FCODEISSR: Mappingtabelle für Funktionscodes des Vorsystems3SANLFProdukttypnvarchar30
59VBUSTArten der Börsenumsatzsteuer3SANLFProdukttypnvarchar30
TOPRisk Analysis
60JBRSVABESTRM: Header Table SDTFT (Additional Info.) for Saved Datasets9SANLFProduct Categorynvarchar30
TOPSingle Transaction Costing
61JBTKREGCosting Rule35SANLFProcedure Groupnvarchar30
TOPTransaction Data Pool
62JBDBSTDSAP Banking: Positions18SANLFProduct Categorynvarchar30
63JBDBSTSPosition Control2SANLFProduct Categorynvarchar30
64JBDKOKOADDONAdditional Information on Table VZZKOKO3SANLFProduct Categorynvarchar30
65JBDMKCDFPRequired/Optional Control for Class Data for Fin. Product1SANLFProduct Categorynvarchar30
TOPTransaction Management
66TCHT_HD_SFGDTSFGDT Representation of Instruments29SANLFProduct Categorynvarchar30
67VTB_FMOD_FTRField Modification Definition5SANLFProduct Categorynvarchar30
68VTB_FMOD_SFGZUSTField Modification at Activity Category Level8SANLFProduct Categorynvarchar30
69VTB_PCAT_FMODBDT Field Modification per Product Category3SANLFProduct Categorynvarchar30
TOPTransaction Manager
70AT05Processing Categories1SANLFProduct Categorynvarchar30
71AT05TName: Processing Category2SANLFProduct Categorynvarchar30
72AT06Allocation of Processing Categories to Activity Categories1SANLFProduct Categorynvarchar30
73BCKVZZKOPOBACKUP: Condition Item Table3SANLFProduct Categorynvarchar30
74THMHRT_HRHedge Relationship21SANLFProduct Categorynvarchar30
75THMTS_ASS_D_CALCDerivative Category, Calculation Cat. & Hedge Cat. Assignmnt1SANLFProduct Categorynvarchar30
76TPMA_DERIV_ASSGNAssignment of Derivation Categories3SANLFProduct Categorynvarchar30
77TZKN1Fields as influencing factors for acct assignment reference3SANLFProduct Categorynvarchar30
78TZKN2Allocation of values to value groups3SANLFProduct Categorynvarchar30
79TZKN2TAllocation of values to value groups4SANLFProduct Categorynvarchar30
80TZKN6Allocation of charact. group to acct.ass.ref. via invoice no3SANLFProduct Categorynvarchar30
81TZKN7Acct assignment reference via the invoice no.3SANLFProduct Categorynvarchar30
82TZKN8TR: Acct assignmnt ref.determination Def. value groups3SANLFProduct Categorynvarchar30
83TZKN8TTR: Acct assignmnt ref.determination Def. value groups4SANLFProduct Categorynvarchar30
84VTBFHATransaction11SANLFProduct Categorynvarchar30
85VTBSIZUHedge Allocation44SANLFProduct Categorynvarchar30
86VTBTRA1Transaction Authoriz. for Traders5SANLFProduct Categorynvarchar30
87VTB_TRADER_AUTHTransparent Table for Trader Authorizations5SANLFProduct Categorynvarchar30
88VTIFHAUnderlying transaction10SANLFProduct Categorynvarchar30
89VWPANLEInterest-bearing securities3SANLFProduct Categorynvarchar30
90VWPTERMWarrants3SANLFProduct Categorynvarchar30
91VZSKOKOCondition header for stock, subscrip.rights, investments4SANLFProduct Categorynvarchar30
TOPTransfer to Financial Accounting
92TRLC_PC_INITTreasury: Product Cats in the Parallel Valuation Classes3SANLFProduct Categorynvarchar30
TOPTreasury
93TPRZ1Partner-Object Relationship3SANLFProduct Categorynvarchar30
94TZ28Asset Type According to Regulatory Accounting Requirements2SANLFProduct Categorynvarchar30
95TZ29BAV asset group stmt 6002SANLFProduct Categorynvarchar30
96TZ30Premium reserve fund list2SANLFProduct Categorynvarchar30
97TZ31Subsection2SANLFProduct Categorynvarchar30
98TZ32BAV asset group stmt 1022SANLFProduct Categorynvarchar30
99TZAFProduct categories1SANLFProduct Categorynvarchar30
100TZAFTProduct categories text2SANLFProduct Categorynvarchar30
101TZPAFinancial Assets Management Product Types4SANLFProduct Categorynvarchar30
102VWPAKTIStock, subscription rights, investment certificates3SANLFProduct Categorynvarchar30
103VWPANLAAsset master for securities3SANLFProduct Categorynvarchar30
104VWPT_FREE_ATTRFree Security Attributes3SANLFProduct Categorynvarchar30
105VZZKOPAAlternative condition item - conditions3SANLFProduct Categorynvarchar30
106VZZKOPOTable condition items3SANLFProduct Categorynvarchar30
107VZZPAROPartner / Role / Object relationship3SANLFProduct Categorynvarchar30
TOPTreasury and Risk Management
108VZZKOKOTable condition header3SANLFProduct Categorynvarchar30
TOPValue Adjustment
109/IBS/TRB_GUIDKVVRBD: GUID Table Key fields of Contract17SANLFRBD: Product Categorynvarchar30
110/IBS/TRB_IASGHDRBD IAS-GATE Header Data5SANLFRBD: Product Categorynvarchar30
111/IBS/TRB_KVVRBD Assignment RBD Account - Contract Source System17SANLFRBD: Product Categorynvarchar30