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  | TVFK
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
Sales and Distribution :: Billing :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TVFK851Billing: Document TypesBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, FKART, KOPGR, NUMKI, NUMKE, INCPO, KUNN0, UEVOR, UMFNG, RFBFK, TRVOG, TXN08, VBTYP, ERNAM, PARGK, PARGP, KALSMC, FKARTS, TXTGR, KAPPL, KALSM, KSCHL, STAFO, KVSLV, KALVG, TXTGR_P, STATI, KALSMBP, BORVF, FKART_RL, RELEP, TXTLF, HITYP_PR, FKART_AB, GRBED_S, ORDNR_FI_S, XBLNR_FI_S, J_1BNFREL, J_1BMAINPA, J_1BTDIDH, J_1BTDCOH, J_1BTDIDL, J_1BTDCOL, FKTYP, XNEGP, BLART, XFILKD, XVALGS, KALSMCA, KALSMCB, KALSMCC, KALSMCD, XKOIV, J_1AINVREF, J_1ACPDEL, UVEIB, FKART_MEV_RESET, VBTYP_EXT, ISM_XKRVO, OICINPD, OIFEEPD, OIINVCYC1, OIINVCYC2, OIINVCYC3, OIINVCYC4, OIINVCYC5, OIINVCYC6, OIINVCYC7, OIINVCYC8, OIINVCYC9, OINETEXIT, OIPTRMEX, OIC_DIFFIN, OIC_DICNTR, OIC_ACCVAL, OIC_ERRHA, OIC_FKART, OISELEXIT, OIFINEXIT, OINETRPT, OIBTCEXIT, OIAMWOFI, OIABALAN, OIINVAPP, OIINDCM FROM TVFK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2FKARTBilling Typenvarchar40CHAR(N' ')NoFKART Allow NULL? 
3KOPGRScreen sequence group in doc. headernvarchar40CHAR(N' ')NoKOPGR 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? 
6INCPOIncrement of item number in the SD documentnvarchar60NUMC(N'000000')NoINCPO Allow NULL? 
7KUNN0Billing type for rebate processingchar10CHAR(N' ')NoBOFKT Allow NULL? 
8UEVORF-code default for overview screennvarchar40CHAR(N' ')NoUEVOR_VF Allow NULL? 
9UMFNGDisplay Rangenvarchar200CHAR(N' ')NoUMFNG Allow NULL? 
10RFBFKBlocked for transfer to accountingchar10CHAR(N' ')NoRFBFK Allow NULL? 
11TRVOGTransaction groupchar10CHAR(N' ')NoTRVOG Allow NULL? 
12TXN08Number of the standard textnvarchar80CHAR(N' ')NoTXN08 Allow NULL? 
13VBTYPSD document categorychar10CHAR(N' ')NoVBTYP Allow NULL? 
14ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
15PARGKPartner determination procedure for the billing doc.headernvarchar40CHAR(N' ')No*PARGK Allow NULL? 
16PARGPPartner determination procedure for the billing doc.itemnvarchar40CHAR(N' ')No*PARGP Allow NULL? 
17KALSMCAccount determination procedurenvarchar60CHAR(N' ')NoT683KALSMC Allow NULL? 
18FKARTSBilling type for cancellationnvarchar40CHAR(N' ')NoTVFKFKARTS Allow NULL? 
19TXTGRText determination procedurenvarchar20CHAR(N' ')NoTTXGTXTGR Allow NULL? 
20KAPPLApplication for output conditionsnvarchar20CHAR(N' ')NoT681ANA_KAPPL Allow NULL? 
21KALSMOutput determination procedurenvarchar60CHAR(N' ')NoT683KALSMB Allow NULL? 
22KSCHLOutput Typenvarchar40CHAR(N' ')No*NA_KSCHL Allow NULL? 
23STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')No*STAFO Allow NULL? 
24KVSLVAccount key for cash allocationnvarchar30CHAR(N' ')NoT687KVSLV Allow NULL? 
25KALVGDocument procedure (for determining pricing procedure)char10CHAR(N' ')NoTVKVKALVG Allow NULL? 
26TXTGR_PText determination procedure for billing itemnvarchar20CHAR(N' ')NoTTXGTXTGR_P Allow NULL? 
27STATIUpdate statisticschar10CHAR(N' ')NoSTATI Allow NULL? 
28KALSMBPProcedure for item outputnvarchar60CHAR(N' ')NoT683KALSMBP Allow NULL? 
29BORVFBilling document is relevant for rebate processingchar10CHAR(N' ')NoBORVF Allow NULL? 
30FKART_RLInvoice list typenvarchar40CHAR(N' ')NoTVFKFKART_RL Allow NULL? 
31RELEPForward invoice lists with line items to FIchar10CHAR(N' ')NoRELEP Allow NULL? 
32TXTLFCopy texts from delivery notechar10CHAR(N' ')NoTXTLF Allow NULL? 
33HITYP_PRHierarchy type for pricingchar10CHAR(N' ')NoTHITHITYP_PR Allow NULL? 
34FKART_ABAccrual billing typenvarchar40CHAR(N' ')NoTVFKFKART_AB Allow NULL? 
35GRBED_SCopying requirementsnvarchar30NUMC(N'000')Yes*GRBED Allow NULL? 
36ORDNR_FI_SAllocation number FIchar10CHAR(N' ')YesORDNR_FI Allow NULL? 
37XBLNR_FI_SFI reference numberchar10CHAR(N' ')YesXBLNR_FI Allow NULL? 
38J_1BNFRELNota Fiscal Relevancechar10CHAR(N' ')YesJ_1BNFREL Allow NULL? 
39J_1BMAINPAMain partner function ID (e.g. SH for ship-to party)nvarchar20CHAR(N' ')YesJ_1BADJ_1BMAINPA Allow NULL? 
40J_1BTDIDHText Id. Nota Fiscal headernvarchar40CHAR(N' ')YesTTXIDJ_1BTDIDH Allow NULL? 
41J_1BTDCOHNumber of text lines headerchar10NUMC(N'0')YesJ_1BTDCOH Allow NULL? 
42J_1BTDIDLText Id Nota Fiscal linesnvarchar40CHAR(N' ')YesTTXIDJ_1BTDIDL Allow NULL? 
43J_1BTDCOLCounter Number of text lines NF linechar10NUMC(N'0')YesJ_1BTDCOL Allow NULL? 
44FKTYPBilling categorychar10CHAR(N' ')YesFKTYP_2 Allow NULL? 
45XNEGPNegative postingchar10CHAR(N' ')YesXNEGP_VF Allow NULL? 
46BLARTDocument Typenvarchar20CHAR(N' ')YesT003BLART Allow NULL? 
47XFILKDBranch/head office relationshipchar10CHAR(N' ')YesXFILKD_VF Allow NULL? 
48XVALGSCredit memo with value datechar10CHAR(N' ')YesXVALGS Allow NULL? 
49KALSMCAPricing procedure for account determination extra paynvarchar60CHAR(N' ')YesT683KALSMCA Allow NULL? 
50KALSMCBPricing procedure for acc. determ. reconciliation accountnvarchar60CHAR(N' ')YesT683KALSMCB Allow NULL? 
51KALSMCCPricing procedure for account determination cash settlementnvarchar60CHAR(N' ')YesT683KALSMCC Allow NULL? 
52KALSMCDPricing procedure for account determination payment cardsnvarchar60CHAR(N' ')YesT683KALSMCD Allow NULL? 
53XKOIVAccount assignment offsetting entry in intercompany billingchar10CHAR(N' ')YesXKOIV Allow NULL? 
54J_1AINVREFInvoice reference in billing documentchar10CHAR(N' ')YesJ_1AINVREF Allow NULL? 
55J_1ACPDELIndicator: Copy branch from Delivery notechar10CHAR(N' ')YesJ_1ACPDEL Allow NULL? 
56UVEIBDoc. pricing procedure for incomplete export/import datanvarchar30CHAR(N' ')YesT609BUVEIB Allow NULL? 
57FKART_MEV_RESETBilling Document Type for Period-End Resetnvarchar40CHAR(N' ')YesTVFKFKART_MEV_RESET Allow NULL? 
58VBTYP_EXTExtension of SD Document Categorynvarchar40CHAR(N' ')YesTDD_VBTYP_EXT Allow NULL? 
59ISM_XKRVOIS-M: Credit-Side Transaction Indicatorchar10CHAR(N' ')YesXKRVO Allow NULL? 
60OICINPDInvoice pricing date rulechar10CHAR(N' ')YesOIC_INPD Allow NULL? 
61OIFEEPDFee pricing datechar10CHAR(N' ')YesOIA_FEEPD Allow NULL? 
62OIINVCYC1Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
63OIINVCYC2Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
64OIINVCYC3Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
65OIINVCYC4Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
66OIINVCYC5Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
67OIINVCYC6Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
68OIINVCYC7Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
69OIINVCYC8Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
70OIINVCYC9Invoice cycle indicator active (X/ )char10CHAR(N' ')YesOIA_INCYCA Allow NULL? 
71OINETEXITUser exit for netting cycle determinationnvarchar30NUMC(N'000')Yes*OIA_NEXIT Allow NULL? 
72OIPTRMEXPayment term transfer to VBRKnvarchar30NUMC(N'000')Yes*OIA_PTEXIT Allow NULL? 
73OIC_DIFFINDifferential invoicechar10CHAR(N' ')YesOIC_DIFFIN Allow NULL? 
74OIC_DICNTRDifferential invoice controlchar10CHAR(N' ')YesOIC_DICNTR Allow NULL? 
75OIC_ACCVALUser exit to accumulate already-invoiced valuesnvarchar30NUMC(N'000')YesOIC_ACCVAL Allow NULL? 
76OIC_ERRHAUser exit for error handling/no breakdown of diff. amountnvarchar30NUMC(N'000')YesOIC_ERRHA Allow NULL? 
77OIC_FKARTDefault billing type for cancel / rebillnvarchar40CHAR(N' ')YesTVFKOIC_FKART Allow NULL? 
78OISELEXITMovements index selection exitnvarchar30NUMC(N'000')Yes*OIA_SELEX Allow NULL? 
79OIFINEXITFinancial document selection exitnvarchar30NUMC(N'000')Yes*OIA_FINEX Allow NULL? 
80OINETRPTABAP Program Namenvarchar400CHAR(N' ')YesTRDIRPROGNAME Allow NULL? 
81OIBTCEXITBTCI generation exit for movements based nettingnvarchar30NUMC(N'000')Yes*OIA_BTCEX Allow NULL? 
82OIAMWOFIMovements without financials indicatorchar10CHAR(N' ')YesOIA_MWOFI Allow NULL? 
83OIABALANInclude balances indicatorchar10CHAR(N' ')YesOIA_BALAN Allow NULL? 
84OIINVAPPInvoice Approval Process (IAP) active flagchar10CHAR(N' ')YesOIC_SDP_INAPPR Allow NULL? 
85OIINDCMActive flag f. Document Change Management (DCM) for invoicechar10CHAR(N' ')YesOIC_SDP_DCM Allow NULL? 
NamePrimaryUniqueTypeColumns
TVFK~0YesYesCLUSTEREDMANDT, FKART

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