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

197 tablesERP 6.0 

Sales and Distribution :: Billing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0A144161Sales Deal Basic DataBilling
2ERP EHP76.0A145111Sales Deal - Customer/MaterialBilling
3ERP EHP76.0A146151Customer HierarchyBilling
4ERP EHP76.0A147171Customer Hierarchy (Sales Deal)Billing
5ERP EHP76.0A148131Product HierarchyBilling
6ERP EHP76.0A149131Customer-dependent data determinationBilling
7ERP EHP76.0A39971Withholding tax code - country-specificBilling
8ERP EHP76.0CRMC_FM_CO_EXP41customizing table cost element to expense type for marketingBilling
9ERP EHP76.0J_1ADOCCL241Texts for official document class in ArgentinaBilling
10ERP EHP76.0J_1ADOCCLS21Official document class for ArgentinaBilling
11ERP EHP76.0J_1AOFNR351Exception table for deal type determ.(export/domestic)Billing
12ERP EHP76.0J_1ASNRDT151Branch Determination for DeliveriesBilling
13ERP EHP76.0J_1ASNRDT251Branch determination for material movementsBilling
14ERP EHP76.0J_1ATXREL21Tax relevant classificationBilling
15ERP EHP76.0J_1ATXRELT41Texts for tax relevant classificationBilling
16ERP EHP76.0J_1A_WS_BRANCH71AR:WS Branch determination(Shipping Point)Billing
17ERP EHP76.0KNVI52Customer Master Tax IndicatorBilling
18ERP EHP76.0KNVL81Customer Master LicensesBilling
19ERP EHP76.0S071201Condition UpdateBilling
20ERP EHP76.0SDFM_SF_AG_INDEX41MANDT MANDTIndex Table for Update of Statistics (Agreements)Billing
21ERP EHP76.0SDFM_SF_INDEX41Index Table for Update of StatisticsBilling
22ERP EHP76.0SDINVOICE21Worklist for SDVPRSUPDATEBilling
23ERP EHP76.0SDINVUPD121VPRS Update: Worklist for VPRS UpdateBilling
24ERP EHP76.0TVCPF251Billing: Copying ControlBilling
25ERP EHP76.0TVFKD31Billing Document: Billing Date by Number RangeBilling
26ERP EHP76.0TVFS21Billing: Reasons for BlockingBilling
27ERP EHP76.0TVFST41Billing : Blocking Reason TextsBilling
28ERP EHP76.0TVKT21Customers: Account Assignment GroupsBilling
29ERP EHP76.0TVKTT41Customers: Account Determination Groups: TextsBilling
30ERP EHP76.0VBRK1112Billing Document: Header DataBilling
31ERP EHP76.0VBRL111Sales Document: Invoice ListBilling
32ERP EHP76.0VBRP2241Billing Document: Item DataBilling
33ERP EHP76.0VRKPA171Sales Index: Bills by Partner FunctionsBilling
34ERP EHP76.0VRPMA161SD Index: Billing Items per MaterialBilling
Sales and Distribution :: Billing :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
35ERP EHP76.0TINC51Customers: IncotermsBasic Functions
36ERP EHP76.0TINCT41Customers: Incoterms: TextsBasic Functions
37ERP EHP76.0TLIC51Tax Exemption LicenseBasic Functions
38ERP EHP76.0TVCIN91Payment cards: TypeBasic Functions
39ERP EHP76.0TVCINT41Description of payment card typeBasic Functions
40ERP EHP76.0TVCLK21Block reason (payment card)Basic Functions
41ERP EHP76.0TVCLKT41Description of blocking reason (payment card)Basic Functions
42ERP EHP76.0TVCTY41Payment card categoryBasic Functions
43ERP EHP76.0TVCTYT41Category description for payment cardBasic Functions
44ERP EHP76.0TVFK851Billing: Document TypesBasic Functions
45ERP EHP76.0TVFKT41Billing: Document Types: TextsBasic Functions
46ERP EHP76.0TVNFACT91SD: Function Activation on BUKRS LevelBasic Functions
47ERP EHP76.0TVNFACTC31SD: Function Activation on CLIENT LevelBasic Functions
48ERP EHP76.0TVRRUR61Revenue Recognition: Account Det.'Unbilled Receiv./Costs'Basic Functions
49ERP EHP76.0TVVIEWP101SD: Function Activation LogBasic Functions
Sales and Distribution :: Billing :: Empties Management
ProductVersionTableColumnsIndexesDescriptionModule
50ERP EHP76.0/BEV1/EM0LGMTX251Customizing - Empties CalculationEmpties Management
51ERP EHP76.0/BEV1/EMDRKKZ81Item Categories That Are Not PrintedEmpties Management
52ERP EHP76.0/BEV1/EMFAKTA21Billing Types Without Empties UpdateEmpties Management
53ERP EHP76.0/BEV1/EMGRP51Empties GroupEmpties Management
54ERP EHP76.0/BEV1/EMGRPT41Text Table for Empties GroupsEmpties Management
55ERP EHP76.0/BEV1/EMLEER41Reference Table for Empties Update in SIS Table S999Empties Management
56ERP EHP76.0/BEV1/EMLGBSD482Customer Empties Stock per MonthEmpties Management
57ERP EHP76.0/BEV1/EMLGBWDK51Customer Empties Movement - Lock ObjectEmpties Management
58ERP EHP76.0/BEV1/EMLGBWDP835Empties Movement Account CustomerEmpties Management
59ERP EHP76.0/BEV1/EMLGFAD562Empties Movement - Customer Billing StatusEmpties Management
60ERP EHP76.0/BEV1/EMLGFLD31Empties FieldsEmpties Management
61ERP EHP76.0/BEV1/EMLGFLDT41Text Table for Empties FieldEmpties Management
62ERP EHP76.0/BEV1/EMLGFSPR61Empties Update LogEmpties Management
63ERP EHP76.0/BEV1/EMLGKTO521Empties AccountEmpties Management
64ERP EHP76.0/BEV1/EMLGMAT21Empties MaterialsEmpties Management
65ERP EHP76.0/BEV1/EMLGOFS142Empties - Billing Document Without UpdateEmpties Management
66ERP EHP76.0/BEV1/EMMATRIX221Empties: Calculation MatrixEmpties Management
67ERP EHP76.0/BEV1/EMMATRIXT41Description for FormulasEmpties Management
68ERP EHP76.0/BEV1/EMMTART21Material Types That Determine EmptiesEmpties Management
69ERP EHP76.0/BEV1/EMPART121Partner Function for Processing EmptiesEmpties Management
70ERP EHP76.0/BEV1/EMPPBWART31BWART for Tied Empties in PP ConfirmationEmpties Management
71ERP EHP76.0/BEV1/EMPTYP41Empties: Item CategoriesEmpties Management
72ERP EHP76.0/BEV1/EMVISF61Empties Customizing Selection for SIS fieldsEmpties Management
Sales and Distribution :: Billing :: Revenue recognition
ProductVersionTableColumnsIndexesDescriptionModule
73ERP EHP76.0VBREVAC151Revenue Recognition: Compression of FI Revenue PostingsRevenue recognition
74ERP EHP76.0VBREVC71Revenue Recognition: Worklist of Changed Sales DocumentsRevenue recognition
75ERP EHP76.0VBREVE452Revenue Recognition: Revenue Recognition LinesRevenue recognition
76ERP EHP76.0VBREVK321Revenue Recognition: Control LinesRevenue recognition
77ERP EHP76.0VBREVR221Revenue Recognition: Reference Document LinesRevenue recognition
Sales and Distribution :: Billing :: Processing Billing Documents :: Complaints Processing
ProductVersionTableColumnsIndexesDescriptionModule
78ERP EHP76.0CMP_KSCHL51Condition Type for Complaints ProcessingComplaints Processing
79ERP EHP76.0CMP_KSCHL_TXT41Condition Types: TextsComplaints Processing
80ERP EHP76.0CMP_MAPKSCHL_TXT41Texts for Mapping Condition ID <-> Condition TypeComplaints Processing
81ERP EHP76.0CMP_MAPMASSKSCHL31Mapping Condition ID <-> Condition TypeComplaints Processing
82ERP EHP76.0CMP_POSTYP31Item Category Customizing Complaints Proc. Credit Memo ItemComplaints Processing
83ERP EHP76.0CMP_PROF31Billing Type for Creating a Pro Forma Billing DocumentComplaints Processing
84ERP EHP76.0CMP_REASON151Customizing for Complaints ReasonsComplaints Processing
85ERP EHP76.0CMP_REASON_TXT41Complaints Reasons: TextsComplaints Processing
86ERP EHP76.0CMP_VBFS_EXT201Status Messages from Mass Complaints ProcessingComplaints Processing
Sales and Distribution :: Billing :: Processing Billing Documents :: Expense-Related Billing
ProductVersionTableColumnsIndexesDescriptionModule
87ERP EHP76.0PRSC_CAT61Engagement mgmt: CategoriesExpense-Related Billing
88ERP EHP76.0PRSC_CATDETMAT51Engagement mgmt: Determine Materials for CategoriesExpense-Related Billing
89ERP EHP76.0PRSC_CATUOM31Engagement mgmt: Unit of Measures for CategoriesExpense-Related Billing
90ERP EHP76.0PRSC_CAT_T41Engagement mgmt: Categories Text tableExpense-Related Billing
91ERP EHP76.0PRSC_CHAR81Engagement mgmt: CharacteristicsExpense-Related Billing
92ERP EHP76.0PRSC_CTRL81Engagement mgmt: Process ControlExpense-Related Billing
93ERP EHP76.0PRSC_MATDETCAT51Engagement mgmt: Determine Categories for MaterialsExpense-Related Billing
94ERP EHP76.0PRSC_METCOL31Engagement mgmt: Metrics ColumnsExpense-Related Billing
95ERP EHP76.0PRSC_METCOL_T41Engagement mgmt: Metrics Column TextsExpense-Related Billing
96ERP EHP76.0PRSC_METMAP71Engagement mgmt: Metrics MappingExpense-Related Billing
97ERP EHP76.0PRSC_METROW31Engagement mgmt: Metrics RowExpense-Related Billing
98ERP EHP76.0PRSC_METROW_T41Engagement mgmt: Metrics Row TextsExpense-Related Billing
99ERP EHP76.0PRSC_SCRVAL51Engagement mgmt: Sceen ValuesExpense-Related Billing
100ERP EHP76.0PRSC_SCRVAL_T81Engagement mgmt: Sceen Values TextsExpense-Related Billing
101ERP EHP76.0PRSC_USAGE21Engagement mgmt: UsageExpense-Related Billing
102ERP EHP76.0PRSC_USAGE_T41Engagement mgmt: Usage TextExpense-Related Billing
103ERP EHP76.0PRSD_CO_MAPPING41EM: Mapping original DMR lines to Carry Over linesExpense-Related Billing
104ERP EHP76.0PRSD_DLIEF_EXT151DLI Document Flow ExtensionExpense-Related Billing
105ERP EHP76.0PRSD_DMRP_ACC_CH421Engagement Mgmt: Accrual Characteristics for DMR LinesExpense-Related Billing
106ERP EHP76.0PRSD_DMRP_EXT251Extended DMR Line InformationExpense-Related Billing
107ERP EHP76.0PRSD_GRP61Grouping, Sorting values for DLIExpense-Related Billing
108ERP EHP76.0PRSD_VBAK_EXT31Engagement mgmt: Extended DMR Head InformationExpense-Related Billing
Sales and Distribution :: Billing :: Processing Billing Documents :: Payment Cards
ProductVersionTableColumnsIndexesDescriptionModule
109ERP EHP76.0CCARDEC112Encrypted Payment Card NumbersPayment Cards
110ERP EHP76.0CCARDEC_CUST31Encryption of Payment Card TypePayment Cards
111ERP EHP76.0FPLTC362Payment cards: Transaction data - SDPayment Cards
112ERP EHP76.0TCCL21Payment cards: Point of receipt for the transactionPayment Cards
113ERP EHP76.0TCCLT41Payment cards: Points of receipt for the transaction (text)Payment Cards
114ERP EHP76.0TCCM21Payment cards: Merchant IDPayment Cards
115ERP EHP76.0TCCMT41Payment cards: Merchant ID (text)Payment Cards
116ERP EHP76.0TVCAA71Payment Cards: Checking Groups - Sales DocumentPayment Cards
117ERP EHP76.0TVCAAT51Payment Cards: Checking Groups - Sales Document (Text)Payment Cards
118ERP EHP76.0TVCTD71Payment Cards: Determine CategoriesPayment Cards
119ERP EHP76.0VCKUN72Assign customer-credit cardPayment Cards
120ERP EHP76.0VCNUM141Credit card masterPayment Cards
Sales and Distribution :: Billing :: Processing Billing Documents :: Self-Billing Proced.
ProductVersionTableColumnsIndexesDescriptionModule
121ERP EHP76.0T665B271SD Self-Billing Procedure: General Processing ParametersSelf-Billing Proced.
122ERP EHP76.0T665C161SD Self-Billing Procedure: EDI Partner Inbound ParametersSelf-Billing Proced.
123ERP EHP76.0T665D121SD Self-Billing Procedure: Contractor Processing ParametersSelf-Billing Proced.
124ERP EHP76.0T665E121SD Self-Billing Procedure: Tolerance Limits, PercentageSelf-Billing Proced.
125ERP EHP76.0T665F121SD Self-Billing Procedures: Tolerance Limits, AbsoluteAmountSelf-Billing Proced.
126ERP EHP76.0T665G21Self-Billing: Customer Tolerance GroupsSelf-Billing Proced.
127ERP EHP76.0T665GT41Self-Billing: Name of Customer Tolerance GroupsSelf-Billing Proced.
128ERP EHP76.0TRNSM163Data TransferSelf-Billing Proced.
129ERP EHP76.0VSBCON151Conditions (Surcharges/Discounts) of an IDoc ItemSelf-Billing Proced.
130ERP EHP76.0VSBDAT81Self-Billing Procedure Data w. Automatic PostingsSelf-Billing Proced.
131ERP EHP76.0VSBDIT201Self-Billing Procedure Delivery Item w. Automatic PostingSelf-Billing Proced.
132ERP EHP76.0VSBEER21Error Types and Editable FieldsSelf-Billing Proced.
133ERP EHP76.0VSBGRH111IDoc Header Regrouping InformationSelf-Billing Proced.
134ERP EHP76.0VSBGRI121IDoc Item Regrouping InformationSelf-Billing Proced.
135ERP EHP76.0VSBHDR473IDoc Self-Billing Procedure w. Automatic PostingsSelf-Billing Proced.
136ERP EHP76.0VSBITM341IDoc-Item Self-Billing Procedure w. Automatic PostingsSelf-Billing Proced.
137ERP EHP76.0VSBMER121Mainstep-Errors in Self-Billing Procedure w. Autom. PostingsSelf-Billing Proced.
138ERP EHP76.0VSBOII51Self-Billing: Index of Generated Open ItemsSelf-Billing Proced.
139ERP EHP76.0VSBPBD41Self-Billing: Processed Billing DocumentsSelf-Billing Proced.
140ERP EHP76.0VSBPER131Prestep-Errors in Self-Billing Procedure w. Autom. PostingsSelf-Billing Proced.
141ERP EHP76.0VSBPLG212Processing Log: Self-Billing Procedure w. Autom. PostingsSelf-Billing Proced.
142ERP EHP76.0VSBPLM111Processing Log MessagesSelf-Billing Proced.
143ERP EHP76.0VSBPST201Processing Status: Self-Billing Procedure w. Autom. PostingsSelf-Billing Proced.
144ERP EHP76.0VSBREF81References: Self-Billing Procedure with Autom. PostingsSelf-Billing Proced.
145ERP EHP76.0VSBTRM281Transmission: Self-Billing Procedure w. Autom. PostingsSelf-Billing Proced.
Sales and Distribution :: Billing :: Rebate Processing :: Extended Rebate
ProductVersionTableColumnsIndexesDescriptionModule
146ERP EHP76.0BON_ENH_CDOC141Settings for Indirect Billing DocumentsExtended Rebate
147ERP EHP76.0BON_ENH_CGEN111Settings for the Update of Indirect SalesExtended Rebate
148ERP EHP76.0BON_ENH_CSEQ71Extended Rebate: VAKEY StructureExtended Rebate
149ERP EHP76.0BON_ENH_CSEQ_S71Extended Rebate: VAKEY Structure, Shadow TableExtended Rebate
150ERP EHP76.0BON_ENH_LEDGER101Reconciliation Accounts for Rebate Credit MemosExtended Rebate
151ERP EHP76.0S469291Erweiterte BonusabrechnungExtended Rebate
152ERP EHP76.0S469E112S469 - StrukturinformationenExtended Rebate
Sales and Distribution :: Billing :: Rebate Processing :: Pendulum List Indirect Sales
ProductVersionTableColumnsIndexesDescriptionModule
153ERP EHP76.0/BEV4/PLCPG121Customizing Period GroupsPendulum List Indirect Sales
154ERP EHP76.0/BEV4/PLCPGI61Period Identifier (If Required)Pendulum List Indirect Sales
155ERP EHP76.0/BEV4/PLCPGT51Period GroupsPendulum List Indirect Sales
156ERP EHP76.0/BEV4/PLCPRT51Period splitPendulum List Indirect Sales
157ERP EHP76.0/BEV4/PLCPVIEWT41Customizing Period View, TextsPendulum List Indirect Sales
158ERP EHP76.0/BEV4/PLCTPGF41Period Group FunctionsPendulum List Indirect Sales
159ERP EHP76.0/BEV4/PLCTPR51Period splitPendulum List Indirect Sales
160ERP EHP76.0/BEV4/PLCTPVIEW21Customizing Period ViewPendulum List Indirect Sales
161ERP EHP76.0/BEV4/PLDALCST_T41General Customizing - Pendulum ListPendulum List Indirect Sales
162ERP EHP76.0/BEV4/PLDALCUST41General Customizing - Pendulum ListPendulum List Indirect Sales
163ERP EHP76.0/BEV4/PLDANFABH212Sales Request HistoryPendulum List Indirect Sales
164ERP EHP76.0/BEV4/PLDANFABS201Sales Request - HeaderPendulum List Indirect Sales
165ERP EHP76.0/BEV4/PLDANFART191Sales Request - ItemsPendulum List Indirect Sales
166ERP EHP76.0/BEV4/PLDANFBEL121Maintenance of Document Types for Indirect OrdersPendulum List Indirect Sales
167ERP EHP76.0/BEV4/PLDANFCST181Customizing Settings for Pendulum List RequestsPendulum List Indirect Sales
168ERP EHP76.0/BEV4/PLDANFCSTT41Customizing Settings for Pendulum List RequestsPendulum List Indirect Sales
169ERP EHP76.0/BEV4/PLDANFKON382Converted Request Table with Reporting PeriodPendulum List Indirect Sales
170ERP EHP76.0/BEV4/PLDANFMEL372Request Table with Reporting PeriodPendulum List Indirect Sales
171ERP EHP76.0/BEV4/PLDANFNUM31Number of Last Request Run - Pendulum ListPendulum List Indirect Sales
172ERP EHP76.0/BEV4/PLDANFORT91Update Determination of Pendulum ListPendulum List Indirect Sales
173ERP EHP76.0/BEV4/PLDANFVKO41Sales Organization-Dependent Control of RequestPendulum List Indirect Sales
174ERP EHP76.0/BEV4/PLDANFZEIT182Requirement UpdatePendulum List Indirect Sales
175ERP EHP76.0/BEV4/PLDAUSGABE41Control Indicator for Output MediumPendulum List Indirect Sales
176ERP EHP76.0/BEV4/PLDAUSGABT41Control Indicator - Translation - Output MediumPendulum List Indirect Sales
177ERP EHP76.0/BEV4/PLDFAUFTR31Function Module Call for Order CreationPendulum List Indirect Sales
178ERP EHP76.0/BEV4/PLDIFST31Interface Control Pendulum ListPendulum List Indirect Sales
179ERP EHP76.0/BEV4/PLDKART41Origin Indicator - Pendulum ListPendulum List Indirect Sales
180ERP EHP76.0/BEV4/PLDKART_T41Origin Indicator Translation - Pendulum ListPendulum List Indirect Sales
181ERP EHP76.0/BEV4/PLDPERIOD41Period Table Pendulum ListsPendulum List Indirect Sales
182ERP EHP76.0/BEV4/PLDPERIODT41Period Table - Translation - Pendulum ListsPendulum List Indirect Sales
183ERP EHP76.0/BEV4/PLDPFAD31Default File PathsPendulum List Indirect Sales
184ERP EHP76.0/BEV4/PLDPFAD_T41Default File PathsPendulum List Indirect Sales
185ERP EHP76.0/BEV4/PLDROLZU31Role Assignment for Pendulum ListPendulum List Indirect Sales
186ERP EHP76.0/BEV4/PLDSTAT31Status - Pendulum ListPendulum List Indirect Sales
187ERP EHP76.0/BEV4/PLDSTAT_T41Status - Translation - Pendulum ListPendulum List Indirect Sales
188ERP EHP76.0/BEV4/PLDUMART181Conversion Table Material MasterPendulum List Indirect Sales
189ERP EHP76.0/BEV4/PLDUMKDN311Conversion Table Customer/Object NumbersPendulum List Indirect Sales
190ERP EHP76.0/BEV4/PLDVKORGZ31Sales Organization Assignment Pendulum ListPendulum List Indirect Sales
191ERP EHP76.0/BEV4/PLPROT81Logs Sales Pendulum List (Master Data)Pendulum List Indirect Sales
192ERP EHP76.0/BEV4/PLPROT_261Log File with Error MessagesPendulum List Indirect Sales
193ERP EHP76.0/BEV4/PLPROT_ALL221Customers and Material RecordsPendulum List Indirect Sales
194ERP EHP76.0S473182Pendulum List - RequisitionerPendulum List Indirect Sales
195ERP EHP76.0S473E143S473 - Structure InformationPendulum List Indirect Sales
196ERP EHP76.0S474302Pendulum List - ConfirmationPendulum List Indirect Sales
197ERP EHP76.0S474E193S474 - Structure InformationPendulum List Indirect Sales