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

122 columns | Print definition?ERP 6.0  | CREABY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAuthorizations and Access Control Context
1/PLMB/AUTH_CHPChangepointers for updating RT5CREABYUser IDnvarchar120
2/PLMB/AUTH_OBSIDObject - Secure Identifier Assignment8CREABYUser IDnvarchar120
3/PLMB/AUTH_SIDRPSecure Identifier Repository8CREABYUser IDnvarchar120
4/PLMB/AUTH_UGSIDUser Entity - Secure ID - Activity List Assignment8CREABYUser IDnvarchar120
TOPCommand and Support Relationships
5/ISDFPS/FORCMDAttributes of Task Organization14CREABYCreated bynvarchar120
6/ISDFPS/FORCMDIDSupply Relationship IDs11CREABYCreated bynvarchar120
7/ISDFPS/FORMNTAttributes of Maintenance Relationships14CREABYCreated bynvarchar120
8/ISDFPS/FORMNTIDIDs of Maintenance Relationships11CREABYCreated bynvarchar120
9/ISDFPS/FOROTHAttributes of Additional Relationships14CREABYCreated bynvarchar120
10/ISDFPS/FOROTHIDIDs of Other Relationships11CREABYCreated bynvarchar120
11/ISDFPS/FORSUPAttributes of Supply Relationships14CREABYCreated bynvarchar120
12/ISDFPS/FORSUPIDSupply Relationship IDs11CREABYCreated bynvarchar120
13/ISDFPS/ORCMDTask Organizations20CREABYCreated bynvarchar120
14/ISDFPS/ORCMD1Task Organization, Basic Types of Dependent Attributes5CREABYCreated bynvarchar120
15/ISDFPS/ORMNTMaintenance Relationships20CREABYCreated bynvarchar120
16/ISDFPS/ORMNT1Maintenance Relationships, Basic Types, Dependent Attributes5CREABYCreated bynvarchar120
17/ISDFPS/OROTHAdditional Relationships20CREABYCreated bynvarchar120
18/ISDFPS/ORSUPSupply Relationships20CREABYCreated bynvarchar120
19/ISDFPS/ORSUP1Supply Relationships, Basic Types, Dependent Attributes5CREABYCreated bynvarchar120
20/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)20CREABYCreated bynvarchar120
TOPConfiguration Control
21CCMHOLEStructure Gap Table9CREABYCreator of Objectnvarchar120
TOPEngineering Change Management
22EDGERelation Between Change Numbers9CREABYUser who created recordnvarchar120
23ENODENodes ECH7CREABYUser who created recordnvarchar120
TOPForce Element
24/ISDFPS/FORBEAttributes of HR - BE Relationship11CREABYCreated bynvarchar120
25/ISDFPS/FORBEIDIDs of HR - BE Relationships10CREABYCreated bynvarchar120
26/ISDFPS/FORCEForce Element (Database)33CREABYCreated bynvarchar120
27/ISDFPS/FORCEMAuthorized Materials23CREABYCreated bynvarchar120
28/ISDFPS/FORCEPMaterial Packages15CREABYCreated bynvarchar120
29/ISDFPS/FORCERReference Force Element (Database)9CREABYCreated bynvarchar120
30/ISDFPS/FORCE_PRIndividual Threshold Values for Readiness17CREABYCreated bynvarchar120
31/ISDFPS/FORCNAttributes of REC - HR Relationship11CREABYCreated bynvarchar120
32/ISDFPS/FORCNIDIDs of HR - REC Relationships10CREABYCreated bynvarchar120
33/ISDFPS/FORDELPlanned Delimitation and Deletion Operations14CREABYCreated bynvarchar120
34/ISDFPS/FOREPAAttributes of the Force Element - EPA Relationships11CREABYCreated bynvarchar120
35/ISDFPS/FOREPAIDIDs of the Force Element - EPA Relationships10CREABYCreated bynvarchar120
36/ISDFPS/FORIPOFORCER: Authorized Infrastructure: Attributes11CREABYCreated bynvarchar120
37/ISDFPS/FORIPOIDFORCER: Authorized Infrastructure: IDs10CREABYCreated bynvarchar120
38/ISDFPS/FORMCAttributes of the Material Container-Force Element Relatshp11CREABYCreated bynvarchar120
39/ISDFPS/FORMCHAttributes of the Material Container - HR Relationship11CREABYCreated bynvarchar120
40/ISDFPS/FORMCHIDIDs of the HR - MC Relationships10CREABYCreated bynvarchar120
41/ISDFPS/FORMCIDIDs of Material Container - Force Element Relationships10CREABYCreated bynvarchar120
42/ISDFPS/FORMPHAttributes of the HR - MPO Relationship11CREABYCreated bynvarchar120
43/ISDFPS/FORMPHIDIDs of the HR - MPO Relationships10CREABYCreated bynvarchar120
44/ISDFPS/FORMPOAttributes of the Force Element - MPO Relationship11CREABYCreated bynvarchar120
45/ISDFPS/FORMPOIDIDs of the Force Element - MPO Relationships10CREABYCreated bynvarchar120
46/ISDFPS/FORRICAttributes of the Force Element - RIC Relationship11CREABYCreated bynvarchar120
47/ISDFPS/FORRICIDIDs of the Force Element - RIC Relationships10CREABYCreated bynvarchar120
48/ISDFPS/FORRRFORCER: RE Search Request: Attributes11CREABYCreated bynvarchar120
49/ISDFPS/FORRRIDFORCER: RE Search Request: IDs10CREABYCreated bynvarchar120
50/ISDFPS/FORTOBAttributes of Relationship to Technical Objects14CREABYCreated bynvarchar120
51/ISDFPS/FORTOBIDIDs of Relationship to Technical Objects11CREABYCreated bynvarchar120
52/ISDFPS/FORVPAAttributes of the Force Element - PPA Relationships11CREABYCreated bynvarchar120
53/ISDFPS/FORVPAIDIDs of the Force Element - PPA Relationships10CREABYCreated bynvarchar120
TOPIntegrated Product and Process Engineering
54CMIG_STATUSStatus Table (iPPE Migration)8CREABYUser who created recordnvarchar120
55CPATYPECustomizing Table for iPPE Alternative Types11CREABYUser who created recordnvarchar120
56CPNTYPECustomizing Table for iPPE Node Type22CREABYUser who created recordnvarchar120
57CPPECNTLGeneral iPPE Customizing24CREABYUser who created recordnvarchar120
58CPRTYPECustomizing: iPPE Relationships24CREABYUser who created recordnvarchar120
59CPVSMDLModel Associations between the PVS Objects9CREABYUser who created recordnvarchar120
60CPVSMDLCModel Associations between the Customer-Spec. PVS Objects9CREABYUser who created recordnvarchar120
61CPVTYPECustomizing Table for the iPPE Variant Types17CREABYUser who created recordnvarchar120
62INSTANCEIDGeometric Instance: Identification11CREABYUser who created recordnvarchar120
63LINEBALLine Balance Versions in iPPE8CREABYUser who created recordnvarchar120
64MODMIXHModel Mix Header Data6CREABYUser who created recordnvarchar120
65OMC_BASICBasic Settings: Enhanced Dependency Editor4CREABYUser who created recordnvarchar120
66OMC_MCDEPDefine Scheme for Enhanced Dependency Editor56CREABYUser who created recordnvarchar120
67OMC_MDEPEnhanced Dependency Editor: Assign Scheme29CREABYUser who created recordnvarchar120
68PALTIDiPPE Alternative: Time-Independent ID and Attributes11CREABYUser who created recordnvarchar120
69PCOLMRColor Key Master Record4CREABYUser who created recordnvarchar120
70PFOBJIDAssignment of Leading Focus Obj: Node to Focus Master Record10CREABYUser who created recordnvarchar120
71PFOBJRAssignment of Focus Object: Relationship to Focus Master Rec10CREABYUser who created recordnvarchar120
72PFOBJVAssignment of Focus Object: Variant to Focus Master Record9CREABYUser who created recordnvarchar120
73PFOCIDiPPE Focus Master Record8CREABYUser who created recordnvarchar120
74PNDALTAlternativensegment zum Positionsknoten7CREABYSachbearbeiter, der den Satz angelegt hatnvarchar120
75PNDRELPositionsknotenbeziehung in der PVS8CREABYSachbearbeiter, der den Satz angelegt hatnvarchar120
76PNODEPositionsknoten in der PVS9CREABYSachbearbeiter, der den Satz angelegt hatnvarchar120
77PNODIDiPPE Node: Identification12CREABYUser who created recordnvarchar120
78POSVIDiPPE Variant: Identification11CREABYUser who created recordnvarchar120
79PPECPROOBJLNKiPPE Assignment Table: Object Links with cProjects13CREABYUser who created recordnvarchar120
80PPEHDRiPPE Access Object19CREABYUser who created recordnvarchar120
81PPESPRECONDiPPE Status Precondition, Central Data7CREABYUser who created recordnvarchar120
82PPESSTATUSiPPE Status, Central Data10CREABYUser who created recordnvarchar120
83PRELACTRelationships for the SNP and Workshop Plan16CREABYUser who created recordnvarchar120
84PRELIDiPPE Relationship: Time-Independent ID and Attributes13CREABYUser who created recordnvarchar120
85PRGENGEN Relationships - Relationships Table16CREABYUser who created recordnvarchar120
86PROJIDiPPE Assignment Table: PS Objects16CREABYUser who created recordnvarchar120
87PRPVRRelationship Between Variants: Identification and Attributes14CREABYUser who created recordnvarchar120
88PRSETSet Relationships: Table of Links15CREABYUser who created recordnvarchar120
89PRTSTTest Relationships - Relationships Table17CREABYUser who created recordnvarchar120
90PVS_VSHEMEVariance Scheme for Structure Node11CREABYUser who created recordnvarchar120
91PXARCIDTable for Archiving Indicators for iPPE Objects14CREABYUser who created recordnvarchar120
92RPPNTiPPE Reporting Points6CREABYUser who created recordnvarchar120
93USRTICLASSClass Assignment for Tabular Maintenance of iPPE8CREABYUser who created recordnvarchar120
TOPLine Maintenance
94/ISDFPS/LM_MISMission7CREABYCreated bynvarchar120
TOPLOGFAS
95/ISDFPS/GEOLOCGeolocation Database Table27CREABYCreated bynvarchar120
96/ISDFPS/RICReportable Item Code15CREABYCreated bynvarchar120
TOPLogistical Requirements
97/ISDFPS/PRMPAIDiPPE Relationship: Time-Independent ID and Attributes13CREABYUser who created recordnvarchar120
TOPMaster Data Distribution
98/ISDFPS/CCMHOLERReplication Table CCMHOLE9CREABYCreator of Objectnvarchar120
TOPMaterial
99RSADDAdditional fields for reservation27CREABYName of Person who Created the Objectnvarchar120
TOPMaterial Categories
100/ISDFPS/PRMPOAttributes of BOM Relationships12CREABYUser who created recordnvarchar120
101/ISDFPS/PRMPOCAttributes of Relationships Between Matl Container and MPO13CREABYUser who created recordnvarchar120
102/ISDFPS/PRMPOCIDiPPE Relationship: Time-Independent ID and Attributes13CREABYUser who created recordnvarchar120
103/ISDFPS/PRMPOIDiPPE Relationship: Time-Independent ID and Attributes13CREABYUser who created recordnvarchar120
TOPProduct and Process Modeling
104RLMFWOHRelease Order - Header Data9CREABYCreated bynvarchar120
TOPResourcen Management
105PREQRRMS-RCP: iPPE Relationship: Equipment Requirement15CREABYUser who created recordnvarchar120
106PRPOBARMS-RCP: iPPE Relationship: Operation-Action15CREABYUser who created recordnvarchar120
107PRPOBIRMS-RCP: iPPE Relationship: Assignment Relationshps f. Items15CREABYUser who created recordnvarchar120
108PRPOBORMS-RCP: iPPE Relationship: Stage-Operation15CREABYUser who created recordnvarchar120
109PRPOBRRMS-RCP: iPPE Relationship: Relationships Between Operations15CREABYUser who created recordnvarchar120
110PRPOBSRMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage15CREABYUser who created recordnvarchar120
111RMSAT_STD_LAY_HRMS-ATL: Header Table Layout Standardization4CREABYCreated Bynvarchar120
112RMSAT_STD_PARA_HRMS-ATL: Header Table Parameter Standardization11CREABYCreated Bynvarchar120
113RMSLA_HDHeader Data of Label Set4CREABYCreated Bynvarchar120
TOPRouting EBOM Assignment
114/PLMI/RTGRCALNKHRouting Component Assignment Link17CREABYUser Who Created the Objectnvarchar120
115/PLMI/RTGRCASCOHRCA Planning Scope Version8CREABYUser Who Created the Objectnvarchar120
TOPSimulation
116VSRSADD_CNVersion: Additional fields for reservation28CREABYName of Person who Created the Objectnvarchar120
TOPWarranty Claim Processing
117PNWTYHWarranty Claim Header (PVS Node)45CREABYUser Who Created Recordnvarchar120
118PNWTYVWarranty Claim Version (PVS Node)41CREABYUser Who Created Recordnvarchar120
119PRWTYiPPE Relationship: Time-Ind. Ident./Attributes Warranty13CREABYUser Who Created Recordnvarchar120
120PVWTYWarranty Claim Item (PPE Variant)50CREABYUser Who Created Recordnvarchar120
121WTY_PARTNER_TABPartner for Warranty Claim11CREABYUser Who Created Recordnvarchar120
122WTY_RCLHSTRecall Actions9CREABYUser who Created the Claimnvarchar120