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

59 columns | Print definition?ERP 6.0  | VERSIONID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DITAT_D_POFLHDPhysical objects fixed-length header data5VERSIONIDVersion idnvarchar60
2DITAT_D_SOHDStructural object header data6VERSIONIDVersion idnvarchar60
3DITAT_D_TTXPhysical objects TTXs3VERSIONIDVersion idnvarchar60
4DITAT_D_VERSIONVersions1VERSIONIDVersion idnvarchar60
5T582MAPITVERSAssignment of Infotype Versions1VERSIONIDID for Infotype Versionsnvarchar20
6T77PAODYCALCParameter Groups for Calculation Methods5VERSIONIDInfotype Versionnvarchar20
7T77PAODYCALCPParameters for Calculation Methods5VERSIONIDInfotype Versionnvarchar20
8T77PAODYCONDConditions5VERSIONIDInfotype Versionnvarchar20
9T77PAODYOPOperations5VERSIONIDInfotype Versionnvarchar20
10T77PAODYOPINFOInformation for Operations6VERSIONIDInfotype Versionnvarchar20
11T77PAODYOPVALDefault Values for Operations5VERSIONIDInfotype Versionnvarchar20
12T77PAODYRULEDynamic Processing Rules5VERSIONIDInfotype Versionnvarchar20
13T77PAOMDCFBasic UI Configurations for SAP and Customer Infotypes3VERSIONIDInfotype Versionnvarchar20
14T77PAOMDCFCCustomer Changes to Basic UI Configurations for Infotypes4VERSIONIDInfotype Versionnvarchar20
15T77PAOMDCFCTCustomer Changes to IT Descriptions in Basic UI Configs5VERSIONIDInfotype Versionnvarchar20
16T77PAOMDCFDTLDetail Configurations for SAP and Customer Infotypes4VERSIONIDInfotype Versionnvarchar20
17T77PAOMDCFDTLCCustomer Changes to Detail Configurations for Infotypes5VERSIONIDInfotype Versionnvarchar20
18T77PAOMDCFPRPConfiguration Properties for SAP and Customer Infotypes3VERSIONIDInfotype Versionnvarchar20
19T77PAOMDCFPRPCCustomer Changes to Configuration Properties for Infotypes4VERSIONIDInfotype Versionnvarchar20
20T77PAOMDCFTSAP and Customer IT Descriptions in Basic UI Configurations4VERSIONIDInfotype Versionnvarchar20
21T77PAOMDOVRCFSAP Configurations for Object Profile Pages2VERSIONIDInfotype Versionnvarchar20
22T77PAOMDOVRCFCCustomer Configurations for Object Profile Pages3VERSIONIDInfotype Versionnvarchar20
23T77PAOMDQVCFSAP Configurations for Quickviews2VERSIONIDInfotype Versionnvarchar20
24T77PAOMDQVCFCCustomer Configurations for Quickviews3VERSIONIDInfotype Versionnvarchar20
25T77PAOMDSPCFSAP Configurations for Short Profiles2VERSIONIDInfotype Versionnvarchar20
26T77PAOMDSPCFCCustomer Configurations for Short Profiles3VERSIONIDInfotype Versionnvarchar20
TOPCommon Parts
27T7XSSPERBIZFLDAvailable fields on bizcards on PersInfo Overview screen3VERSIONIDID for Infotype Versionsnvarchar20
28T7XSSPERBIZFLDCCustomize fields for bizcards on PersInfo Overview screen3VERSIONIDID for Infotype Versionsnvarchar20
29T7XSSPERBIZFLDCTText table for T7XSSPERBIZFLDC4VERSIONIDID for Infotype Versionsnvarchar20
30T7XSSPERBIZFLDTText table for T7XSSPERBIZFLD4VERSIONIDID for Infotype Versionsnvarchar20
31T7XSSREUSEUISNReuse of Screen Structure Name for New Country Version5VERSIONIDID for Infotype Versionsnvarchar20
TOPControlling
32FCOMC_SETVERHierarchy Versions2VERSIONIDHierarchy Version IDnvarchar80
33FCOMC_SETVER_TText Table of Hierarchy Versions2VERSIONIDHierarchy Version IDnvarchar80
34FCOMT_INASETInactive Groups5VERSIONIDHierarchy Version IDnvarchar80
TOPHR Administrative Services
35T5ASRFSCNForm Scenarios5VERSIONIDInfotype Versionnvarchar20
TOPliveCache Applications
36ACTINDEXTAB(Only in the liveCache)2VERSIONIDName of Planning Versionnvarchar220
37MATRIXINDEXTAB(Only in the liveCache)2VERSIONIDName of Planning Versionnvarchar220
TOPNetwork Operations
38GHO_OTSGHO Order Template Structures4VERSIONIDGHO Production Network Version Identificationnvarchar30
TOPPersonnel Administration
39T582ITVCHCKVerification Class for a Version Flag3VERSIONIDID for Infotype Versionsnvarchar20
40T582ITVERSEntity Table for Infotype Versions2VERSIONIDID for Infotype Versionsnvarchar20
41T582ITVERSTEntity Table for Infotype Versions3VERSIONIDID for Infotype Versionsnvarchar20
42T588UICONVCLASAssignment UI Structures and UI Conversion Classes4VERSIONIDID for Infotype Versionsnvarchar20
TOPSocial Services and Social Security
43PSSCD_GEDGross Entitlement Determination Header Data2VERSIONIDVersion of a Social Services Objectnvarchar320
44PSSCD_GEDITEMGross Entitlement Determination Item Data2VERSIONIDVersion of a Social Services Objectnvarchar320
45PSSCD_GPDGross Payment Document Header Data2VERSIONIDVersion of a Social Services Objectnvarchar320
46PSSCD_GPDITEMGross Payment Docment Item Data2VERSIONIDVersion of a Social Services Objectnvarchar320
47PSSCD_SXPSXP Header Data2VERSIONIDSocial Services Object Versionvarbinary160
48PSSCD_SXPITEMSXP Item Data2VERSIONIDSocial Services Object Versionvarbinary160
49PSSCD_SXP_APPTSXP Appointment2VERSIONIDSocial Services Object Versionvarbinary160
50PSSCD_SXP_CUST_HSXP Customer Include (Header)2VERSIONIDSocial Services Object Versionvarbinary160
51PSSCD_SXP_CUST_ISXP Customer Include (Item)2VERSIONIDSocial Services Object Versionvarbinary160
52PSSCD_SXP_ELIGEligibility Periods2VERSIONIDSocial Services Object Versionvarbinary160
53PSSCD_SXP_PARTNRSXP Partner2VERSIONIDSocial Services Object Versionvarbinary160
54PSSCD_SXP_PAYM_RSXP Additional Payment Recipients2VERSIONIDSocial Services Object Versionvarbinary160
55PSSCD_SXP_STATUSSXP Status2VERSIONIDSocial Services Object Versionvarbinary160
TOPTransport Management System
56CTSOBJLISTCTS+ Object List: DB Main Persistence4VERSIONIDECTS: Object Versionnvarchar400
57CTSOBJLISTTCTS+ Object List: DB Language Part Persistence4VERSIONIDECTS: Object Versionnvarchar400
58CTSOBJPROSCTS+ Object List: DB Properties Persistence4VERSIONIDECTS: Object Versionnvarchar400
TOPWorkforce Management Core
59/SAPAPO/LRPASSARTable of Dispatching Details for Assignment2VERSIONIDGUID of a Persistent Objectnvarchar220