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

93 columns | Print definition?ERP 6.0  | FIELD_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/C_SGX_DV_FWorklist fields to be displayed as Gantt cols in Demand View3FIELD_IDWorklist Field IDnvarchar10
2/SYCLO/WB001FDevTool: Mobile Screen layout2FIELD_IDDevTool: Field Unique Identifiernvarchar320
3/SYCLO/WB001VDevTool: Screen field value table4FIELD_IDDevTool: Field Unique Identifiernvarchar320
4CNVMBTFCATTo Store Field Catalog Info. for RFC Diagnostic Tool3FIELD_IDComponent namenvarchar300
5CNVMBTFCATTTo Store Field Catalog Info. for RFC Diagnostic Tool3FIELD_IDComponent namenvarchar300
6DOCRP_FLDBMPDBOS Cockpit: CRP: Source Field4FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
7DODP_ASSOCNDBOSC-DP: Navigation Association5FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
8DODP_ASSOCN_FLDDBOSC-DP: Navigation Association Fields4FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
9DODP_ASSOCR_FLDDBOSC-DP: Referential Association Fields4FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
10DODP_ASSOC_FIELDDBOSC-DP: Association From Field to Reference Field4FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
11DODP_FIELDDBOSC-DP: Data Provider Field5FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
12DODP_FIELD_VALUEDBOS-DP: Data Provider Field Value5FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
13DORAN_FIELDDBOSC-RAN: Data Source Field5FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
14DORDS_FIELDDBOSC-RDS: Reques Process DB SQL Data Source Field5FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
15DORDS_JOIN_EQDBOSC-RDS: Reques Process DB SQL Data Source Join Field EQ5FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
16DORDS_SET_EQDBOSC-RDS: Reques Process DB SQL Data Source Set Field EQ5FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
17DORQ_FIELDDBOSC-RQ: Request Fields6FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
18DOUI_MAP_FIELDDBOS Cockpit: Mapping Between UI and Request6FIELD_IDDBOSC-CR: Generated ID (30)nvarchar300
19GRACEUPCONFIGEnd User Personalization Fields2FIELD_IDField ID for EUPnvarchar30
20GRACEUPCONFIGIDConfiguration Field ID1FIELD_IDField ID for EUPnvarchar30
21GRACEUPCONFIGTDescription for EUP fields2FIELD_IDField ID for EUPnvarchar30
22GRACPSSHRPSS HR Verification2FIELD_IDVerification IDnvarchar40
23GRACPSSHRTPSS HR Verification Texts2FIELD_IDVerification IDnvarchar40
24GRFNREPCOLTXTCustomizable column header texts - report specific3FIELD_IDReport: Field IDnvarchar300
25GRFNREPCOLTXTGCustomizable column header texts1FIELD_IDReport: Field IDnvarchar300
26GRFNREPCOLVERReport: Column in Version2FIELD_IDReport: Field IDnvarchar300
27GRFNREPCOLVERCReport: Column in Version - customer3FIELD_IDReport: Field IDnvarchar300
28GRFNREPFIELDMAPReport: Special fields for reporting1FIELD_IDReport: Field IDnvarchar300
29GRFNREPFIELDTYPEReport: Field types for reporting1FIELD_IDReport: Field IDnvarchar300
30GRFNREPFILTERCReport: Filter - customer3FIELD_IDReport: Field IDnvarchar300
31GRFNREPFILVERReport: Filter in Version2FIELD_IDReport: Field IDnvarchar300
32GRFNREPFILVERCReport: Filter in Version - customer3FIELD_IDReport: Field IDnvarchar300
33HRT1107Table Part Infotype 11074FIELD_IDID of SFSF Fieldnvarchar2550
34SRAL_BCTX_FIELDSRAL: Fields of Business Context4FIELD_IDRAL: Field IDnvarchar400
35SRAL_COND_FIELDSRAL: Condition for field7FIELD_IDRAL: Field IDnvarchar400
36SRAL_FIELDSRAL: Generic channel fields3FIELD_IDRAL: Field IDnvarchar400
37SRAL_FIELDS_DYNPRAL: Channel specific fields3FIELD_IDRAL: Field IDnvarchar400
38SRAL_FIELDS_RFCRAL: Channel specific fields3FIELD_IDRAL: Field IDnvarchar400
39SRAL_FIELDS_SYRAL: System Field3FIELD_IDRAL: Field IDnvarchar400
40SRAL_FIELDS_WDRAL: Channel specific fields3FIELD_IDRAL: Field IDnvarchar400
41SRAL_FIELDS_WSRAL: Channel specific fields3FIELD_IDRAL: Field IDnvarchar400
42SRAL_LOG_FIELDSRAL: Log group fields4FIELD_IDRAL: Field IDnvarchar400
43T77SFI_COMP_EXFDFields for export of compensation data to SFSF3FIELD_IDSFSF Field IDnvarchar500
44WDY_HISTORYField History for Web Dynpro ABAP3FIELD_IDHash Value (160 Bits)nvarchar400
TOPConnection to External Systems
45DPR_MSP_EXT_ATTRMapping of extended attributes field name and field id1FIELD_IDMSP Extended Attributes field IDnvarchar120
TOPEasy Enhancement Workbench
46AXT_BOL_RULEOBSOLETE (to be deleted)5FIELD_IDField IDnvarchar300
47AXT_RUN_BO_PARTExt. runtime access: Field registration for BO and PARTS3FIELD_IDField IDnvarchar300
48AXT_RUN_FIELDDEFExtensibility runtime field definition1FIELD_IDField IDnvarchar300
49AXT_RUN_FIELDUSEExtensibility runtime fields1FIELD_IDField IDnvarchar300
50AXT_RUN_FLAGEnabled flags for fields4FIELD_IDField IDnvarchar300
51AXT_RUN_MAPOBSOLETE2FIELD_IDField IDnvarchar300
52AXT_RUN_SEARCHExtensibility runtime search info2FIELD_IDField IDnvarchar300
TOPEnterprise Search Integration
53CRMD_ES_ATTRNode attributes6FIELD_IDField ID for CRM ESnvarchar300
54CRMD_ES_TMPLRELRelations of templates for ES14FIELD_IDField ID for CRM ESnvarchar300
TOPExpenditure Certification
55FMEUFRUNLSelection Details for Certification Run4FIELD_IDField which the multiple selection refers tonvarchar20
TOPFast Search Infrastructure
56SFSG_QR_INPUTResult mapping of query definition3FIELD_IDGUID in 'RAW' formatvarbinary160
57SFSG_QR_RESULTResult mapping of query definition3FIELD_IDGUID in 'RAW' formatvarbinary160
TOPGeneric Project Planning
58CGPL_MAPPINGMapping of SAP App. Field to MS Project5FIELD_IDNatural Numberint100
TOPGovernance, Risk and Compliance
59GRFNFIELDMAPNOT USED! Mapping of fields to entity1FIELD_IDReport: Field IDnvarchar300
60GRFNREPCOLUMNReport: Columns2FIELD_IDReport: Field IDnvarchar300
61GRFNREPCOLUMNCReport: Columns - customer3FIELD_IDReport: Field IDnvarchar300
62GRFNREPFILTERReport: Filter2FIELD_IDReport: Field IDnvarchar300
TOPMaintenance Orders
63/MRSS/C_DEM_WL_FWork list fields to be displayed as Gantt cols in Demand Vie3FIELD_IDWorklist Field IDnvarchar10
TOPMaterial Master
64WGDS_ATTRIBUTESGDS storage: Attributes assignement4FIELD_IDField unique idnvarchar320
65WGDS_ATTR_VALUESStore user-defined selection-option value2FIELD_IDField unique idnvarchar320
TOPMDG Material
66MDG_BS_MAT_TEXTMapping table for texts4FIELD_IDName of Dictionary Typenvarchar300
TOPPlant Maintenance
67PLMN_FL_EXTGHO Object characteristics3FIELD_IDField Idnvarchar300
TOPProfitability Analysis
68TKEXYWFValue Field Name <-> Value Field Key3FIELD_IDnvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
69TFMCA_ACTN_0011TRM BRF+: Customizing Table for Formfield6FIELD_IDFDT: Universal Unique Identifiernvarchar320
70TFMCA_ACTN_0011ATRM BRF+: Application Table for Formfield6FIELD_IDFDT: Universal Unique Identifiernvarchar320
71TFMCA_ACTN_0011STRM BRF+: System Table for Formfield5FIELD_IDFDT: Universal Unique Identifiernvarchar320
72TFMCA_ACTN_0012TRM BRF+: Customizing Table for Check Condition4FIELD_IDFDT: Universal Unique Identifiernvarchar320
73TFMCA_ACTN_0012ATRM BRF+: Application Table for Check Condition4FIELD_IDFDT: Universal Unique Identifiernvarchar320
74TFMCA_ACTN_0012STRM BRF+: System Table for Check Condition3FIELD_IDFDT: Universal Unique Identifiernvarchar320
75TFMCA_ACTN_0013TRM BRF+: Customizing Table for Check Action4FIELD_IDFDT: Universal Unique Identifiernvarchar320
76TFMCA_ACTN_0013ATRM BRF+: Application Table for Check Content4FIELD_IDFDT: Universal Unique Identifiernvarchar320
77TFMCA_ACTN_0013STRM BRF+: System Table for Check Content3FIELD_IDFDT: Universal Unique Identifiernvarchar320
78TFMCA_ACTN_0014TRM BRF+: Customizing Table for Check Message4FIELD_IDFDT: Universal Unique Identifiernvarchar320
79TFMCA_ACTN_0014ATRM BRF+: Application Table for Check Message4FIELD_IDFDT: Universal Unique Identifiernvarchar320
80TFMCA_ACTN_0014STRM BRF+: System Table for Check Message3FIELD_IDFDT: Universal Unique Identifiernvarchar320
TOPRoyalty Reporting
81OIUREP_AGY_LSEAgency assigned Leases7FIELD_IDField IDnvarchar100
TOPWorkforce Management Application
82WFAC_FIELD_SELCustom field selection records4FIELD_IDCustom field IDnvarchar30
83WFAC_FIELD_SEL_TField selection text table4FIELD_IDCustom field IDnvarchar30
84WFAC_FLD_CLUSTERContains the cluster assigned2FIELD_IDCustom field IDnvarchar30
85WFAC_FLD_PRF_MAPCustom fields and profile mapping2FIELD_IDCustom field IDnvarchar30
86WFAC_QUERY_FIELDQuery fields info includes label, type, etc2FIELD_IDCustom field IDnvarchar30
87WFAC_QUERY_FLD_TQuery field2FIELD_IDCustom field IDnvarchar30
TOPWorkforce Management Core
88WFMC_FIELD_SELCustom field selection records4FIELD_IDCustom field IDnvarchar30
89WFMC_FIELD_SEL_TField selection text table4FIELD_IDCustom field IDnvarchar30
90WFMC_FLD_CLUSTERContains the cluster assigned2FIELD_IDCustom field IDnvarchar30
91WFMC_FLD_PRF_MAPCustom fields and profile mapping2FIELD_IDCustom field IDnvarchar30
92WFMC_QUERY_FIELDQuery fields info includes label, type, etc2FIELD_IDCustom field IDnvarchar30
93WFMC_QUERY_FLD_TQuery field2FIELD_IDCustom field IDnvarchar30