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

102 columns | Print definition?ERP 6.0  | PARTNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSBW_REQOBJRequests and objects between tdms ERP and BI6PARTNRPARTNRnvarchar100
2VDARC_RETRetention table for Loans Management4PARTNRBusiness Partner Numbernvarchar100
3VDSEPA_MND_USGOverview of mandates used in Loans Management5PARTNRBusiness Partner Numbernvarchar100
TOPBank Components
4JBDSERVSAP Banking: Master Table for Service Transactions6PARTNRBusiness Partner Numbernvarchar100
5JBKLOBJ1Segment Table for Financial Transactions, CL Part17PARTNRBusiness Partner Numbernvarchar100
TOPBasic Functions
6T028RTRANSRepetitive Transfer Transactions20PARTNRBusiness partnernvarchar100
TOPBusiness Partner
7BP011Employment Data2PARTNRBusiness Partner Numbernvarchar100
8BP021Fiscal Year Information2PARTNRBusiness Partner Numbernvarchar100
9BP1010Creditworthiness Data2PARTNRBusiness Partner Numbernvarchar100
10BP1030BP: Business partner - reporting data2PARTNRBusiness Partner Numbernvarchar100
11BPTRGP_ADREConversion: TR Addresses - PDC Addresses5PARTNRBusiness Partner Numbernvarchar100
12TP017Value Table for Liability Risks3PARTNRBusiness Partner Numbernvarchar100
13VTBSTA1Allocation of Payment Details as Standing Instructions2PARTNRBusiness Partner Numbernvarchar100
14VTBSTA2Standing Instructions for Correspondence2PARTNRBusiness Partner Numbernvarchar100
15VTBSTA3SI for Business Partner: Transaction Authorizations3PARTNRBusiness Partner Numbernvarchar100
16VTBSTA4SI for Business Partner: Derived Flows3PARTNRBusiness Partner Numbernvarchar100
17VTBSTC1Components of Payment Details for Standing Instruction2PARTNRBusiness Partner Numbernvarchar100
TOPBusiness Partner Enhancements for Financial Services
18BP000Business Partner Master (General Data)2PARTNRBusiness Partner Numbernvarchar100
19BP030BP: Business partner - address2PARTNRBusiness Partner Numbernvarchar100
20BP1000BP: Business Partner - Role2PARTNRBusiness Partner Numbernvarchar100
21BP1020BP: Business Partner - Fiscal Data2PARTNRBusiness Partner Numbernvarchar100
22BP1040Business partner: Reporting data in company code2PARTNRBusiness Partner Numbernvarchar100
23BP1050Business Partner: General Control Data2PARTNRBusiness Partner Numbernvarchar100
24BP1060OBSOLETE: Business Partner: Company Code Control Data2PARTNRBusiness Partner Numbernvarchar100
25BP3000BP: Additional Data (from Darwin-BP)2PARTNRBusiness Partner Numbernvarchar100
26UBBP000TR-EDT: Transfer Business Partners2PARTNRBusiness Partner Numbernvarchar100
TOPData Staging
27RSDELPARTAggregation management of the IC for the Monitor5PARTNRMaster data IDint100
28RSSTATMANPARTStore for G_T_PART of Request Display in DTA Administration4PARTNRNumeric Character Field, Length 10nvarchar100
29RSSTATMANPARTTStore for G_T_PART of Request Display in DTA Administration5PARTNRNumeric Character Field, Length 10nvarchar100
30RSSTATMANPSAStore for G_T_PART of Request Display in DTA Administration3PARTNR10 digit numbernvarchar100
31RSSTATMANPSATStore for G_T_PART of Request Display in DTA Administration4PARTNR10 digit numbernvarchar100
32RSSTATMANT_SAVE2Store for G_T_PART of Request Display in DTA Administration5PARTNRNumeric Character Field, Length 10nvarchar100
33RSSTATMAN_SAVE2Store for G_T_PART of Request Display in DTA Administration4PARTNRNumeric Character Field, Length 10nvarchar100
TOPDB2 for OS39
34DB2DB02EXTENTSTx DB02: Data for DB02's Extent Monitor3PARTNRNumber of partitionint100
35DB2IXBACKList of indexes that need a backup25PARTNRPartition numbersmallint50
36DB2TSBACKList of tablespaces that need a backup27PARTNRPartition numbersmallint50
TOPDefault Risk and Limit System
37BCKKLFAZ01Backup for Facilities9PARTNRPrimary Business Partnernvarchar100
38KLARPDefault Risk Line Items5PARTNRBusiness Partner Numbernvarchar100
39KLCMMAPPINGMapping Table for CM and Business Partner6PARTNRBusiness Partner Numbernvarchar100
40KLFAZ01Facilities (Header)9PARTNRPrimary Business Partnernvarchar100
41KLNT01Definition of Netting Group4PARTNRBusiness Partner Numbernvarchar100
42KLREPRisk Line Items4PARTNRBusiness Partner Numbernvarchar100
43KLSDCPROT3Log Gen. for Single Transaction Check: Result in ALV Format10PARTNRBusiness Partner Numbernvarchar100
44KLSI06Global Collateral (Assignment)4PARTNRBusiness Partner Numbernvarchar100
45KLSI06_BAKBackup for Euro Changeover for Global Collateral (Assignmt)4PARTNRBusiness Partner Numbernvarchar100
46VTBLIDLimit: Details of Utilizations (Single Records)9PARTNRBusiness Partner Numbernvarchar100
47VTBLRHReservations for Limit Amounts (Header)7PARTNRBusiness Partner Numbernvarchar100
48VTBLSLimits: Mapping Logical - Physical Keys6PARTNRBusiness Partner Numbernvarchar100
49VTBLSDGlobal Collateral: Utilizations - Details9PARTNRBusiness Partner Numbernvarchar100
TOPFlexible Real Estate Management
50VIFEIGENTLUM: Flurstück - Eigentümer4PARTNRGeschäftspartnernummer Eigentümernvarchar100
51VIGBOOKLUM: Grundbuch3PARTNRGeschäftspartnernummernvarchar100
52VIVNACHWLUM: Veränderungsnachweis - Allgemeine Daten4PARTNRGeschäftspartnernummer Katasteramtnvarchar100
TOPInformation System
53FTI_BUT000_TTemporary Text Tables for Business Partners (Performance)3PARTNRBusiness Partner Numbernvarchar100
TOPLoans Management
54VDAUSZDrawings on Disbursement48PARTNRBusiness Partner Numbernvarchar100
55VDCBR_HISTHistory of Data Supplied to Credit Bureau8PARTNRBusiness Partner Numbernvarchar100
56VDGPOLoan: Relationship Partner/Role Object4PARTNRBusiness Partner Numbernvarchar100
57VDINSURE_PARTNE0Do Not Use: Link Partner <-> Insurance3PARTNRBusiness Partner Numbernvarchar100
58VDORDERBorrower's note loan order data52PARTNRBusiness Partner Numbernvarchar100
59VDREPAYMENTPayoff Master Data66PARTNRPayer of Payoffnvarchar100
60VDSONSISpecial Arrangements for Collateral5PARTNRBusiness Partner Numbernvarchar100
61VDZKPAssign Partner / Correspondence Class not Required2PARTNRBusiness Partner Numbernvarchar100
62VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity11PARTNRBusiness Partner Numbernvarchar100
63VZFZE_VDAUSZCentral Entry Table for Release Procedure50PARTNRBusiness Partner Numbernvarchar100
TOPProfitability Analysis
64CE1E_B1Model Bank59PARTNRBusiness Partner Numbernvarchar100
65CE2E_B1Model Bank43PARTNRBusiness Partner Numbernvarchar100
66CE4E_B1Model Bank26PARTNRBusiness Partner Numbernvarchar100
67CE4E_B1_ACCTModel Bank27PARTNRBusiness Partner Numbernvarchar100
68CE4E_B1_FLAGModel Bank23PARTNRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
69CE4E_B1_KENCModel Bank25PARTNRBusiness Partner Numbernvarchar100
TOPReal Estate Management
70S401RE standard analysis partner11PARTNRBusiness Partner Numbernvarchar100
71S408Land registers45PARTNRBusiness Partner Numbernvarchar100
72VIAR02RE: REse@rch - RE Requests83PARTNRBusiness Partner Numbernvarchar100
73VICNSCSRHReal Estate Contract: Service Charge Settlement Header4PARTNRBusiness Partner Numbernvarchar100
74VIEA06Management information: Owner for owner settlement10PARTNRPartner numbernvarchar100
75VIGBUCHLand register3PARTNRBusiness Partner Numbernvarchar100
76VIMI32Other collateral12PARTNRPartner numbernvarchar100
77VIMIIHInvoice Header5PARTNRBusiness Partner Numbernvarchar100
78VIMIWBAccomm.entitlement certif. for application and LO2PARTNRBusiness Partner Numbernvarchar100
TOPRisk Analysis
79JBRDBKORM: DB Table Header Information Extended Risk Object12PARTNRBusiness Partner Numbernvarchar100
80JBRHKORM: Version Table: Header Information: Extended Risk Object13PARTNRBusiness Partner Numbernvarchar100
81JBRSVKORM: Header Table of SDTFT for Saved Datasets7PARTNRBusiness Partner Numbernvarchar100
TOPTraders and Schedulers Workbench
82OIJNOMCOIL-TSW: Nomination copy table25PARTNRLocation Partnernvarchar100
83OIJNOMINomination Item25PARTNRLocation Partnernvarchar100
84OIJNOMIVERSNomination Item Version Table27PARTNRLocation Partnernvarchar100
85OIJ_EL_DOC_I_REFDocument item reference to nomination38PARTNRLocation Partnernvarchar100
86OIJ_SCHEDPlanned Schedule Lines76PARTNRLocation Partnernvarchar100
87S430SIS: (OIL-TSW) Sales document statistics by TSW object37PARTNRLocation Partnernvarchar100
88S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object42PARTNRLocation Partnernvarchar100
TOPTransaction Management
89AT81M1Assignment Table: SWIFT Code of Sender -> Business Partner3PARTNRBusiness Partner Numbernvarchar100
90TCHT_HD_SFGDTSFGDT Representation of Instruments26PARTNRBusiness Partner Numbernvarchar100
TOPTransaction Manager
91TCORT_BP_ASSIGN(Obsolete) TCOR: Assignment of Profile & BP Group to BP3PARTNRBusiness Partner Numbernvarchar100
92TCORT_COCorrespondence Administrative Data17PARTNRBusiness Partner Numbernvarchar100
93TCORT_EXT_ASSIGNAssignments of Profiles & BP groups to external recipients2PARTNRBusiness Partner Numbernvarchar100
94TCORT_INB_ASSIGNBP group assignment for Inbound Correspondence2PARTNRBusiness Partner Numbernvarchar100
95TCORT_INB_FUNCInbound CO function assignment3PARTNRBusiness Partner Numbernvarchar100
96VTBMAPAMaster Agreement: Permitted Bus. Partners3PARTNRBusiness Partner Numbernvarchar100
TOPTreasury
97SPBB1Partner-Bank relationship2PARTNRPartner numbernvarchar100
98SPKR1Partner-Vendor relationship2PARTNRPartner numbernvarchar100
99VZGPOPartner/role object relationship4PARTNRBusiness Partner Numbernvarchar100
100VZPARZAPartner addit. data (general part)2PARTNRPartner numbernvarchar100
101VZROLLEPartner / role list2PARTNRPartner numbernvarchar100
102VZZPAROPartner / Role / Object relationship7PARTNRPartner numbernvarchar100