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

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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

72 columns | Print definition?ERP 6.0  | PERCENT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECF_PCFRBD ECF - Provision Cash Flow10PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
2/IBS/TRB_ECF_VCFRBD ECF - Value Adjustment - Cash Flow10PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
3/IBS/TRB_ECH_PCFRBD ECF - Provision History - Cash Flow11PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
4/IBS/TRB_ECH_VCFRBD ECF - Value Adjustment History - Cash Flow11PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
5/OPT/AT_APPR_HISApproval History for Level Based Approvals71PERCENTLine percentagedecimal52
6/OPT/AT_LBA_LOGApproval History for Level Based Approvals72PERCENTLine percentagedecimal52
7BBP_PDDEPDB Structure for Factor and Distribution Set12PERCENTPercentage Ratedecimal52
8CNVA_CCD_ANA_RESResult table for CC deletion downtime Analysis10PERCENTPercentage of Total Objects Eligible for Deletiondecimal52
9CNV_20551_PERCDetermine percentage of data to be deleted9PERCENTPercentage of table content that is relevant for deletionnvarchar30
10CNV_20551_STATStatistics10PERCENTPercentage of deleted table recordsnvarchar30
11J_3RSPOD_WARNWaring status for passport of deal4PERCENTAllowed Amount of Deal Passport in Percentnvarchar30
12TFKBOL_BANKID2Boleto: Bank ID Determination Customizing II-payment method6PERCENTPercentage to be assigned to bankdecimal62
13VIYCCOST2MTCMajor Tenant deduction for lease in CAM recovery9PERCENTPercentagedecimal92
14VIYCMAJTENANTMajor Tenant Parameters11PERCENTPercentagedecimal92
TOPAccrual Engine
15TACEDS_OP_PERCPercentages for Derived Accrual Types (Operator "P")4PERCENTPercentage for Derived Accrual Type (Operator "P")decimal83
TOPAMI Event Management
16TEAMI_EM_EVTATTRIS-U Event Management Attributes for AMI Events18PERCENTEvent Attribute Percentdecimal166
TOPAsset Accounting
17J_1GAMAFATax free reductions4PERCENT% Aforologito apothematikodecimal52
TOPBasic Functions
18T852GSubgroup companies6PERCENTGroup sharedecimal74
19T852USubgroup companies7PERCENTGroup sharedecimal74
TOPBudgeting
20BUCC_RULE_OPDConsistency Checks - Operands10PERCENTKey Figures - Scaling Factor for Key Figuredecimal52
TOPClaims Management
21ICLPOLSSums Insured and Calculations in Policy Snapshot23PERCENTReference Sum Insured in Percentdecimal52
22ICL_PRIVILEGESpecial Rights (Benefit/3rd Party Rights) in Benefit Split12PERCENTShare (Percentage) of Special Rightsdecimal52
23ICL_WCMPDFS-CM: Item Data Workers Compensation15PERCENTPercentage of Wage Paid as Benefitdecimal107
24ICSPOLSSums Insured and Calculations in Policy Snapshot23PERCENTReference Sum Insured in Percentdecimal52
25ICS_PRIVILEGESpecial Rights (Shadow Table)12PERCENTShare (Percentage) of Special Rightsdecimal52
26ICS_WCMPDFS-CM: Item Data Workers Compensation15PERCENTPercentage of Wage Paid as Benefitdecimal107
27TICL083Internal Claim Type: Limit and Deductible18PERCENTPercentage of Reference Limit/Reference Deductibledecimal52
28TICL163Benefit Type Tree: Limit and Deductible18PERCENTPercentage of Reference Limit/Reference Deductibledecimal52
29TICL167Benefit Type Tree: Sum Insured and Calculation Rules16PERCENTReference Sum Insured in Percentdecimal52
TOPCross-Application Components
30CACNS_PM_PROJEasyProjectMarket24PERCENTProject Market: Percenttinyint30
31ETP_TASKSEasy Task Planning: Tasks16PERCENT2 byte integer (signed)smallint50
TOPData Mining
32RSDMESC_ABC_CUMCumulated Distribution for ABC Analysis10PERCENTPercentage Value (ABC)decimal63
33RSDMTC_DISTRIBUTDistribution of Attribute Values among a Cluster8PERCENTPercentage in Distributiondecimal52
TOPDownloadUpload
34/DSD/HH_RADELCDDSD Route Settlement: Delivery Execution Conditions11PERCENTPercentdecimal74
35/DSD/HH_RADELCNDDSD Route Settlement: Delivery Execution Conditions12PERCENTPercentdecimal74
TOPFinland
36T7FIT0Trade Unions Finland5PERCENTNumberdecimal72
37T7FITUTrade Unions / Locals Finland6PERCENTNumberdecimal72
TOPGlobal Trade Services
38/SAPSLL/PREGPPROGTS: Preference: Procedure Groups (Data Provider Upload)13PERCENTPreference: Percentagedecimal52
39/SAPSLL/PRFPMRPSLL: Preference: Log: product: Result of BOM Calc - Proc.20PERCENTPreference: Percentagedecimal52
40/SAPSLL/PSVGPPROGTS: Preference: Procedure Groups (Manual Entry)13PERCENTPreference: Percentagedecimal52
TOPIncentive and Commission Management ICM
41CACS_RETAGRIndividual Retention Agreement in Commission Contract8PERCENTPercentage of Retentiondecimal83
42TCACS_STRETRUCharacteristic Attributes of Retention Rule8PERCENTPercentage of Retentiondecimal83
TOPJoint Venture und Production Sharing Accounting
43T8JHLConfiguration for JV AM/MM Transfers11PERCENTPercentage to apply to amount in JV Postingnvarchar30
44T8JJAJV Load Balancing5PERCENTPercentage of volume used for determining JOB sizenvarchar30
TOPliveCache Applications
45/SAPAPO/OMPRORECTable for holding profiling sessions19PERCENTProfiled percentual execution timedecimal83
46LCA_PRORECProfiling-Sessions ext19PERCENTPercentdecimal80
TOPLocalization
47J_3RTSESecondary index table for VAT14PERCENTPercentdecimal132
48TIVXCFRSBAObsolete - To be deleted!!!14PERCENTChange to Index Series Since Last Adjustment in Percentdecimal74
49TIVXCPTRAPARAMcustomizing parameters for the Rent adjustment5PERCENTPercentage of Rent Adjustmentdecimal96
TOPLogistics Basic Data
50WCMPSTWCMPS5PERCENTPercentagenvarchar30
TOPMessages
51DNOD_NOTIF_TANotification: Data for Task Planning19PERCENT2 byte integer (signed)smallint50
TOPOLAP Technology
52RSDDTREXCHECK_KSettings for 'K' Check3PERCENTNatural Numberint100
53RSDDTREXCHECK_QSettings for 'Q' Check3PERCENTint100
TOPPayments
54TFKBOL_BANKIDBoleto: Bank ID Determination Customizing5PERCENTPercentage to be assigned to bankdecimal62
TOPPayroll General Parts
55T51AV_2PAssignment of Partial Period Parameters to Average Bases7PERCENTPercentage for average basesdecimal72
TOPReport Selection for Product Costing
56TKKBJRule basis keys for exception rules2PERCENTFlag for percentage threshold value (X = allowed)nvarchar10
TOPRoyalty Reporting
57OIUREP_MASTER_OVRegID Split table (e.g. MMS Override Group split)4PERCENTReg. ID split percentagedecimal52
58OIUREP_MASTER_PCRegID Split table (e.g. LA Parish split)4PERCENTReg. ID split percentagedecimal52
TOPSales-Based Rent and Settlement
59VISRTMMSBSBAssignment of a Sales Rule to a Peak Sales Rule9PERCENTPercentage of Sales-Based Rent Used in Calculationdecimal96
TOPTariffs, Duties and Permits
60OIH_J1B_INCBrazil: Incoming taxation table16PERCENTPercentage of backward sub.trib. collecteddecimal62
TOPTransaction Manager
61IDCFMBRSETX_HSTHistory table for taxation8PERCENTPercentage Rate to Determine Derived Amountdecimal107
62IDCFMSETX_RATETax rates for tax reports TRM Brazil5PERCENTPercentage Rate to Determine Derived Amountdecimal107
TOPTravel Planning
63FTPT_REQ_ACCOUNTTravel Request Cost Assignment7PERCENTPercentage of Cost Distributiondecimal52
TOPTreasury
64JBDRATEBARDeviation range of ref. int. rates depend. on exact time3PERCENTPercentage of deviation ref. int. rates dep. on exact timetinyint30
TOPUSA
65BRCDTABSI-TAX 4.0 BRCDTA22PERCENTBSI40: PERCENTnvarchar240
66BRCGDTABSI-TAX 4.0 BRCGDTA22PERCENTBSI40: PERCENTnvarchar240
TOPValue Adjustment
67/IBS/TRB_SHEETRBD IAS - Value Adjustment Cash Flow Positions9PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
68/IBS/TRB_SHEET_RRBD IAS - Provision Cash Flow Positions8PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
69/IBS/TRB_SHISTRBD IAS - History Value Adjustment Cash Flow Positions10PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
70/IBS/TRB_SHIST_RRBD IAS - History Provision Cash Flow Positions9PERCENTRBD: Percentage Expectation Used for Cash Flowdecimal52
TOPWaste Management
71EHSWAT_ENACCDisposal Processing: Account Assignments for Entry Document14PERCENTPercentage Proportion of Waste Quantity for Acct Assgnt Itemdecimal31
72EHSWAT_MNACCAccount Assignments for Disposal Document14PERCENTPercentage Proportion of Waste Quantity for Acct Assgnt Itemdecimal31