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

97 columns | Print definition?ERP 6.0  | BIS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/UST12Copy of table UST12 (used in Security Optimization Services)6BISAuthorization Valuenvarchar400
2T548SDate Conversion5BISText for end datenvarchar200
TOPBusiness Package for Manager Self-Service FI
3FPB_GEN_PROF_LOGLog Entries for Generating Authorizations8BISAuthorization Valuenvarchar400
4FPB_VALUESAuthorizations for FG FPB_Berechtigungen7BISAuthorization Valuenvarchar400
TOPCapacity Leveling
5R2AUFNROrder number for transfer from R/2 to PP-PI2BISLast order number in the interval to be transferrednvarchar80
TOPContract Accounts Receivable and Payable
6TE011Code for Tax Code Determination5BISDate at Which a Time Slice Expiresnvarchar80
TOPContract Billing
7DBERCHVConsumption History6BISDate at Which a Time Slice Expiresnvarchar80
8DBERCHZIndividual Line Items21BISDate at Which a Time Slice Expiresnvarchar80
9DBERCHZ1Individual line items21BISDate at Which a Time Slice Expiresnvarchar80
10DBERCHZ5Individual line items (unimportant rows)21BISDate at Which a Time Slice Expiresnvarchar80
11EBURNHBurning Hour Calendar for Lighting Unit4BISDate at Which a Time Slice Expiresnvarchar80
12EDSCHDiscount Historical Data5BISDate at Which a Time Slice Expiresnvarchar80
13EKDIRate Facts6BISDate at Which a Time Slice Expiresnvarchar80
14EPRESCLHHistory of Price Adjustment Clause3BISDate at Which a Time Slice Expiresnvarchar80
15ERCHPAnalysis periods for dynamic period control5BISDate at Which a Time Slice Expiresnvarchar80
16ERCHV_GEN_PROTStructure Log of Consumption History9BISTo Date of Selection for ERCHV Structurenvarchar80
17ERCHZ_SHORTBilling Document Individual Lines Extract20BISDate at Which a Time Slice Expiresnvarchar80
18ERTFNDRate Determination4BISDate at Which a Time Slice Expiresnvarchar80
19ETFNDRate Determ.4BISDate at Which a Time Slice Expiresnvarchar80
20ETTAFRate Cat.Facts5BISDate at Which a Time Slice Expiresnvarchar80
21ETTIFInstln Facts8BISDate at Which a Time Slice Expiresnvarchar80
22ETTIFBInstallation Facts (Reference Values)6BISDate at Which a Time Slice Expiresnvarchar80
23ETTIFNInstallation Facts (Normal)7BISDate at Which a Time Slice Expiresnvarchar80
TOPCustomer Service
24EDISCOBJHDisconn.Doc.: Disc.Period4BISDate to which a disconnection is validnvarchar80
25EDISCREMOVDisconnection Document: Device Removal Periods5BISDate to which a disconnection is validnvarchar80
TOPDevice installation
26EADZMultiple-Installation Billing Data: Register3BISDate at Which a Time Slice Expiresnvarchar80
27EASTIRegister Relationships4BISDate at Which a Time Slice Expiresnvarchar80
28EASTLBilling data: Installation Structure at Device Level4BISDate at Which a Time Slice Expiresnvarchar80
29EASTSBilling data: Installation Structure at Reg. Level4BISDate at Which a Time Slice Expiresnvarchar80
30ETDZTechnical Data for Installed Register4BISDate at Which a Time Slice Expiresnvarchar80
31EZUGDevice Allocations for Device (Non-Metering Devices)3BISDate at Which a Time Slice Expiresnvarchar80
32EZUZDevice Allocations for Register (Metering Devices)3BISDate at Which a Time Slice Expiresnvarchar80
TOPDevice Management
33EANASIS-U Device Checker: Current Processing Status of Test6BISNumber of Last Object to be Testednvarchar300
34EDEVGR_CDChange Document for Dev. Group: Table with Device Data4BISDate at Which a Time Slice Expiresnvarchar80
35EGERHHistorical Data of ISU Device Master Record3BISDate at Which a Time Slice Expiresnvarchar80
36EGERRDevice data: Info record for point of delivery - historical3BISDate at Which a Time Slice Expiresnvarchar80
TOPEnergy Data Management
37EEDMUISETTLUNITAllocation of Point of Delivery to Settlement Unit4BISDate at Which a Time Slice Expiresnvarchar80
TOPGRC Access Control Plug-In
38/VIRSA/FUNCTOBJFunction - Objects7BIS'To' valuenvarchar400
39/VIRSA/ORGRULESOrganizational values6BIS'To' valuenvarchar400
40/VIRSA/ORGUSERSMapping between users and the organizational values6BIS'To' valuenvarchar400
41/VIRSA/ZCRAUTHAuthorization Objects6BIS'To' valuenvarchar400
42/VIRSA/ZCRAUTHC1Restricted Critical Authorizations6BIS'To' valuenvarchar400
43/VIRSA/ZCRAUTHL1SOD Authorization Object6BIS'To' valuenvarchar400
44/VIRSA/ZCRAUTHL2SOD Authorization Object6BIS'To' valuenvarchar400
45/VIRSA/ZCRAUTHL3SOD Authorization Object6BIS'To' valuenvarchar400
46/VIRSA/ZCRAUTHL4SOD Authorization Object6BIS'To' valuenvarchar400
47/VIRSA/ZCRAUTHL5SOD Authorization Object6BIS'To' valuenvarchar400
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
48TFAINCalendar: Intervals for company holidays, special shifts4BISDate, until which the rule appliesnvarchar80
TOPIntegration Customer Relationship Management
49ECRM_REPL_HDHeader Data for IS-U Sales Replication Error Handling4BISDate at Which a Time Slice Expiresnvarchar80
50EVER_CRMQISU Contract CRM-Entry Queue7BISDate at Which a Time Slice Expiresnvarchar80
TOPIntercompany Data Exchange
51EGRIDHAllocation of Distributor to Grid3BISDate at Which a Time Slice Expiresnvarchar80
52EGRIDRATEDETRate Determination for Grid6BISDate at Which a Time Slice Expiresnvarchar80
TOPInvoicing
53DBERDLPrint Document Line Items41BISDate at Which a Time Slice Expiresnvarchar80
54DBERDZDB Table: Individ. Lines - Print Document47BISDate at Which a Time Slice Expiresnvarchar80
55TE211BB: Rounding Parameter6BISUpper limit of budget billing amount for roundingdecimal122
56TE647Dynamic Determination of BB Cycle4BISUpper limit for dynamic determination of bud. billing cycledecimal122
TOPMaster Data
57EANLHInstall.Time Slice3BISDate at Which a Time Slice Expiresnvarchar80
58EBP_ADDR_SERVICESearch Index for Business Partner Service Addresses4BISDate at Which a Time Slice Expiresnvarchar80
59EVERHIS-U Contract History3BISDate at Which a Time Slice Expiresnvarchar80
TOPMeter Reading
60EABLQDCONVConversion History for Quantity Det. During Meter Reading5BISDate at Which a Time Slice Expiresnvarchar80
61EABLQDCONVDELConversion History for QD During (Deleted) Meter Reading5BISDate at Which a Time Slice Expiresnvarchar80
62EASTERegister-related Period Consumption4BISDate at Which a Time Slice Expiresnvarchar80
TOPMobile Applications
63/ISDFPS/MECAA010Local Authorization (Item) for Logging11BISAuthorization Valuenvarchar400
TOPPublic Sector
64P01ZFA_NN_DATAZfA: Notifications Not Assigned40BISTo-Period (5.0)nvarchar60
65P01ZFA_NN_KIDSZfA: Notifications Not Assigned - Child Data18BISTo-Period (5.0)nvarchar60
TOPSAP Utilities
66ECONCARDHBusiness Partner - Concession Card: Time Slice4BISDate at Which a Time Slice Expiresnvarchar80
67ELPASSAllocation of Load Profiles to any BOR Objects5BISDate at Which a Time Slice Expiresnvarchar80
68EUFASSAllocation of Usage Factor to any BOR Objects5BISDate at Which a Time Slice Expiresnvarchar80
69EUFASS_HISTTable of Usage Factor Applied to a Load Profile (History)4BISDate at Which a Time Slice Expiresnvarchar80
TOPUser and Authorization Management
70USKRIAEntry of Critical Auths for Report RSUSR0095BIS'To' valuenvarchar400
71USKRIATText table for USKRIA6BIS'To' valuenvarchar400
72UST12User master: Authorizations7BISAuthorization Valuenvarchar400
TOPWaste Management
73EEWA_GUARANTORHGuarantor Contract History3BISDate at Which a Time Slice Expiresnvarchar80
74EEWA_PROPAllocation of Cleaning Objects to Property4BISDate at Which a Time Slice Expiresnvarchar80
75EEWA_ROBCleaning Object3BISDate at Which a Time Slice Expiresnvarchar80
76EWAELOCEOAllocation Table: Waste Disp. Object to Container Location6BISDate at Which a Time Slice Expiresnvarchar80
77EWAELOCSDAllocation Table: Container Loc.Data <-> Sales Document Item4BISDate at Which a Time Slice Expiresnvarchar80
78EWAELOCSD_INTEWAELOCSD Dummy Table With Key Fields as CHAR4BISDate at Which a Time Slice Expiresnvarchar80
79EWAELOCSD_NEWAllocation Table: Container Loc.Data <-> Sales Document Item4BISDate at Which a Time Slice Expiresnvarchar80
80EWAELOC_DIFFCAllocation Table: Notes for Container Location5BISDate at Which a Time Slice Expiresnvarchar80
81EWAOBJHService Frequency -> Services (History for EWAOBJ)4BISDate at Which a Time Slice Expiresnvarchar80
82EWAOBJH_AAT_HISTHistory and Valution of WBCs for Service Freq. Service6BISValid-To Datenvarchar80
83EWAOBJH_DATESAppendix table of changed data for service frequency4BISDate at Which a Time Slice Expiresnvarchar80
84EWAOBJH_DIFFCULTService Frequency Notes4BISDate at Which a Time Slice Expiresnvarchar80
85EWAOBJH_SDSHARESubitems of Sales Document for Service Type4BISDate at Which a Time Slice Expiresnvarchar80
86EWAOBJH_SEQUENCERoute Sequence per EWAOBJH4BISDate at Which a Time Slice Expiresnvarchar80
87EWAOBJH_UPOSSubitems of Sales Document for Service Type4BISDate at Which a Time Slice Expiresnvarchar80
88EWAPROPSDAllocation Table: Property <-> Sales Document Item4BISDate at Which a Time Slice Expiresnvarchar80
89EWA_CCOC_ASS_EQCO Assignment and Vehicle20BISDate at Which a Time Slice Expiresnvarchar80
90EWA_CCOC_ASS_IUPAssign CO Data for WD Item and SD Item17BISDate at Which a Time Slice Expiresnvarchar80
91EWA_CCOC_ASS_IWPAssign CO Data WD Item and Waste/Waste Disposal Facility18BISDate at Which a Time Slice Expiresnvarchar80
92EWA_CCOC_ASS_REAllocate CO and Container (Rent)23BISDate at Which a Time Slice Expiresnvarchar80
93EWA_CCOC_ASS_RSAssign CO Data to Resources18BISDate at Which a Time Slice Expiresnvarchar80
94EWA_CCOC_ASS_WPCO Assignment to Waste Disposal Facility18BISDate at Which a Time Slice Expiresnvarchar80
95EWA_CCOC_ASS_WPCAllocation of CO Data for Weighing Transaction (Waste)18BISDate at Which a Time Slice Expiresnvarchar80
96EWA_FAKTORFactors for Billing of Waste Management Services4BISDate at Which a Time Slice Expiresnvarchar80
97EWA_VBSTable Supplement for Premise with Historical Data3BISDate at Which a Time Slice Expiresnvarchar80