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

166 columns | Print definition?ERP 6.0  | DATETO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/TFPERIDTexts: Char. Employee3DATETOValid tonvarchar80
2/B631/HPLANTHierarchy: InfoObject Plant12DATETOValid tonvarchar80
3/B631/TACTTYPETexts: Char. Activity Type4DATETOValid tonvarchar80
4/B631/TCOSTCNTRTexts: Char. Cost Center4DATETOValid tonvarchar80
5/B631/TCOSTELMTTexts: Char. Cost Element4DATETOValid tonvarchar80
6/B631/TPROFTCTRTexts: Char. Profit Center3DATETOValid tonvarchar80
7/BI0/HTCTQUERIDHierarchy: InfoObject Query (UID)12DATETOValid tonvarchar80
8/BI0/HTCTUSERNMHierarchy: InfoObject User12DATETOValid-to datenvarchar80
9/BI0/HTCTUSRNMHierarchy: InfoObject User ID12DATETOValid tonvarchar80
10/BI0/PCALMONTHMaster Data (Time-Ind.): Characteristic Calendar Year/Month9DATETOValid tonvarchar80
11/BI0/PCALWEEKMaster Data (Time-Ind.): Characteristic Calendar Year/Week7DATETOValid tonvarchar80
12/BI0/PCALYEARMaster Data (Time-Ind.): Characteristic Calendar Year7DATETOValid tonvarchar80
13/BI0/QRSPL_ORGMaster Data (Time-Ind.): Characteristic Area of Responsibil.3DATETOValid tonvarchar80
14/BIC/B0000159000PSA for 0COSTCENTER_ATTR T90CLNT090 Cost center7DATETOnvarchar80
15/BIC/B0000160000PSA for 0COSTCENTER_TEXT T90CLNT090 Cost Center8DATETOnvarchar80
16/BIC/B0000161000Error Stack DTP_00O2TFZRKJJTTMXXZL7N57I2W 00017DATETOnvarchar80
17/BIC/B0000282000PSA for 0EMPLOYEE_TEXT T90CLNT090 Employee6DATETOnvarchar80
18/BIC/B0000284000PSA for 0EMPLOYEE_2_TEXT T90CLNT090 Employee (Texts)6DATETOnvarchar80
19/BIC/B0000286000PSA for 0PERSON_TEXT T90CLNT090 Person6DATETOnvarchar80
20/BIC/TZCOSTCENTTexts: Char. Cost Center5DATETOValid tonvarchar80
21/BIC/TZEMPTexts: Char. Employee3DATETOValid tonvarchar80
22/SDF/SQLTIMSTSQL Monitor History: Timestamps - Mapping to time frame4DATETOBegin of Data Collectionnvarchar80
23CMCBD_LQH_ATTRLiquidity Item Hierarchy Attributes (Header) Runtime6DATETOValid Tonvarchar80
24CMCB_LQH_ATTRLiquidity Item Hierarchy Attributes (Header) Runtime4DATETOValid Tonvarchar80
25DBERCHECondition Data7DATETOEnd Datenvarchar80
26DFKKSAFTSALObsolete!8DATETODatenvarchar80
27DFKKSAFTSAL_BPSAF-T Balances10DATETODatenvarchar80
28ECONDIIS-U: Conditions7DATETOEnd Datenvarchar80
29ETOUEXCEPTIONTOU Exception5DATETOTOU Exception To-Datenvarchar80
30FARR_D_POB_HISHistory table for POB/Contract Structure Change3DATETOValid To Datenvarchar80
31FCLM_LQH_ATTRLiquidity Item Hierarchy Attributes (Header)4DATETOValid Tonvarchar80
32RSBPCE_DAP_DIMBPC: DAP Dimension & Hierarchy10DATETOValid-to datenvarchar80
33RSDDSTATSLICEEXExtracted values5DATETOValid-to datenvarchar80
34RSDMASTTAB_NOSIDModel Table: Sidless Attr. SID Table (Non-time-dependent)3DATETOValid-to datenvarchar80
35RSSMADAPPARAMParameter perisitence for dap generation2DATETOValid-to datenvarchar80
36TIVXCESACCOMPCompanies with agreement of Autonomous community5DATETODate: Valid Tonvarchar80
37VIXCESCDLOGLog of Secure Deposit Files7DATETODate: Valid Tonvarchar80
38VIXCESIBIDATAIBI master data6DATETODate: Valid Tonvarchar80
39VIXCITCADAOTemporary architectural object data95DATETODate: Valid Tonvarchar80
40VIXCITTASIDATATASI master data4DATETODate: Valid Tonvarchar80
TOPAerospace Defence Industry Solution
41EQUIPKPIUsed to store the Delta values and counters for MTBE calc4DATETOEnd date of time segmentnvarchar80
42ROTKPITable is used to store the various KPI values of rotables4DATETOEnd date of time segmentnvarchar80
TOPAssortment Maintenance
43WSOJOBMAPMAP: Temporary Listing Table from Planning13DATETOValid To Datenvarchar80
TOPBI Content Analyzer
44RSCONTENTCHECK_EExceptions Table for Content Checks8DATETOSystem Datenvarchar80
TOPBilling in Contract Accounts Receivable and Payable
45TFK8010Billing Rate Determination6DATETOEnd of Validity for a Billing Rate (Date)nvarchar80
TOPBusiness Partner
46BP3100Additional information14DATETOValid-To Date for Additional Informationnvarchar80
TOPBusiness Planning
47UPB_HI_REFPlanning Applucations: Reference to Hierarchy4DATETOValid Tonvarchar80
TOPBusiness Planning and Simulation
48UPC_NODESHierarchy Node6DATETOValid Tonvarchar80
49UPC_STEPSRelations between Characteristics of a Planning Area8DATETOValid Tonvarchar80
50UPC_VAR_HIEVariables - Hierarchies6DATETOValid Tonvarchar80
51UPC_VAR_HIE_SELVariables - Selections using Hierarchies8DATETOValid Tonvarchar80
52UPC_VAR_HIE_SELAVariables - Selections using Hierarchies (Active Values)8DATETOValid Tonvarchar80
53UPP_DOCPlanning: Layout Builder Info about Document15DATETOValid Tonvarchar80
54UPS_TP_HIERARCHYConnection Subplan-Hierarchy6DATETOValid Tonvarchar80
55UPX_DSRC_HEADUPX: Data Sources - Header7DATETOValid Tonvarchar80
TOPBW Service API
56ROVERFIELHHierarchy using Test Fields in Verification Scenario12DATETOValid-to datenvarchar80
57ROVERTYPEATest Type in Verification Scenario4DATETOValid-to datenvarchar80
58ROVERTYPETTexts for Test Type in Verification Scenario4DATETOValid-to datenvarchar80
TOPCapacity Evaluations
59TCY08Option profiles27DATETOFinish date for output of capacity evaluationsnvarchar100
TOPClaims Management
60ICLPROCUREClaim Item Groupings17DATETOEnd Date of Periodnvarchar80
61ICSPROCUREClaim Item Groupings17DATETOEnd Date of Periodnvarchar80
TOPCommodity Pricing Engine
62CPEC_PERIODDETCPE Term - Period Determination Rule16DATETOCPE Term - End Date for Fixed Periodnvarchar80
63CPED_PERIODDTINCPE Term - Changed Input Data for Period Determination14DATETOCPE Term - End Date for Fixed Periodnvarchar80
TOPConsumption-Based Planning See Also PP-MRP
64WSAF_EVENTS_OCDefinition of Calendar Events Occurred5DATETOValid Tonvarchar80
65WSAF_EVENTS_OC_TDefinition of Calendar Effects Occurred (Text)6DATETOValid Tonvarchar80
TOPContract Billing
66DBERCHZ4Individual line items (rarely used fields)41DATETOEnd Datenvarchar80
67DBERCHZ8Document line items (rarely used fields, unimportant)41DATETOEnd Datenvarchar80
68EMDUSDRQEXCLException Days for Subrequest7DATETOEnd Datenvarchar80
69EMDUSDRQITEMSubrequest for Request8DATETOEnd Datenvarchar80
TOPControlling
70FCOMIPHIEDIRUnique Ids for extracted Hierarchies6DATETOValid-to datenvarchar80
TOPData Basis
71RSBMONMonitor Variants for Open Hub Monitor4DATETOValid-to datenvarchar80
72RSDMDATTRDATERelation: Char. and Key Dates of Time-Dependent Attribute2DATETOValid-to datenvarchar80
73RSHIEDIRHierarchy Catalog6DATETOValid-to datenvarchar80
74RSMAXHIETABHierarchy Node Table with Maximum Possible Structure12DATETOValid-to datenvarchar80
75RSMDUCMUKHIERUT Hierarchy: Identifying attributes for MUKs7DATETOValid-to datenvarchar80
TOPData Mining
76RSDMTP_BAT_HRHDRBW Hierarchy Creation - Hierarchy Header Details5DATETOValid-to datenvarchar80
TOPData Staging
77RSHIENODETMPHelp Table for Packaged Loading of Hierarchies11DATETOValid-to datenvarchar80
78RSTSIDOCIDoc Operational Data Store for the transfer structure3DATETOValid-to datenvarchar80
79RSTSODSOperational Data Store for the transfer structure3DATETOValid-to datenvarchar80
TOPElectronic Data Interchange
80PRICAT_K001PRICAT: Catalog header12DATETOPRICAT: "Valid to" date of messagenvarchar80
TOPEnd User Technology
81RSRA_BP_OBJECTSParts of the Batch Printing Setting24DATETOValid-to datenvarchar80
82RSRA_ER_DRILLDrill Characteristics for the Exception Reporting Setting9DATETOValid-to datenvarchar80
83RSZELTPROPElement properties (settings)48DATETOBW: Unequivocal ID in room and time (numbers and letters)nvarchar250
84RSZGLOBVGlobal Variables in Reporting34DATETOValid-to datenvarchar80
85RSZRANGESelection specification for an element24DATETOBW: Unequivocal ID in room and time (numbers and letters)nvarchar250
TOPEnergy Data Management
86EDEXDEFSERVPROVData Exchange Definition for Service Provider6DATETOValid Tonvarchar80
87EDEXDEFUIData Exchange Definition for Service Provider7DATETOValid Tonvarchar80
88EEDMIMPORTLOG_DBEDM Import Log: Database Table7DATETOTo-Date for Profile Valuesnvarchar80
89EEDMPROSENDRecording of Sent Profiles5DATETOTo-Datenvarchar80
90EEDMSETTLDOCSettlement Document (Header)5DATETOTo-Datenvarchar80
91EEDMSETTLDOCSNDPSettlement Document (Sent Profiles)10DATETOTo-Datenvarchar80
92EEDMSETTLDOCUPDPSettlement Document (Updated Profiles)12DATETOTo-Datenvarchar80
93EEDMSETTLINLoad Shapes Per Settlement Run6DATETOTo-Datenvarchar80
94EEDMSETTLPODCONSGenerated Consumption per Point of Delivery3DATETOTo-Datenvarchar80
95EEDMSETTLUFUsage Factors per Settlement Run6DATETOTo-Datenvarchar80
96EEDMSETTLUNITSettlement Unit (Header Data)5DATETOTo-Datenvarchar80
97EEDMSETTLUNITGENSettlement Unit: Generated Form5DATETOTo-Datenvarchar80
98EEDMSETTLUNITHSettlement Unit (Historical Data)5DATETOTo-Datenvarchar80
99EEDMSYNPROFALLOCSynthetic Profile: Allocation of Profiles4DATETOTo-Datenvarchar80
100EFORMULAHIERIS-U EDM Hierarchy Levels of Formula Instance (DB Table)9DATETOTo-Datenvarchar80
101EFORMULAINSTPMIISU EDM Input Parameters for Formula Instance (DB Table)5DATETOTo-Datenvarchar80
102EFORMULATRIGKMPISU EDM Compressed Trigger File for Formula Inst. (DB Table)5DATETOTo-Datenvarchar80
103EFORMULATRIGTMPISU EDM Temporary Trigger File for Formula Inst. (DB Table)6DATETOTo-Datenvarchar80
104EPROFASSAllocation of Profiles4DATETOTo-Datenvarchar80
105EPROFHEADProfile Header Data18DATETOTo-Datenvarchar80
106EPROFHEAD_TMPHeader Data of Temporary Profile18DATETOTo-Datenvarchar80
107EPROFVALSTATProfile Value Status3DATETOTo-Datenvarchar80
108EPROFVALSTATHISTHistory of Profile Value Status3DATETOTo-Datenvarchar80
109EPROFVALSTAT_TMPStatus of Temporary Profile Values3DATETOTo-Datenvarchar80
110EPROFVERSHEADHeader Data for Profile Version6DATETOTo-Datenvarchar80
111EPROFVERSSTATStatus of Profile Version of Version3DATETOTo-Datenvarchar80
112ERTPEXDAY_TO_INSAllocation of Exception Agreement for Installation4DATETOTo-Datenvarchar80
113ERTPIFACECOMPHISComponents for RTP Interface (Historical Part)6DATETOTo-Datenvarchar80
114ERTPIFACEINPAllocation of Input Parameters for RTP Interface8DATETOTo-Datenvarchar80
115ERTPIFACEINSTActivation of RTP Components for Individual Installations5DATETOTo-Datenvarchar80
116ERTPIFACEINSTPARAllocation of Parameters to RTP Interface for Indiv. Insts7DATETOTo-Datenvarchar80
117ESERVPROVHISTService Provider (Historical Data)5DATETOTo-Datenvarchar80
118ESERVPROVSERVICENon-Billable Services (Service Types) for Service Provider4DATETOTo-Datenvarchar80
119ESOURCEHSource of Object (Historical Data)3DATETOTo-Datenvarchar80
TOPEnhanced Intercompany Data Exchange
120/ISIDEX/ECANCONCancellation Conditions3DATETOTo-Datenvarchar80
TOPFlexible Real Estate Management
121VIXCITICIDATAICI master data5DATETODate: Valid Tonvarchar80
122VIXCRAESRREFIAssignment of ISR Ref./Cash Flow Plan (Item)10DATETODate: Valid Tonvarchar80
TOPIntercompany Data Exchange
123EDEREGPODGROUPPoD Group5DATETOValid Tonvarchar80
124EDEREGSCENARIOSupply Scenario6DATETOTo-Datenvarchar80
125EDEREGSPAGREEService Provider Agreements5DATETOTo-Datenvarchar80
126EDRGPODGRASSIGNAllocation Criteria for PoD to PoD Group (Default)6DATETOValid Tonvarchar80
127EUIPODGROUPPoint of Delivery Group at PoD3DATETOTo-Datenvarchar80
128TINV_INV_LOGHDLog Table - HEAD - for Bill Receipt Processing7DATETODatenvarchar80
TOPLocalization
129VIXCFRBUDGETBudget Seasonality Data89DATETODate: Valid Tonvarchar80
130VIXCFREOStatuses of Extraordinary Operation4DATETOValid Tonvarchar80
131VIXCPTIMIDATAIMI Master Data5DATETOValid to datenvarchar80
TOPMetadata Repository
132RSDMASTTABModel Table: Attributes SID Table (Non-time-dependent)3DATETOValid-to datenvarchar80
133RSDMCHTTABModel Table: Master Data Table (Time-dependent)3DATETOValid-to datenvarchar80
134RSDMHSITABTHJModel Table: Conversion Hierarchy Nodes - SID (THJ)6DATETOQuery: Key datenvarchar80
135RSDMSIDTABTHJModel Table: Master Data IDs of a Characteristic (THJ)4DATETOQuery: Key datenvarchar80
136RSDMTXTTABModel table: Texts of a characteristic3DATETOValid-to datenvarchar80
TOPOLAP Technology
137RSDDAGGRCOMPDescription of the aggregates12DATETOValid-to datenvarchar80
138RSRHIEDIR_TIMDEPTime Intervals with Time-Dependent Hierarchies3DATETOValid-to datenvarchar80
139RSSAUTHHIERDefinition of the Authorizations for Hierarchies6DATETOValid-to datenvarchar80
TOPPatient Management
140NATMIS-H/IS-H*MED: Time Slot Modification8DATETOIS-H/IS-H*MED: Modification End Datenvarchar80
TOPPersonalization Framework
141FPB_PERSPARMPersonalization: User Settings7DATETODatenvarchar80
TOPPlanning
142RSPLF_SRV_CONDRule Condition in Planning Service19DATETOBW: Unequivocal ID in room and time (numbers and letters)nvarchar250
143RSPLF_SRV_PSParameter Value (Selection Type)21DATETOBW: Unequivocal ID in room and time (numbers and letters)nvarchar250
144RSPLS_CR_PROPCharacteristic Relationships: Settings3DATETOCharacteristic Relationships: Validity Datenvarchar80
145RSPLS_CR_RANGEChar.Relationship: Range (for example, for DataStore Object)19DATETOBW: Unequivocal ID in room and time (numbers and letters)nvarchar250
146RSPLS_CR_STEPSRelationships Between Characteristics in Basic InfoProvider13DATETOValid-to datenvarchar80
147RSPLS_DS_RANGEData Slices: Selection19DATETOBW: Unequivocal ID in room and time (numbers and letters)nvarchar250
TOPPoint of delivery
148EUIGRIDAllocation of PoD to Grid3DATETOTo-Datenvarchar80
149EUIINSTLNAllocation of Installation to PoD4DATETOTo-Datenvarchar80
150EUILNRAllocation of Logical Device to PoD4DATETOTo-Datenvarchar80
151EUILZWAllocation of Logical Register to PoD4DATETOTo-Datenvarchar80
152EUITRANSTransformation of Internal/External Point of Delivery No.3DATETOTo-Datenvarchar80
TOPPortal Content
153ISTNLMALERTCAAlert Category3DATETOValidity End for Alert Categorynvarchar80
TOPRevenues and Earnings
154VPKHEADSales Pricing Header Data20DATETOPosting date tonvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
155TNWAT_EDI_FACDEFIS-H AT: EDIVKA Korrekturenfaktoren und Nebenbedingungen5DATETOIS-H AT: EDIVKA - Eintrag gültig bis Datumnvarchar80
156TNWAT_EDI_KONDMPIS-H AT: EDIVKA Konditionen zu Korrekturfakt./Nebenbeding.6DATETOIS-H AT: EDIVKA - Eintrag gültig bis Datumnvarchar80
TOPSAP Utilities
157EEXTSYNPROFConversion of External Synthetic Profile ID and Profile4DATETOTo-Datenvarchar80
158EEXTSYNPROFTConversion of Ext. Synth. Prof. Description and Prof. (Txt)4DATETOTo-Datenvarchar80
TOPStakeholder Relationship Management
159USS_BW_HIERARCHYUSTH0: BW Hierarchy5DATETOValid Tonvarchar80
TOPTime Zones
160TTZDFSummer time rules (fixed annual dates)6DATETOEnd of Daylight Saving Time: Datenvarchar80
TOPWithout Description
161RSHIENODESHierarchy Node(s)12DATETOValid-to datenvarchar80
162RSRBDIMDimension table including the print settings27DATETOValid-to datenvarchar80
TOPWork Clearance Management
163WCAAPWCM: Application19DATETOValid-To Date for WCM Objectnvarchar80
164WCAHEWCM: Work Clearance Document (Header)20DATETOValid-To Date for WCM Objectnvarchar80
165WCAJWCM: Lineup25DATETOValid-To Date for WCM Objectnvarchar80
166WCAWWCM: Work Approval18DATETOValid-To Date for WCM Objectnvarchar80