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

127 columns | Print definition?ERP 6.0  | RECID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals95RECIDRecovery Indicatornvarchar20
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals96RECIDRecovery Indicatornvarchar20
3/OPT/VIM_1ITEM_SDocument Item101RECIDRecovery Indicatornvarchar20
4/OPT/VIM_TITEMDocument Item101RECIDRecovery Indicatornvarchar20
5AUAASettlement Document: Receiver Segment21RECIDRecovery Indicatornvarchar20
6BSEGAccounting Document Segment210RECIDRecovery Indicatornvarchar20
7BSSEGAccounting Document Segment199RECIDRecovery Indicatornvarchar20
8CNV_20100_CSKBBackup copy - CSKB20RECIDRecovery Indicatornvarchar20
9CNV_20100_SKB1CNV backup copy for SKB135RECIDRecovery Indicatornvarchar20
10CNV_20305_CBUKRSSAP LT: Backup table of CEPC_BUKRS7RECIDRecovery Indicatornvarchar20
11CNV_20305_CEPCSAP LT: Backup table of CEPC38RECIDRecovery Indicatornvarchar20
12FUDT_VDOCBSEGVerification Document Item with Additional Info199RECIDRecovery Indicatornvarchar20
13FUDT_VDOCBSEGEVVerification Document Item in the Entry View199RECIDRecovery Indicatornvarchar20
14FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)199RECIDRecovery Indicatornvarchar20
15GLPOS_C_CTFI Document: Entry View211RECIDRecovery Indicatornvarchar20
16GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items211RECIDRecovery Indicatornvarchar20
17GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items211RECIDRecovery Indicatornvarchar20
18GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items211RECIDRecovery Indicatornvarchar20
19GLPOS_N_CTNew General Ledger: Line Item with Currency Type216RECIDRecovery Indicatornvarchar20
20GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type216RECIDRecovery Indicatornvarchar20
21NNL_ZH308_V9_R04ZH308 V09 Record04 Soll Daten6RECIDnvarchar100
22NNL_ZH308_V9_R06ZH308 V09 Record06 Soll Daten6RECIDnvarchar100
23NNL_ZH308_V9_R16ZH308 V09 Record16 Soll Daten6RECIDnvarchar100
24PA3347HR Master Record Infotype 334732RECIDUnique Record Identifier (ID)nvarchar320
25PAPBSGBH_13_CHESA: Contract table (2012/13 onwards)8RECIDHESA: Record type indicatornvarchar50
26PAPBSGBH_13_PHESA: Person table (2012/13 onwards)7RECIDHESA: Record type indicatornvarchar50
27PAPBSGB_HESA_CHESA Archive table for NISR Contract table8RECIDHESA: Record type indicatornvarchar50
28PAPBSGB_HESA_GRHESA Archive table for NISR Grade table8RECIDHESA: Record type indicatornvarchar50
29PAPBSGB_HESA_PHESA: Archive table for NISR Person table7RECIDHESA: Record type indicatornvarchar50
30PAPBSGB_TPS_ARCHTPS Archive table for TPS Annual return records of type 13RECIDTPS Control record IDnvarchar80
31T052RRules for Issuing Invoices5RECIDRules for Issuing an Invoicenvarchar40
32T5GPBST_CONTROLTPS Control records2RECIDTPS Control record IDnvarchar80
33T7CNTPM_PROCRECTPM: Process Record2RECIDProcess Record IDnvarchar320
34VIXCESM180RECModelo 180 - Witholding Tax Recipients DMEE Line 026RECIDRecipient VAT Registration Numbernvarchar200
35YVIM_1ITEMDocument Item101RECIDRecovery Indicatornvarchar20
TOPAccounting Interface
36GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)213RECIDRecovery Indicatornvarchar20
37GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)213RECIDRecovery Indicatornvarchar20
TOPBasic Functions
38SKB1G/L account master (company code)34RECIDRecovery Indicatornvarchar20
39SKM1Sample G/L accounts32RECIDRecovery Indicatornvarchar20
TOPBelgium
40T5BSRReductions for an employee reported on level 38RECIDRecord identification on SI tapenvarchar30
TOPConstruction Equipment Management
41J_3GBELKDocument File - Header Data96RECIDRecovery Indicatornvarchar20
42J_3GBELPDocument Data - Item Data129RECIDRecovery Indicatornvarchar20
TOPContract Accounts Receivable and Payable
43DFKKTHITransfer Records for Invoice Issue by Third Party18RECIDRecipientnvarchar400
44DFKKTHI_HIST2Reversal: Historical Entries DFKKTHI (w/o Tax Posting)11RECIDRecipientnvarchar400
45DFKKTHI_SUMAggregated Transfer Records for Invoicing9RECIDRecipientnvarchar400
46DFKKTHPTransfer Records for Billing on Behalf of 3rd Party21RECIDRecipientnvarchar400
TOPControlling
47CSKBCost Elements (Data Dependent on Controlling Area)19RECIDRecovery Indicatornvarchar20
48CSKSCost Center Master Data68RECIDRecovery Indicatornvarchar20
TOPCross-Application Components
49AAUUFKOrder master data94RECIDRecovery Indicatornvarchar20
TOPDocument Management System
50DRZADDS: Recipient list (document <-> recipient allocations)8RECIDRecipient for document distributionnvarchar700
51DRZOCDDS: partial order7RECIDRecipient for document distributionnvarchar700
52DRZOPDDS: distribution order package10RECIDRecipient for document distributionnvarchar700
TOPElectronic Bank Statement
53FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)48RECIDRecovery Indicatornvarchar20
54FEB_ACTAcct Assignment Templates48RECIDRecovery Indicatornvarchar20
TOPExternal Services
55ESKNAccount Assignment in Service Package34RECIDRecovery Indicatornvarchar20
TOPFinancial Accounting
56/OPT/VIM_1ITEMDocument Item101RECIDRecovery Indicatornvarchar20
57ACCTITCompressed Data from FI/CO Document84RECIDRecovery Indicatornvarchar20
58EBSEGDoc.Segment of Fin.Accntng External Documents63RECIDRecovery Indicatornvarchar20
59KMZEIFI: Account Assignment Model Item Information41RECIDRecovery Indicatornvarchar20
60KOMUAccount Assignment Templates for G/L Account Items41RECIDRecovery Indicatornvarchar20
61T003Document Types14RECIDDebit Recovery Indicatornvarchar20
62VBSEGADocument Segment for Document Parking - Asset Database40RECIDRules for Issuing an Invoicenvarchar40
63VBSEGSDocument Segment for Document Parking - G/L Account Database67RECIDRecovery Indicatornvarchar20
TOPFinland
64T7FIA0Record Identifiers (ATS)2RECIDRecord identifier for Annual Tax Statementnvarchar80
65T7FIA0TRecord Identifier Texts (ATS)2RECIDRecord identifier for Annual Tax Statementnvarchar80
66T7FIA2Tax Code Assignments to ATS Data Records2RECIDRecord identifier for Annual Tax Statementnvarchar80
67T7FIA3Assign Structure Fields to Tax Codes (ATS)2RECIDRecord identifier for Annual Tax Statementnvarchar80
68T7FIA4Wage Type Assignment to Tax Codes (ATS)4RECIDRecord identifier for Annual Tax Statementnvarchar80
TOPFreight Processing
69VFKNAccount Determination in Shipment Costs Item33RECIDRecovery Indicatornvarchar20
TOPFunctions for U.S. Federal Government
70FMFG_PRIOR_RPTTable for Prior Reported Information2RECIDRecording IDnvarchar160
71FMFG_PRIOR_RPTKFPrior Reported Keyfigures2RECIDRecording IDnvarchar160
TOPFunds Management-Specific Postings
72FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years66RECIDRecovery Indicatornvarchar20
73PSOSEGADocument Segment for Assets Document Parking41RECIDRules for Issuing an Invoicenvarchar40
74PSOSEGSRecurring Request Document Segment, G/L Accounts65RECIDRecovery Indicatornvarchar20
TOPGeneral Ledger Accounting
75BSEG_ADDEntry View of Accounting Document for Additional Ledgers39RECIDRecovery Indicatornvarchar20
76FAGLSKFGeneral Ledger: Statistical Key Figures (Current Values)3RECIDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
77FAGL_SPLINFOSplittling Information of Open Items84RECIDRecovery Indicatornvarchar20
TOPGL Account Posting
78TCJ_POSITIONSCash Journal Document Items55RECIDRecovery Indicatornvarchar20
TOPIntercompany Data Exchange
79EPAYTHPIDE: transfer records for third party payments8RECIDRecipientnvarchar400
80IUEEDPPLOTATHEADDistribution Lot Header8RECIDService Provider That Invoices the Contractnvarchar100
81TINV_BW_TRIG_THITrigger for Delta Extraction of Transfer Recs f. Third Party10RECIDRecipientnvarchar400
TOPInventory Management
82MWZDM07M2ZDM07M213RECIDRecovery Indicatornvarchar20
83RKPFDocument Header: Reservation48RECIDInternal Recovery Indicatornvarchar20
TOPInvoice Verification
84RBCODocument Item, Incoming Invoice, Account Assignment25RECIDRules for Issuing an Invoicenvarchar40
TOPJoint Venture und Production Sharing Accounting
85JVGLFLEX07General Ledger: Joint Venture Accounting Fields4RECIDRecovery Indicatornvarchar20
86JVGLFLEXAGeneral Ledger: Actual Line Items31RECIDRecovery Indicatornvarchar20
87JVGLFLEXPGeneral Ledger: Plan Line Items33RECIDRecovery Indicatornvarchar20
88JVGLFLEXTGeneral Ledger: Totals40RECIDRecovery Indicatornvarchar20
89T8J0GBilling Method Posting Rule Detail6RECIDRecovery Indicatornvarchar20
90T8J5CJV Recovery indicator for supplemental detail3RECIDRecovery Indicatornvarchar20
91T8JJRecovery Indicator3RECIDRecovery Indicatornvarchar20
92T8JJTRecovery Indicator Description4RECIDRecovery Indicatornvarchar20
93T8JPT1Cutback Payment Terms per Recovery Indicator4RECIDRecovery Indicatornvarchar20
94T8JPT2Cutback Payment Terms per RI and Original Payment Terms4RECIDRecovery Indicatornvarchar20
95T8JRIJV Recovery indicator determination method4RECIDRecovery Indicatornvarchar20
96T8JSCJoint Venture Substitute Cost Object5RECIDRecovery Indicatornvarchar20
97T8JWInternal Recovery Indicator2RECIDInternal Recovery Indicatornvarchar20
98T8JWTInternal Recovery Indicator Description3RECIDInternal Recovery Indicatornvarchar20
TOPOperative Structures
99PROJProject definition78RECIDRecovery Indicatornvarchar20
100PRPSWBS (Work Breakdown Structure) Element Master Data104RECIDRecovery Indicatornvarchar20
TOPOverhead Cost Controlling
101CMDT_CCGeneric Master Data: Cost Center Enhancements32RECIDRecovery Indicatornvarchar20
TOPOverhead Cost Orders
102AUFKOrder master data97RECIDRecovery Indicatornvarchar20
103COBRBDistribution Rules Settlement Rule Order Settlement48RECIDRecovery Indicatornvarchar20
104TKB6Account Determination for Settlement8RECIDRecovery Indicatornvarchar20
TOPProduct Safety
105CVDPHDDS: OBSOLETE !! DDOC log, header record12RECIDGeneric recipient numbernvarchar200
TOPProduction Orders
106AFVUDB structure of the user fields of the operation22RECIDRecovery Indicatornvarchar20
TOPProfit Center Accounting
107CEPCProfit Center Master Data Table38RECIDRecovery Indicatornvarchar20
108CEPC_BUKRSAssignment of Profit Centers to a Company Code6RECIDRecovery Indicatornvarchar20
109CMDT_PC_BUKRSGeneric Master Record: Company Code Assign. for Profit Cent.8RECIDRecovery Indicatornvarchar20
TOPPurchasing
110EBKNPurchase Requisition Account Assignment36RECIDRecovery Indicatornvarchar20
111EKKNAccount Assignment in Purchasing Document39RECIDRecovery Indicatornvarchar20
TOPRemaining Beverage - Obsolete Objects
112/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1201RECIDRecovery Indicatornvarchar20
TOPRevenue
113OIUHS_JE_ACC_IDPRA: Journal Entry Posting Rules per Account Type7RECIDRecovery Indicatornvarchar20
114OIUHS_JE_ACC_TYPPRA: Journal Entry Posting Rules per Account Type6RECIDRecovery Indicatornvarchar20
115OIUHS_JE_ACRPRA: Journal Entry Account Categories3RECIDRecovery Indicatornvarchar20
TOPSAP Business Workflow
116SWEINSTCOUInstance Linkage Event - Receiver7RECIDReceiver IDnvarchar900
117SWELOGTable for entries of the event log4RECIDReceiver IDnvarchar900
118SWEQUEUEEvent Queue for Temporary Storage of Triggered Events9RECIDReceiver IDnvarchar900
TOPSAP Healthcare - Industry-Specific Components for Hospitals
119NLVERPRechnungregister-position6RECIDnvarchar100
TOPSelf-Service Procurement
120/SRMERP/D_ACC_ITAccount assignment item33RECIDRecovery Indicatornvarchar20
TOPSimulation
121VSAFVU_CNVersion: User fields in operation in order23RECIDRecovery Indicatornvarchar20
122VSAUFK_CNVersion: Order master data98RECIDRecovery Indicatornvarchar20
123VSEBKN_CNVersion: Purchase requisition account assignment37RECIDRecovery Indicatornvarchar20
124VSPROJ_CNVersion: Project definition79RECIDRecovery Indicatornvarchar20
125VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data105RECIDRecovery Indicatornvarchar20
TOPTemplates
126PROJSStandard project definition80RECIDRecovery Indicatornvarchar20
127PRPSSStandard WBS Element (WBS element) - Master Data87RECIDRecovery Indicatornvarchar20