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  | VTTK
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Logistics Execution :: Transportation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VTTK1403Shipment HeaderTransportation
SQL:  selectupdate insert create

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

SELECT MANDT, TKNUM, VBTYP, SHTYP, TPLST, ERNAM, ERDAT, ERZET, AENAM, AEDAT, AEZET, STERM, ABFER, ABWST, BFART, VSART, VSAVL, VSANL, LAUFK, VSBED, ROUTE, SIGNI, EXTI1, EXTI2, TPBEZ, STDIS, DTDIS, UZDIS, STREG, DPREG, UPREG, DAREG, UAREG, STLBG, DPLBG, UPLBG, DALBG, UALBG, STLAD, DPLEN, UPLEN, DALEN, UALEN, STABF, DPABF, UPABF, DTABF, UZABF, STTBG, DPTBG, UPTBG, DATBG, UATBG, STTEN, DPTEN, UPTEN, DATEN, UATEN, STTRG, TDLNR, TERNR, PKSTK, DTMEG, DTMEV, DISTZ, MEDST, FAHZT, GESZT, MEIZT, STAFO, FBSTA, FBGST, ARSTA, ARGST, STERM_DONE, VSE_FRK, KKALSM, SDABW, FRKRL, GESZTD, FAHZTD, GESZTDA, FAHZTDA, ROCPY_DONE, HANDLE, TSEGFL, TSEGTP, ADD01, ADD02, ADD03, ADD04, TEXT1, TEXT2, TEXT3, TEXT4, PROLI, DGTLOCK, DGMDDAT, CONT_DG, WARZTD, WARZTDA, AULWE, TNDRST, TNDRRC, TNDR_TEXT, TNDRDAT, TNDRZET, TNDR_MAXP, TNDR_MAXC, TNDR_ACTP, TNDR_ACTC, TNDR_CARR, TNDR_CRNM, TNDR_TRKID, TNDR_EXPD, TNDR_EXPT, TNDR_ERPD, TNDR_ERPT, TNDR_LTPD, TNDR_LTPT, TNDR_ERDD, TNDR_ERDT, TNDR_LTDD, TNDR_LTDT, TNDR_LDLG, TNDR_LDLU, KZHULFR, ALLOWED_TWGT, VLSTK, VERURSYS, CM_IDENT, CM_SEQUENCE, EXT_FREIGHT_ORD, EXT_TM_SYS, /BEV1/RPFAR1, /BEV1/RPFAR2, /BEV1/RPMOWA, /BEV1/RPANHAE, /BEV1/RPFLGNR, /VSO/R_STATUS FROM VTTK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TKNUMShipment Numbernvarchar100CHAR(N' ')NoTKNUM Allow NULL? 
3VBTYPSD document categorychar10CHAR(N' ')NoVBTYP Allow NULL? 
4SHTYPShipment typenvarchar40CHAR(N' ')NoTVTKSHTYP Allow NULL? 
5TPLSTTransportation planning pointnvarchar40CHAR(N' ')NoTTDSTPLST Allow NULL? 
6ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
7ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
8ERZETEntry timenvarchar60TIMS(N'000000')NoERZET Allow NULL? 
9AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')NoAENAM Allow NULL? 
10AEDATChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
11AEZETTime last change was madenvarchar60TIMS(N'000000')NoAEZET Allow NULL? 
12STERMLeg determinationchar10CHAR(N' ')NoSTERM Allow NULL? 
13ABFERShipment completion typechar10CHAR(N' ')NoABFER Allow NULL? 
14ABWSTProcessing controlchar10CHAR(N' ')NoABWST Allow NULL? 
15BFARTService Levelchar10CHAR(N' ')NoBFART Allow NULL? 
16VSARTShipping typenvarchar20CHAR(N' ')NoT173VSARTTR Allow NULL? 
17VSAVLShipping type of preliminary legnvarchar20CHAR(N' ')NoT173VSAVL Allow NULL? 
18VSANLShipping type of subsequent legnvarchar20CHAR(N' ')NoT173VSANL Allow NULL? 
19LAUFKLeg Indicatorchar10CHAR(N' ')NoLAUFK Allow NULL? 
20VSBEDShipping Conditionsnvarchar20CHAR(N' ')NoTVSBVSBED Allow NULL? 
21ROUTEShipment routenvarchar60CHAR(N' ')NoTVROROUTR Allow NULL? 
22SIGNIContainer IDnvarchar200CHAR(N' ')NoSIGNI Allow NULL? 
23EXTI1External identification 1nvarchar200CHAR(N' ')NoEXTI1 Allow NULL? 
24EXTI2External identification 2nvarchar200CHAR(N' ')NoEXTI2 Allow NULL? 
25TPBEZDescription of Shipmentnvarchar200CHAR(N' ')NoTPBEZ Allow NULL? 
26STDISStatus of transportation planningchar10CHAR(N' ')NoSTDIS Allow NULL? 
27DTDISDate of end of planningnvarchar80DATS(N'00000000')NoDTDIS Allow NULL? 
28UZDISScheduling end timenvarchar60TIMS(N'000000')NoUZDIS Allow NULL? 
29STREGStatus of check-inchar10CHAR(N' ')YesSTREG Allow NULL? 
30DPREGPlanned date of check-innvarchar80DATS(N'00000000')YesDPREG Allow NULL? 
31UPREGPlanned check-in timenvarchar60TIMS(N'000000')YesUPREG Allow NULL? 
32DAREGActual date of check-innvarchar80DATS(N'00000000')YesDAREG Allow NULL? 
33UAREGCurrent time of check-innvarchar60TIMS(N'000000')YesUAREG Allow NULL? 
34STLBGStatus for start of loadingchar10CHAR(N' ')NoSTLBG Allow NULL? 
35DPLBGPlanned date for start of loadingnvarchar80DATS(N'00000000')NoDPLBG Allow NULL? 
36UPLBGPlanned loading start timenvarchar60TIMS(N'000000')NoUPLBG Allow NULL? 
37DALBGCurrent date for start of loadingnvarchar80DATS(N'00000000')NoDALBG Allow NULL? 
38UALBGActual loading start timenvarchar60TIMS(N'000000')NoUALBG Allow NULL? 
39STLADStatus for end of loadingchar10CHAR(N' ')NoSTLAD Allow NULL? 
40DPLENPlanned date for end of loadingnvarchar80DATS(N'00000000')NoDPLEND Allow NULL? 
41UPLENPlanned loading end timenvarchar60TIMS(N'000000')NoUPLEND Allow NULL? 
42DALENActual date for end of loadingnvarchar80DATS(N'00000000')NoDALEND Allow NULL? 
43UALENActual loading end timenvarchar60TIMS(N'000000')NoUALEND Allow NULL? 
44STABFStatus of shipment completionchar10CHAR(N' ')NoSTABF Allow NULL? 
45DPABFPlanned date for shipment completionnvarchar80DATS(N'00000000')YesDPABF Allow NULL? 
46UPABFPlanned time for processingnvarchar60TIMS(N'000000')YesUPABF Allow NULL? 
47DTABFCurrent date of shipment completionnvarchar80DATS(N'00000000')NoDTABF Allow NULL? 
48UZABFTime of transportation processingnvarchar60TIMS(N'000000')NoUZABF Allow NULL? 
49STTBGStatus for start of shipmentchar10CHAR(N' ')NoSTTBG Allow NULL? 
50DPTBGPlanned date for start of shipmentnvarchar80DATS(N'00000000')NoDPTBG Allow NULL? 
51UPTBGPlanned transport start timenvarchar60TIMS(N'000000')NoUPTBG Allow NULL? 
52DATBGCurrent date for start of shipmentnvarchar80DATS(N'00000000')NoDATBG Allow NULL? 
53UATBGActual transport start timenvarchar60TIMS(N'000000')NoUATBG Allow NULL? 
54STTENStatus for end of shipmentchar10CHAR(N' ')NoSTTEN Allow NULL? 
55DPTENPlanned date for end of shipmentnvarchar80DATS(N'00000000')NoDPTEN Allow NULL? 
56UPTENPlanned transport end timenvarchar60TIMS(N'000000')NoUPTEN Allow NULL? 
57DATENActual Date for End of Shipmentnvarchar80DATS(N'00000000')NoDATEND Allow NULL? 
58UATENActual shipment end timenvarchar60TIMS(N'000000')NoUATEND Allow NULL? 
59STTRGOverall transportation statuschar10CHAR(N' ')YesSTTRG Allow NULL? 
60TDLNRNumber of forwarding agentnvarchar100CHAR(N' ')NoLFA1TDLNR Allow NULL? 
61TERNROrder Numbernvarchar120CHAR(N' ')No*AUFNR Allow NULL? 
62PKSTKShipment Contains Handling Unitschar10CHAR(N' ')NoPKSTK_VTTK Allow NULL? 
63DTMEGUnit of Weight for Transportation Planningnvarchar30UNIT(N' ')No*DTMEG Allow NULL? 
64DTMEVVolume Unit for Transportation Planningnvarchar30UNIT(N' ')No*DTMEV Allow NULL? 
65DISTZDistancedecimal133QUAN((0))YesDISTZ
66MEDSTUnit of measure for distancenvarchar30UNIT(N' ')Yes*MEDST Allow NULL? 
67FAHZTTravelling time only between two locationsdecimal52QUAN((0))YesFAHZT
68GESZTTotal travelling time between two locations incl. breaksdecimal52QUAN((0))YesGESZT
69MEIZTUnit of measure for travelling timesnvarchar30UNIT(N' ')Yes*MEIZT Allow NULL? 
70STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')Yes*STAFO Allow NULL? 
71FBSTAStatus of shipment costs calculationchar10CHAR(N' ')YesFBSTA Allow NULL? 
72FBGSTOverall status of calculation of shipment costs for shipmentchar10CHAR(N' ')YesFBGST Allow NULL? 
73ARSTAStatus of shipment costs settlementchar10CHAR(N' ')YesARSTA Allow NULL? 
74ARGSTTotal status of shipment costs settlement for shipmentchar10CHAR(N' ')YesARGST Allow NULL? 
75STERM_DONELeg determination completechar10CHAR(N' ')YesSTERM_DONE Allow NULL? 
76VSE_FRKHandling Unit Data are Referred in Shipment Cost Documentchar10CHAR(N' ')YesVSE_FRK Allow NULL? 
77KKALSMPricing procedure in shipment headernvarchar60CHAR(N' ')YesT683KALSM_KOPF Allow NULL? 
78SDABWSpecial processing indicatornvarchar40CHAR(N' ')YesTVSAKSDABW Allow NULL? 
79FRKRLShipment costs relevancechar10CHAR(N' ')YesKFRKRL Allow NULL? 
80GESZTDPlanned total time of transportation (in days)decimal110DEC((0))YesKP_GESZTDP
81FAHZTDPlanned duration of transportation (in hours:minutes)decimal110DEC((0))YesKP_EFFZTDP
82GESZTDAActual total time of shipment (in days)decimal110DEC((0))YesKP_GESZTDA
83FAHZTDAActual time needed for transporation (in hours:minutes)decimal110DEC((0))YesKP_EFFZTDA
84ROCPY_DONERoute copied from deliverychar10CHAR(N' ')YesROCPY_DONE Allow NULL? 
85HANDLEGlobally unique identifier (linked to time segment, etc)nvarchar220CHAR(N' ')YesTSEGGUID Allow NULL? 
86TSEGFLTime segment existschar10CHAR(N' ')YesTSEGEXISTS Allow NULL? 
87TSEGTPTime segment event group shipment headernvarchar100CHAR(N' ')Yes*TSEGTPLVTT Allow NULL? 
88ADD01Suppl. 1nvarchar100CHAR(N' ')YesVTADD01VTTK_ADD01 Allow NULL? 
89ADD02Suppl. 2nvarchar100CHAR(N' ')YesVTADD02VTTK_ADD02 Allow NULL? 
90ADD03Suppl. 3nvarchar100CHAR(N' ')YesVTADD03VTTK_ADD03 Allow NULL? 
91ADD04Suppl. 4nvarchar100CHAR(N' ')YesVTADD04VTTK_ADD04 Allow NULL? 
92TEXT1Addit.text 1nvarchar400CHAR(N' ')YesVTTK_TEXT1 Allow NULL? 
93TEXT2Addit.text 2nvarchar400CHAR(N' ')YesVTTK_TEXT2 Allow NULL? 
94TEXT3Addit.text 3nvarchar400CHAR(N' ')YesVTTK_TEXT3 Allow NULL? 
95TEXT4Addit.text 4nvarchar400CHAR(N' ')YesVTTK_TEXT4 Allow NULL? 
96PROLIDangerous Goods Management Profile in SD Documentsnvarchar30CHAR(N' ')YesTDGC5ADGE_PROLI Allow NULL? 
97DGTLOCKBlock Indicator for Dangerous Goodschar10CHAR(N' ')YesADGE_TLOCK Allow NULL? 
98DGMDDATSelection date dangerous goods master datanvarchar80DATS(N'00000000')YesADGE_MDDAT Allow NULL? 
99CONT_DGIndicator: Document contains dangerous goodschar10CHAR(N' ')YesADGE_NCDG Allow NULL? 
100WARZTDPlanned waiting time of shipment (in hours:minutes)decimal110DEC((0))YesKP_WARZTDP
101WARZTDACurrent waiting time of shipment (in hours:minutes)decimal110DEC((0))YesKP_WARZTDA
102AULWERoute Schedulenvarchar100CHAR(N' ')Yes*AULWE Allow NULL? 
103TNDRSTTender Statusnvarchar20CHAR(N' ')YesTNDRST Allow NULL? 
104TNDRRCAcceptance Condition/Rejection Reasonnvarchar20CHAR(N' ')YesTNDRRC Allow NULL? 
105TNDR_TEXTTendering Textnvarchar800CHAR(N' ')YesTNDR_TEXT Allow NULL? 
106TNDRDATDate of tender statusnvarchar80DATS(N'00000000')YesTNDRDAT Allow NULL? 
107TNDRZETTime of tender statusnvarchar60TIMS(N'000000')YesTNDRZET Allow NULL? 
108TNDR_MAXPMaximum Price for Shipmentdecimal152CURR((0))YesTNDR_MAXP
109TNDR_MAXCCurrency of Maximum Pricenvarchar50CUKY(N' ')YesTCURCTNDR_MAXC Allow NULL? 
110TNDR_ACTPActual Shipment Costs for Shipmentdecimal152CURR((0))YesTNDR_ACTP
111TNDR_ACTCCurrency of Actual Shipment Costsnvarchar50CUKY(N' ')YesTCURCTNDR_ACTC Allow NULL? 
112TNDR_CARRForwarding Agent Who Accepted the Shipmentnvarchar100CHAR(N' ')YesTNDR_CARR Allow NULL? 
113TNDR_CRNMName of Carrier Who Accepted the Shipmentnvarchar350CHAR(N' ')YesTNDR_CRNM Allow NULL? 
114TNDR_TRKIDForwarding Agent Tracking IDnvarchar350CHAR(N' ')YesTNDR_TRKID Allow NULL? 
115TNDR_EXPDDate on Which Offer Expiresnvarchar80DATS(N'00000000')YesTNDR_EXPD Allow NULL? 
116TNDR_EXPTTime at Which Quotation Expiresnvarchar60TIMS(N'000000')YesTNDR_EXPT Allow NULL? 
117TNDR_ERPDEarliest Pickup Datenvarchar80DATS(N'00000000')YesTNDR_ERPD Allow NULL? 
118TNDR_ERPTEarliest Pickup Timenvarchar60TIMS(N'000000')YesTNDR_ERPT Allow NULL? 
119TNDR_LTPDLatest Pickup Datenvarchar80DATS(N'00000000')YesTNDR_LTPD Allow NULL? 
120TNDR_LTPTLatest Pickup Timenvarchar60TIMS(N'000000')YesTNDR_LTPT Allow NULL? 
121TNDR_ERDDEarliest Delivery Datenvarchar80DATS(N'00000000')YesTNDR_ERDD Allow NULL? 
122TNDR_ERDTEarliest Delivery Timenvarchar60TIMS(N'000000')YesTNDR_ERDT Allow NULL? 
123TNDR_LTDDLatest Delivery Datenvarchar80DATS(N'00000000')YesTNDR_LTDD Allow NULL? 
124TNDR_LTDTLatest Delivery Timenvarchar60TIMS(N'000000')YesTNDR_LTDT Allow NULL? 
125TNDR_LDLGLength of Loading Platformdecimal133QUAN((0))YesTNDR_LDLG
126TNDR_LDLUUnit of Measure for Load Lengthnvarchar30UNIT(N' ')Yes*TNDR_LDLU Allow NULL? 
127KZHULFRIndicator: HUs Relevant for Delivery Item Generationchar10CHAR(N' ')YesKZHULFR Allow NULL? 
128ALLOWED_TWGTAllowed total weight of shipmentdecimal80QUAN((0))YesALLOWED_TWGT
129VLSTKDistribution Status (Decentralized Warehouse Processing)char10CHAR(N' ')YesVLSTK Allow NULL? 
130VERURSYSShipment Distribution: Original Systemnvarchar100CHAR(N' ')Yes*TRA_VERURSYS Allow NULL? 
131CM_IDENTIdentification Number for Continuous Movesnvarchar120CHAR(N' ')YesCMIDENTIFIER Allow NULL? 
132CM_SEQUENCESequence of Transports in Connecting Trafficenvarchar40NUMC(N'0000')YesCMSEQUENCE Allow NULL? 
133EXT_FREIGHT_ORDExternal Freight Order IDnvarchar200CHAR(N' ')YesEXT_FREIGHT_ORDER Allow NULL? 
134EXT_TM_SYSKey Name of Business Systemnvarchar600CHAR(N' ')YesSLD_BSKEY Allow NULL? 
135/BEV1/RPFAR1Driver 1nvarchar100CHAR(N' ')YesKNA1/DSD/RP_DRIVER1 Allow NULL? 
136/BEV1/RPFAR2Driver 2nvarchar100CHAR(N' ')YesKNA1/DSD/RP_DRIVER2 Allow NULL? 
137/BEV1/RPMOWAVehiclenvarchar180CHAR(N' ')Yes*/DSD/RP_TRUCK Allow NULL? 
138/BEV1/RPANHAETrailernvarchar180CHAR(N' ')Yes*/DSD/RP_TRAIL Allow NULL? 
139/BEV1/RPFLGNRLoading Sequence Number in the Tournvarchar50NUMC(N'00000')Yes/DSD/RP_SEQUENCENR Allow NULL? 
140/VSO/R_STATUSStatus of Vehicle Space Optimizationchar10CHAR(N' ')Yes/VSO/M_VSO_STATUS Allow NULL? 
NamePrimaryUniqueTypeColumns
VTTK~0YesYesCLUSTEREDMANDT, TKNUM
VTTK~ANoNoNONCLUSTEREDMANDT, TPLST, SHTYP
VTTK~BNoNoNONCLUSTEREDEXTI1

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