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  | TPTCOR_LOGISTIC
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
Personnel Time Management :: Time Data Recording and Administration :: Personnel Time Events
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TPTCOR_LOGISTIC871Logistics Orders (Correction Scenario)Personnel Time Events
SQL:  selectupdate insert create

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

SELECT MANDT, ITEM_ID, PDC_OTYPE, PDC_PLANS, PDC_USRUP, USER2, INDEU, RUECK, RMZHL, STOKZ, STZHL, GRUNR, GRUNA, BUDAT, LSTYP, PRFOR, APPKZ, SRCSYS, AUFTYP, AUFART, AUFNR, FOLGE, VORNR, UVORN, SPLIT, KAPAR, LOARR, ARBPL, WERKS, BUKRS, GSBER, KOSTL, LOGRR, PDC_TRFST, MEINH, LMNGA, XMNGA, GRUND, BMSCH, VGW01, VGE01, SOW01, SOE01, RUW01, RUE01, BEG01, END01, VGW02, VGE02, SOW02, SOE02, RUW02, RUE02, BEG02, END02, VGW03, VGE03, SOW03, SOE03, RUW03, RUE03, BEG03, END03, VGW04, VGE04, SOW04, SOE04, RUW04, RUE04, BEG04, END04, VGW05, VGE05, SOW05, SOE05, RUW05, RUE05, BEG05, END05, VGW06, VGE06, SOW06, SOE06, RUW06, RUE06, BEG06, END06 FROM TPTCOR_LOGISTIC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ITEM_IDID of Request Itemnvarchar320CHAR(N' ')NoTIM_REQ_ITEM_ID Allow NULL? 
3PDC_OTYPEObject Typenvarchar20CHAR(N' ')Yes*OTYPE Allow NULL? 
4PDC_PLANSPositionnvarchar80NUMC(N'00000000')Yes*PLANS Allow NULL? 
5PDC_USRUPCustomer-Specific Fieldnvarchar200CHAR(N' ')YesPDC_USRUP Allow NULL? 
6USER2Customer-Specific Fieldnvarchar400CHAR(N' ')YesHR_USRFLD Allow NULL? 
7INDEUInsert/delete or update indicatorchar10CHAR(N' ')YesINDEU Allow NULL? 
8RUECKCompletion confirmation number for the operationnvarchar100NUMC(N'0000000000')YesPW_RUECK Allow NULL? 
9RMZHLConfirmation counternvarchar80NUMC(N'00000000')YesPW_RMZHL Allow NULL? 
10STOKZIndicator: "Confirmation Cancelled"char10CHAR(N' ')YesPW_STOKZ Allow NULL? 
11STZHLConfirmation counter of cancelled confirmationnvarchar80NUMC(N'00000000')YesPW_STZHL Allow NULL? 
12GRUNRGroup numbernvarchar80NUMC(N'00000000')Yes*PW_GRUNR Allow NULL? 
13GRUNAGroup namenvarchar200CHAR(N' ')YesPW_GRUNA Allow NULL? 
14BUDATPosting datenvarchar80DATS(N'00000000')YesPW_BUDAT Allow NULL? 
15LSTYPTime ticket typenvarchar20CHAR(N' ')Yes*PW_LSTYP Allow NULL? 
16PRFORPremium formulanvarchar30NUMC(N'000')Yes*PW_PRFOR Allow NULL? 
17APPKZSource application (for confirmations)nvarchar20CHAR(N' ')YesPW_APPKZ Allow NULL? 
18SRCSYSLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
19AUFTYPOrder categorynvarchar20NUMC(N'00')YesPW_AUFTYP Allow NULL? 
20AUFARTOrder typenvarchar40CHAR(N' ')Yes*PW_AUFART Allow NULL? 
21AUFNROrder Numbernvarchar120CHAR(N' ')Yes*PW_AUFNR Allow NULL? 
22FOLGESequence numbernvarchar60CHAR(N' ')YesPW_AUFFN Allow NULL? 
23VORNROperation numbernvarchar40CHAR(N' ')YesPW_AUFAV Allow NULL? 
24UVORNSuboperation Numbernvarchar40CHAR(N' ')YesPW_AUFUV Allow NULL? 
25SPLITSplit numbertinyint30INT1((0))YesCY_SPLIT
26KAPARCapacity categorynvarchar30CHAR(N' ')YesKAPAR Allow NULL? 
27LOARRWage typenvarchar40CHAR(N' ')Yes*PW_LGART Allow NULL? 
28ARBPLWork Centernvarchar80CHAR(N' ')YesPW_ARBPL Allow NULL? 
29WERKSPlantnvarchar40CHAR(N' ')Yes*PW_WERKS Allow NULL? 
30BUKRSCompany codenvarchar40CHAR(N' ')Yes*PW_BUKRS Allow NULL? 
31GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
32KOSTLCost centernvarchar100CHAR(N' ')Yes*PW_KOSTL Allow NULL? 
33LOGRRPay Scale Groupnvarchar80CHAR(N' ')YesPW_TRFGR Allow NULL? 
34PDC_TRFSTPay scale levelnvarchar20CHAR(N' ')YesPW_TRFST Allow NULL? 
35MEINHUnit of Measurenvarchar30UNIT(N' ')YesT006PW_MEINH Allow NULL? 
36LMNGAYielddecimal133QUAN((0))YesPW_LMNGR
37XMNGAScrapdecimal133QUAN((0))YesPW_XMNGR
38GRUNDScrap reasonnvarchar40CHAR(N' ')YesPW_GRUND Allow NULL? 
39BMSCHBase quantitydecimal133QUAN((0))YesPW_BMSCH
40VGW01Standard value of processing timedecimal133QUAN((0))YesPW_VGWRT01
41VGE01Measurement unit for standard valuenvarchar30UNIT(N' ')YesT006PW_VGWRTEH Allow NULL? 
42SOW01Target value of processing timedecimal133QUAN((0))YesPW_SOWRT01
43SOE01Measurement unit for target valuenvarchar30UNIT(N' ')YesT006PW_SOWRTEH Allow NULL? 
44RUW01Confirmed value of processing timedecimal133QUAN((0))YesPW_RUWRT01
45RUE01Measurement unit of confirmed valuenvarchar30UNIT(N' ')YesT006PW_RUWRTEH Allow NULL? 
46BEG01Start of processing timenvarchar60TIMS(N'000000')YesPW_BEGUZ01 Allow NULL? 
47END01End of processing timenvarchar60TIMS(N'000000')YesPW_ENDUZ01 Allow NULL? 
48VGW02Standard value of setup timedecimal133QUAN((0))YesPW_VGWRT02
49VGE02Measurement unit for standard valuenvarchar30UNIT(N' ')YesT006PW_VGWRTEH Allow NULL? 
50SOW02Target value of setup timedecimal133QUAN((0))YesPW_SOWRT02
51SOE02Measurement unit for target valuenvarchar30UNIT(N' ')YesT006PW_SOWRTEH Allow NULL? 
52RUW02Confirmed value of setup timedecimal133QUAN((0))YesPW_RUWRT02
53RUE02Measurement unit of confirmed valuenvarchar30UNIT(N' ')YesT006PW_RUWRTEH Allow NULL? 
54BEG02Start of setup timenvarchar60TIMS(N'000000')YesPW_BEGUZ02 Allow NULL? 
55END02End of setup timenvarchar60TIMS(N'000000')YesPW_ENDUZ02 Allow NULL? 
56VGW03Standard value of machine timedecimal133QUAN((0))YesPW_VGWRT03
57VGE03Measurement unit for standard valuenvarchar30UNIT(N' ')YesT006PW_VGWRTEH Allow NULL? 
58SOW03Target value of machine timedecimal133QUAN((0))YesPW_SOWRT03
59SOE03Measurement unit for target valuenvarchar30UNIT(N' ')YesT006PW_SOWRTEH Allow NULL? 
60RUW03Confirmed value of machine timedecimal133QUAN((0))YesPW_RUWRT03
61RUE03Measurement unit of confirmed valuenvarchar30UNIT(N' ')YesT006PW_RUWRTEH Allow NULL? 
62BEG03Start machine timenvarchar60TIMS(N'000000')YesPW_BEGUZ03 Allow NULL? 
63END03End of machine timenvarchar60TIMS(N'000000')YesPW_ENDUZ03 Allow NULL? 
64VGW04Standard value of variable activitydecimal133QUAN((0))YesPW_VGWRT04
65VGE04Measurement unit for standard valuenvarchar30UNIT(N' ')YesT006PW_VGWRTEH Allow NULL? 
66SOW04Target value of variable activitydecimal133QUAN((0))YesPW_SOWRT04
67SOE04Measurement unit for target valuenvarchar30UNIT(N' ')YesT006PW_SOWRTEH Allow NULL? 
68RUW04Confirmed value of variable activitydecimal133QUAN((0))YesPW_RUWRT04
69RUE04Measurement unit of confirmed valuenvarchar30UNIT(N' ')YesT006PW_RUWRTEH Allow NULL? 
70BEG04Start of variable activitynvarchar60TIMS(N'000000')YesPW_BEGUZ04 Allow NULL? 
71END04End of variable activitynvarchar60TIMS(N'000000')YesPW_ENDUZ04 Allow NULL? 
72VGW05Standard value of teardown timedecimal133QUAN((0))YesPW_VGWRT05
73VGE05Measurement unit for standard valuenvarchar30UNIT(N' ')YesT006PW_VGWRTEH Allow NULL? 
74SOW05Target value of teardown timedecimal133QUAN((0))YesPW_SOWRT05
75SOE05Measurement unit for target valuenvarchar30UNIT(N' ')YesT006PW_SOWRTEH Allow NULL? 
76RUW05Confirmed value of teardown timedecimal133QUAN((0))YesPW_RUWRT05
77RUE05Measurement unit of confirmed valuenvarchar30UNIT(N' ')YesT006PW_RUWRTEH Allow NULL? 
78BEG05Start of teardown timenvarchar60TIMS(N'000000')YesPW_BEGUZ05 Allow NULL? 
79END05End of teardown timenvarchar60TIMS(N'000000')YesPW_ENDUZ05 Allow NULL? 
80VGW06Standard value of variable activitydecimal133QUAN((0))YesPW_VGWRT06
81VGE06Measurement unit for standard valuenvarchar30UNIT(N' ')YesT006PW_VGWRTEH Allow NULL? 
82SOW06Target value of variable activitydecimal133QUAN((0))YesPW_SOWRT06
83SOE06Measurement unit for target valuenvarchar30UNIT(N' ')YesT006PW_SOWRTEH Allow NULL? 
84RUW06Confirmed value of variable activitydecimal133QUAN((0))YesPW_RUWRT06
85RUE06Measurement unit of confirmed valuenvarchar30UNIT(N' ')YesT006PW_RUWRTEH Allow NULL? 
86BEG06Start of variable activitynvarchar60TIMS(N'000000')YesPW_BEGUZ06 Allow NULL? 
87END06End of variable activitynvarchar60TIMS(N'000000')YesPW_ENDUZ06 Allow NULL? 
NamePrimaryUniqueTypeColumns
TPTCOR_LOGISTIC~0YesYesCLUSTEREDMANDT, ITEM_ID

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