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

83 columns | Print definition?ERP 6.0  | VIEWID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTEI/DU_WD_DCTPDocument types customzing table3VIEWIDViewnvarchar30
2/OTEI/DU_WD_EMALEmail customizing table3VIEWIDViewnvarchar30
3/OTEI/DU_WD_TISTTicket Subject3VIEWIDViewnvarchar30
4/OTEI/DU_WD_TISUTicket Subject3VIEWIDViewnvarchar30
5/OTEI/DU_WD_TITLTitle and subtitle customizing table4VIEWIDViewnvarchar30
6/OTEI/DU_WD_TITTTitle and subtitle customizing text table4VIEWIDViewnvarchar30
7/OTEI/T_ACT_DELCConfigure Activity Log delete options4VIEWIDViewnvarchar30
8/OTEI/T_A_LOG_CUTable for activity logging configuration4VIEWIDViewnvarchar30
9/OTEI/T_BUSDOC_CMaster for business document types4VIEWIDViewnvarchar30
10/OTEI/T_CHANGE_CCustomizing options for changing actions in EFM5VIEWIDViewnvarchar30
11/OTEI/T_SETEFM: General settings4VIEWIDViewnvarchar30
12NWVIEW_019Special View Data for Workflow Tasks3VIEWIDIdentification of a Viewnvarchar100
13RSCRMVIEWSTORERepository for ISQ Views3VIEWIDNew View ID in BW30nvarchar300
TOPBusiness Analytics
14UALAYOUTLayout Table6VIEWIDCharacter Field Length = 10nvarchar100
15UALAYOUTTText Table for UALAYOUT6VIEWIDCharacter Field Length = 10nvarchar100
TOPBusiness Package for Manager Self-Service HR
16TWPC_NAVDefine Navigation Types3VIEWIDView of an Organizational Structurenvarchar60
17TWPC_OTYPESObject Types to be Displayed in the List2VIEWIDView of an Organizational Structurenvarchar60
18TWPC_OTYPES_CObject Types to be Displayed in the List - Customer2VIEWIDView of an Organizational Structurenvarchar60
19TWPC_VView Definition2VIEWIDView of an Organizational Structurenvarchar60
20TWPC_VGGrouping the Views3VIEWIDView of an Organizational Structurenvarchar60
21TWPC_VG_CGrouping the Views3VIEWIDView of an Organizational Structurenvarchar60
22TWPC_V_CView Definition - Customer2VIEWIDView of an Organizational Structurenvarchar60
23TWPC_V_TTexts for Views3VIEWIDView of an Organizational Structurenvarchar60
24TWPC_V_T_CTexts for Views3VIEWIDView of an Organizational Structurenvarchar60
TOPClinical System
25N1VIEW_017_PERSi.s.h.med: Personal Setting for View Type 0174VIEWIDIdentification of a Viewnvarchar100
26NWVIEW_006IS-H / IS-H*MED: Special View Data Documents3VIEWIDIdentification of a Viewnvarchar100
27NWVIEW_011IS-H / IS-H*MED: Special View Data Surgeries3VIEWIDIdentification of a Viewnvarchar100
28NWVIEW_012IS-H / IS-H*MED: Special View Data Drug Order3VIEWIDIdentification of a Viewnvarchar100
29NWVIEW_013IS-H / IS-H*MED: Special View Data Drug Events3VIEWIDIdentification of a Viewnvarchar100
30NWVIEW_015Medication: Medication Order, Cross-Institutional3VIEWIDIdentification of a Viewnvarchar100
31NWVIEW_016IS-H / ISHMED: Special View Data Dictations3VIEWIDIdentification of a Viewnvarchar100
32NWVIEW_017i.s.h.med: Special View Data Surgery Progress Monitor3VIEWIDIdentification of a Viewnvarchar100
33NWVIEW_018IS-H/ISHMED: Special View Data Surgery Planning Work Station3VIEWIDIdentification of a Viewnvarchar100
34NWVIEW_P01IS-H / IS-H*MED: Spezialization Table for Patient Organizer3VIEWIDIdentification of a Viewnvarchar100
TOPCustomer Interaction Center
35EWVIEWCIC View: View of Object Data Environment2VIEWIDCIC View Identifiernvarchar100
36EWVIEWATTRCIC View: Attribute Control2VIEWIDCIC View Identifiernvarchar100
TOPDealer Portal
37/SAPDII/CCOM_SETComponent View Settings4VIEWIDId-For view descriptions and Sequencenvarchar40
38/SAPDII/C_COMPIDValue Table for Component ID4VIEWIDId-For view descriptions and Sequencenvarchar40
TOPEnd User Technology
39RSRA_BC_LOGLog Table for the Batch Runs for Precalculating Template11VIEWIDView IDnvarchar400
40RSZWVIEWHeader Table for BW Views1VIEWIDTechnical Name of a Viewnvarchar300
41RSZW_WBITEMSTable of Deleted BDS Items and Views3VIEWIDMedium-Length Descriptionnvarchar400
TOPMedia Product Sales and Distribution
42JKSDDYN_FORMDynamic Formulas for Calc. Methods in Quantity Planning2VIEWIDQuantity Planning Viewnvarchar30
43TJKSDVIEWFIHIERAssignment of Quantity Planning Views to Filter Hierarchies2VIEWIDQuantity Planning Viewnvarchar30
TOPOLAP Technology
44RSRA_IXDSCluster table for storing the key for the DataStore3VIEWIDView IDnvarchar400
TOPPatient Accounting
45NWVIEW_L01IS-H: NL10 - View Type L01 - Table Control Settings3VIEWIDIdentification of a Viewnvarchar100
46NWVIEW_L02IS-H: NL10 - View Type L02 - Table Control Settings3VIEWIDIdentification of a Viewnvarchar100
47NWVIEW_L03IS-H: NL10 - View Type L03 - Table Control Settings3VIEWIDIdentification of a Viewnvarchar100
48NWVIEW_L04IS-H: NL10 - View Type L04 - Table Control Settings3VIEWIDIdentification of a Viewnvarchar100
49NWVIEW_L07IS-H: Definition of Form Folders3VIEWIDIdentification of a Viewnvarchar100
50NWVIEW_L07_FORMSIS-H: Forms Entered for Case4VIEWIDIdentification of a Viewnvarchar100
51NWVIEW_W01IS-H: Workplace - View Type W01 - MiniApp Reports3VIEWIDIdentification of a Viewnvarchar100
TOPPatient Management
52NWPVZWork Environment-to-View Assignment5VIEWIDIdentification of a Viewnvarchar100
53NWPVZTWork Environment-to-View Assignment6VIEWIDIdentification of a Viewnvarchar100
54NWPVZ_USZIS-H / IS-H*MED: Work Environment-to-Service View Assignment5VIEWIDIdentification of a Viewnvarchar100
55NWVIEWViews in Work Stations3VIEWIDIdentification of a Viewnvarchar100
56NWVIEWTViews in Work Stations4VIEWIDIdentification of a Viewnvarchar100
57NWVIEW_001IS-H / IS-H*MED: Speical View Data for Occupancy3VIEWIDIdentification of a Viewnvarchar100
58NWVIEW_002IS-H / IS-H*MED: Special View Data for Arrivals3VIEWIDIdentification of a Viewnvarchar100
59NWVIEW_003IS-H / IS-H*MED: Special View Data for Departures3VIEWIDIdentification of a Viewnvarchar100
60NWVIEW_004IS-H / IS-H*MED: Special View Data for Requests3VIEWIDIdentification of a Viewnvarchar100
61NWVIEW_005IS-H / IS-H*MED: Special View Data for Transport Orders3VIEWIDIdentification of a Viewnvarchar100
62NWVIEW_007IS-H/IS-H*MED: Special View Data Svce Facility/Outp. Clinic3VIEWIDIdentification of a Viewnvarchar100
63NWVIEW_008IS-H/IS-H*MED: Special View Data Medical Controlling3VIEWIDIdentification of a Viewnvarchar100
64NWVIEW_009IS-H / IS-H*MED: Special View Data Occupancy Characteristic3VIEWIDIdentification of a Viewnvarchar100
65NWVIEW_010IS-H / IS-H*MED: Special View Data Preregistrations3VIEWIDIdentification of a Viewnvarchar100
66NWVIEW_A01IS-H: Clinical Process Builder - Additional Data of View3VIEWIDIdentification of a Viewnvarchar100
67NWVIEW_A02IS-H: Clinical Process Builder - Modules for View3VIEWIDIdentification of a Viewnvarchar100
68NWVIEW_A05IS-H: Clinical Process Builder - Selection for Appt List3VIEWIDIdentification of a Viewnvarchar100
69NWVIEW_AP1IS-H: View Type AP1 - Search Variant for Standard Search3VIEWIDIdentification of a Viewnvarchar100
70NWVIEW_AP2IS-H: View Type AP2 - Search Variant for Enh. Time Slot Sear3VIEWIDIdentification of a Viewnvarchar100
71NWVIEW_FCDFunction Bar: Function Code Data3VIEWIDIdentification of a Viewnvarchar100
72NWVIEW_FCDTFunction Bar: Function Code Data4VIEWIDIdentification of a Viewnvarchar100
73NWVIEW_PERSPersonalization Information for View4VIEWIDIdentification of a Viewnvarchar100
TOPPlanning
74N1WVIEW_PG_CLIS-H*MED: Planning Grid Settings of Planning Objects4VIEWIDIdentification of a Viewnvarchar100
75N1WVIEW_PG_DTIS-H*MED: Planning Grid Tab Page for Date View Type3VIEWIDIdentification of a Viewnvarchar100
76N1WVIEW_PG_DT_OUIS-H*MED: PG Org. Unit Setting for DT and PO View Type4VIEWIDIdentification of a Viewnvarchar100
77N1WVIEW_PG_OUIS-H*MED: Planning Grid Tab Page for OU View Type3VIEWIDIdentification of a Viewnvarchar100
78N1WVIEW_PG_POIS-H*MED: Planning Grid Tab Page for Plan. Object View Type3VIEWIDIdentification of a Viewnvarchar100
79NWVIEW_014IS-H / IS-H*MED: Appointment Planning Special View Data3VIEWIDIdentification of a Viewnvarchar100
TOPSales and Distribution
80SCEINVIEWAllocation of Characteristic of Class to Org. Area5VIEWIDOrganizational area to which characteristic can be assignednvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
81NWVIEW_FR1IS-H-FR: Special View Data for Absences3VIEWIDIdentification of a Viewnvarchar100
82NWVIEW_NL1Sichtdaten cockpit3VIEWIDIdentifikation einer Sichtnvarchar100
TOPWithout Description
83RSCRMOLDBDSKEYQuery View: Links Old BDS Key with New View ID2VIEWIDTechnical Name of a Viewnvarchar300