SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OBOT10Bill Of Exchang Transaction
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

149 columns | Print definition?ERP 6.0  | VORNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000103000PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA5VORNRnvarchar40
2/BIC/B0000103001PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA5VORNRnvarchar40
3/BIC/B0000111000Error Stack DTP_00O2TFWN1YKGA5W5VMZCQUQ9C 00014VORNRnvarchar40
4/OPT/VIM_1ITEM_SDocument Item57VORNROperation/Activity Numbernvarchar40
5/OPT/VIM_TITEMDocument Item57VORNROperation/Activity Numbernvarchar40
6/SYCLO/AUFNR_M1Syclo - Work Order Mobile Data Header3VORNROperation/Activity Numbernvarchar40
7P2B2_C1HCM Declustering B2 - Cost Distribution Table C116VORNROperation/Activity Numbernvarchar40
8P2B2_CWSTHCM Declustering B2 - PDC Time Tickets104VORNROperation/Activity Numbernvarchar40
9P2B2_WSTHCM Declustering B2 - PDC Time Tickets104VORNROperation/Activity Numbernvarchar40
10P2PL_RETROADJPayroll Result PL: Retro, originals and changes26VORNROperation/Activity Numbernvarchar40
11P2PL_RETRODIFPayroll Result PL: Retro, originals and changes26VORNROperation/Activity Numbernvarchar40
12P2PL_RETROMEMPayroll Result PL: Retro, originals and changes26VORNROperation/Activity Numbernvarchar40
13P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)33VORNROperation/Activity Numbernvarchar40
14P2RT_CZDAVP18_0317VORNROperation/Activity Numbernvarchar40
15P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)33VORNROperation/Activity Numbernvarchar40
16P2RX_C1Cost Distribution Table C114VORNROperation/Activity Numbernvarchar40
17P2RX_FUNDAccounting Structure for Funds Management26VORNROperation/Activity Numbernvarchar40
18S981OF ARTICLES POSTES9VORNRNuméro d'opérationnvarchar40
19S981ES981 - Info structurelles4VORNRNuméro d'opérationnvarchar40
20S983SUIVI ATELIER10VORNRNuméro d'opérationnvarchar40
21S983ES983 - Info structurelles5VORNRNuméro d'opérationnvarchar40
22YVIM_1ITEMDocument Item57VORNROperation/Activity Numbernvarchar40
23ZMES_RES_POMES: Rescheduled Production Order3VORNROperation/Activity Numbernvarchar40
24ZQUALITY_PARMSInspection Lot Parameters for material quality task lists4VORNROperation/Activity Numbernvarchar40
TOPABAP List-Based PI Sheet
25COFTPPI Sheet: Process Instructions7VORNROperation/Activity Numbernvarchar40
TOPAccounting Interface
26GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)399VORNROperation/Activity Numbernvarchar40
27GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)399VORNROperation/Activity Numbernvarchar40
TOPActive Quality Control
28QDQLQuality level14VORNROperation Number in the Quality Levelnvarchar40
TOPAttendancesAbsences
29CATSHRCross-Application Time Sheet (CATS): Transfer to HR34VORNROperation/Activity Numbernvarchar40
TOPConfirmations
30AFRDDefault values for collective confirmation62VORNROperation/Activity Numbernvarchar40
31AFRP0Table of planned changes for confirmation (PDC)14VORNROperation/Activity Numbernvarchar40
32AFRUOrder Confirmations70VORNROperation/Activity Numbernvarchar40
33AFRVConfirmation pool24VORNROperation/Activity Numbernvarchar40
34AFRV_DELBackup Copy for Confirmation Pool24VORNROperation/Activity Numbernvarchar40
TOPConstruction Industry
35T5DB4HR Construction Site File8VORNROperation/Activity Numbernvarchar40
36T5DB8Construction Sector: Team Assignment to Work Site30VORNROperation/Activity Numbernvarchar40
37T5DBVConstruction Pay: Cost Assignment: Hostels13VORNROperation/Activity Numbernvarchar40
38T5DBXConstruction Pay: Incentive Wage Connection13VORNROperation/Activity Numbernvarchar40
TOPCost Object
39FCO_DOC_HEADFailure Cost Document Header18VORNROperation/Activity Numbernvarchar40
TOPCross-Application Components
40PLLPOTask list - operation/activity16VORNROperation/Activity Numbernvarchar40
TOPData Collection
41S022SFIS: Order Operation Data for Work Center16VORNROperation/Activity Numbernvarchar40
42S022ES022 - Structural information7VORNROperation/Activity Numbernvarchar40
43S028Reporting Point Statistics15VORNRReporting Pointnvarchar40
44S028ES028 - Structural Information10VORNRReporting Pointnvarchar40
45S161Inspection Results: General28VORNRQMIS Operation Numbernvarchar40
46S162Quantitative Inspection Results30VORNRQMIS Operation Numbernvarchar40
47S163Quantitative Inspection Result: Vendor29VORNRQMIS Operation Numbernvarchar40
48S164Quantitative Inspection Result: Vendor31VORNRQMIS Operation Numbernvarchar40
49S165Inspection Results (General): Customers30VORNRQMIS Operation Numbernvarchar40
50S166Quantitative Inspection Results: Customer31VORNRQMIS Operation Numbernvarchar40
TOPData Transfer
51PPDITTransfer to Accounting: Lines in HR IDOCs22VORNROperation/Activity Numbernvarchar40
52PPDSTTransfer to Accounting: Substituted Acc. Assig. Object11VORNROperation/Activity Numbernvarchar40
53PPKIXTransfer FI/CO: Index of Account Assignment Combinations13VORNROperation/Activity Numbernvarchar40
TOPElectronic Bank Statement
54FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)33VORNROperation/Activity Numbernvarchar40
55FEB_ACTAcct Assignment Templates33VORNROperation/Activity Numbernvarchar40
TOPESS Based on WD ABAP
56HRESS_D_CATS_FAVCATS Favorites: database table125VORNROperation/Activity Numbernvarchar40
TOPFinancial Accounting
57/OPT/VIM_1ITEMDocument Item57VORNROperation/Activity Numbernvarchar40
58KMZEIFI: Account Assignment Model Item Information79VORNROperation/Activity Numbernvarchar40
59KOMUAccount Assignment Templates for G/L Account Items79VORNROperation/Activity Numbernvarchar40
60VBSEGADocument Segment for Document Parking - Asset Database51VORNROperation/Activity Numbernvarchar40
61VBSEGSDocument Segment for Document Parking - G/L Account Database102VORNROperation/Activity Numbernvarchar40
TOPFreight Processing
62VFKNAccount Determination in Shipment Costs Item27VORNROperation/Activity Numbernvarchar40
TOPFunds Management
63KBLPDocument Item: Manual Document Entry105VORNROperation/Activity Numbernvarchar40
TOPFunds Management-Specific Postings
64FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years101VORNROperation/Activity Numbernvarchar40
65PSOSEGSRecurring Request Document Segment, G/L Accounts101VORNROperation/Activity Numbernvarchar40
TOPGeneral Ledger Reorganization
66FAGL_R_SPLReorganization: Splitting Information of the Open Items18VORNROperation/Activity Numbernvarchar40
TOPGL Account Posting
67TCJ_POSITIONSCash Journal Document Items40VORNROperation/Activity Numbernvarchar40
TOPInformation System
68MCAFVGVVersions: Order Procedure9VORNROperation/Activity Numbernvarchar40
69MCSFISR/2 SFIS Data: Old72VORNROperation/Activity Numbernvarchar40
TOPInterface to External Project Software
70NVGUIDGUIDs for Network Activity6VORNROperation/Activity Numbernvarchar40
TOPInventory Management
71RESBReservation/dependent requirements99VORNROperation/Activity Numbernvarchar40
TOPInvoice Verification
72RBCODocument Item, Incoming Invoice, Account Assignment65VORNROperation/Activity Numbernvarchar40
TOPJapan
73T7JPSK_CONTTShukko Contract Template13VORNROperation/Activity Numbernvarchar40
TOPJoint Venture und Production Sharing Accounting
74JVCO1JV Object Table 2 for JVTO14VORNROperation/Activity Numbernvarchar40
75JVPO1JVA: Plan Line Items34VORNROperation/Activity Numbernvarchar40
76JVSO1JV LI Table with Objects for JVTO134VORNROperation/Activity Numbernvarchar40
77JVTO1JV Summary Table with Objects29VORNROperation/Activity Numbernvarchar40
TOPLogbook
78DIACL_DIS_SIGDS : Order operation within Logbook (For Distribution)4VORNROperation/Activity Numbernvarchar40
TOPLogistics Information System LIS
79S281Order Operation, BW9VORNROperation/Activity Numbernvarchar40
80S281BIW1S281BIW1 * Order Process, BW9VORNROperation/Activity Numbernvarchar40
81S281BIW2S281BIW2 * Order Process, BW9VORNROperation/Activity Numbernvarchar40
TOPMaintenance History
82AFVC_DIS_SIGDigital Signature of Order Operation for Distribution4VORNROperation/Activity Numbernvarchar40
83HIMAPM order history - materials3VORNROperation/Activity Numbernvarchar40
84HIVGPM order history - operations3VORNROperation/Activity Numbernvarchar40
TOPMaintenance Orders
85/CUM/ACTIONMCU: Example Action-Task List Operation Mapping Table3VORNROperation/Activity Numbernvarchar40
TOPMaster Data
86MDSMSimulative dependent requirements82VORNROperation/Activity Numbernvarchar40
TOPMaster Data Distribution
87/ISDFPS/TL1Task List - Operation/Activity16VORNROperation/Activity Numbernvarchar40
TOPMaterial Identification and Reconciliation
88BEREITMaterial identification: staging data7VORNROperation/Activity Numbernvarchar40
89MISTATUSStatus Table for Material Identification on Mat./Batch Level7VORNROperation/Activity Numbernvarchar40
TOPPayroll
90T5TPSC1SPLITRozdelení nákladu24VORNRCíslo operacenvarchar40
TOPPermits
91IHSGObject-Related Permits in Plant Maintenance17VORNROperation/Activity Numbernvarchar40
TOPPersonnel Time Events
92TPTCOR_LOGISTICLogistics Orders (Correction Scenario)23VORNROperation numbernvarchar40
TOPPersonnel Time Management
93ASSOBAssignment Objects12VORNROperation/Activity Numbernvarchar40
94CC1ERPIncorrect Time Events from CC1, Postings37VORNROperation numbernvarchar40
95CC1TEVTemporary Buffer for Time Events from CC129VORNROperation/Activity Numbernvarchar40
96COIFTInterface to Activity Allocation44VORNROperation/Activity Numbernvarchar40
97PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)54VORNROperation/Activity Numbernvarchar40
98PTEX2003GENInterface Table for IT 2003: General Information53VORNROperation/Activity Numbernvarchar40
99PTEX2003SPECInterface Table for IT 2003: Interval Information29VORNROperation/Activity Numbernvarchar40
100PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)53VORNROperation/Activity Numbernvarchar40
101TEVEN_MOREAdditional Data for Time Events36VORNROperation numbernvarchar40
TOPPlant Data Collection
102RUECKTemp. storage for subsystem confirmations19VORNROperation/Activity Numbernvarchar40
TOPPlant Maintenance
103Z9I_STK_IF_NPVPM/PS-Schnittstelle: Netzplanvorgänge7VORNRVorgangsnummernvarchar40
104Z9I_STK_IF_NPV_WPM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht7VORNRVorgangsnummernvarchar40
105Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge14VORNRVorgangsnummernvarchar40
106Z9MIANFStillstanndsplanung - Daten für Anfragen12VORNRVorgangsnummernvarchar40
TOPPosition Budgeting and Control
107HRFPM_DIFFERENCEHRFPM: Personnel Costs Savings/ Overrun35VORNROperation/Activity Numbernvarchar40
108HRFPM_FM_POSHRFPM: FM Documents - Items19VORNROperation/Activity Numbernvarchar40
109HRFPM_FM_POS_BUHRFPM: FM Documents - Items for Budget20VORNROperation/Activity Numbernvarchar40
110HRFPM_FPM_POSHRFPM: FPM Documents - Items33VORNROperation/Activity Numbernvarchar40
111HRFPM_FPM_POS_BUHRFPM: FPM Documents - Items for Budget34VORNROperation/Activity Numbernvarchar40
112HRFPM_OBJECTSHRFPM: Object table of the commitment engine29VORNROperation/Activity Numbernvarchar40
TOPProcess Management
113COCQPPPI/QM Integration: Buffer Table for Reporting Results4VORNROperation/Activity Numbernvarchar40
114COFTProcess Management: Process Instructions in Control Recipe5VORNROperation/Activity Numbernvarchar40
115COMQTemporary Storage for Material Production Messages for QM7VORNROperation/Activity Numbernvarchar40
TOPProduct Cost Planning
116CKISItems Unit Costing/Itemization Product Costing89VORNROperation/Activity Numbernvarchar40
TOPProduction Orders
117AFVCOperation within an order11VORNROperation/Activity Numbernvarchar40
118COWIPB_CHVWWIP Batches with Where-Used List28VORNROperation/Activity Numbernvarchar40
119ORDCOMCommunication control Operation download8VORNROperation/Activity Numbernvarchar40
120ORDLYTable of delays for production order5VORNROperation/Activity Numbernvarchar40
TOPProject System
121PSHLPDB_HIER_TMPTable to store temporary hierarchy data11VORNROperation/Activity Numbernvarchar40
122PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy11VORNROperation/Activity Numbernvarchar40
TOPPurchasing
123EKCPAPurchasing Contract Commitment Plan Account Assignment Data16VORNROperation/Activity Numbernvarchar40
TOPQuality Inspection
124TQ30Inspection types16VORNROperation/Activity Numbernvarchar40
TOPRemote Logistics Management
125OIO_RT_RTDOC_MTReturns document - material items18VORNROperation/Activity Numbernvarchar40
TOPRepetitive Manufacturing
126COMPMOVEGoods Movement of Components120VORNROperation/Activity Numbernvarchar40
127RMRPHR Data of Repetitive Manufacturing Backflush6VORNROperation/Activity Numbernvarchar40
TOPResults Recording
128QEWLQM Handheld: Worklist for Transfer6VORNROperation/Activity Numbernvarchar40
129QIWLTransfer table for QM subsystems5VORNROperation/Activity Numbernvarchar40
TOPRouting
130PLPOTask list - operation/activity16VORNROperation/Activity Numbernvarchar40
TOPSamples and SPC
131QASHQuality control chart34VORNROperation/Activity Numbernvarchar40
TOPScheduling
132KBEDCapacity Requirements Records48VORNROperation/Activity Numbernvarchar40
TOPSelf-Service Procurement
133/SRMERP/D_ACC_ITAccount assignment item45VORNROperation/Activity Numbernvarchar40
TOPSimulation
134VSAFVC_CNVersion: Operation in order12VORNROperation/Activity Numbernvarchar40
135VSKBED_CNVersion: Capacity requirement records49VORNROperation/Activity Numbernvarchar40
136VSRESB_CNVersion: Reservation/Dependent requirements100VORNROperation/Activity Numbernvarchar40
TOPSocial Insurance
137T5D3PHR Technical Assignments for Workers' Compensation Assoc.8VORNROperation/Activity Numbernvarchar40
TOPStructures
138PSPR_GRP_IND_PRGrouping Indicators and purchase requisition numbers5VORNROperation/Activity Numbernvarchar40
139PSPR_GR_IND_RELAssignment of group indicator data5VORNROperation/Activity Numbernvarchar40
140PSSKF_RATES_TABSave the SKF rates for the calculation of the work duration.11VORNROperation/Activity Numbernvarchar40
TOPTime Sheet
141CATS_TEMPCATS: Database Table for Templates75VORNROperation/Activity Numbernvarchar40
TOPTime Tickets
142EVHRHR Order Confirmations (Times/Time Events)36VORNROperation numbernvarchar40
143LSHRHR Order Confirmations (Durations/Time Tickets)36VORNROperation numbernvarchar40
TOPTravel Expenses
144PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document21VORNROperation/Activity Numbernvarchar40
TOPTravel Planning
145FTPT_REQ_ACCOUNTTravel Request Cost Assignment16VORNROperation/Activity Numbernvarchar40
TOPVehicle Management System
146VLCSMORDNOTVELO : Link Between Service Notif. and Service Order6VORNROperation/Activity Numbernvarchar40
TOPWork Clearance Management
147WCAAPWCM: Application38VORNRActivity number replaced by sub-networknvarchar40
148WCAHEWCM: Work Clearance Document (Header)38VORNRActivity number replaced by sub-networknvarchar40
149WCAWWCM: Work Approval36VORNRActivity number replaced by sub-networknvarchar40