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

58 columns | Print definition?ERP 6.0  | PARTN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1J_3RF_TP_CP_SBCDControllable Partners. Data saved in backgroud. BC Documents9PARTNPartnernvarchar100
2J_3RF_TP_CP_SNBDControllable Partners. Data saved in backgroud. NonBC Docum9PARTNPartnernvarchar100
3T510OCost-of-Living Allowances -BAT-4PARTNPartnershipnvarchar20
4T5D5AOBSOLETE: Check Table for COLA Level/Partner Indicator3PARTNPartnershipnvarchar20
5T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)13PARTNPartner account numbernvarchar100
TOPBank Customer Accounts
6BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA15PARTNPartner numbernvarchar170
TOPBasic Functions
7FEBEPElectronic Bank Statement Line Items40PARTNBusiness Partnernvarchar550
8T028PAssign Search Strings to Bank Statement Transactions11PARTNBusiness Partnernvarchar550
TOPCash Desk
9FMSHERLOCKClarification List (Payments to be Clarified)23PARTNBusiness Partnernvarchar550
TOPContract Accounts Receivable and Payable
10FKKBEPElectronic Bank Statement Line Items40PARTNBusiness Partnernvarchar550
TOPJoint Venture und Production Sharing Accounting
11JVBXJV Billing Database (INDX-Table)11PARTNPartner account numbernvarchar100
12JVOO1Object Table for FI-SL Table JVTO121PARTNPartner account numbernvarchar100
13JVOO2JV Billing FI-SL Object Table10PARTNPartner account numbernvarchar100
14JVPSC01AActual line item table34PARTNPartner account numbernvarchar100
15JVPSC01CObject table 29PARTNPartner account numbernvarchar100
16JVPSC01PPlan line item table34PARTNPartner account numbernvarchar100
17JVPSC01TSummary table33PARTNPartner account numbernvarchar100
18JVT1JV Summary Table13PARTNPartner account numbernvarchar100
19PSAITPSA Document Items18PARTNPartner account numbernvarchar100
20PSCITPSC document line items18PARTNPartner account numbernvarchar100
21T8J4BJV Cash Call Batch table5PARTNPartner account numbernvarchar100
22T8J4CBill Trans Fields Table (Deprecated -> replaced by T8J4G)9PARTNPartner account numbernvarchar100
23T8J4GNon-Op saved bills - Header Info (for holding bills)7PARTNJV Operatornvarchar100
24T8J6NJV EDI Processed Partners/Ventures6PARTNJV partnernvarchar100
25T8J9CJoint operating agreement partner shares5PARTNJV partnernvarchar100
26T8JBI_THJVA billing thresholds3PARTNPartner account numbernvarchar100
27T8JBI_THDJVA billing threshold details3PARTNPartner account numbernvarchar100
28T8JDCJV EDI Inbound: Sender's JIBE/PASC Number Table4PARTNPartner account numbernvarchar100
29T8JOPartner3PARTNJV partnernvarchar100
30T8JOACompany addresses3PARTNJV partnernvarchar100
31T8JOATCompany addresses (text)4PARTNJV partnernvarchar100
32T8JQJoint Venture Owner Equity5PARTNJV partnernvarchar100
33T8PSA_CLOS_STOCKPSA Closing Stock per Partner9PARTNJV partnernvarchar100
34T8PSA_EGPSC Equity Group5PARTNJV partnernvarchar100
35T8PSA_EG_HISTPSC Equity Group History Information8PARTNJV partnernvarchar100
36T8PSA_LIFT_VOLLifting Volumes11PARTNPartner account numbernvarchar100
37T8PSA_STOCK_ADJPSA Stock Adjustment14PARTNJV partnernvarchar100
38T8PSC_LIFTPSC Lifting Data10PARTNJV partnernvarchar100
TOPLoans Management
39VDZNB_PAYINFOPayment Postprocessing: Payment Inform. for a PPP Activity16PARTNBusiness Partnernvarchar550
40VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity27PARTNBusiness Partnernvarchar550
TOPPayment Transactions
41FIBL_RPCODEMaster Data for Repetitive Code14PARTNReference to Business Partner Receiving Paymentnvarchar160
TOPPayroll
42T7UAF230Form 23 rows3PARTNPart numbernvarchar10
43T7UAF230TForm 23 rows texts4PARTNPart numbernvarchar10
44T7UAF231Form 23 rows3PARTNPart numbernvarchar10
45T7UAF232Form 23 rows3PARTNPart numbernvarchar10
46T7UAF23PForm 23 parts3PARTNPart numbernvarchar10
47T7UAF23PTForm 23 parts texts4PARTNPart numbernvarchar10
TOPPersonnel Administration
48PA0008HR Master Record: Infotype 0008 (Basic Pay)30PARTNPartnershipnvarchar20
TOPProduction and Revenue Accounting
49OIUCM_T8JOPRA Partner Table from JV3PARTNCustomer Numbernvarchar100
TOPProject Risk Management for Contractors
50/SAPPCE/HRP1960DB table for info type 196019PARTNJoint Venture Partnernvarchar100
51/SAPPCE/JVA_T8JOE&C version of table T8JO3PARTNJoint Venture Partnernvarchar100
52/SAPPCE/JVA_T8JVE&C table for JVA master data5PARTNJoint Venture Partnernvarchar100
TOPPublic Sector
53PA0237HR Master Record: Infotype 0237 / View for 0052 (PSG)27PARTNPartnershipnvarchar20
TOPRecruitment
54PB0008Applicant Master Record Infotype (Basic Pay)30PARTNPartnershipnvarchar20
TOPRussia
55T7RUM0Military card information catalogue2PARTNSection in Military Catalognvarchar20
TOPService Process Warranty
56WTYSCC_STATMAPClaim status mapping2PARTNPartner Parts that Have to Be Returnednvarchar10
TOPWarranty Claim Processing
57CWTY004Status for Parts that Have to Be Returned2PARTNPartner Parts that Have to Be Returnednvarchar10
58CWTY004TTexts for Parts Statuses2PARTNPartner Parts that Have to Be Returnednvarchar10