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

114 columns | Print definition?ERP 6.0  | CHNGDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCommand and Support Relationships
1/ISDFPS/FORCMDAttributes of Task Organization15CHNGDATLast Changed onnvarchar80
2/ISDFPS/FORCMDIDSupply Relationship IDs12CHNGDATLast Changed onnvarchar80
3/ISDFPS/FORMNTAttributes of Maintenance Relationships15CHNGDATLast Changed onnvarchar80
4/ISDFPS/FORMNTIDIDs of Maintenance Relationships12CHNGDATLast Changed onnvarchar80
5/ISDFPS/FOROTHAttributes of Additional Relationships15CHNGDATLast Changed onnvarchar80
6/ISDFPS/FOROTHIDIDs of Other Relationships12CHNGDATLast Changed onnvarchar80
7/ISDFPS/FORSUPAttributes of Supply Relationships15CHNGDATLast Changed onnvarchar80
8/ISDFPS/FORSUPIDSupply Relationship IDs12CHNGDATLast Changed onnvarchar80
9/ISDFPS/ORCMDTask Organizations21CHNGDATLast Changed onnvarchar80
10/ISDFPS/ORCMD1Task Organization, Basic Types of Dependent Attributes6CHNGDATLast Changed onnvarchar80
11/ISDFPS/ORMNTMaintenance Relationships21CHNGDATLast Changed onnvarchar80
12/ISDFPS/ORMNT1Maintenance Relationships, Basic Types, Dependent Attributes6CHNGDATLast Changed onnvarchar80
13/ISDFPS/OROTHAdditional Relationships21CHNGDATLast Changed onnvarchar80
14/ISDFPS/ORSUPSupply Relationships21CHNGDATLast Changed onnvarchar80
15/ISDFPS/ORSUP1Supply Relationships, Basic Types, Dependent Attributes6CHNGDATLast Changed onnvarchar80
16/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)21CHNGDATLast Changed onnvarchar80
TOPConfiguration Control
17CCMHOLEStructure Gap Table10CHNGDATLast Changed Onnvarchar140
TOPEngineering Change Management
18EDGERelation Between Change Numbers10CHNGDATChanged Onnvarchar80
19ENODENodes ECH8CHNGDATChanged Onnvarchar80
TOPForce Element
20/ISDFPS/FORBEAttributes of HR - BE Relationship12CHNGDATLast Changed onnvarchar80
21/ISDFPS/FORBEIDIDs of HR - BE Relationships11CHNGDATLast Changed onnvarchar80
22/ISDFPS/FORCEForce Element (Database)34CHNGDATLast Changed onnvarchar80
23/ISDFPS/FORCEMAuthorized Materials24CHNGDATLast Changed onnvarchar80
24/ISDFPS/FORCEPMaterial Packages16CHNGDATLast Changed onnvarchar80
25/ISDFPS/FORCERReference Force Element (Database)10CHNGDATLast Changed onnvarchar80
26/ISDFPS/FORCE_PRIndividual Threshold Values for Readiness18CHNGDATLast Changed onnvarchar80
27/ISDFPS/FORCNAttributes of REC - HR Relationship12CHNGDATLast Changed onnvarchar80
28/ISDFPS/FORCNIDIDs of HR - REC Relationships11CHNGDATLast Changed onnvarchar80
29/ISDFPS/FORDELPlanned Delimitation and Deletion Operations15CHNGDATLast Changed onnvarchar80
30/ISDFPS/FOREPAAttributes of the Force Element - EPA Relationships12CHNGDATLast Changed onnvarchar80
31/ISDFPS/FOREPAIDIDs of the Force Element - EPA Relationships11CHNGDATLast Changed onnvarchar80
32/ISDFPS/FORIPOFORCER: Authorized Infrastructure: Attributes12CHNGDATLast Changed onnvarchar80
33/ISDFPS/FORIPOIDFORCER: Authorized Infrastructure: IDs11CHNGDATLast Changed onnvarchar80
34/ISDFPS/FORMCAttributes of the Material Container-Force Element Relatshp12CHNGDATLast Changed onnvarchar80
35/ISDFPS/FORMCHAttributes of the Material Container - HR Relationship12CHNGDATLast Changed onnvarchar80
36/ISDFPS/FORMCHIDIDs of the HR - MC Relationships11CHNGDATLast Changed onnvarchar80
37/ISDFPS/FORMCIDIDs of Material Container - Force Element Relationships11CHNGDATLast Changed onnvarchar80
38/ISDFPS/FORMPHAttributes of the HR - MPO Relationship12CHNGDATLast Changed onnvarchar80
39/ISDFPS/FORMPHIDIDs of the HR - MPO Relationships11CHNGDATLast Changed onnvarchar80
40/ISDFPS/FORMPOAttributes of the Force Element - MPO Relationship12CHNGDATLast Changed onnvarchar80
41/ISDFPS/FORMPOIDIDs of the Force Element - MPO Relationships11CHNGDATLast Changed onnvarchar80
42/ISDFPS/FORRICAttributes of the Force Element - RIC Relationship12CHNGDATLast Changed onnvarchar80
43/ISDFPS/FORRICIDIDs of the Force Element - RIC Relationships11CHNGDATLast Changed onnvarchar80
44/ISDFPS/FORRRFORCER: RE Search Request: Attributes12CHNGDATLast Changed onnvarchar80
45/ISDFPS/FORRRIDFORCER: RE Search Request: IDs11CHNGDATLast Changed onnvarchar80
46/ISDFPS/FORTOBAttributes of Relationship to Technical Objects15CHNGDATLast Changed onnvarchar80
47/ISDFPS/FORTOBIDIDs of Relationship to Technical Objects12CHNGDATLast Changed onnvarchar80
48/ISDFPS/FORVPAAttributes of the Force Element - PPA Relationships12CHNGDATLast Changed onnvarchar80
49/ISDFPS/FORVPAIDIDs of the Force Element - PPA Relationships11CHNGDATLast Changed onnvarchar80
TOPIntegrated Product and Process Engineering
50CPATYPECustomizing Table for iPPE Alternative Types12CHNGDATDate of Last Changenvarchar80
51CPNTYPECustomizing Table for iPPE Node Type23CHNGDATDate of Last Changenvarchar80
52CPPECNTLGeneral iPPE Customizing25CHNGDATDate of Last Changenvarchar80
53CPRTYPECustomizing: iPPE Relationships25CHNGDATDate of Last Changenvarchar80
54CPVSMDLModel Associations between the PVS Objects10CHNGDATDate of Last Changenvarchar80
55CPVSMDLCModel Associations between the Customer-Spec. PVS Objects10CHNGDATDate of Last Changenvarchar80
56CPVTYPECustomizing Table for the iPPE Variant Types18CHNGDATDate of Last Changenvarchar80
57INSTANCEIDGeometric Instance: Identification12CHNGDATDate of Last Changenvarchar80
58LINEBALLine Balance Versions in iPPE9CHNGDATDate of Last Changenvarchar80
59MODMIXHModel Mix Header Data7CHNGDATDate of Last Changenvarchar80
60OMC_BASICBasic Settings: Enhanced Dependency Editor5CHNGDATDate of Last Changenvarchar80
61OMC_MCDEPDefine Scheme for Enhanced Dependency Editor57CHNGDATDate of Last Changenvarchar80
62OMC_MDEPEnhanced Dependency Editor: Assign Scheme30CHNGDATDate of Last Changenvarchar80
63PALTIDiPPE Alternative: Time-Independent ID and Attributes12CHNGDATDate of Last Changenvarchar80
64PCOLMRColor Key Master Record5CHNGDATDate of Last Changenvarchar80
65PFOCIDiPPE Focus Master Record9CHNGDATDate of Last Changenvarchar80
66PNDALTAlternativensegment zum Positionsknoten8CHNGDATDatum der letzten Änderungnvarchar80
67PNDRELPositionsknotenbeziehung in der PVS9CHNGDATDatum der letzten Änderungnvarchar80
68PNODEPositionsknoten in der PVS10CHNGDATDatum der letzten Änderungnvarchar80
69PNODIDiPPE Node: Identification13CHNGDATDate of Last Changenvarchar80
70POSVIDiPPE Variant: Identification12CHNGDATDate of Last Changenvarchar80
71PPEHDRiPPE Access Object20CHNGDATDate of Last Changenvarchar80
72PPESPRECONDiPPE Status Precondition, Central Data8CHNGDATDate of Last Changenvarchar80
73PPESSTATUSiPPE Status, Central Data11CHNGDATDate of Last Changenvarchar80
74PRELACTRelationships for the SNP and Workshop Plan17CHNGDATDate of Last Changenvarchar80
75PRELIDiPPE Relationship: Time-Independent ID and Attributes14CHNGDATDate of Last Changenvarchar80
76PRGENGEN Relationships - Relationships Table17CHNGDATDate of Last Changenvarchar80
77PROJIDiPPE Assignment Table: PS Objects13CHNGDATDate of Last Changenvarchar80
78PRPVRRelationship Between Variants: Identification and Attributes15CHNGDATDate of Last Changenvarchar80
79PRSETSet Relationships: Table of Links16CHNGDATDate of Last Changenvarchar80
80PRTSTTest Relationships - Relationships Table18CHNGDATDate of Last Changenvarchar80
81PVS_VSHEMEVariance Scheme for Structure Node12CHNGDATDate of Last Changenvarchar80
82PXARCIDTable for Archiving Indicators for iPPE Objects15CHNGDATDate of Last Changenvarchar80
83RPPNTiPPE Reporting Points7CHNGDATDate of Last Changenvarchar80
84USRTICLASSClass Assignment for Tabular Maintenance of iPPE9CHNGDATDate of Last Changenvarchar80
TOPLine Maintenance
85/ISDFPS/LM_MISMission8CHNGDATLast Changed onnvarchar80
TOPLOGFAS
86/ISDFPS/GEOLOCGeolocation Database Table28CHNGDATLast Changed onnvarchar80
87/ISDFPS/RICReportable Item Code16CHNGDATLast Changed onnvarchar80
TOPLogistical Requirements
88/ISDFPS/PRMPAIDiPPE Relationship: Time-Independent ID and Attributes14CHNGDATDate of Last Changenvarchar80
TOPMaster Data Distribution
89/ISDFPS/CCMHOLERReplication Table CCMHOLE10CHNGDATLast Changed Onnvarchar140
TOPMaterial Categories
90/ISDFPS/PRMPOAttributes of BOM Relationships13CHNGDATDate of Last Changenvarchar80
91/ISDFPS/PRMPOCAttributes of Relationships Between Matl Container and MPO14CHNGDATDate of Last Changenvarchar80
92/ISDFPS/PRMPOCIDiPPE Relationship: Time-Independent ID and Attributes14CHNGDATDate of Last Changenvarchar80
93/ISDFPS/PRMPOIDiPPE Relationship: Time-Independent ID and Attributes14CHNGDATDate of Last Changenvarchar80
TOPProduct and Process Modeling
94RLMFWOHRelease Order - Header Data10CHNGDATChanged onnvarchar80
95RLMFWOHARelease Order - Processor7CHNGDATChanged onnvarchar80
96RLMFWOLRelease Order - Items22CHNGDATChanged onnvarchar80
TOPRecipe
97RCPT_PPMIG_CLASSRMS-RCP: Class Migration Log4CHNGDATDate of Last Changenvarchar80
98RCPT_PPMIG_ROOTRMS-RCP: PP Migration Log4CHNGDATDate of Last Changenvarchar80
99RCPT_PPMIG_STATSRMS-RCP: Migration Steps - Status4CHNGDATDate of Last Changenvarchar80
TOPResourcen Management
100PREQRRMS-RCP: iPPE Relationship: Equipment Requirement16CHNGDATDate of Last Changenvarchar80
101PRPOBARMS-RCP: iPPE Relationship: Operation-Action16CHNGDATDate of Last Changenvarchar80
102PRPOBIRMS-RCP: iPPE Relationship: Assignment Relationshps f. Items16CHNGDATDate of Last Changenvarchar80
103PRPOBORMS-RCP: iPPE Relationship: Stage-Operation16CHNGDATDate of Last Changenvarchar80
104PRPOBRRMS-RCP: iPPE Relationship: Relationships Between Operations16CHNGDATDate of Last Changenvarchar80
105PRPOBSRMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage16CHNGDATDate of Last Changenvarchar80
106RMSAT_STD_PARA_HRMS-ATL: Header Table Parameter Standardization12CHNGDATChanged Onnvarchar80
107RMSLA_HDHeader Data of Label Set5CHNGDATChanged Onnvarchar80
TOPRouting EBOM Assignment
108/PLMI/RTGRCALNKHRouting Component Assignment Link18CHNGDATDate on Which the Object Was Last Changednvarchar80
109/PLMI/RTGRCASCOHRCA Planning Scope Version9CHNGDATDate on Which the Object Was Last Changednvarchar80
TOPWarranty Claim Processing
110PNWTYHWarranty Claim Header (PVS Node)46CHNGDATDate of Last Changenvarchar80
111PNWTYVWarranty Claim Version (PVS Node)42CHNGDATDate of Last Changenvarchar80
112PRWTYiPPE Relationship: Time-Ind. Ident./Attributes Warranty14CHNGDATDate of Last Changenvarchar80
113PVWTYWarranty Claim Item (PPE Variant)51CHNGDATDate of Last Changenvarchar80
114WTY_PARTNER_TABPartner for Warranty Claim12CHNGDATDate of Last Changenvarchar80