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  | T8JZ
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
Cross-Application Components :: Joint Venture und Production Sharing Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T8JZ791JV Global Company ParametersJoint Venture und Production Sharing Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, ITD, NETACCOPT, INT_US, OPACCNUMB, BILLBASIS, CORPVENT, CORPEQGP, CORPRECIND, CORPVBACRI, BALANCVENT, FRYEAR, FRPERIOD, TOYEAR, TOPERIOD, VBANK, TAXIN, INVLEVEL, TAXOUT, TXJCD, CRPTAXCODE, BSTRUCT, STPAY, XSETCON, XSETCAT, XPER1, XPER2, XSETCAP, NONCOMP, COMPULS, OFFCC, EXPAND, TAXEXPDTL, TAXPER, EQGNUM, POMACT, GSTNO, AFABE_HAN, AFABE_NB, AFABE_BI, CRPCAL, AM_METH, WBIND, SELTAB, SELFLD, CBYEAR, CBPERI, KURST, OFFPCOCC, OFFPCOPROJ, OFFPCOORNR, POSTCORP, ASSTVENT, CI_GROSS, CI_FB01, CB_TCURR, FSJVCT, FSJVOT, FSJVPT, BUDGETMESS, VIDIST, OP_AS_PART, KOSTL_CORP, AM_CORP_RI, BANK_RI_SW, BCURR, XVBA, XASST_CO, BILLTHRES, BILLTHRESC, TVARCURR, TVAROLD, SPLIT_BY_LI, EC_USE, BILLTHRESS, PM_ACT, PM_EG, PM_ACT_YEAR FROM T8JZ
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3ITDInception to datechar10CHAR(N' ')YesJV_ITD2 Allow NULL? 
4NETACCOPTJV Net Account optionchar10CHAR(N' ')YesJV_NET Allow NULL? 
5INT_USJoint Venture Regionchar10CHAR(N' ')YesJV_INTER Allow NULL? 
6OPACCNUMBOperatornvarchar100CHAR(N' ')YesKNB1JV_OPER Allow NULL? 
7BILLBASISBilling Basischar10NUMC(N'0')YesJV_BBASIS Allow NULL? 
8CORPVENTJoint Venturenvarchar60CHAR(N' ')YesT8JVJV_NAME Allow NULL? 
9CORPEQGPEquity groupnvarchar30CHAR(N' ')YesT8JFJV_EGROUP Allow NULL? 
10CORPRECINDCorporate Recovery Indicator (corporately funded)nvarchar20CHAR(N' ')YesT8JJJV_CORPRI1 Allow NULL? 
11CORPVBACRICorporate Recovery Indicator (Venture Funded)nvarchar20CHAR(N' ')YesT8JJJV_CORPRI2 Allow NULL? 
12BALANCVENTJV Balanced Venture Flagchar10CHAR(N' ')YesJV_BAL Allow NULL? 
13FRYEARJoint Venture year for first period allowednvarchar40NUMC(N'0000')YesJV_FRYEAR Allow NULL? 
14FRPERIODfirst JV period allowednvarchar30NUMC(N'000')YesJV_FRPER Allow NULL? 
15TOYEARJV year for last period allowednvarchar40NUMC(N'0000')YesJV_TOYEAR Allow NULL? 
16TOPERIODLast JV period allowednvarchar30NUMC(N'000')YesJV_TOPER Allow NULL? 
17VBANKVenture Bank Accountschar10CHAR(N' ')YesJV_BANK Allow NULL? 
18TAXINInput Tax Code (Usually used when posting expense)nvarchar20CHAR(N' ')YesT007AJV_TAXIN Allow NULL? 
19INVLEVELJoint Venture Invoice Levelchar10CHAR(N' ')YesJV_INVLVL Allow NULL? 
20TAXOUTOutput Tax Code (Usually used when posting revenue)nvarchar20CHAR(N' ')YesT007AJV_TAXOUT Allow NULL? 
21TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
22CRPTAXCODECRP Tax Codenvarchar20CHAR(N' ')YesT007AJV_TAXCRP Allow NULL? 
23BSTRUCTJV Billing Structurenvarchar40CHAR(N' ')YesT8JSJV_BILLSTR Allow NULL? 
24STPAYStandard (internal) % to apply for payroll burden clearingdecimal52DEC((0))YesJV_STPAY
25XSETCONSet of Accounts to Exclude from Construction Overhead Calc.nvarchar240CHAR(N' ')YesJV_XSETCON Allow NULL? 
26XSETCATSet of Accounts to Exclude from Catastrophe Overhead Calc.nvarchar240CHAR(N' ')YesJV_XSETCAT Allow NULL? 
27XPER1Exclusion Set of Accounts - Percent 1 (JVA)nvarchar240CHAR(N' ')YesJV_XPER1 Allow NULL? 
28XPER2Exclusion Set of Accounts - Percent 2 (JVA)nvarchar240CHAR(N' ')YesJV_XPER2 Allow NULL? 
29XSETCAPSet of Accounts to Exclude from Capital Overhead Calc.nvarchar240CHAR(N' ')YesJV_XSETCAP Allow NULL? 
30NONCOMPNon-compulsory benefits rate for payroll burden clearingdecimal52DEC((0))YesJV_NONCOMP
31COMPULSCompulsory benefits rate for Canadian payroll burdendecimal52DEC((0))YesJV_COMPULS
32OFFCCCorporate Offset Cost Centrenvarchar100CHAR(N' ')YesCSKSJV_OFFCC2 Allow NULL? 
33EXPANDStore lines in JV single item ledger not compressedchar10CHAR(N' ')YesJV_EXPAND Allow NULL? 
34TAXEXPDTLFlag for tax being reported on expenditure detailchar10CHAR(N' ')YesJV_TAXEXP Allow NULL? 
35TAXPERPost Tax in Next Periodchar10CHAR(N' ')YesJV_TAXPER Allow NULL? 
36EQGNUMMaximum Number of Active Equity Groups per Vent./Equity Typenvarchar20NUMC(N'00')YesJV_EQGNUM Allow NULL? 
37POMACTProcessing Operational Month and Billing Month activechar10CHAR(N' ')YesJV_POMACT Allow NULL? 
38GSTNOGST registration numbernvarchar200CHAR(N' ')YesJV_GSTNO Allow NULL? 
39AFABE_HANDepreciation Area for Book Depreciationnvarchar20NUMC(N'00')YesT093AFABE_HAN Allow NULL? 
40AFABE_NBDepreciation Area for non billable Cost (Gross)nvarchar20NUMC(N'00')YesT093AFABE_NB Allow NULL? 
41AFABE_BIDepreciation Area for Gross billable costnvarchar20NUMC(N'00')YesT093AFABE_BI Allow NULL? 
42CRPCALFlag CRP Calculation: Yes or NOchar10CHAR(N' ')YesJV_CRPCAL Allow NULL? 
43AM_METHMethod for AM/MM Postingschar10CHAR(N' ')YesJV_AMMETH Allow NULL? 
44WBINDIndex series to for calculation of estimated book cost (EBC)nvarchar50CHAR(N' ')YesT094AJV_WBIND Allow NULL? 
45SELTABTable for additional selection fieldnvarchar300CHAR(N' ')YesDD02LJV_TABNAME Allow NULL? 
46SELFLDField for additional selection in CRP transfersnvarchar300CHAR(N' ')YesDD03LJV_FIELDNAME Allow NULL? 
47CBYEARJV Cutback Yearnvarchar40NUMC(N'0000')YesJV_CBYEAR Allow NULL? 
48CBPERIJV Cutback Periodnvarchar30NUMC(N'000')YesJV_CBPERI Allow NULL? 
49KURSTJV exchange rate typenvarchar40CHAR(N' ')YesTCURVJV_KURST Allow NULL? 
50OFFPCOCCCorporate PCO Cost Centrenvarchar100CHAR(N' ')NoCSKSJV_OFFPCCC Allow NULL? 
51OFFPCOPROJCorporate PCO Projectnvarchar80NUMC(N'00000000')YesPRPSJV_OFFPCPJ Allow NULL? 
52OFFPCOORNRCoporate PCO Ordernvarchar120CHAR(N' ')YesAUFKJV_OFFPCOD Allow NULL? 
53POSTCORPPost also doc. with corporate venture/equity group only_char10CHAR(N' ')YesJV_POSTCR1 Allow NULL? 
54ASSTVENTVenture derivation from Assetchar10CHAR(N' ')YesJV_ASSTVNT Allow NULL? 
55CI_GROSSGross postings to CI Partnerchar10CHAR(N' ')YesJV_CI_GRO Allow NULL? 
56CI_FB01CI Posting in FB01char10CHAR(N' ')YesJV_CI_FB01 Allow NULL? 
57CB_TCURRJV Cutback in transaction currencychar10CHAR(N' ')YesJV_CU_TCUR Allow NULL? 
58FSJVCTField status JV Cost Center Typechar10CHAR(N' ')YesJV_FSJVCT Allow NULL? 
59FSJVOTField status JV Internal Order Typechar10CHAR(N' ')YesJV_FSJVOT Allow NULL? 
60FSJVPTField status JV project typechar10CHAR(N' ')YesJV_FSJVPT Allow NULL? 
61BUDGETMESSIndicator: Message for impact on budget for JV Asset Xferschar10CHAR(N' ')YesJV_MESSBDG Allow NULL? 
62VIDISTVenture info distribution from Asset lineschar10CHAR(N' ')YesJV_VIDIST Allow NULL? 
63OP_AS_PARTFlag: Operator as partnerchar10CHAR(N' ')YesJV_FL_PART Allow NULL? 
64KOSTL_CORPCorporate cost center for JVnvarchar100CHAR(N' ')YesCSKSJV_KOSTLCP Allow NULL? 
65AM_CORP_RICoporate Recovery Indicator for AM Postingsnvarchar20CHAR(N' ')YesT8JJJV_CORPRI3 Allow NULL? 
66BANK_RI_SWRecovery Indicator switch for bank lines in non-clearing tr.char10CHAR(N' ')YesJV_BANK_RI Allow NULL? 
67BCURRJV Default Billing Currencynvarchar20CHAR(N' ')YesJV_BCURR Allow NULL? 
68XVBAVenture Bank Account Switching is usedchar10CHAR(N' ')YesJV_XVBA Allow NULL? 
69XASST_CONo CO object on asset lineschar10CHAR(N' ')YesJV_ASSTCO Allow NULL? 
70BILLTHRESBilling threshold (debit)decimal132CURR((0))YesJV_BILL_THRESH
71BILLTHRESCBilling threshold (credit)decimal132CURR((0))YesJV_BILL_THRESH_C
72TVARCURRTransfer variant for intercompany asset transfersnvarchar40CHAR(N' ')YesTA1TVTRANSVAR Allow NULL? 
73TVAROLDTransfer variant for intercompany asset transfersnvarchar40CHAR(N' ')YesTA1TVTRANSVAR Allow NULL? 
74SPLIT_BY_LISplit by line itemchar10CHAR(N' ')YesJV_SPLIT_BY_LI Allow NULL? 
75EC_USECA-JVA-PRC Active in Company Codechar10CHAR(N' ')Yes/SAPPCE/JVA_EC_USAGE Allow NULL? 
76BILLTHRESSPrepare separate reports for suppressed periodschar10CHAR(N' ')YesJV_BILL_THRESH_SEP Allow NULL? 
77PM_ACTJoint Venture Production month processing activechar10CHAR(N' ')YesJV_PM_ACTIVE Allow NULL? 
78PM_EGDerive Equity Group from Production Monthchar10CHAR(N' ')YesJV_PM_EG Allow NULL? 
79PM_ACT_YEARNumber of years Production month information is availablenvarchar20NUMC(N'00')YesJV_PM_ACT_YEAR Allow NULL? 
NamePrimaryUniqueTypeColumns
T8JZ~0YesYesCLUSTEREDBUKRS, MANDT

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