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  | TVLK
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 :: Shipping :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TVLK691Delivery TypesBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, LFART, KOPGR, UEVOR, TXN08, UMFNG, NUMKI, NUMKE, NUMKIRULE, INCPO, PARGR, AUFER, DAART, POBED, REGGR, REGLG, WAAUS, ROUTF, VBTYP, TXTGR, ERNAM, KAPPL, KALSM, KSCHL, STGAK, CMGRL, CMGRK, CMGRW, QHERK, TRSPG, TDIIX, PROFIDNETZ, EXCOK, NEUTE, KALSP, FEHGR, LNSPL, AVERP, PM_ITEM_GEN, REGTB, BZOPS, EXCBC, EXCEM, EXCLG, J_1ADOCCLS, RFPL_SW, TSEGTP, UVEIB, DBTCH, DSFAD, SPOFI, OIDELDCM, SPE_NUMKT, SPE_NR_RECYCLING, BORGR_LIFEX_MUST, BORGR_LIFEX_UNQ, BORGR_LIFEX_EEDI, BORGR_LIFEX_EDIA, BORGR_SODET, HOLD_DATA, TDID, TDSPRAS, EDI_WEIGHTVOL, SPE_ENABLE_VALID, MSR_FKARA, FSH_AUDELOC, FSH_VASS_ACT, FSH_VASS_KALSM, FSH_VASS_CORR FROM TVLK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LFARTDelivery Typenvarchar40CHAR(N' ')NoLFART Allow NULL? 
3KOPGRScreen sequence group for document header & itemnvarchar40CHAR(N' ')NoTVHBBIFGR Allow NULL? 
4UEVORF-code default for overview screennvarchar40CHAR(N' ')NoUEVOR_VL Allow NULL? 
5TXN08Number of the standard textnvarchar80CHAR(N' ')NoTXN08 Allow NULL? 
6UMFNGDisplay Rangenvarchar200CHAR(N' ')NoUMFNG Allow NULL? 
7NUMKINumber range in the case of internal number assignmentnvarchar20CHAR(N' ')NoNUMKI Allow NULL? 
8NUMKENumber range in the case of external number assignmentnvarchar20CHAR(N' ')NoNUMKE Allow NULL? 
9NUMKIRULERule for Determining Number Ranges for Decentralized LESchar10CHAR(N' ')YesLESHP_NUMKI_RULE Allow NULL? 
10INCPOIncrement of item number in the SD documentnvarchar60NUMC(N'000000')NoINCPO Allow NULL? 
11PARGRPartner Determination Procedurenvarchar40CHAR(N' ')NoTVPGPARGR Allow NULL? 
12AUFERA sales order is required as basis for deliverychar10CHAR(N' ')NoAUFER Allow NULL? 
13DAARTDefault order type for deliveries without reference to ordernvarchar40CHAR(N' ')NoTVAKDAART Allow NULL? 
14POBEDRequirement for item that does not refer to a sales ordernvarchar30NUMC(N'000')NoPOBED Allow NULL? 
15REGGRDummy functionnvarchar30CHAR(N' ')NoDUMMY_3 Allow NULL? 
16REGLGRule for determining the storage location for pickingnvarchar40CHAR(N' ')NoREGLG Allow NULL? 
17WAAUSDummy function in length 1char10CHAR(N' ')NoDUMMY Allow NULL? 
18ROUTFNew route determination: with or without a check?char10CHAR(N' ')NoROUTF Allow NULL? 
19VBTYPSD document categorychar10CHAR(N' ')NoVBTYP Allow NULL? 
20TXTGRText determination procedurenvarchar20CHAR(N' ')NoTTXGTXTGR Allow NULL? 
21ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
22KAPPLApplication for output conditionsnvarchar20CHAR(N' ')NoT681ANA_KAPPL Allow NULL? 
23KALSMOutput determination procedurenvarchar60CHAR(N' ')NoT683KALSMB Allow NULL? 
24KSCHLOutput Typenvarchar40CHAR(N' ')NoT685NA_KSCHL Allow NULL? 
25STGAKStatistics group for sales document typenvarchar20CHAR(N' ')NoTVSFSTGAK Allow NULL? 
26CMGRLDelivery credit groupnvarchar20CHAR(N' ')NoT691DCMGRL Allow NULL? 
27CMGRKCredit group for pickingnvarchar20CHAR(N' ')NoT691DCMGRK Allow NULL? 
28CMGRWGoods issue credit groupnvarchar20CHAR(N' ')NoT691DCMGRW Allow NULL? 
29QHERKInspection Lot Originnvarchar20CHAR(N' ')NoTQ31QHERK Allow NULL? 
30TRSPGShipment Blocking Reasonnvarchar20CHAR(N' ')NoTTSGTRSPG Allow NULL? 
31TDIIXTransportation relevant indicator for deliverychar10CHAR(N' ')NoTDIIX_LIEF Allow NULL? 
32PROFIDNETZNetwork profilenvarchar70CHAR(N' ')NoTCN41PROFIDNZPL Allow NULL? 
33EXCOKCarry out legal control for sales document typechar10CHAR(N' ')NoEXCOK Allow NULL? 
34NEUTEReschedule deliverieschar10CHAR(N' ')NoNEUTE Allow NULL? 
35KALSPShipping: Pricing procedurenvarchar60CHAR(N' ')NoT683KALSP Allow NULL? 
36FEHGRIncompletion procedure for sales documentnvarchar20CHAR(N' ')YesTVUVFEHGR Allow NULL? 
37LNSPLPerform Delivery Split According to Warehouse Numberchar10CHAR(N' ')YesLNSPL Allow NULL? 
38AVERPAutomatic packing using packing proposalchar10CHAR(N' ')YesAVERP Allow NULL? 
39PM_ITEM_GENGeneration of Delivery Items for HU Packaging Materialschar10CHAR(N' ')YesLESHP_ITEM_GEN Allow NULL? 
40REGTBRule for determining door and material staging areanvarchar40CHAR(N' ')YesREGTB Allow NULL? 
41BZOPSStaging area determination at delivery item level?char10CHAR(N' ')YesBZOPS Allow NULL? 
42EXCBCBoycott list check of standard partners f.Foreign Trade - Onchar10CHAR(N' ')YesEXCBC Allow NULL? 
43EXCEMEmbargo check of standard partners for Foreign Trade - Onchar10CHAR(N' ')YesEXCEM Allow NULL? 
44EXCLGIndicator: Save legal control logchar10CHAR(N' ')YesEXCLG Allow NULL? 
45J_1ADOCCLSDocument Classchar10CHAR(N' ')YesJ_1ADOCCLSJ_1ADOCCL_ Allow NULL? 
46RFPL_SWRoute schedule switch for delivery typeschar10CHAR(N' ')YesRFPL_SW Allow NULL? 
47TSEGTPEvent group time segment delivery headernvarchar100CHAR(N' ')YesTTSEGTPLHTSEGTPLLIK Allow NULL? 
48UVEIBDoc. pricing procedure for incomplete export/import datanvarchar30CHAR(N' ')YesT609BUVEIB Allow NULL? 
49DBTCHDistribution Mode for the Deliverychar10CHAR(N' ')YesDBTCH Allow NULL? 
50DSFADDelivery Split for Additional Partnerschar10CHAR(N' ')YesTVLK_DSFAD Allow NULL? 
51SPOFIRules for Shipping Point Determinationchar10CHAR(N' ')YesSPOFI Allow NULL? 
52OIDELDCMActive flag f. Document Change Management (DCM) f.deliverieschar10CHAR(N' ')YesOIC_SDP_DDCM Allow NULL? 
53SPE_NUMKTNumber Range for Temporary Inbound Deliveriesnvarchar20CHAR(N' ')Yes/SPE/INB_NUMKT Allow NULL? 
54SPE_NR_RECYCLINGEnable Number Reuse for Unchecked/Temporary Deliverieschar10CHAR(N' ')Yes/SPE/NR_RECYCLING Allow NULL? 
55BORGR_LIFEX_MUSTRequired Entrychar10CHAR(N' ')Yes/SPE/EXID_MUST Allow NULL? 
56BORGR_LIFEX_UNQUniqueness of the External IDchar10CHAR(N' ')Yes/SPE/EXID_UNIQUE Allow NULL? 
57BORGR_LIFEX_EEDIError Message Type when ID Transferred by EDI Is Not Uniquechar10CHAR(N' ')Yes/SPE/EXID_ERREDI Allow NULL? 
58BORGR_LIFEX_EDIAType of Error Message when Online ID is not Uniquechar10CHAR(N' ')Yes/SPE/EXID_ERRDIA Allow NULL? 
59BORGR_SODETAutomatic PO Determinationchar10CHAR(N' ')Yes/SPE/INB_SODET Allow NULL? 
60HOLD_DATAIndicator Whether Inbound Deliveries on Hold Are Allowedchar10CHAR(N' ')Yes/SPE/HOLD_DATA Allow NULL? 
61TDIDText IDnvarchar40CHAR(N' ')YesTTXSTDID Allow NULL? 
62TDSPRASLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
63EDI_WEIGHTVOLAdopt Weight and Volume from IDocchar10CHAR(N' ')YesBORGR_EDI_WEIGHTVOL Allow NULL? 
64SPE_ENABLE_VALIDEnable Validation for All Deliveries within VL60char10CHAR(N' ')Yes/SPE/INB_ENABLE_VALIDATION Allow NULL? 
65MSR_FKARADefault Billing Typenvarchar40CHAR(N' ')YesTVFKMSR_FKARA Allow NULL? 
66FSH_AUDELOCAutomatic Deallocation for Delivery Changeschar10CHAR(N' ')YesFSH_AUDELOC Allow NULL? 
67FSH_VASS_ACTVAS Active Flag in SDchar10CHAR(N' ')YesFSH_VASS_ACT Allow NULL? 
68FSH_VASS_KALSMDetermination Procedure in SDnvarchar60CHAR(N' ')YesFSH_VASS_KALSM Allow NULL? 
69FSH_VASS_CORRVAS Correlation in Deliverieschar10CHAR(N' ')YesFSH_VASS_CORR_L Allow NULL? 
NamePrimaryUniqueTypeColumns
TVLK~0YesYesCLUSTEREDMANDT, LFART

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