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  | TVTK
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.0TVTK691Shipment TypesTransportation
SQL:  selectupdate insert create

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

SELECT MANDT, SHTYP, VBTYP, NUMKI, NUMKE, KOPGR, STERM, ABFER, ABWST, BFART, VSART, VSAVL, VSANL, LAUFK, KALSM, KAPPL, TXTGR, PARGR, SVTRA, PROFIDNETZ, DTMEG, DTMEV, KSCHL, ROUTE_VLF, SPEDI_VLF, ABF_ACTPRF, FKART, STGTA, FRKRL, FRKRL_STR, FRKRL_UMP, FRKRL_GRP, ROUTE_STAG, CHGDOC_SHTYP, DIS_ACTPRF, REG_ACTPRF, LBG_ACTPRF, LEN_ACTPRF, TBG_ACTPRF, TEN_ACTPRF, PLANNING_PROFILE, TSEGTP, KOPRF, TERMIN_VLF, TRINF_UEB, PMODE_VD, PMODE_ND, KZHULFR, VTDWM, BORGR_PROCTYP, BORGR_AUTO_REG, BORGR_AUTO_LEN, BORGR_EXTI1_UNQ, BORGR_EXTI1_MUST, BORGR_EXTI1_EEDI, BORGR_EXTI1_EDIA, BORGR_EXTI2_UNQ, BORGR_EXTI2_MUST, BORGR_EXTI2_EEDI, BORGR_EXTI2_EDIA, BORGR_SIGNI_UNQ, BORGR_SIGNI_MUST, BORGR_SIGNI_EEDI, BORGR_SIGNI_EDIA, BORGR_TPBEZ_UNQ, BORGR_TPBEZ_MUST, BORGR_TPBEZ_EEDI, BORGR_TPBEZ_EDIA, BORGR_ASN_NOT_EX FROM TVTK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SHTYPShipment typenvarchar40CHAR(N' ')NoSHTYP Allow NULL? 
3VBTYPSD document categorychar10CHAR(N' ')NoVBTYP Allow NULL? 
4NUMKINumber range in the case of internal number assignmentnvarchar20CHAR(N' ')NoNUMKI Allow NULL? 
5NUMKENumber range in the case of external number assignmentnvarchar20CHAR(N' ')NoNUMKE Allow NULL? 
6KOPGRScreen sequence group in doc. headernvarchar40CHAR(N' ')NoKOPGR Allow NULL? 
7STERMLeg determinationchar10CHAR(N' ')NoSTERM Allow NULL? 
8ABFERShipment completion typechar10CHAR(N' ')NoABFER Allow NULL? 
9ABWSTProcessing controlchar10CHAR(N' ')NoABWST Allow NULL? 
10BFARTService Levelchar10CHAR(N' ')NoBFART Allow NULL? 
11VSARTShipping typenvarchar20CHAR(N' ')NoT173VERSART Allow NULL? 
12VSAVLShipping type of preliminary legnvarchar20CHAR(N' ')NoT173VSAVL Allow NULL? 
13VSANLShipping type of subsequent legnvarchar20CHAR(N' ')NoT173VSANL Allow NULL? 
14LAUFKLeg Indicatorchar10CHAR(N' ')NoLAUFK Allow NULL? 
15KALSMOutput determination procedurenvarchar60CHAR(N' ')NoT683KALSMB Allow NULL? 
16KAPPLApplication for output conditionsnvarchar20CHAR(N' ')NoT681ANA_KAPPL Allow NULL? 
17TXTGRText determination procedurenvarchar20CHAR(N' ')NoTTXGTXTGR Allow NULL? 
18PARGRPartner Determination Procedurenvarchar40CHAR(N' ')NoTVPGPARGR Allow NULL? 
19SVTRASelection variant for transportation planningnvarchar140CHAR(N' ')NoSVTRA Allow NULL? 
20PROFIDNETZNetwork profilenvarchar70CHAR(N' ')NoTCN41PROFIDNZPL Allow NULL? 
21DTMEGUnit of Weight for Transportation Planningnvarchar30UNIT(N' ')No*DTMEG Allow NULL? 
22DTMEVVolume Unit for Transportation Planningnvarchar30UNIT(N' ')No*DTMEV Allow NULL? 
23KSCHLOutput Typenvarchar40CHAR(N' ')No*NA_KSCHL Allow NULL? 
24ROUTE_VLFIndicator: Proposed route from deliverychar10CHAR(N' ')YesROUTE_VLF Allow NULL? 
25SPEDI_VLFIndicator: Proposed forwarding agent from deliverychar10CHAR(N' ')YesSPEDI_VLF Allow NULL? 
26ABF_ACTPRFActions to be carried out for completing a shipmentnvarchar140CHAR(N' ')YesABF_ACTPRF Allow NULL? 
27FKARTShipment cost typenvarchar40CHAR(N' ')YesTVTFFKART_T Allow NULL? 
28STGTAShipment: statistics group, shipment typenvarchar20CHAR(N' ')YesVTSGTSTGTA Allow NULL? 
29FRKRLProposal freight costs relevance, Shipment headerchar10CHAR(N' ')YesFRKRL_KOP Allow NULL? 
30FRKRL_STRProposal freight costs relevance, shipment legchar10CHAR(N' ')YesFRKRL_STR Allow NULL? 
31FRKRL_UMPProposal for shipment costs relevance - Load transfer pointchar10CHAR(N' ')YesFRKRL_UMP Allow NULL? 
32FRKRL_GRPProposal for freight costs relevance, Border cross.ptchar10CHAR(N' ')YesFRKRL_GRP Allow NULL? 
33ROUTE_STAGAdopt stages from route into shipmentchar10CHAR(N' ')YesROUTE_STAG Allow NULL? 
34CHGDOC_SHTYPIndicator: Change document shipment for shipment typechar10CHAR(N' ')YesCHGDOC_SHTYP Allow NULL? 
35DIS_ACTPRFActivities to be performed for planning a shipmentnvarchar140CHAR(N' ')YesDIS_ACTPRF Allow NULL? 
36REG_ACTPRFActivites to be carried out at shipment check-innvarchar140CHAR(N' ')YesREG_ACTPRF Allow NULL? 
37LBG_ACTPRFActivities to be performed at start of shipment loadingnvarchar140CHAR(N' ')YesLBG_ACTPRF Allow NULL? 
38LEN_ACTPRFActivities to be performed at loading finish of shipmentnvarchar140CHAR(N' ')YesLEN_ACTPRF Allow NULL? 
39TBG_ACTPRFActivites to be carried out at the beginning of a shipmentnvarchar140CHAR(N' ')YesTBG_ACTPRF Allow NULL? 
40TEN_ACTPRFActivities to be carried out at the end of a shipmentnvarchar140CHAR(N' ')YesTEN_ACTPRF Allow NULL? 
41PLANNING_PROFILEPlanning profile for transportation planningnvarchar140CHAR(N' ')YesPLANNING_PROFILE Allow NULL? 
42TSEGTPTime segment event group shipment headernvarchar100CHAR(N' ')YesTTSEGTPLHTSEGTPLVTT Allow NULL? 
43KOPRFControl Indicator for Pick Check in Shipmentchar10CHAR(N' ')YesKOPRF Allow NULL? 
44TERMIN_VLFIndicator: Proposal for deadlines from deliverieschar10CHAR(N' ')YesTERMIN_VLF Allow NULL? 
45TRINF_UEBData transfernvarchar30NUMC(N'000')Yes*TRINF_UEB Allow NULL? 
46PMODE_VDDelivery Split Profile Before Transportation Planningnvarchar40CHAR(N' ')YesTVDSSLEDSPD_PMODE_TRA1 Allow NULL? 
47PMODE_NDDelivery Split Profile after Transportation Planningnvarchar40CHAR(N' ')YesTVDSSLEDSPD_PMODE_TRA2 Allow NULL? 
48KZHULFRIndicator: HUs Relevant for Delivery Item Generationchar10CHAR(N' ')YesKZHULFR Allow NULL? 
49VTDWMDistribution Control: Decentralized WMSchar10CHAR(N' ')YesVTDWM Allow NULL? 
50BORGR_PROCTYPGR-Relevance Indicatornvarchar20CHAR(N' ')NoBORGR_PROCTYP Allow NULL? 
51BORGR_AUTO_REGAutomatic Registration for the Status of the Inb. Deliverieschar10CHAR(N' ')NoBORGR_AUTO_REG Allow NULL? 
52BORGR_AUTO_LENAut. "Loading end" From the Status of the Inb. Deliverieschar10CHAR(N' ')NoBORGR_AUTO_LEN Allow NULL? 
53BORGR_EXTI1_UNQUniqueness of the External IDchar10CHAR(N' ')NoBORGR_EXID_UNIQUE Allow NULL? 
54BORGR_EXTI1_MUSTRequired Entrychar10CHAR(N' ')NoBORGR_EXID_MUST Allow NULL? 
55BORGR_EXTI1_EEDITy.of Error Message when ID Transferred by EDI is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERREDI Allow NULL? 
56BORGR_EXTI1_EDIAType of Error Message when Online ID is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERRDIA Allow NULL? 
57BORGR_EXTI2_UNQUniqueness of the External IDchar10CHAR(N' ')NoBORGR_EXID_UNIQUE Allow NULL? 
58BORGR_EXTI2_MUSTRequired Entrychar10CHAR(N' ')NoBORGR_EXID_MUST Allow NULL? 
59BORGR_EXTI2_EEDITy.of Error Message when ID Transferred by EDI is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERREDI Allow NULL? 
60BORGR_EXTI2_EDIAType of Error Message when Online ID is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERRDIA Allow NULL? 
61BORGR_SIGNI_UNQUniqueness of the External IDchar10CHAR(N' ')NoBORGR_EXID_UNIQUE Allow NULL? 
62BORGR_SIGNI_MUSTRequired Entrychar10CHAR(N' ')NoBORGR_EXID_MUST Allow NULL? 
63BORGR_SIGNI_EEDITy.of Error Message when ID Transferred by EDI is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERREDI Allow NULL? 
64BORGR_SIGNI_EDIAType of Error Message when Online ID is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERRDIA Allow NULL? 
65BORGR_TPBEZ_UNQUniqueness of the External IDchar10CHAR(N' ')NoBORGR_EXID_UNIQUE Allow NULL? 
66BORGR_TPBEZ_MUSTRequired Entrychar10CHAR(N' ')NoBORGR_EXID_MUST Allow NULL? 
67BORGR_TPBEZ_EEDITy.of Error Message when ID Transferred by EDI is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERREDI Allow NULL? 
68BORGR_TPBEZ_EDIAType of Error Message when Online ID is not Uniquechar10CHAR(N' ')NoBORGR_EXID_ERRDIA Allow NULL? 
69BORGR_ASN_NOT_EXShipments for Non-Existing Inbound Deliveries Allowedchar10CHAR(N' ')YesBORGR_ASN_NOT_EXIST Allow NULL? 
NamePrimaryUniqueTypeColumns
TVTK~0YesYesCLUSTEREDMANDT, SHTYP

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