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

142 columns | Print definition?ERP 6.0  | LENG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/EHR/S71_FIELDMaintenance Output Fields (obsolet)4LENGLength (No. of Characters)nvarchar60
2/EHR/S71_OUTPMaintenance Output Fields5LENGField lengthnvarchar60
3/SAPQUERY/TA04Plane12LENGLength of planefloat1516
4/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info14LENGLength (No. of Characters)nvarchar60
5/SYCLO/CA003DMDO DOF Table Rule - Meta Data11LENGLength (No. of Characters)nvarchar60
6CNVCDOPUCIA_BDCCDOP: UCIA-Collect the BDC Program Comparison data12LENGnvarchar10
7CNVCMIS_A_1_DOMASelection of Object Type Master information8LENGLength (No. of Characters)nvarchar60
8CNVCMIS_A_1_DTELSelection of Object Type Master information33LENGLength (No. of Characters)nvarchar60
9CNVCMIS_A_1_SHLDSearch Help Data (Parameters)21LENGLength (No. of Characters)nvarchar60
10CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information22LENGLength (No. of Characters)nvarchar60
11CNVCMIS_A_1_TTYPTable types for Repository Analysis10LENGLength (No. of Characters)nvarchar60
12CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison16LENGLengthnvarchar60
13CNVMBTTABSTRUCField list of tables for file transfer13LENGLength (No. of Characters)nvarchar60
14CNV_10100_SETCLS(Obsolete for Package 10100)5LENGLengthnvarchar30
15CNV_10400_DTYPESStorage of data types to be analyzed4LENGLength (No. of Characters)nvarchar60
16CNV_20308_FLDCATField Catalog for Download10LENGLength (No. of Characters)nvarchar60
17CNV_20330_FIELDTable analysis - table fields with object numbers5LENGLength (No. of Characters)nvarchar60
18CNV_20330_TSTRUCStructure of CO object numbers8LENGLength (No. of Characters)nvarchar60
19CNV_20551_COMPOSMerge intransparent fields4LENGLengthnvarchar30
20CNV_20551_DEFINEIntransparent fields: Definition3LENGLengthnvarchar30
21CNV_20551_PARAMSIntransparent fields: Parameters3LENGLengthnvarchar30
22CNV_20551_PCLXStructure information for PCLx-RELID4LENGLength (No. of Characters)nvarchar60
23CNV_20551_TSTRU2Intransparent fields: Condition for structure description7LENGLength of distinguishing characteristic in intr. fieldnvarchar30
24CNV_20551_TSTRUCIntransparent fields: Structure description7LENGLengthnvarchar30
25CNV_INTR_FLD_COMMerge intransparent fields4LENGLengthnvarchar30
26CNV_INTR_FLD_DEFIntransparent fields: Definition3LENGLengthnvarchar30
27CNV_INTR_FLD_PARIntransparent fields: Parameters3LENGLengthnvarchar30
28CNV_INTR_FLD_STPIntransparent fields: Condition for structure description7LENGLengthnvarchar30
29CNV_INTR_FLD_STRIntransparent fields: Structure description7LENGLengthnvarchar30
30DD03NDDD: Attributes of a Node of a Structured Object17LENGLength (No. of Characters)nvarchar60
31DD10BDD: Parameters for Structured Objects, for ex. View Entities9LENGLength (No. of Characters)nvarchar60
32DDREPLICNVDATADD: Information on Metadata Transfer: Fields - Data Convers.9LENGLength (No. of Characters)nvarchar60
33DDREPLINDATADD: Information on Metadata Transfer: New Fields9LENGLength (No. of Characters)nvarchar60
34DFKKBIXC8162CIT Class Configuration Version (Table TFK8162)12LENGLength (No. of Characters)nvarchar60
35DFKKBIXE8162Working Version CIT Class Configuration (Table TFK8162)11LENGLength (No. of Characters)nvarchar60
36DFKKBIXG8162CIT Class Generation Version (Table TFK8162)12LENGLength (No. of Characters)nvarchar60
37FARR_C_RAI52Fields of a Revenue Accounting Item Class12LENGLength (No. of Characters)nvarchar60
38FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)13LENGLength (No. of Characters)nvarchar60
39FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)13LENGLength (No. of Characters)nvarchar60
40FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)13LENGLength (No. of Characters)nvarchar60
41IUUC_DB_COL_TYPEOverride default column type mapping of CL_IUUC_SQL_TOOLS7LENGLength (No. of Characters)nvarchar60
42IUUC_RL_TABSTRstructural historical information for tables(Transp,Cluster)12LENGLength (No. of Characters)nvarchar60
43MBO_FIELDBO - Table to maintain key information8LENGiSeries: Table field lengthint100
44NWS_EXT_HFData Transport Management Tool Reference Fields7LENGLength (No. of Characters)nvarchar60
45NWS_EXT_PARAMProgram Parameters7LENGLength (No. of Characters)nvarchar60
46RSCRMEXFLDSRSCRM: Extract field6LENGInternal Length in Bytesnvarchar60
47RSDODSODDICFIELDDataStore Object: Predefined DDIC Type Fields5LENGLength (No. of Characters)nvarchar60
48TFK8162Fields of a Consumption Item Class11LENGLength (No. of Characters)nvarchar60
49ZSA_D_PARAMProgram Parameters8LENGLength (No. of Characters)nvarchar60
TOPABAP Workbench, Java IDE and Infrastructure
50SAPLANEPlane12LENGLength of planefloat1516
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
51DD01LDomains5LENGLength (No. of Characters)nvarchar60
52DD03LTable Fields19LENGLength (No. of Characters)nvarchar60
53DD04LData elements25LENGLength (No. of Characters)nvarchar60
54DD16SR/3 DD: SQL table fields8LENGLength (No. of Characters)nvarchar60
55DD40LTable types (internal tables defined in DD)7LENGLength (No. of Characters)nvarchar60
TOPApplication Framework
56MDG_MDF2005Properties of Master Data Fields21LENGLength (No. of Characters)nvarchar60
TOPBasis Services Communication Interfaces
57KCDSPSender structure (part)6LENGData transfer: Sender field lengthnvarchar40
TOPBilling in Contract Accounts Receivable and Payable
58DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)13LENGLength (No. of Characters)nvarchar60
59DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)13LENGLength (No. of Characters)nvarchar60
60DFKKBIXG8152BIT Class Generation Version (Table TFK8152)13LENGLength (No. of Characters)nvarchar60
61TFK8152Fields for a Class of Billable Items12LENGLength (No. of Characters)nvarchar60
TOPBusiness Application Support
62CNV_10992_TSTRUCStructure of text object keys for texts8LENGLengthnvarchar30
63CNV_10994_TSTRUCIntransparent fields in change doc. obj.: Structure9LENGLengthnvarchar30
TOPBusiness Planning
64UPB_SY_CLINFOAttributes of Generated Class for Connection of Survey8LENGLength (No. of Characters)nvarchar60
TOPBW Service API
65ROOSGENQVFField Descriptions for Extract Structure Versions8LENGLength (No. of Characters)nvarchar60
TOPChange Documents
66CDSOLMIG_DDChange Document Objects to be Migrated16LENGLength (No. of Characters)nvarchar60
TOPChecksums
67CSUM_EV_FLDSExecuted Analyses - Fields7LENGLength (No. of Characters)nvarchar60
TOPCondition Technique
68/SAPCND/T688CFields from Condition Tables Sorted Acc. To Dependency18LENGLength (No. of Characters)nvarchar60
TOPCross-Application Components
69/IXOS/DC_TAMAGeneral Doculink administraton data for data source10LENGLength (No. of Characters)nvarchar60
TOPCustom Development Management Cockpit
70CNVCDMCUCIA_BDCCDMC: UCIA-Collect the BDC Program Comparison data12LENGnvarchar10
TOPData Basis
71RSBOHFIELDSFields of the Open Hub Destination9LENGLength (No. of Characters)nvarchar60
TOPData Collection
72MCSLISEFLIS Inbound Interface: Control Information (Fields)9LENGInternal Length in Bytesnvarchar60
TOPData Staging
73RSDANLSEGVFBW Archiving: Segment Version of a Nearline Object7LENGLength (No. of Characters)nvarchar60
74RSDSSEGFDDataSource - Segment Fields9LENGLength (No. of Characters)nvarchar60
75RSDSSEGFDSHDataSource in BW - Shadow Table Fields9LENGLength (No. of Characters)nvarchar60
76RSISFIELDSHShadow table: InfoSource fields11LENGLength (No. of Characters)nvarchar60
77RSISOFIELDInfoSource fields (provider structure of a source system)11LENGLength (No. of Characters)nvarchar60
78RSKSFIELDNEWFields for New InfoSource11LENGLength (No. of Characters)nvarchar60
79RSKSFIELDSHShadow table: Communication structure fields9LENGLength (No. of Characters)nvarchar60
80RSOLTPHIECOMReplicate of Compounding Info. for Hier.-DataSource in BW8LENGLength (No. of Characters)nvarchar60
81RSOLTPSOURCEFDSHShadow Table: OLTP Source Fields11LENGLength (No. of Characters)nvarchar60
82RSOLTPSOURCEFIEOLTP Source Fields11LENGLength (No. of Characters)nvarchar60
83RSOLTPSOURCESFISegment Fields of a DataSource12LENGLength (No. of Characters)nvarchar60
84RSOSATTFDSHShadow table: InfoSource attributes11LENGLength (No. of Characters)nvarchar60
85RSOSFIELDSHShadow table: InfoSource fields11LENGLength (No. of Characters)nvarchar60
86RSOSOATTFDInfoSource attributes of a source system11LENGLength (No. of Characters)nvarchar60
87RSOSOFIELDInfoSource fields of a source system10LENGLength (No. of Characters)nvarchar60
88RSRULEPARAMRule Parameters8LENGLength (No. of Characters)nvarchar60
89RSTRFIELDSHShadow table: Transfer Structure Fields11LENGLength (No. of Characters)nvarchar60
90RSTSDOMAGeneral domains for transfer structure2LENGLength (No. of Characters)nvarchar60
91RSTSDTELData element for transfer structure per logical system4LENGLength (No. of Characters)nvarchar60
92RSTSDTELNEWData element for transfer structure per logical system4LENGLength (No. of Characters)nvarchar60
93RSTSFIELDTransfer structure fields9LENGLength (No. of Characters)nvarchar60
94RSTSFIELDSHShadow table: Transfer structure fields11LENGLength (No. of Characters)nvarchar60
95RSTSIDOCFIELDFields for the IDoc Operational Data Store9LENGLength (No. of Characters)nvarchar60
96RSTSODSFIELDFields for the Operational Data Store10LENGLength (No. of Characters)nvarchar60
97RSUIFIELDSFields for Generated User Interfaces5LENGLength (No. of Characters)nvarchar60
TOPElectronic Data Interchange
98WRF_PRICAT_010SPrice Catalog Generic Structures and Fields per Catalog7LENGLength (No. of Characters)nvarchar60
TOPEmployee Self-Service
99T77WWW_WHO_SRDESS Who's Who: Field Selection per Country Grpg & Appl.Type15LENGSAP Query (S): Lengthnvarchar30
TOPF4 Help
100DD32SSearch Help Parameter17LENGLength (No. of Characters)nvarchar60
TOPFast Search Infrastructure
101SFSRFW_IDX_IFDReplication Framework - Definition of Index Fields7LENGLength of Field (Number of Characters)nvarchar40
102SFSRFW_IDX_KEY_DReplication Framework - Doc. ID Description of an Index6LENGLength of Field (Number of Characters)nvarchar40
103SFSRFW_REQ_OBJSReplication Framework Requested Tables9LENGLength of Field (Number of Characters)nvarchar40
TOPFinancials Basis
104UGMD2005FIN Master Data: Field Properties22LENGLength (No. of Characters)nvarchar60
105UGMD2140FIN Master Data: (Role-independent) Definition of Fields16LENGLength (No. of Characters)nvarchar60
106UGMD2150FIN Master Data: Active (Role-Indep.) Definition of Fields15LENGLength (No. of Characters)nvarchar60
107UGR31008FIN Master Data: Dummy Field Names with Properties21LENGLength (No. of Characters)nvarchar60
108UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures19LENGLength (No. of Characters)nvarchar60
TOPGermany
109T5DP1PAISY Interface12LENGLength (No. of Characters)nvarchar60
TOPIndustry-Specific Component Automotive
110MGV_LAMASCRLAYOULAMA Screen Fields14LENGText lengthvarbinary10
TOPInformation Consistency
111SIC_NODE_FIELDSDefinition of Fields per Node13LENGLength (No. of Characters)nvarchar60
TOPInterfaces
112VXSITDLExpress Delivery Company: Meta Description Data Field8LENGLength of the XSI Data Fieldnvarchar60
TOPLegacy System Migration Workbench
113/SAPDMC/LSGBDCBI Name: "Code"19LENGLength (No. of Characters)nvarchar60
TOPMerchandise and Assortment Planning
114TWISPC_REQKENNZMAP: Customizing for External Applications: Key Figures6LENGLength (No. of Characters)nvarchar60
115TWISPC_REQMERKMAP: Customizing for External Applications: Characteristics6LENGLength (No. of Characters)nvarchar60
TOPNetWeaver Enterprise Search
116ESH_OM_ADATATYData Types8LENGLength (No. of Characters)nvarchar60
117ESH_OM_CDATATYData Types8LENGLength (No. of Characters)nvarchar60
118ESH_OM_IDATATYData Types8LENGLength (No. of Characters)nvarchar60
119ESH_OM_SDATATYData Types8LENGLength (No. of Characters)nvarchar60
TOPPension fund Netherlands
120T5NKCTariff Calculation: Tabeltype kolom7LENGLengte (aantal tekens)nvarchar60
121T5NKGTariff Calculation: Tariefsettype parameters5LENGLengte (aantal tekens)nvarchar60
122T5NKKTariff Calculation: Tarief type parameter5LENGLengte (aantal tekens)nvarchar60
123T5NKOTariff Calculation: Calculatie actie - Input parameter6LENGLengte (aantal tekens)nvarchar60
124T5NKPTariff Calculation: Calculatie actie - Output parameter6LENGLengte (aantal tekens)nvarchar60
125T5NKRActuarial File: Actuarieel bestandstype kolom6LENGLengte (aantal tekens)nvarchar60
126T5NKVActuarial File: Parameter groep type parameters5LENGLengte (aantal tekens)nvarchar60
127T5NKZSelectiesettype parameter5LENGLengte (aantal tekens)nvarchar60
TOPPlanning
128T8PL01DDFI Planning: Dimensions Table Index - Dictionary Information8LENGLength (No. of Characters)nvarchar60
TOPProfitability Analysis
129/EACA/TPMCKYFVARList of the Calculated Key Figures for Variant6LENGLength (No. of Characters)nvarchar60
130TKEANCO-PA: Control Table for PA Derivation of Characteristics8LENGField length for derivation of characteristic valuesnvarchar60
131TKEZUCO-PA: Assignments to CO-PA Characteristics8LENGLength (No. of Characters)nvarchar60
TOPService Data Download
132/BDL/IFFIELD/BDL/SDCC: fiels, dataelements and domains of table14LENGnvarchar60
133BDLIFFIELDBDL SDCC: Table's Fields, Data Elements, Domains14LENGnvarchar60
TOPTax Reporting
134OIUX3_TX_RP_EDT1OBSOLETE - Tax 2.0 - Texas Report Field Attribute Edits7LENGLength (No. of Characters)nvarchar60
TOPTreasury
135CML_MIG_BUFFERTable DDIC buffering (migration)11LENGLength (No. of Characters)nvarchar60
TOPUnits of Measurement
136T006DDimensions3LENGLength exponentsmallint50
TOPUse Subcomponents
137TSINASAPBPT: Configuration Table18LENGColumn widthnvarchar30
138TSINOSAPBPT: General SAP configuration columns7LENGColumn widthnvarchar30
139TSINUSAPBPT: Configuration Table User7LENGColumn widthnvarchar30
TOPUser and Authorization Management
140AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary7LENGLength (No. of Characters)nvarchar60
TOPWithout Description
141RSKSFIELDFields of the communication structure9LENGLength (No. of Characters)nvarchar60
TOPWorkbench Utilities
142SPAR_NTDBParameter Storage: Persistent Nametab Container14LENGLength (No. of Characters)nvarchar60