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  | TJHVA
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
Industry Specific :: SAP Media :: Advertising Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TJHVA941IS-M/AM: General Contract Attributes for Sales AreaAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, VKORG, VTWEG, SPART, ABS_TYP1, XBEST_PR, EINH1, EINH2, HITYP, XINI_KONZ, XVBONUS, PROZ_BEZ, XPAR_ABS, XQUASI, XST_GEGES, GTORE_COMP, XST_GTORE, XST_KFIND, KALSM, KALSM_KUBO, N_KALSM, N_KALSM_AB, ABS_KOLI, NUMKR_A, NUMKR_F, QABR, XAABRREG, XABETRNET, B_AUSR, E_AUSR, REG_DAU, EABR_NACHL, XTOL_FERN, AB_TOL, MIN_GUT, MIN_LAST, BAG_WAERS, XST_BAG, XMENGA, LFZ_VORL, XABE, ERN_VORL, MAX_UNT, MAX_RDAT, XERN_AGENT, XERN_HINW, XRABA, XRABA_ALL, XST_RFIND, XST_RKUMU, XZIELANP, XRANPASS, XRANPASSL, STAND_TYP, XSTAN_SUM, XSUMRAB, XSUMFR, XAUTO_BEST, XNB_ZUORD, XTO_BEST, XTO_WARN, XTO_HINW, XRABSPERR, XBEST_FIND, XFIND_HINW, XF_HINW_GE, KONFL_STEU, ZLSCHA, ZLSCHB, PARGR, FKART, FAKSA, FAKSP_B, FAKSP_G, FAKSP_L, TAGE_SP, BEZKD_DTI, XST_AVMACT, XNOVABR, XERRABSUBL, QUASI_VERH, KOQSI_VERH, ABS_TYP_SI, EINH1_SI, EINH2_SI, XERN_BEST, XERN_LEER, XARCH_OEABR, XWOENQ, KOZGF, KONFL, XNO_CHDK, XFAKTPRZUO, XSBC_OVL_CHK FROM TJHVA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VKORGSales Organizationnvarchar40CHAR(N' ')NoTVTAVKORG Allow NULL? 
3VTWEGDistribution Channelnvarchar20CHAR(N' ')NoTVTAVTWEG Allow NULL? 
4SPARTDivisionnvarchar20CHAR(N' ')NoTVTASPART Allow NULL? 
5ABS_TYP1IS-M/AM: Contract Categorychar10CHAR(N' ')YesTJH11ABS_TYP Allow NULL? 
6XBEST_PRIS-M: Apply Best Conditions to Number / Quantitychar10CHAR(N' ')YesXBEST_PR Allow NULL? 
7EINH1IS-M: Contract Units of Measurementnvarchar30UNIT(N' ')YesT006AB_MEINH1 Allow NULL? 
8EINH2IS-M/AM: Contract Units of Measurementnvarchar30UNIT(N' ')YesT006AB_MEINH2 Allow NULL? 
9HITYPIS-M: Hierarchy Type of BP Hierarchychar10CHAR(N' ')YesTJJ69DHITYP Allow NULL? 
10XINI_KONZIS-M: Control Default Setting for Group Indicatorchar10CHAR(N' ')YesXINI_KONZ Allow NULL? 
11XVBONUSIS-M: Advance Bonus Indicatorchar10CHAR(N' ')YesXVBONUS Allow NULL? 
12PROZ_BEZIS-M: Limit in Percent of Contract-Relevant Involvementdecimal52DEC((0))YesABS_PROZ
13XPAR_ABSIS-M: Work With Parallel Contracts Indicatorchar10CHAR(N' ')YesXPAR_ABS Allow NULL? 
14XQUASIIS-M: Define System Contractschar10CHAR(N' ')YesISM_QUASI Allow NULL? 
15XST_GEGESIS-M: Work with Barter Deal Yes/No Indicatorchar10CHAR(N' ')YesXST_GEGES Allow NULL? 
16GTORE_COMPField Namenvarchar300CHAR(N' ')NoMJJVA5FIELDNAME Allow NULL? 
17XST_GTOREIS-M: Largest Subsidiary Rule - Sort Criterionchar10CHAR(N' ')YesXST_GTORE Allow NULL? 
18XST_KFINDBackground Processing Activechar10CHAR(N' ')YesSYBATCH Allow NULL? 
19KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...)nvarchar60CHAR(N' ')YesT683KALSM_D Allow NULL? 
20KALSM_KUBOProcedure (Pricing, Output Control, Acct. Det., Costing,...)nvarchar60CHAR(N' ')YesT683KALSM_D Allow NULL? 
21N_KALSMIS-M: Contract Output Determination Procedurenvarchar60CHAR(N' ')YesT683KALSMB_ABS Allow NULL? 
22N_KALSM_ABIS-M: Contract Settlement for Output Determination Procedurenvarchar60CHAR(N' ')YesT683KALSMB_AAB Allow NULL? 
23ABS_KOLIIS-M: Contract Condition Listnvarchar400CHAR(N' ')YesABS_KOLI Allow NULL? 
24NUMKR_AIS-M: Number Rge for Plan.Doc.Conds in Contract Settlementnvarchar20CHAR(N' ')YesJHNUMKR_A Allow NULL? 
25NUMKR_FIS-M: Number Rge for Diff.Doc.Conds in Contract Settlementnvarchar20CHAR(N' ')YesJHNUMKR_F Allow NULL? 
26QABRIS-M: Define Settlement for System Contractschar10CHAR(N' ')YesQABR Allow NULL? 
27XAABRREGIS-M: Contract Settlement in Payer Currency Indicatorchar10CHAR(N' ')NoJH_AABRREG Allow NULL? 
28XABETRNETIS-M: Indicator: Settlement Amount Without Taxchar10CHAR(N' ')NoJH_ABETRNET Allow NULL? 
29B_AUSRIS-M: Rule for Contract Startchar10CHAR(N' ')YesTJJV14ABSCHL_BEG Allow NULL? 
30E_AUSRIS-M: Rule for Contract Endchar10CHAR(N' ')YesTJJV15ABSCHL_END Allow NULL? 
31REG_DAUIS-M: Standard Validity Period for Contracts (in Months)nvarchar20NUMC(N'00')YesABSCHLZEIT Allow NULL? 
32EABR_NACHLIS-M: Time of Final Settlement After Runtime (in Months)nvarchar20NUMC(N'00')YesEABR_NACHL Allow NULL? 
33XTOL_FERNIS-M: Control Tolerance Levelschar10CHAR(N' ')YesXTOL_FERN Allow NULL? 
34AB_TOLIS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)nvarchar30NUMC(N'000')YesABSCHL_TOL Allow NULL? 
35MIN_GUTIS-M: De Minimis Limitation for Contract Credit Memodecimal72CURR((0))YesMIN_GUTSCH
36MIN_LASTIS-M/AM: De Minimis Limitation for Contract Debit Memodecimal72CURR((0))YesMIN_LAST
37BAG_WAERSIS-M: Currency Keynvarchar50CUKY(N' ')YesTCURCJWAERS Allow NULL? 
38XST_BAGIS-M: Control De Mnimis Limitation For Contract Settlementchar10CHAR(N' ')YesXST_BAG Allow NULL? 
39XMENGAQuantity Adjustment for Change to Contract Validity Periodchar10CHAR(N' ')YesXANPASS Allow NULL? 
40LFZ_VORLLead Time for Pending Validity Period End Date (Contract)nvarchar20NUMC(N'00')YesLFZ_VORL Allow NULL? 
41XABEIS-M: Automatic Contract Renewal?char10CHAR(N' ')YesXABSCH_ERN Allow NULL? 
42ERN_VORLIS-M: Lead Time for Contract Renewalnvarchar20NUMC(N'00')YesERN_VORL Allow NULL? 
43MAX_UNTIS-M: Maximum Interruption in Validity Period (in Months)nvarchar20NUMC(N'00')YesMAX_UNT Allow NULL? 
44MAX_RDATIS-M: Maximum Backdating Start of Validity Period (Months)nvarchar20NUMC(N'00')YesMAX_RDAT Allow NULL? 
45XERN_AGENTIS-M: Do not Renew Contract for Agency Orderschar10CHAR(N' ')YesXERN_AGENT Allow NULL? 
46XERN_HINWIS-M: Renewal Notification Immediately/ With First Placementchar10CHAR(N' ')YesXERN_HINW Allow NULL? 
47XRABAIS-M: Disc./Price Adjustment During Contract Validity Periodchar10CHAR(N' ')YesRABATTANP Allow NULL? 
48XRABA_ALLIS-M: Discount/Price Change Affects All Billing Datasetschar10CHAR(N' ')YesXRABA_ALL Allow NULL? 
49XST_RFINDIS-M: Control discount adjustment - accepted/billedchar10NUMC(N'0')YesXST_RFIND Allow NULL? 
50XST_RKUMUIS-M: Type of cumulation for rolling discountchar10NUMC(N'0')YesXST_RKUMU Allow NULL? 
51XZIELANPIS-M: Change Target Quantities For Rolling Discountchar10CHAR(N' ')YesXZIELANP Allow NULL? 
52XRANPASSIS-M: Increase discount in the case of over-fulfillment ind.char10CHAR(N' ')YesXRANPASS Allow NULL? 
53XRANPASSLIS-M: Reduce discount in the case of non-fulfillment ind.char10CHAR(N' ')YesXRANPASSL Allow NULL? 
54STAND_TYPIS-M/AM: Type for Contract Standing Screenchar10CHAR(N' ')YesSTAND_TYP Allow NULL? 
55XSTAN_SUMIS-M/AM: Determine Total Types In The Contract Standingchar10CHAR(N' ')YesXSTAN_SUM Allow NULL? 
56XSUMRABIS-M: Indicator Only original orders qual.for discountchar10CHAR(N' ')YesXSUMRAB Allow NULL? 
57XSUMFRIS-M/AM: Indicator Only totals from other BUs which countchar10CHAR(N' ')YesXSUMFR Allow NULL? 
58XAUTO_BESTContract is Confirmed on Creation Indicator Yes/No Ind.char10CHAR(N' ')YesXAUTO_BEST Allow NULL? 
59XNB_ZUORDIS-M: Assignment to Unconfirmed Contracts Possible? Y/Nchar10CHAR(N' ')YesXNB_ZUORD Allow NULL? 
60XTO_BESTIS-M: "Confirnation Required" Indicatorchar10CHAR(N' ')YesXTO_BEST Allow NULL? 
61XTO_WARNIS-M: Advance Warning Indicatorchar10CHAR(N' ')YesXTO_WARN Allow NULL? 
62XTO_HINWIS-M: Generate end note indicatorchar10CHAR(N' ')YesXTO_HINW Allow NULL? 
63XRABSPERRIS-M: Block higher-level discounts indicatorchar10CHAR(N' ')YesXRABSPERR Allow NULL? 
64XBEST_FINDIS-M: Indicator: Do Not Determine BU Distancechar10CHAR(N' ')YesXBEST_FIND Allow NULL? 
65XFIND_HINWIS-M: Output Note with Contract Determinationchar10CHAR(N' ')YesXFIND_HINW Allow NULL? 
66XF_HINW_GEIS-M: Control Barter Deal not Found Notechar10CHAR(N' ')YesXF_HINW_GE Allow NULL? 
67KONFL_STEUIS-M: Display Original Assignments in Orderchar10CHAR(N' ')YesKONFL_STEU Allow NULL? 
68ZLSCHAIS-M: Payment Method for Contract Settlementchar10CHAR(N' ')YesT042ZJHZLSCHA Allow NULL? 
69ZLSCHBIS-M/AM: Payment Method for Customer Bonus Settlementchar10CHAR(N' ')YesT042ZJHZLSCHB Allow NULL? 
70PARGRIS-M: Partner Determination Procedurenvarchar40CHAR(N' ')NoJHVTJJ25_FKEYJHPARGR Allow NULL? 
71FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40CHAR(N' ')NoJHV05FKART_PAM Allow NULL? 
72FAKSAIS-M: Billing Blocknvarchar20CHAR(N' ')YesTVFSPAM_FAKSP Allow NULL? 
73FAKSP_BIS-M: Billing Block Indicator for Trivial Amountsnvarchar20CHAR(N' ')YesTVFSFAKSP_B Allow NULL? 
74FAKSP_GIS-M: Billing Block for Credit Memosnvarchar20CHAR(N' ')YesTVFSFAKSP_G Allow NULL? 
75FAKSP_LIS-M: Billing Block for Debit Memosnvarchar20CHAR(N' ')YesTVFSFAKSP_L Allow NULL? 
76TAGE_SPBlocking Period between Contract Settlement and Billingnvarchar30NUMC(N'000')YesTAGE_SP Allow NULL? 
77BEZKD_DTIContract Evaluation Details for Cond.Reference: Advertisernvarchar20CHAR(N' ')YesTJJ83BEZDK_DTI Allow NULL? 
78XST_AVMACTIS-M: Control Order Update from Contractchar10NUMC(N'0')YesXST_AVMACT Allow NULL? 
79XNOVABRIS-M: Contract Settlement Billing not Rel.to Commission Ind.char10CHAR(N' ')YesJHXNOVABR Allow NULL? 
80XERRABSUBLIS-M: Error Handling for Contract Overlapnvarchar20CHAR(N' ')YesJHERRABSUL Allow NULL? 
81QUASI_VERHIS-M: Prevent Conflicts for System Contractschar10NUMC(N'0')YesJHQU_VERH Allow NULL? 
82KOQSI_VERHIS-M: Control Prevention of Group Contract Creationchar10NUMC(N'0')YesJHKQ_VERH Allow NULL? 
83ABS_TYP_SIIS-M/AM: Contract Categorychar10CHAR(N' ')YesTJH11ABS_TYP Allow NULL? 
84EINH1_SIIS-M: Contract Units of Measurementnvarchar30UNIT(N' ')YesT006AB_MEINH1 Allow NULL? 
85EINH2_SIIS-M/AM: Contract Units of Measurementnvarchar30UNIT(N' ')YesT006AB_MEINH2 Allow NULL? 
86XERN_BESTIS-M: Indicator Automatic Confirmation of Renewed Contractschar10CHAR(N' ')YesJHERN_BEST Allow NULL? 
87XERN_LEERIS-M: Indicator Contract without Assignments to be Renewedchar10CHAR(N' ')YesJHERN_LEER Allow NULL? 
88XARCH_OEABRIS-M: Ind: Contracts W/O Final Settlement Are Archivablechar10CHAR(N' ')YesISM_XARCH_OEABR Allow NULL? 
89XWOENQIS-M: Indicator for Contract Determination Without Blockchar10CHAR(N' ')NoISM_COAWOENQ Allow NULL? 
90KOZGFAccess Sequence for Partner Selection in Contract Determ.nvarchar40CHAR(N' ')NoTJJV3JHZUO_KOZGF Allow NULL? 
91KONFLIS-M: Conflict Controlnvarchar40CHAR(N' ')NoTJJV7JH_KONFL Allow NULL? 
92XNO_CHDKIS-M: Do Not Generate Change Documentschar10CHAR(N' ')NoXNO_CHDK Allow NULL? 
93XFAKTPRZUOIS-M: Assign Billed Orders to Price Contractschar10CHAR(N' ')NoISM_XFAKT_PRZUO Allow NULL? 
94XSBC_OVL_CHKIS-M: Perform Overlap Check for Scale Basis Contractschar10CHAR(N' ')NoISM_SBC_OVL_CHK Allow NULL? 
NamePrimaryUniqueTypeColumns
TJHVA~0YesYesCLUSTEREDMANDT, VKORG, VTWEG, SPART

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