How to look up a sales document in sap Table in SAP

• CRMC_MCAL_KPI
  Table for Marketing calendar: KPI look up table
  Table Type : TRANSP
  Package : CRM_MCAL_CUSTOMIZING
  Module : CRM-MKT-MPL-CAL
• DBAERR
  Table for Look-Up Table for Database Operation Errors
  Table Type : TRANSP
  Package : SDBA
  Module : BC-DB-ORA-CCM
• DBAFID
  Table for Look-Up Table for Database Operations
  Table Type : TRANSP
  Package : SDBA
  Module : BC-DB-ORA-CCM

• DBATRIAL
  Table for Look-Up Tables for Database Sub-Operations
  Table Type : TRANSP
  Package : SDBA
  Module : BC-DB-ORA-CCM
• FDT_DEMO_0001
  Table for FDT: Demo Table for DB Look-up Demos
  Table Type : TRANSP
  Package : SFDT_DEMO_OBJECTS
  Module : BC-SRV-BR
• RMPSD_TRF_IM_ID
  Table for Import Run - Identifier Look Up
  Table Type : TRANSP
  Package : RMPS_DOD_TRF_RUNTIME
  Module : CA-GTF-RCM
• SXMSLOOKUPENGINE
  Table for Look Up Table for Engine Type and Engine Name
  Table Type : TRANSP
  Package : SXMSPERSIST
  Module : BC-XI-IS-IEN
• /SAPSRM/C_MDASBL
  Table for Look-Up Table BO specific Restriction of Set Field Metadata
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• /SAPSRM/C_MDASDL
  Table for Look-Up Table for Dependant Object(Set) Action Metadata
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• /SAPSRM/C_MDA_IL
  Table for Look-Up Table for Meta Data Configuration for Item Actions
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• /SAPSRM/C_MDFSBL
  Table for Look-Up Table BO specific Restriction of Set Field Metadata
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• /SAPSRM/C_MDFSDL
  Table for Look-Up Table for Dependant Object/Set Field Metadata
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW

• /SAPSRM/C_MDF_HL
  Table for Look-Up Table for Meta Data Configuration for Header Fields
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• /SAPSRM/C_MDF_IL
  Table for Look-Up Table for Meta Data Configuration for Item Fields
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• /SAPSRM/C_MDS_HL
  Table for Look-Up Table Metadata Configuration for Header Set Types
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• /SAPSRM/C_MDS_IL
  Table for Look-Up Table for Metadata Configuration for Item Set Types
  Table Type : TRANSP
  Package : /SAPSRM/PDO_SHARED_META
  Module : SRM-EBP-FW
• 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
• TJAKT
  Table for Sales Order: Texts for Sales Document Types
  Table Type : TRANSP
  Package : JSD
  Module : IS-M
• IDGT_GTDM
  Table for Mapping of SAP Document and GT Document
  Table Type : TRANSP
  Package : ID-SD-CN-GT-01
  Module : FI-LOC
• WBRFN
  Table for Document Flow of Reference Document to Agency Document
  Table Type : TRANSP
  Package : WZRE
  Module : LO-AB
• 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
• 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
• 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
• SDEMO_SO
  Table for SAP NetWeaver Demo Model - Sales Order Header
  Table Type : TRANSP
  Package : S_NWDEMO_MODEL_SALES_ORDER
  Module : BC-SRV-NWD
• SDEMO_SO_I
  Table for SAP NetWeaver Demo Model - Sales Order Item
  Table Type : TRANSP
  Package : S_NWDEMO_MODEL_SALES_ORDER
  Module : BC-SRV-NWD
• ALDPLOOKAH
  Table Data element for Alert: "Look ahead" time for a tool dispatcher
• OII_TPIPRD
  Table Data element for OIL-TPI: Default partner role for partner look-up
• SMO7_LHIER
  Table Data element for Look up hierarchy.
• SXMS_ENGINE_KEY
  Table Data element for Key for Engine Look Up Table
• XBSED_021
  Table Data element for Indicator: Look up bill of exchange data ?
• XPAYR
  Table Data element for Indicator: Look up PAYR
• VKOAU
  Table Data element for Reference sales org.for sales doc.types (by sales area)
• W_ZMUMS
  Table Data element for Means of payment sales from sales as per receipts/aggr.sales
• SMO3VKOAU
  Table Data element for Reference sales org.for sales doc.types (by sales area)
• DPBP_AUART_DPR
  Table Data element for Sales Document Type for Down Payment Requests (Sales)
• ESALES_VBTYP
  Table Data element for Sales Document Types in Utilities Sales
• ISPAUAGRP
  Table Data element for IS-M: Sales Document Type Grouping for Sales Order

How to look up a sales document in sap 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.