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

83 columns | Print definition?ERP 6.0  | TIMSTMP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RSCRMPACK_LOGPackaging log2TIMSTMPnvarchar220
TOPCommand and Support Relationships
2/ISDFPS/FORCMDAttributes of Task Organization12TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
3/ISDFPS/FORCMDIDSupply Relationship IDs9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
4/ISDFPS/FORMNTAttributes of Maintenance Relationships12TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
5/ISDFPS/FORMNTIDIDs of Maintenance Relationships9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
6/ISDFPS/FOROTHAttributes of Additional Relationships12TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
7/ISDFPS/FOROTHIDIDs of Other Relationships9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
8/ISDFPS/FORSUPAttributes of Supply Relationships12TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
9/ISDFPS/FORSUPIDSupply Relationship IDs9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
10/ISDFPS/ORCMDTask Organizations18TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
11/ISDFPS/ORMNTMaintenance Relationships18TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
12/ISDFPS/OROTHAdditional Relationships18TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
13/ISDFPS/ORSUPSupply Relationships18TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
14/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)18TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
TOPEngineering Change Management
15EDGERelation Between Change Numbers7TIMSTMPUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
16ENODENodes ECH5TIMSTMPUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPForce Element
17/ISDFPS/FORBEAttributes of HR - BE Relationship9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
18/ISDFPS/FORBEIDIDs of HR - BE Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
19/ISDFPS/FORCEForce Element (Database)25TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
20/ISDFPS/FORCEMAuthorized Materials18TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
21/ISDFPS/FORCEPMaterial Packages11TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
22/ISDFPS/FORCERReference Force Element (Database)7TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
23/ISDFPS/FORCNAttributes of REC - HR Relationship9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
24/ISDFPS/FORCNIDIDs of HR - REC Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
25/ISDFPS/FORDELPlanned Delimitation and Deletion Operations12TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
26/ISDFPS/FOREPAAttributes of the Force Element - EPA Relationships9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
27/ISDFPS/FOREPAIDIDs of the Force Element - EPA Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
28/ISDFPS/FORIPOFORCER: Authorized Infrastructure: Attributes9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
29/ISDFPS/FORIPOIDFORCER: Authorized Infrastructure: IDs8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
30/ISDFPS/FORMCAttributes of the Material Container-Force Element Relatshp9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
31/ISDFPS/FORMCHAttributes of the Material Container - HR Relationship9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
32/ISDFPS/FORMCHIDIDs of the HR - MC Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
33/ISDFPS/FORMCIDIDs of Material Container - Force Element Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
34/ISDFPS/FORMPHAttributes of the HR - MPO Relationship9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
35/ISDFPS/FORMPHIDIDs of the HR - MPO Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
36/ISDFPS/FORMPOAttributes of the Force Element - MPO Relationship9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
37/ISDFPS/FORMPOIDIDs of the Force Element - MPO Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
38/ISDFPS/FORRICAttributes of the Force Element - RIC Relationship9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
39/ISDFPS/FORRICIDIDs of the Force Element - RIC Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
40/ISDFPS/FORRRFORCER: RE Search Request: Attributes9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
41/ISDFPS/FORRRIDFORCER: RE Search Request: IDs8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
42/ISDFPS/FORTOBAttributes of Relationship to Technical Objects12TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
43/ISDFPS/FORTOBIDIDs of Relationship to Technical Objects9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
44/ISDFPS/FORVPAAttributes of the Force Element - PPA Relationships9TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
45/ISDFPS/FORVPAIDIDs of the Force Element - PPA Relationships8TIMSTMPTime Stamp with Format (YYYYMMDDhhmmss)decimal150
TOPIntegrated Product and Process Engineering
46CMIG_STATUSStatus Table (iPPE Migration)7TIMSTMPTime Stampnvarchar140
47INSTANCEIDGeometric Instance: Identification8TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
48LINEBALLine Balance Versions in iPPE6TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
49MODMIXHModel Mix Header Data4TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
50PALTIDiPPE Alternative: Time-Independent ID and Attributes8TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
51PFOBJIDAssignment of Leading Focus Obj: Node to Focus Master Record11TIMSTMPTime Stamp - Short Formatdecimal150
52PFOBJRAssignment of Focus Object: Relationship to Focus Master Rec11TIMSTMPTime Stamp - Short Formatdecimal150
53PFOBJVAssignment of Focus Object: Variant to Focus Master Record10TIMSTMPTime Stamp - Short Formatdecimal150
54PFOCIDiPPE Focus Master Record12TIMSTMPTime Stamp - Short Formatdecimal150
55PNODIDiPPE Node: Identification10TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
56POSVIDiPPE Variant: Identification8TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
57PPEHDRiPPE Access Object17TIMSTMPShort Time Stamp in PPEHDRdecimal150
58PPESSTATUSiPPE Status, Central Data8TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
59PRELACTRelationships for the SNP and Workshop Plan4TIMSTMPTime Stamp - Short Formatdecimal150
60PRELIDiPPE Relationship: Time-Independent ID and Attributes17TIMSTMPTime Stamp - Short Formatdecimal150
61PRGENGEN Relationships - Relationships Table4TIMSTMPTime Stamp - Short Formatdecimal150
62PROJIDiPPE Assignment Table: PS Objects14TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
63PRTSTTest Relationships - Relationships Table4TIMSTMPTime Stamp - Short Formatdecimal150
64PVSCSQChange Sequence in the PVS4TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
65TIMSTMP_TABTime Stamp Aggregation in iPPE7TIMSTMPTime Stamp - Short Formatdecimal150
TOPLogistical Requirements
66/ISDFPS/PRMPAIDiPPE Relationship: Time-Independent ID and Attributes17TIMSTMPTime Stamp - Short Formatdecimal150
TOPMaterial Categories
67/ISDFPS/PRMPOAttributes of BOM Relationships10TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
68/ISDFPS/PRMPOCAttributes of Relationships Between Matl Container and MPO11TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
69/ISDFPS/PRMPOCIDiPPE Relationship: Time-Independent ID and Attributes17TIMSTMPTime Stamp - Short Formatdecimal150
70/ISDFPS/PRMPOIDiPPE Relationship: Time-Independent ID and Attributes17TIMSTMPTime Stamp - Short Formatdecimal150
TOPResourcen Management
71PREQRRMS-RCP: iPPE Relationship: Equipment Requirement20TIMSTMPTime Stamp - Short Formatdecimal150
72PRPOBARMS-RCP: iPPE Relationship: Operation-Action20TIMSTMPTime Stamp - Short Formatdecimal150
73PRPOBIRMS-RCP: iPPE Relationship: Assignment Relationshps f. Items20TIMSTMPTime Stamp - Short Formatdecimal150
74PRPOBORMS-RCP: iPPE Relationship: Stage-Operation20TIMSTMPTime Stamp - Short Formatdecimal150
75PRPOBRRMS-RCP: iPPE Relationship: Relationships Between Operations20TIMSTMPTime Stamp - Short Formatdecimal150
76PRPOBSRMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage20TIMSTMPTime Stamp - Short Formatdecimal150
77RMSAT_STD_PARA_HRMS-ATL: Header Table Parameter Standardization9TIMSTMPTime Stamp Databasedecimal217
TOPWarranty Claim Processing
78PNWTYHWarranty Claim Header (PVS Node)43TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
79PNWTYVWarranty Claim Version (PVS Node)39TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
80PRWTYiPPE Relationship: Time-Ind. Ident./Attributes Warranty17TIMSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
81PVWTYWarranty Claim Item (PPE Variant)48TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
82WTY_PARTNER_TABPartner for Warranty Claim9TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPWeb Service and SOAP - ABAP
83SRT_TF_LPTable for storing all LP of the TF and delete it afterwards3TIMSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150