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

42 columns | Print definition?ERP 6.0  | PLANNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCross-Application Components
1PDS_OPERPDS Data for Operations and Dependent Data4PLANNRKey for Task List Groupnvarchar80
TOPMaterial Master
2WSTN_AL_ALLOCPrepack allocation planning lines2PLANNRPrepack allocation plan numbernvarchar100
3WSTN_AL_AULWPrepack allocation planning delivery phases2PLANNRPrepack allocation plan numbernvarchar100
4WSTN_AL_AUVWPrepack DC put away planning delivery phases2PLANNRPrepack allocation plan numbernvarchar100
5WSTN_AL_DFTLWPrepack allocation planning default delivery phases2PLANNRPrepack allocation plan numbernvarchar100
6WSTN_AL_FILGRPPrepack allocation planning site group assignation2PLANNRPrepack allocation plan numbernvarchar100
7WSTN_AL_LINKRelation between alloc table created and generic article12PLANNRPrepack allocation plan numbernvarchar100
8WSTN_AL_MSGPrepack allocation table posting messages2PLANNRPrepack allocation plan numbernvarchar100
9WSTN_AL_POSIPrepack allocation table item reference2PLANNRPrepack allocation plan numbernvarchar100
10WSTN_AL_PTWAYPrepack DC put away planning lines2PLANNRPrepack allocation plan numbernvarchar100
11WSTN_AL_SGROUPPrepack allocation planning site group definition2PLANNRPrepack allocation plan numbernvarchar100
TOPTravel Planning
12FTPT_CARTravel Request Item - Car Rental Service4PLANNRTravel Plan Number (Sequential Number)nvarchar20
13FTPT_CAR_PREFRental car service preferences of a travel plan4PLANNRTravel Plan Number (Sequential Number)nvarchar20
14FTPT_FARE_COMPRate components4PLANNRTravel Plan Number (Sequential Number)nvarchar20
15FTPT_FARE_NOTERate Rules4PLANNRTravel Plan Number (Sequential Number)nvarchar20
16FTPT_FLIGHTTravel Request Item - Flight Service4PLANNRTravel Plan Number (Sequential Number)nvarchar20
17FTPT_FLIGHT_FAREAssignment table: flights <-> rate components4PLANNRTravel Plan Number (Sequential Number)nvarchar20
18FTPT_FLIGHT_FCMPAssignment table: flights <-> rate components4PLANNRTravel Plan Number (Sequential Number)nvarchar20
19FTPT_FLIGHT_LEGLeg of flight4PLANNRTravel Plan Number (Sequential Number)nvarchar20
20FTPT_FLIGHT_PREFFlight service preferences of a travel plan4PLANNRTravel Plan Number (Sequential Number)nvarchar20
21FTPT_FLIGHT_TSTTicket information4PLANNRTravel Plan Number (Sequential Number)nvarchar20
22FTPT_FLIGHT_TSTKTicket Information4PLANNRTravel Plan Number (Sequential Number)nvarchar20
23FTPT_HOTELTravel Request Item - Hotel Service4PLANNRTravel Plan Number (Sequential Number)nvarchar20
24FTPT_HOTEL_PREFHotel service preferences of a travel plan4PLANNRTravel Plan Number (Sequential Number)nvarchar20
25FTPT_ITEMTravel Service Request Item4PLANNRTravel Plan Number (Sequential Number)nvarchar20
26FTPT_OTHERTravel Reservation Request Item - Other Service4PLANNRTravel Plan Number (Sequential Number)nvarchar20
27FTPT_PLANGeneral Plan Data4PLANNRTravel Plan Number (Sequential Number)nvarchar20
28FTPT_PLANHISTORYGeneral Plan Data4PLANNRTravel Plan Number (Sequential Number)nvarchar20
29FTPT_PNRElements of passenger name records of travel plan variant4PLANNRTravel Plan Number (Sequential Number)nvarchar20
30FTPT_PNR_ADDRESSPNR delivery / billing addresses4PLANNRTravel Plan Number (Sequential Number)nvarchar20
31FTPT_PNR_NAMEName element of PNR4PLANNRTravel Plan Number (Sequential Number)nvarchar20
32FTPT_PNR_OSIOther PNR service information4PLANNRTravel Plan Number (Sequential Number)nvarchar20
33FTPT_PNR_PHONEPNR telephone references4PLANNRTravel Plan Number (Sequential Number)nvarchar20
34FTPT_PNR_REMARKSPNR remarks4PLANNRTravel Plan Number (Sequential Number)nvarchar20
35FTPT_PNR_SSRSpecial PNR service requests4PLANNRTravel Plan Number (Sequential Number)nvarchar20
36FTPT_REQUESTTravel Plan Requests4PLANNRTravel Plan Number (Sequential Number)nvarchar20
37FTPT_SERVICEGeneral Services4PLANNRTravel Plan Number (Sequential Number)nvarchar20
38FTPT_SYNC_DATAData Synchronization: SAP - External System4PLANNRTravel Plan Number (Sequential Number)nvarchar20
39FTPT_TRAINTravel Request Item - Train Service4PLANNRTravel Plan Number (Sequential Number)nvarchar20
40FTPT_TRAIN_PREFTrain service preferences of a travel plan4PLANNRTravel Plan Number (Sequential Number)nvarchar20
41FTPT_VARIANTTable of Travel Plan Variants4PLANNRTravel Plan Number (Sequential Number)nvarchar20
42FTPT_VAR_INFOInfo texts for travel plan variants4PLANNRTravel Plan Number (Sequential Number)nvarchar20