Sales deal Table in SAP

• A144
  Table for Sales Deal Basic Data
  Table Type : TRANSP
  Package : VF
  Module : AP-PRC-PR
• A145
  Table for Sales Deal - Customer/Material
  Table Type : TRANSP
  Package : VF
  Module : AP-PRC-PR
• A147
  Table for Customer Hierarchy (Sales Deal)
  Table Type : TRANSP
  Package : VF
  Module : AP-PRC-PR

• J_1AOFNR3
  Table for Exception table for deal type determ.(export/domestic)
  Table Type : TRANSP
  Package : J1AS
  Module : CRM-BF-TAX
• J_3RSPASSDEAL
  Table for Deal Passport
  Table Type : TRANSP
  Package : J3RS
  Module : FI-LOC
• OIJ_EL_DEALGROUP
  Table for OIL-TSW: Deal groups (trading system)
  Table Type : TRANSP
  Package : OIJ_EL
  Module : IS-OIL-DS-TSW
• OIJ_EL_DEALGRTX
  Table for OIL-TSW: Deal group texts (trading system)
  Table Type : TRANSP
  Package : OIJ_EL
  Module : IS-OIL-DS-TSW
• OIJ_EL_DEALTYPE
  Table for OIL-TSW: Deal types (trading system)
  Table Type : TRANSP
  Package : OIJ_EL
  Module : IS-OIL-DS-TSW
• OIJ_EL_DEALTYPET
  Table for OIL-TSW: Deal type texts (trading system)
  Table Type : TRANSP
  Package : OIJ_EL
  Module : IS-OIL-DS-TSW
• A152
  Table for Sales Org./Dist. Channel/Plant/Material/Sales Unit/Customer
  Table Type : TRANSP
  Package : WVKP
  Module : CRM
• A153
  Table for Sales Org./Distribution Channel/Plant/Sales Unit/Customer
  Table Type : TRANSP
  Package : WVKP
  Module : CRM
• A155
  Table for Sales Org./Dist. Channel/Price List/Material/Sales Unit
  Table Type : TRANSP
  Package : WVKP
  Module : CRM

• B002
  Table for Sales Organization/Sales Activity Type
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• B405
  Table for Sales Organization/Distribution Channel/Division/Sales Off.
  Table Type : TRANSP
  Package : JSD
  Module : IS-M
• CRMC_SGRP_R3GRP
  Table for Mapping CRM Sales Group and R3 Sales Group
  Table Type : TRANSP
  Package : CRM_ORGMAN
  Module : CRM-MD-ORG
• CRMC_SOFF_R3OFF
  Table for Mapping CRM Sales Office and R3 Sales Office
  Table Type : TRANSP
  Package : CRM_ORGMAN
  Module : CRM-MD-ORG
• JHAKPV
  Table for IS-M/AM: OPM Header Sales Agent / Item Sales Agent
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• JJTVA
  Table for Incl/Exclusive Sales Agt Requirements for Entire Sales Area
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• JJTVT
  Table for Requirement - Sales Area Assignment (Media Sales Agent)
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• KOTN201
  Table for Sales Org./Distr.Channel/Bonus Buy/Material/Sales Unit
  Table Type : TRANSP
  Package : WCBBY
  Module : SD-BF-FG
• SMOORGCO
  Table for attribute country for sales organization in CRM Mobile Sales
  Table Type : TRANSP
  Package : SMO3
  Module : CRM-MSA
• SMOSDCATG
  Table for Sales Document Categories (Customizing Sales Docs)
  Table Type : TRANSP
  Package : SMO3
  Module : CRM-MSA
• SMOSDFLDS
  Table for Field Status of sales document types (Customizing Sales doc)
  Table Type : TRANSP
  Package : SMO3
  Module : CRM-MSA
• SMOTVAKZ
  Table for Sales Documents: Allowed Order Types per Sales Org.
  Table Type : TRANSP
  Package : SMO3
  Module : CRM-MSA

• SMOTVBVK
  Table for Organizational Unit: Sales Groups per Sales Office
  Table Type : TRANSP
  Package : SMO3
  Module : CRM-MSA
• TJAKT
  Table for Sales Order: Texts for Sales Document Types
  Table Type : TRANSP
  Package : JSD
  Module : IS-M
• TVAKZ
  Table for Sales Documents: Allowed Order Types per Sales Org.
  Table Type : TRANSP
  Package : VA0C
  Module : CRM-BF
• TVARK
  Table for Archiving Control for Sales Activities in Sales Support
  Table Type : POOL
  Package : VZ
  Module : CRM-BTX-BF-IF
• TVBVK
  Table for Organizational Unit: Sales Groups per Sales Office
  Table Type : TRANSP
  Package : VZ0CCORE
  Module : SD-BF-ACT
• VIMI07
  Table for Reported Sales for Sales-Based Lease-Out
  Table Type : TRANSP
  Package : FVVI
  Module : CRM
• VIMI24
  Table for Percentage for Sales for Sales-Based Lease-Out
  Table Type : TRANSP
  Package : FVVI
  Module : CRM
• VIMI35
  Table for Percent for sales for sales-based rental agrmnt (offer)
  Table Type : TRANSP
  Package : FVVI
  Module : CRM
• VIMIUH
  Table for Sales-Based LO: Contractual Sales Lease-Outs Header
  Table Type : TRANSP
  Package : FVVI
  Module : CRM
• VISRTMMSBSB
  Table for Assignment of a Sales Rule to a Peak Sales Rule
  Table Type : TRANSP
  Package : RE_SR_TM
  Module : RE-FX-SR
• VKAOF
  Table for Sales Index: Open Sales Activities
  Table Type : TRANSP
  Package : VCA
  Module : CRM
• /BEV1/TSSVARI
  Table for Telephone Sales: Fields for Order Item in Sales Activity
  Table Type : TRANSP
  Package : /BEV1/TS_OBSOLETE
  Module : SD-SLS-PLL-OBS
• /BEV1/TSVB
  Table for Customizing Telephone Sales per Sales Area
  Table Type : TRANSP
  Package : /BEV1/TS_OBSOLETE
  Module : SD-SLS-PLL-OBS
• /BEV1/TSZKK
  Table for Cyclical Customer Sales Activities for Telephone Sales
  Table Type : TRANSP
  Package : /BEV1/TS_OBSOLETE
  Module : SD-SLS-PLL-OBS
• /BEV1/TSZKKS
  Table for Telephone Sales: Changes to Planned Sales Activities
  Table Type : TRANSP
  Package : /BEV1/TS_OBSOLETE
  Module : SD-SLS-PLL-OBS
• /POSDW/DMF_AGGR1
  Table for POS aggregate "Sales for DMF": Section "Sales"
  Table Type : TRANSP
  Package : /POSDW/OUTPUT_CONVERSION_EN
  Module : BW-BCT-ISR-PIP
• A048
  Table for Sales conditions sample structure for pricing
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A050
  Table for Sales conditions sample structure for pricing
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A055
  Table for Sales conditions sample structure for pricing
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A056
  Table for Sales conditions sample structure for pricing
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A079
  Table for Sales Organization/Distribution Channel/Material Group
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A110
  Table for Sales Organization/Destination Country
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A140
  Table for Sales Area / Accounting Indicator
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A210
  Table for IS-M: Commission/Bonus for Media Sales Agent Contract
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• A273
  Table for Sales org./Distr. chl/Division/Material/Customer/Item
  Table Type : TRANSP
  Package : DRM
  Module : IS-HT-DRM
• A274
  Table for Sales org./Distr. chl/Division/Material/Item
  Table Type : TRANSP
  Package : DRM
  Module : IS-HT-DRM
• A350
  Table for Sales org.
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• /DSD/PR_PRONR
  Table Data element for DSD Deal Conditions - Deal Condition Number
• /DSD/PR_SEQNR
  Table Data element for DSD Deal Conditions - Deal Condition Sequence Number
• /DSD/PR_TYPE
  Table Data element for DSD Deal Conditions - Deal Condition Type
• /DSD/PR_DESCRIPTION
  Table Data element for DSD Deal Conditions - Deal Condition Type Description
• /DSD/PR_STATUS
  Table Data element for DSD Deal Conditions - Status of a Deal Condition
• /DSD/PR_PRO_DESCR
  Table Data element for DSD Deal Conditions - Deal Condition Description
• KNUMA_AG
  Table Data element for Sales deal
• BOTEXT
  Table Data element for Description of agreement (e.g. sales deal, promotion)
• LEINT_BOTEXT
  Table Data element for Description of agreement (e.g. sales deal, promotion)
• SMO3KNUMA1
  Table Data element for Sales deal
• /DSD/PR_VKORG_ACTIVE
  Table Data element for DSD Deal Conditions - Sales organization Active Flag
• XEGDR
  Table Data element for Indicator: Triangular deal within the EU ?

Sales deal related terms

Definitions

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.