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

112 columns | Print definition?ERP 6.0  | SERVICE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/C_MGDEAMCustomizing table: Routing for OData Services2SERVICE_IDService Document Identifiernvarchar400
2/IWFND/C_MGDETSCustomizing table: Error tolerant Services for MDC2SERVICE_IDService Document Identifiernvarchar400
3/IWFND/L_NOTIF_PPull-oriented Push Notification Data(ODC) Payload4SERVICE_IDExternal Service Document Namenvarchar400
4/PLMB/PR_OBJSRVIItem of PR Object Type Background Service Assignment3SERVICE_IDProcess Route Background Service IDnvarchar160
5/PLMB/PR_SRVProcess Route Service5SERVICE_IDProcess Route Background Service IDnvarchar160
6/PLMB/PR_SRVDEFTText Table for Process Route Background Service Definition3SERVICE_IDProcess Route Background Service IDnvarchar160
7/PLMB/PR_SRV_DEFProcess Route Background Service Definition2SERVICE_IDProcess Route Background Service IDnvarchar160
8/PLMI/PRT_LINEProcess Route Template Line14SERVICE_IDService IDnvarchar160
9BBP_WS_DETAILSExtension for Table WSI_ENTITY2SERVICE_IDTechnical Key of a Web Service (for Example - a Catalog)nvarchar200
10DODP_ASSOCDBOSC-DP: Association3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
11DODP_ASSOCNDBOSC-DP: Navigation Association3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
12DODP_ASSOCRDBOSC-DP: Referential Association3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
13DODP_FIELDDBOSC-DP: Data Provider Field3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
14DODP_FIELD_VALUEDBOS-DP: Data Provider Field Value3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
15DODP_MAP_SOURCEDBOSC-DP: Map Data Provider to Data Source3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
16DODP_PROVIDERDBOSC-DP: Data Providers2SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
17DODP_SERVICEDBOSC-DP: Service2SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
18DOOD_ENTITY_SETDBOSC-OD: OData Entity Type2SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
19DOOD_ENTITY_TYPEDBOSC-OD: OData Entity Type3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
20DOOD_PROPERTYDBOSC-DP: Data Provider Field2SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
21DOOD_SERVICEDBOSC-OD: Service3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
22DORQ_FIELDDBOSC-RQ: Request Fields3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
23DORQ_OPTIONDBOSC-RQ: Request Options3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
24DORQ_REQUESTDBOSC-RQ: Request3SERVICE_IDDBOSC-CR: Generated ID (4)nvarchar40
25FDT_BRS_CC_0005FDT: Database table for non productive simulation2SERVICE_IDUUID in character formnvarchar320
26FDT_BRS_DSM_0020BRS DSM:Statistics4SERVICE_IDUUID in character formnvarchar320
27FDT_BRS_DSM_0030BRS DSM: Application Service Exit Relation3SERVICE_IDFDT: Universal Unique Identifiernvarchar320
28SIMDQ_ADDR_STGIM in HANA address related settings3SERVICE_IDIM in HANA service IDnvarchar330
29SIMDQ_CMPRSRCIM in HANA compare source settings for Match Policy2SERVICE_IDIM in HANA service IDnvarchar330
30SIMDQ_CNTRY_IDIM in HANA cleanse country identification settings2SERVICE_IDIM in HANA service IDnvarchar330
31SIMDQ_INP_FILTERIM in HANA Filter for input2SERVICE_IDIM in HANA service IDnvarchar330
32SIMDQ_INP_MAPIM in HANA input map3SERVICE_IDIM in HANA service IDnvarchar330
33SIMDQ_MTCADDRSTGIM in HANA address settings for the Match Policy2SERVICE_IDIM in HANA service IDnvarchar330
34SIMDQ_MTCCSTMSTGIM in HANA custom component settings for Custom Match Policy2SERVICE_IDIM in HANA service IDnvarchar330
35SIMDQ_MTCFIRMSTGIM in HANA firm settings for the Match Policy2SERVICE_IDIM in HANA service IDnvarchar330
36SIMDQ_MTCOTHRSTGIM in HANA other match component for Match Policy2SERVICE_IDIM in HANA service IDnvarchar330
37SIMDQ_MTCPERSTGIM in HANA person settings for the Match Policy2SERVICE_IDIM in HANA service IDnvarchar330
38SIMDQ_MTC_POLICYIM in HANA match policy settings2SERVICE_IDIM in HANA service IDnvarchar330
39SIMDQ_OTHR_STGIM in HANA non-address settings3SERVICE_IDIM in HANA service IDnvarchar330
40SIMDQ_OUTP_MAPIM in HANA map of table model field to transform output fld3SERVICE_IDIM in HANA service IDnvarchar330
41SIMDQ_SVC_DEFIM in HANA service definition2SERVICE_IDIM in HANA service IDnvarchar330
42VBCC_GC_SERVGeo-Location Service Definitions Header1SERVICE_IDConfiguration Identifiernvarchar500
43VBCC_SERV_URLGeo Location Service URLs1SERVICE_IDConfiguration Identifiernvarchar500
44VBCC_SERV_URLCGeo Location Service URLs2SERVICE_IDConfiguration Identifiernvarchar500
45VBIC_GC_SERVGeo-Location Service Definitions Header1SERVICE_IDConfiguration Identifiernvarchar500
46VBIC_SERV_URLGeo Location Service URLs1SERVICE_IDConfiguration Identifiernvarchar500
47VBIC_SERV_URLCGeo Location Service URLs2SERVICE_IDConfiguration Identifiernvarchar500
TOPBasic Functions
48MMPUROCI_DETAILSEnhancement to Table WSI_ENTITY2SERVICE_IDTechnical Key of a Web Service (for Example - a Catalog)nvarchar200
TOPCommunication
49TNHCF_MAP_INFOMapping table for generic mapping handling1SERVICE_ID3-Byte fieldnvarchar30
TOPData Mining
50RSDMTPN_MODELAnalytical Models using the services available3SERVICE_IDAnalytical Methodnvarchar300
51RSDMTPN_PARA_DSCDescription of Service and parameters - Different Language1SERVICE_IDAnalytical Methodnvarchar300
52RSDMTPN_SRV_PARParameters required for the services1SERVICE_IDAnalytical Methodnvarchar300
53RSDMTP_DSRC_BWDMining Source to Datasource Relation6SERVICE_IDAnalytical Methodnvarchar300
54RSDMTP_MODELAnalytical Models using the services available3SERVICE_IDAnalytical Methodnvarchar300
55RSDMTP_PARAM_DSCDescription of Service and parameters - Different Language1SERVICE_IDAnalytical Methodnvarchar300
56RSDMTP_SERVICESList of all the analytical services1SERVICE_IDAnalytical Methodnvarchar300
57RSDMTP_SRV_CTYPEContent Types supported by service1SERVICE_IDAnalytical Methodnvarchar300
58RSDMTP_SRV_DTYPEDistribution Types supported by service1SERVICE_IDAnalytical Methodnvarchar300
59RSDMTP_SRV_PARAMParameters required for the services1SERVICE_IDAnalytical Methodnvarchar300
60RSDMTX_DSRC_KEYSModel keys to Datasource relation3SERVICE_IDAnalytical Methodnvarchar300
TOPDefense Forces and Public Security
61PA0803Personnel Master Record Infotype 080324SERVICE_IDOrganizational Areanvarchar10
TOPEnd User Technology
62RSDASDirectory of Data Access Services1SERVICE_IDID of a Data Access Servicenvarchar400
63RSDASLOCLocal Properties: Data Access Services1SERVICE_IDID of a Data Access Servicenvarchar400
64RSDASSERVPARService Parameter of the Data Access Service1SERVICE_IDID of a Data Access Servicenvarchar400
65RSDASSERVPARTDescriptions for Service Parametesr of the DAS2SERVICE_IDID of a Data Access Servicenvarchar400
66RSDASSERVPARVALValue of the Service Parameter of the Data Access Service1SERVICE_IDID of a Data Access Servicenvarchar400
67RSDASTDescriptions for Data Access Services2SERVICE_IDID of a Data Access Servicenvarchar400
TOPEnterprise Services in Purchasing
68T175ESOAEnterprise Services Context vs. ESOA3SERVICE_IDService IDnvarchar300
TOPForce Element
69/ISDFPS/CBRANCHBranches3SERVICE_IDOrganizational Areanvarchar10
70/ISDFPS/CBRANCHSBranch Additions3SERVICE_IDOrganizational Areanvarchar10
71/ISDFPS/CBRANCHTText Table: Branches4SERVICE_IDOrganizational Areanvarchar10
72/ISDFPS/CBRNCHSTBranches3SERVICE_IDOrganizational Areanvarchar10
73/ISDFPS/CFLEVELStructure Types3SERVICE_IDOrganizational Areanvarchar10
74/ISDFPS/CFLEVELTText Table for Structure Types4SERVICE_IDOrganizational Areanvarchar10
75/ISDFPS/CMATQUALMaterial Indicators3SERVICE_IDOrganizational Areanvarchar10
76/ISDFPS/CMATQULTText Table for Material Indicators4SERVICE_IDOrganizational Areanvarchar10
77/ISDFPS/CSERVOrganizational Area3SERVICE_IDOrganizational Areanvarchar10
78/ISDFPS/CSERVTLanguage Table for Organizational Areas4SERVICE_IDOrganizational Areanvarchar10
TOPGeographical Information System
79GEOPROC_OPTIONSGeo Processing4SERVICE_IDService IDnvarchar320
80GEOPRO_CONF_BASEGeo Processing Service Configuration2SERVICE_IDService IDnvarchar320
81GEOPRO_PARAM_SERParameter for Services2SERVICE_IDService IDnvarchar320
82GEO_PROCESS_CONFGeo Processing3SERVICE_IDService IDnvarchar320
83GEO_PROC_EXPORTExport Parameter table2SERVICE_IDService IDnvarchar320
84GEO_PROC_IMPORTTable for Import parameters for Geo Processing Services2SERVICE_IDService IDnvarchar320
TOPHR Administrative Services
85T5ASRFSCNGSMAPField Mapping for Generic Services4SERVICE_IDBackend Servicenvarchar300
86T5ASRFSCNGSOPOperations for Generic Services4SERVICE_IDBackend Servicenvarchar300
TOPImplementation of Organizational Flexibility in Logistics
87/ISDFPS/RELSEQDefinition of Relocation Steps3SERVICE_IDOrganizational Areanvarchar10
TOPIncentive and Commission Management ICM
88TCACS_RULESERVAgreement Rules Services18SERVICE_IDService Identification for Service Toolnvarchar100
TOPIntegration of Catalogs, Partner Directories OCI, OPI
89WSI_CALLSTRUCCall Structure for Web Services with own UI (OCI/OPI)2SERVICE_IDTechnical Key of a Web Service (for Example - a Catalog)nvarchar200
90WSI_CALLSTRUC_IFCall Structure for Calls in Application Frame2SERVICE_IDTechnical Key of a Web Service (for Example - a Catalog)nvarchar200
91WSI_DESCRIPTIONDescription of a Web Service with Own UI (OCI/OPI)3SERVICE_IDTechnical Key of a Web Service (for Example - a Catalog)nvarchar200
92WSI_ENTITYEntity Table for Web Services With Own UI (OCI/OPI)2SERVICE_IDTechnical Key of a Web Service (for Example - a Catalog)nvarchar200
TOPMaterial Categories
93/ISDFPS/MPO_PROTLog of Data Transfers into MPO38SERVICE_IDOrganizational Areanvarchar10
94/ISDFPS/PNMPOSOrganizational Areas Using Object (Def. in CSERV)5SERVICE_IDOrganizational Areanvarchar10
TOPPortfolio Management
95/RPM/BUCKET_SOperational bucket service providers6SERVICE_IDServicenvarchar150
96/RPM/OBJ_CUS_FLDObject type custom fields4SERVICE_IDServicenvarchar150
97/RPM/OBJ_SAP_FLDObject type SAP fields3SERVICE_IDServicenvarchar150
98/RPM/OBJ_SERVICEMapping objects and services3SERVICE_IDServicenvarchar150
99/RPM/P_FICAP_SPNxRPM:Portfolio dependant fin/cap override sponsor field5SERVICE_IDServicenvarchar150
100/RPM/SERVICEServices Definition2SERVICE_IDServicenvarchar150
101/RPM/SERVICE_TService Texts3SERVICE_IDServicenvarchar150
102RPM_BUCKET_S_CDBucket service table - Pseudo table for change documents6SERVICE_IDServicenvarchar150
TOPPublic Sector Contract Accounts Receivable and Payable
103TFMCA_SERVICESCustomizing Table for Services4SERVICE_IDSequence Number for Servicenvarchar30
104TFMCA_SERVICESTCustomizing Table for Language-Dependent Text for Services5SERVICE_IDNumc3, internal usenvarchar30
TOPRuntime WorkbenchMonitoring
105SXMSMSGINDSRVSAP XI: Services for Indexing of Messages3SERVICE_IDSAP XI: Service ID for Indexing of Messagesnvarchar400
TOPStructures Workbench
106/ISDFPS/CFDPSA05Derivation Table: Force Element - Accounting Object3SERVICE_IDOrganizational Areanvarchar10
107/ISDFPS/CMLILEVCustomizing: Hierarchy Level for Hierarchy Explosion3SERVICE_IDOrganizational Areanvarchar10
108HRP1950DB Table for Infotype 195019SERVICE_IDOrganizational Areanvarchar10
109HRP1958DB Table for Infotype 195819SERVICE_IDOrganizational Areanvarchar10
110PA0792Personnel Master Record Infotype 079225SERVICE_IDOrganizational Areanvarchar10
TOPTransport Registry
111TRN_REG_SRVCService of Application2SERVICE_IDServicenvarchar300
112TRN_REG_SRVCTServices of Application3SERVICE_IDServicenvarchar300