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

Home | ERP 6.0  | T163P
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
Materials Management :: Purchasing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T163P1281Release Creation ProfilePurchasing
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, WERKS, ABUEB, RUSKZ, FRUSA, LRUSA, FABHO, LABHO, FKAGG, LKAGG, FTAGG, LTAGG, FPAGG, FKALA, LPAGG, LKALA, LWAGG, LMAGG, FKUEB, LKUEB, FTUEB, LTUEB, FPUEB, FKALU, LPUEB, LKALU, FWUEB, LWUEB, LMUEB, LPLT1, LPLT2, LPLT3, FPLT1, FPLT2, FPLT3, LOTO1, LOTO2, LOTO3, FOTO1, FOTO2, FOTO3, LUTO1, LUTO2, LUTO3, FUTO1, FUTO2, FUTO3, LPRA1, LPRA2, LPRA3, FPRA1, FPRA2, FPRA3, LRUEC, FRUEC, FAEODT, FAEN, FDT, FAEUDT, FNO, LAEODT, LAEN, LDT, LAEUDT, LNO, FPRHO, LPRHO, IFAB, ILAB, FBEST, LBEST, LAGGR, FRSVZ, LRSVZ, FVWE, LWE, FZWEFZ, LZWEFZ, FAASN, LAASN, FAWE, LAWE, FSORT1, LSORT1, FSORT2, LSORT2, FSORT3, LSORT3, FBMAIL, LBMAIL, FLMAIL, LLMAIL, FPAGE2, FLASTDEL, FCHANGES, FPACKING, FFOLLOWM, FSUBCON, LSTOPPLT1, LSTOPPLT2, LSTOPPLT3, FSTOPPLT1, FSTOPPLT2, FSTOPPLT3, LSTOPOTO1, LSTOPOTO2, LSTOPOTO3, FSTOPOTO1, FSTOPOTO2, FSTOPOTO3, LSTOPUTO1, LSTOPUTO2, LSTOPUTO3, FSTOPUTO1, FSTOPUTO2, FSTOPUTO3, LSTOPPRA1, LSTOPPRA2, LSTOPPRA3, FSTOPPRA1, FSTOPPRA2, FSTOPPRA3, FABREV, LABREV, FANACHF, LANACHF, FSTOPPRHO, LSTOPPRHO FROM T163P
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2WERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
3ABUEBRelease Creation Profilenvarchar40CHAR(N' ')NoABUEB Allow NULL? 
4RUSKZBacklog and/or immediate requirement exist(s)char10CHAR(N' ')YesRUSKZ Allow NULL? 
5FRUSAJIT: Show Backlog and Immediate Requirementchar10CHAR(N' ')YesFRUSA Allow NULL? 
6LRUSAFRC Delivery Schedule: Show Backlog and Imm. Requirementchar10CHAR(N' ')YesLRUSA Allow NULL? 
7FABHOJIT deliv. schedule horizon (SA release horizon) in workdaysnvarchar30NUMC(N'000')YesFABHO Allow NULL? 
8LABHOForecast delivery schedule horizon in workdaysnvarchar30NUMC(N'000')YesLABHO Allow NULL? 
9FKAGGJIT Delivery Schedule Creation Without Aggregationnvarchar30NUMC(N'000')YesFKAGG Allow NULL? 
10LKAGGForecast Delivery Schedule Creation Without Aggregationnvarchar30NUMC(N'000')YesLKAGG Allow NULL? 
11FTAGGJIT Delivery Schedule Creation with Daily Aggregationnvarchar30NUMC(N'000')YesFTAGG Allow NULL? 
12LTAGGForecast Delivery Schedule Creation with Daily Aggregationnvarchar30NUMC(N'000')YesLTAGG Allow NULL? 
13FPAGGCreation of JIT Schedules with Aggreg. Acc. to Planning Cal.nvarchar30NUMC(N'000')YesFPAGG Allow NULL? 
14FKALAPlanning Calendar for Aggregationnvarchar30CHAR(N' ')Yes*FKALA Allow NULL? 
15LPAGGCreation of FRC Schedules with Aggreg. Acc. to Planning Cal.nvarchar30NUMC(N'000')YesLPAGG Allow NULL? 
16LKALAPlanning Calendar for Aggregationnvarchar30CHAR(N' ')Yes*LKALA Allow NULL? 
17LWAGGForecast Delivery Schedule Creation with Weekly Aggregationnvarchar30NUMC(N'000')YesLWAGG Allow NULL? 
18LMAGGForecast Schedule Creation with Monthly Aggregationnvarchar30NUMC(N'000')YesLMAGG Allow NULL? 
19FKUEBNo periodic transmission of JIT delivery scheduleschar10CHAR(N' ')YesFKUEB Allow NULL? 
20LKUEBNo periodic transmission of forecast delivery scheduleschar10CHAR(N' ')YesLKUEB Allow NULL? 
21FTUEBPeriodic transmission of JIT delivery schedules (daily)char10CHAR(N' ')YesFTUEB Allow NULL? 
22LTUEBPeriodic transmission of forecast delivery schedules (daily)char10CHAR(N' ')YesLTUEB Allow NULL? 
23FPUEBPeriodic transm. of JIT schedules acc. to planning calendarchar10CHAR(N' ')YesFPUEB Allow NULL? 
24FKALUPlanning calendar for periodic transmissionnvarchar30CHAR(N' ')Yes*FKALU Allow NULL? 
25LPUEBPeriodic transm. of FRC schedules acc. to planning calendarchar10CHAR(N' ')YesLPUEB Allow NULL? 
26LKALUPlanning calendar for periodic transmissionnvarchar30CHAR(N' ')Yes*LKALU Allow NULL? 
27FWUEBPeriodic transmission of JIT delivery schedules (weekly)char10CHAR(N' ')YesFWUEB Allow NULL? 
28LWUEBPeriodic transmission of forecast deliv. schedules (weekly)char10CHAR(N' ')YesLWUEB Allow NULL? 
29LMUEBPeriodic transmission of forecast deliv. schedules (monthly)char10CHAR(N' ')YesLMUEB Allow NULL? 
30LPLT1Length of Checking Period 1 for FRC Schedules in Workdaysnvarchar30NUMC(N'000')YesLPLT1 Allow NULL? 
31LPLT2Length of Checking Period 2 for FRC Schedules in Workdaysnvarchar30NUMC(N'000')YesLPLT2 Allow NULL? 
32LPLT3Length of Checking Period 3 for FRC Schedules in Workdaysnvarchar30NUMC(N'000')YesLPLT3 Allow NULL? 
33FPLT1Length of Checking Period 1 for JIT Schedules in Workdaysnvarchar30NUMC(N'000')YesFPLT1 Allow NULL? 
34FPLT2Length of Checking Period 2 for JIT Schedules in Workdaysnvarchar30NUMC(N'000')YesFPLT2 Allow NULL? 
35FPLT3Length of Checking Period 3 for JIT Schedules in Workdaysnvarchar30NUMC(N'000')YesFPLT3 Allow NULL? 
36LOTO1Upper Tolerance Limit for FRC Schedules in Checking Period 1nvarchar30NUMC(N'000')YesLOTO1 Allow NULL? 
37LOTO2Upper Tolerance Limit for FRC Schedules in Checking Period 2nvarchar30NUMC(N'000')YesLOTO2 Allow NULL? 
38LOTO3Upper Tolerance Limit for FRC Schedules in Checking Period 3nvarchar30NUMC(N'000')YesLOTO3 Allow NULL? 
39FOTO1Upper Tolerance Limit for JIT Schedules in Checking Period 1nvarchar30NUMC(N'000')YesFOTO1 Allow NULL? 
40FOTO2Upper Tolerance Limit for JIT Schedules in Checking Period 2nvarchar30NUMC(N'000')YesFOTO2 Allow NULL? 
41FOTO3Upper Tolerance Limit for JIT Schedules in Checking Period 3nvarchar30NUMC(N'000')YesFOTO3 Allow NULL? 
42LUTO1Lower Tolerance Limit for FRC Schedules in Checking Period 1nvarchar30NUMC(N'000')YesLUTO1 Allow NULL? 
43LUTO2Lower Tolerance Limit for FRC Schedules in Checking Period 2nvarchar30NUMC(N'000')YesLUTO2 Allow NULL? 
44LUTO3Lower Tolerance Limit for FRC Schedules in Checking Period 3nvarchar30NUMC(N'000')YesLUTO3 Allow NULL? 
45FUTO1Lower Tolerance Limit for JIT Schedules in Checking Period 1nvarchar30NUMC(N'000')YesFUTO1 Allow NULL? 
46FUTO2Lower Tolerance Limit for JIT Schedules in Checking Period 2nvarchar30NUMC(N'000')YesFUTO2 Allow NULL? 
47FUTO3Lower Tolerance Limit for JIT Schedules in Checking Period 3nvarchar30NUMC(N'000')YesFUTO3 Allow NULL? 
48LPRA1Type of Check for Forecast Delivery Schedules in Period 1char10CHAR(N' ')YesLPRA1 Allow NULL? 
49LPRA2Type of Check for Forecast Delivery Schedules in Period 2char10CHAR(N' ')YesLPRA2 Allow NULL? 
50LPRA3Type of Check for Forecast Delivery Schedules in Period 3char10CHAR(N' ')YesLPRA3 Allow NULL? 
51FPRA1Type of Check for JIT Delivery Schedules in Period 1char10CHAR(N' ')YesFPRA1 Allow NULL? 
52FPRA2Type of Check for JIT Delivery Schedules in Period 2char10CHAR(N' ')YesFPRA2 Allow NULL? 
53FPRA3Type of Check for JIT Delivery Schedules in Period 3char10CHAR(N' ')YesFPRA3 Allow NULL? 
54LRUECBacklog in FRC Delivery Schedules is Transmission-Relevantchar10CHAR(N' ')YesLRUECK Allow NULL? 
55FRUECBacklog in JIT Delivery Schedules is Transmission-Relevantchar10CHAR(N' ')YesFRUECK Allow NULL? 
56FAEODTCreation Strategy for JIT Del. Sched.: Changed or Next Datechar10CHAR(N' ')YesFAEODT Allow NULL? 
57FAENCreation Strategy for JIT Delivery Schedule: Changed Onlychar10CHAR(N' ')YesFAEN Allow NULL? 
58FDTCreation Strategy for JIT Delivery Schedule: Next Date Onlychar10CHAR(N' ')YesFDT Allow NULL? 
59FAEUDTCreation Strategy for JIT Del. Sched.: Changed and Next Datechar10CHAR(N' ')YesFAEUDT Allow NULL? 
60FNOJIT: No Past Dates/Timeschar10CHAR(N' ')YesFNO Allow NULL? 
61LAEODTCreation Strategy for FRC Schedule: Changed or Next Datechar10CHAR(N' ')YesLAEODT Allow NULL? 
62LAENCreation Strategy for Forecast Deliv. Schedule: Changed Onlychar10CHAR(N' ')YesLAEN Allow NULL? 
63LDTCreation Strategy for FRC Schedule: Next Date Onlychar10CHAR(N' ')YesLDT Allow NULL? 
64LAEUDTCreation Strategy for FRC Schedule: Changed and Next Datechar10CHAR(N' ')YesLAEUDT Allow NULL? 
65LNOFRC: No Past Dates/Timeschar10CHAR(N' ')YesLNO Allow NULL? 
66FPRHOChecking Horizon for JIT Schedulenvarchar30NUMC(N'000')YesFPRHO Allow NULL? 
67LPRHOChecking Horizon for Forecast Delivery Schedulenvarchar30NUMC(N'000')YesLPRHO Allow NULL? 
68IFABJIT: Internet Releasechar10CHAR(N' ')YesIFAB Allow NULL? 
69ILABFRC: Internet Releasechar10CHAR(N' ')YesILAB Allow NULL? 
70FBESTJIT: Acknowledgment of Internet Release by Vendorchar10CHAR(N' ')YesFBEST Allow NULL? 
71LBESTFRC: Acknowledgment of Internet Release by Vendorchar10CHAR(N' ')YesLBEST Allow NULL? 
72LAGGRFRC: Aggregationchar10CHAR(N' ')YesLAGGR Allow NULL? 
73FRSVZJIT: Bring Forward Backlog and Immediate Requirementchar10CHAR(N' ')YesFRSVZ Allow NULL? 
74LRSVZFRC: Bring Forward Backlog and Immediate Requirementchar10CHAR(N' ')YesLRSVZ Allow NULL? 
75FVWEJIT: Activate Number of GRs/Deliveries Greater Than 1char10CHAR(N' ')YesFVWE Allow NULL? 
76LWEFRC: Activate No. of GRs/Inbound Deliveries Greater Than 1char10CHAR(N' ')YesLWE Allow NULL? 
77FZWEFZJIT: 2nd Cumulative Received Quantity (2nd CRQ)char10CHAR(N' ')YesFZWEFZ Allow NULL? 
78LZWEFZFRC: 2nd Cumulative Received Quantity (2nd CRQ)char10CHAR(N' ')YesLZWEFZ Allow NULL? 
79FAASNJIT: No. of Inbound Deliverieschar10NUMC(N'0')YesFAASN Allow NULL? 
80LAASNFRC: Number of Deliverieschar10NUMC(N'0')YesLAASN Allow NULL? 
81FAWEJIT: No. of Last Goods Receipts Against SA Releasechar10NUMC(N'0')YesFAWE Allow NULL? 
82LAWEFRC: Number of Last GRs Against SA Releasechar10NUMC(N'0')YesLAWE Allow NULL? 
83FSORT1Sort Criterion for Last GRs/Shipping Notificationsnvarchar300CHAR(N' ')Yes*LGR_ASN_SORT Allow NULL? 
84LSORT1Sort Criterion for Last GRs/Shipping Notificationsnvarchar300CHAR(N' ')Yes*LGR_ASN_SORT Allow NULL? 
85FSORT2Sort Criterion for Last GRs/Shipping Notificationsnvarchar300CHAR(N' ')Yes*LGR_ASN_SORT Allow NULL? 
86LSORT2Sort Criterion for Last GRs/Shipping Notificationsnvarchar300CHAR(N' ')Yes*LGR_ASN_SORT Allow NULL? 
87FSORT3Sort Criterion for Last GRs/Shipping Notificationsnvarchar300CHAR(N' ')Yes*LGR_ASN_SORT Allow NULL? 
88LSORT3Sort Criterion for Last GRs/Shipping Notificationsnvarchar300CHAR(N' ')Yes*LGR_ASN_SORT Allow NULL? 
89FBMAILJIT: Workflow for Acknowledgment of Release by Vendorchar10CHAR(N' ')YesFBMAIL Allow NULL? 
90LBMAILFRC: Workflow in Case of Acknowledgment of Release by Vendorchar10CHAR(N' ')YesLBMAIL Allow NULL? 
91FLMAILJIT: Mail to Vendor on Generation of Internet Releasechar10CHAR(N' ')YesFLMAIL Allow NULL? 
92LLMAILFRC: Mail to Vendor on Creation of an Internet Releasechar10CHAR(N' ')YesLLMAIL Allow NULL? 
93FPAGE2Automotive Print with Smart Forms: Print More Than One Pagechar10CHAR(N' ')YesFPAGE2 Allow NULL? 
94FLASTDELAutomotive Print with Smart Forms: Print Last Deliverieschar10CHAR(N' ')YesFLASTDEL Allow NULL? 
95FCHANGESAutomotive Print with Smart Forms: Print Change Statuseschar10CHAR(N' ')YesFCHANGES Allow NULL? 
96FPACKINGAutomotive Print with Smart Forms: Print Packing Infochar10CHAR(N' ')YesFPACKING Allow NULL? 
97FFOLLOWMAutomotive Print with Smart Forms: Print Follow-Up Materialchar10CHAR(N' ')YesFFOLLOWM Allow NULL? 
98FSUBCONAutomotive Print with Smart Form: Print Subcontr. Componentschar10CHAR(N' ')YesFSUBCON Allow NULL? 
99LSTOPPLT1Length of Checking Period 1 for FRC Schedules in Workdaysnvarchar30NUMC(N'000')YesLPLT1 Allow NULL? 
100LSTOPPLT2Length of Checking Period 2 for FRC Schedules in Workdaysnvarchar30NUMC(N'000')YesLPLT2 Allow NULL? 
101LSTOPPLT3Length of Checking Period 3 for FRC Schedules in Workdaysnvarchar30NUMC(N'000')YesLPLT3 Allow NULL? 
102FSTOPPLT1Length of Checking Period 1 for JIT Schedules in Workdaysnvarchar30NUMC(N'000')YesFPLT1 Allow NULL? 
103FSTOPPLT2Length of Checking Period 2 for JIT Schedules in Workdaysnvarchar30NUMC(N'000')YesFPLT2 Allow NULL? 
104FSTOPPLT3Length of Checking Period 3 for JIT Schedules in Workdaysnvarchar30NUMC(N'000')YesFPLT3 Allow NULL? 
105LSTOPOTO1Upper Tolerance Limit for Checking Period 1nvarchar30NUMC(N'000')YesISA_ESCR1 Allow NULL? 
106LSTOPOTO2Upper Tolerance Limit for Checking Period 2nvarchar30NUMC(N'000')YesISA_ESCR2 Allow NULL? 
107LSTOPOTO3Upper Tolerance Limit for Checking Period 3nvarchar30NUMC(N'000')YesISA_ESCR3 Allow NULL? 
108FSTOPOTO1Upper Tolerance Limit for Checking Period 1nvarchar30NUMC(N'000')YesISA_ESCR1 Allow NULL? 
109FSTOPOTO2Upper Tolerance Limit for Checking Period 2nvarchar30NUMC(N'000')YesISA_ESCR2 Allow NULL? 
110FSTOPOTO3Upper Tolerance Limit for Checking Period 3nvarchar30NUMC(N'000')YesISA_ESCR3 Allow NULL? 
111LSTOPUTO1Lower Tolerance Limit for Checking Period 1nvarchar30NUMC(N'000')YesISA_ESCR4 Allow NULL? 
112LSTOPUTO2Lower Tolerance Limit for Checking Period 2nvarchar30NUMC(N'000')YesISA_ESCR5 Allow NULL? 
113LSTOPUTO3Lower Tolerance Limit for Checking Period 3nvarchar30NUMC(N'000')YesISA_ESCR6 Allow NULL? 
114FSTOPUTO1Lower Tolerance Limit for Checking Period 1nvarchar30NUMC(N'000')YesISA_ESCR4 Allow NULL? 
115FSTOPUTO2Lower Tolerance Limit for Checking Period 2nvarchar30NUMC(N'000')YesISA_ESCR5 Allow NULL? 
116FSTOPUTO3Lower Tolerance Limit for Checking Period 3nvarchar30NUMC(N'000')YesISA_ESCR6 Allow NULL? 
117LSTOPPRA1Type of Check for Forecast Delivery Schedules in Period 1char10CHAR(N' ')YesLPRA1 Allow NULL? 
118LSTOPPRA2Type of Check for Forecast Delivery Schedules in Period 2char10CHAR(N' ')YesLPRA2 Allow NULL? 
119LSTOPPRA3Type of Check for Forecast Delivery Schedules in Period 3char10CHAR(N' ')YesLPRA3 Allow NULL? 
120FSTOPPRA1Type of Check for JIT Delivery Schedules in Period 1char10CHAR(N' ')YesFPRA1 Allow NULL? 
121FSTOPPRA2Type of Check for JIT Delivery Schedules in Period 2char10CHAR(N' ')YesFPRA2 Allow NULL? 
122FSTOPPRA3Type of Check for JIT Delivery Schedules in Period 3char10CHAR(N' ')YesFPRA3 Allow NULL? 
123FABREVJIT Delivery Schedule: Change in Revision Levelchar10CHAR(N' ')YesFABREV Allow NULL? 
124LABREVForecast Delivery Schedule: Change of Revision Levelchar10CHAR(N' ')YesLABREV Allow NULL? 
125FANACHFJIT Delivery Schedule: Follow-Up Materialchar10CHAR(N' ')YesFANACHF Allow NULL? 
126LANACHFForecast Delivery Schedule: Follow-up Materialchar10CHAR(N' ')YesLANACHF Allow NULL? 
127FSTOPPRHOChecking Horizon for JIT Schedulenvarchar30NUMC(N'000')YesFPRHO Allow NULL? 
128LSTOPPRHOChecking Horizon for Forecast Delivery Schedulenvarchar30NUMC(N'000')YesLPRHO Allow NULL? 
NamePrimaryUniqueTypeColumns
T163P~0YesYesCLUSTEREDABUEB, WERKS, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy