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

79 columns | Print definition?ERP 6.0  | PLTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____0124SID-Tabelle fuer Price List3PLTYPPrice list typenvarchar20
2A006Price List Type/Currency/Material6PLTYPPrice list typenvarchar20
TOPAdvertising Management
3JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset88PLTYPPrice list typenvarchar20
4JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order44PLTYPPrice list typenvarchar20
5JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header89PLTYPPrice list typenvarchar20
TOPAssortment List
6WBBHAssortment list header27PLTYPPrice list typenvarchar20
7WBB_SAVE2Temporary Assortment List Objects: Store-Specific23PLTYPPrice list typenvarchar20
TOPBasic Data
8TN121IS-H: Assign Person to Position6PLTYPIS-H: Type of Responsibility for a Positionnvarchar10
9TN124IS-H: Position5PLTYPIS-H: Type of Responsibility for a Positionnvarchar10
10TN128IS-H: Assignment Position/Org. Unit/Institution7PLTYPIS-H: Type of Responsibility for a Positionnvarchar10
TOPBenefits
11PA0167HR Master Record: Infotype 0167 (Health Plans)25PLTYPBenefit plan typenvarchar40
12PA0168HR Master Record: Infotype 0168 (Insurance Plans)25PLTYPBenefit plan typenvarchar40
13PA0169HR Master Record: Infotype 0169 (Savings Plan)25PLTYPBenefit plan typenvarchar40
14PA0170HR Master Record: Infotype 0170 (Flexible Spending Accounts)25PLTYPBenefit plan typenvarchar40
15PA0172HR Master Record: Infotype 0172 (FSA Claims)25PLTYPBenefit plan typenvarchar40
16PA0212HR Master Record: Infotpye 0212 (COBRA Health Plan)25PLTYPBenefit plan typenvarchar40
17PA0236HR Master Record: Infotype 0236 (Credit Plans)25PLTYPBenefit plan typenvarchar40
18PA0377HR Master Record: Infotype 0377 (Miscellaneous Plans)25PLTYPBenefit plan typenvarchar40
19PA0379HR Master Record: Infotype 0379 (Stock Purchase Plans)25PLTYPBenefit plan typenvarchar40
20PA0671HR Master Record - Infotype 0671 (COBRA Flex. Spending Acct)25PLTYPBenefit plan typenvarchar40
21T5UB1Benefit plan type3PLTYPBenefit plan typenvarchar40
22T5UB6Benefit Standard Health Selection5PLTYPBenefit plan typenvarchar40
23T5UB7Benefit standard insurance selection5PLTYPBenefit plan typenvarchar40
24T5UBABenefit plan6PLTYPBenefit plan typenvarchar40
25T5UC1Benefit plan type texts4PLTYPBenefit plan typenvarchar40
26T74AACOBRA-qualified dependent/plan type assignment4PLTYPBenefit plan typenvarchar40
27T74FMBenefit Standard Savings Selection5PLTYPBenefit plan typenvarchar40
28T74FNBenefit Standard Spending Account Selection5PLTYPBenefit plan typenvarchar40
29T74FOBenefit standard credit selection5PLTYPBenefit plan typenvarchar40
30T74FPBenefit Standard Miscellaneous Selection5PLTYPBenefit plan typenvarchar40
31T74FQBenefit standard stock purchase selection5PLTYPBenefit plan typenvarchar40
32T74HBBenefit adjustment authorization5PLTYPBenefit plan typenvarchar40
TOPBilling
33A144Sales Deal Basic Data14PLTYPPrice list typenvarchar20
34A149Customer-dependent data determination11PLTYPPrice list typenvarchar20
35VBRKBilling Document: Header Data19PLTYPPrice list typenvarchar20
TOPConditions
36A106Price List/Material Group6PLTYPPrice list typenvarchar20
37A306Price list category/currency/material with release status6PLTYPPrice list typenvarchar20
TOPConstruction Equipment Management
38J_3GPRLISTCEM Price List Data3PLTYPPrice list typenvarchar20
TOPCross-Application Components
39VVBKDSales Document: Business Data7PLTYPPrice list typenvarchar20
TOPCustomer Master
40KNVVCustomer Master Sales Data16PLTYPPrice list typenvarchar20
TOPDistributor-Reseller-Management
41KOTW001Matl grp 2/Matl grp 3/Price list6PLTYPPrice list typenvarchar20
TOPFree Goods
42KOTN202SalesOrg./SalesChan/PriceList/BonusBuy/Material/SalesUnit6PLTYPPrice list typenvarchar20
TOPGeneral Parts
43T74_FBN00Flexible Benefits Plan Type Attribute3PLTYPBenefit plan typenvarchar40
TOPJapan
44T5J98HR Conversion IT0144 to IT0169 JP6PLTYPBenefit plan typenvarchar40
TOPMarketing, Accounting and Pricing
45OICPLCustomer price list2PLTYPPrice list typenvarchar20
TOPMaterial Maintenance
46T189Conditions: Price List Categories2PLTYPPrice list typenvarchar20
47T189TConditions: Price List Categories: Texts3PLTYPPrice list typenvarchar20
TOPNetherlands
48P05FBN_PLTYP_EIGCharacteristics of Plan Type3PLTYPBenefit plan typenvarchar40
TOPPatient Accounting
49NVBRKIS-H: Billing document header data13PLTYPPrice list typenvarchar20
TOPPeriodical Sales and Distribution
50JFRKIS-M/SD: Billing - Header Data16PLTYPPrice list typenvarchar20
51JKKDSales Order: Business Data6PLTYPPrice list typenvarchar20
TOPPrice Planning Workbench
52WRF_PPW_PPDCALCPPD Calculation Set9PLTYPPrice List Categorynvarchar20
53WRF_PPW_PPDOSITPPD Organization Set - Item6PLTYPPrice List Categorynvarchar20
54WRF_PPW_WORKLERRPPW Worklist Error Table8PLTYPPrice List Categorynvarchar20
55WRF_PPW_WORKLISTPPW Worklist8PLTYPPrice List Categorynvarchar20
TOPPromotion
56WAKHPromotion Header Data, IS-R75PLTYPPrice list type: promotion headernvarchar20
57WMFLMarkdown Planning - Price Lists5PLTYPMarkdown Planning: Price Listnvarchar20
TOPPublic sector Sweden
58T5SK0_CEKPA events7PLTYPBenefit plan typenvarchar40
59T5SK1_CEKPA absences7PLTYPBenefit plan typenvarchar40
60T5SK2_CEKPA income5PLTYPBenefit plan typenvarchar40
TOPRecycling Administration Core Functions
61J_7LE04REA Partner Master Record: Volume/Area Classes5PLTYPPrice List Item Categorynvarchar10
62J_7LP02REA Price List: Items7PLTYPPrice List Item Categorynvarchar10
63J_7LV1PREA Document: Item Data16PLTYPPrice List Item Categorynvarchar10
TOPRetail Pricing
64A154SalesOrg./Dist.Channel/PriceList/Material/SalesUnit/Customer6PLTYPPrice list typenvarchar20
65A155Sales Org./Dist. Channel/Price List/Material/Sales Unit6PLTYPPrice list typenvarchar20
66TWEGOSales Price Calculation: Assignment of price point group5PLTYPPrice list typenvarchar20
67TWKAOSales Price Calculation: Assignment of pricing type4PLTYPPrice list typenvarchar20
68WELPCompetitor: Price Entry Document (Item)10PLTYPPrice list typenvarchar20
69WKBPPricing document: item53PLTYPPrice list typenvarchar20
70WPFDOFamily Pricing: Diff. Dist. Chain-Depnd. Price Relationships6PLTYPPrice list typenvarchar20
TOPSales
71VBKDSales Document: Business Data7PLTYPPrice list typenvarchar20
TOPSimulation
72VSVBKD_CNVersion: Sales document - commercial data8PLTYPPrice list typenvarchar20
TOPSweden
73T5SPPHR-SE: Information needed to be reported to Alecta15PLTYPBenefit plan typenvarchar40
TOPTraders and Schedulers Workbench
74OIJBRDHRD header f.batch:Don't use(obsolete) & don't delete(XPRA)36PLTYPOIL-TSW: Planning typenvarchar30
75OIJLOCMATOIL-TSW: Location Rundown/Planning material table25PLTYPOIL-TSW: Planning typenvarchar30
76OIJRDHRundown header: Don't use (obsolete) & don't delete (XPRA)35PLTYPOIL-TSW: Planning typenvarchar30
77OIJTSMATOIL-TSW: TS Rundown/Planning material table24PLTYPOIL-TSW: Planning typenvarchar30
78OIJ_RDHEADStock Projection header38PLTYPOIL-TSW: Planning typenvarchar30
TOPUSA
79T5UPBSPA16Federal Health Plan Mapping (PS)3PLTYPBenefit plan typenvarchar40