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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

56 columns | Print definition?ERP 6.0  | SERVICE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/CHK_STATUSCheck DS service status2SERVICE_TYPESingle-Character Indicatornvarchar10
2/FLDQ/E_CHK_STATCheck DS service status2SERVICE_TYPESingle-Character Indicatornvarchar10
3/SAPSRM/C_REP_MXDefining maximum number of records4SERVICE_TYPESearch Service Typenvarchar40
4/SAPSRM/C_REP_SVSearch: Service Customizing3SERVICE_TYPESearch Service Typenvarchar40
5/SLOAP/SERTYPESLOAS Service Types2SERVICE_TYPESLOAS Service Typenvarchar50
6/SLOAP/SERVICESLOAS - Analysis Services10SERVICE_TYPESLOAS Service Typenvarchar50
7EWAT_SUPPR_DMRCSTM: Constraints For Suppression of Debit Memo Request3SERVICE_TYPEService Typenvarchar20
8SIMDQ_SVC_DEFIM in HANA service definition5SERVICE_TYPEIM in HANA service typenvarchar100
9SIMDQ_SVC_MAPIM in HANA table to map service type to implementation class1SERVICE_TYPEIM in HANA service typenvarchar100
10SIMDQ_TRAN_FLDIM in HANA transform field1SERVICE_TYPEIM in HANA service typenvarchar100
11VBCC_SERV_URLGeo Location Service URLs2SERVICE_TYPEGeo Coding Service Typenvarchar10
12VBCC_SERV_URLCGeo Location Service URLs3SERVICE_TYPEGeo Coding Service Typenvarchar10
13VBIC_SERV_URLGeo Location Service URLs2SERVICE_TYPEGeo Coding Service Typenvarchar10
14VBIC_SERV_URLCGeo Location Service URLs3SERVICE_TYPEGeo Coding Service Typenvarchar10
TOPABAP Authorization and Role Management
15USOBHASHAuthorization Trace for Services: Hash Values6SERVICE_TYPEType of External Servicenvarchar160
TOPControlling
16CRMC_SRVTYP_COService Type2SERVICE_TYPEService Typenvarchar40
17CRMC_SRVTYP_CO_TService Type: Texts2SERVICE_TYPEService Typenvarchar40
18QISR_PRICELISTPrice List for ISR Scenarios3SERVICE_TYPEService Type for Cost-Incurring ISR Scenarionvarchar20
19QISR_PRICELIST_TText Table for QISR_PRICELIST3SERVICE_TYPEService Type for Cost-Incurring ISR Scenarionvarchar20
TOPForce Element
20/ISDFPS/CLGROUPStructure Levels2SERVICE_TYPEOrganizational Area Typenvarchar10
21/ISDFPS/CLGROUPTText Table for Structure Levels3SERVICE_TYPEOrganizational Area Typenvarchar10
22/ISDFPS/CLSERVOrg. Area Types2SERVICE_TYPEOrganizational Area Typenvarchar10
23/ISDFPS/CLSERV_TOrg. Area Types (Text Table)3SERVICE_TYPEOrganizational Area Typenvarchar10
24/ISDFPS/CSERVOrganizational Area5SERVICE_TYPEOrganizational Area Typenvarchar10
TOPGeographical Information System
25GEOM_CONF_BASEGeometry Service Configuration6SERVICE_TYPEService Typenvarchar300
26GEOPRO_CONF_BASEGeo Processing Service Configuration5SERVICE_TYPEService Typenvarchar300
TOPHealthcare Communication Framework
27NHCF_SRVNMServices names2SERVICE_TYPEType of servicenvarchar10
TOPHR Administrative Services
28T5ASRFSCNSRVBackend Services for Form Scenarios4SERVICE_TYPEType of Backend Servicenvarchar100
TOPInformation Consistency
29SIC_SERVICE_DEFDefinition of ICM Services8SERVICE_TYPEService Typenvarchar10
TOPProcessing
30EWA_WDOC_WA_STSelection Data from Work Area for Service Type3SERVICE_TYPEService Typenvarchar20
TOPRuntime WorkbenchMonitoring
31SXMSMSGINDSRVSAP XI: Services for Indexing of Messages4SERVICE_TYPESAP XI: Service Type for Indexing of Messagesnvarchar10
TOPServices
32SSRVSERVICEXI: Services, Party Identifiers for a Service5SERVICE_TYPEXI: Service Typenvarchar20
TOPStructures Workbench
33HRP1950DB Table for Infotype 195025SERVICE_TYPEOrganizational Area Typenvarchar10
TOPTraders and Schedulers Workbench
34OIJRELCRITERIATo define criteria for relevancy types3SERVICE_TYPEField - Service Typenvarchar150
TOPWaste Management
35EWACONFPREDImplicit Confirmation Mode2SERVICE_TYPEService Typenvarchar20
36EWAOBJHService Frequency -> Services (History for EWAOBJ)21SERVICE_TYPEService Typenvarchar20
37EWAOBJH_AAT_HISTHistory and Valution of WBCs for Service Freq. Service9SERVICE_TYPEService Typenvarchar20
38EWA_CCOC_ASS_IUPAssign CO Data for WD Item and SD Item3SERVICE_TYPEService Typenvarchar20
39EWA_CCOC_ASS_REAllocate CO and Container (Rent)19SERVICE_TYPEService Typenvarchar20
40EWA_CCOC_COPAFLDMap Confirmation Fields to CO-PA Characteristic3SERVICE_TYPEService Typenvarchar20
41EWA_ORDER_OBJECTItem Table for Waste Disposal Order10SERVICE_TYPEService Typenvarchar20
42TEEWA_BULKY_CUSTBulk Refuse Order Types3SERVICE_TYPEService Typenvarchar20
43TEEWA_BULK_CUSTZBulk Refuse Order Types3SERVICE_TYPEService Typenvarchar20
44TESERVICETYPEActivity Types2SERVICE_TYPEService Typenvarchar20
45TESERVICETYPEAATWaste billing categories for service type2SERVICE_TYPEService Typenvarchar20
46TESERVICETYPETTexts of service types2SERVICE_TYPEService Typenvarchar20
47TESERVICETYPEVALValuation of service types2SERVICE_TYPEService Typenvarchar20
48TEWACONFPRDCTConfirmation Cat. Dependent on Service Type and Ser.Provider2SERVICE_TYPEService Typenvarchar20
49TEWACONFSTYPEService Type-to-Confirmation Category Allocation Table2SERVICE_TYPEService Typenvarchar20
50TEWASERVGRPTMPLDefault Values for Service Grouping15SERVICE_TYPEService Typenvarchar20
51TEWASERVICETAXIMapping of Service Frequency Fields to Characteristics3SERVICE_TYPEService Typenvarchar20
52TEWASERVICETMPLDefault Values for Service Type for Service Product3SERVICE_TYPEService Typenvarchar20
53TEWASERVICEUPOSSubitems for Service Types / Service Products3SERVICE_TYPEService Typenvarchar20
54TEWASERVWDOIPRControl of Processing for Each Service Type/Service Product3SERVICE_TYPEService Typenvarchar20
55TEWAUPOSADMISBLEPermissable Waste/Waste Fraction for Subitem3SERVICE_TYPEService Typenvarchar20
56TPRDCTAREASTYPEAssignment Table of Service Types to Service Area3SERVICE_TYPEService Typenvarchar20