SAP SD (Sales and Distribution) Module Tables list

SD is a SAP module coming under SAP_APPL component.Total 1580 SD tables are stored in our database.View these tables by sub modules coming under SAP SD.You can also refer SAP SD transaction codes from this link
  • Module description : Sales and Distribution
  • Application component : HLA0009600
  • First release : 30A

SD Tables

SAP SD Tables by sub module wise

SD-BF ( View full 15 Tables )
TableNote
TPACHECKChecking Table Directory for Check Modules of SD Partner
KOND3Conditions: Campaign Determination - Data Part
TPACHECKRELATIONDependency Graph for Check Modules in SD Partner Processing
SDPROTTYPTValue table for SD protocol types: Texts
CMPB_ASGNCampaign Assignment
SD-BF-AC ( View full 3 Tables )
TableNote
LATQ_ENQPersistent Lock Records for Product Allocation
LATP_ENQPersistent Lock Records for ATP in R/3 from External Systems
BAPIPICProduct info (screens) for ATP information in the internet
SD-BF-ACT ( View full 9 Tables )
TableNote
TVKBTOrganizational Unit: Sales Offices: Texts
TVBVKOrganizational Unit: Sales Groups per Sales Office
TVGRTOrganizational Unit: Sales Groups: Texts
TVTWTOrganizational Unit: Distribution Channels: Texts
TSPAOrganizational Unit: Sales Divisions
SD-BF-AS ( View full 7 Tables )
TableNote
/BEV1/EMASVMaterial Sorting Variant
/BEV1/EMASVTMaterial Sorting Variant - Texts
/BEV1/EMFAS2Material Sorting: Shipping Documents
/BEV1/EMFAS1Material Sorting: Sales Documents
/BEV1/EMFASForm for Material Sorting Variant
SD-BF-CPE ( View full 7 Tables )
TableNote
CPED_KNUMVTOGUIDCPE Caller - Mapping KNUMV and Document Item to GUID
CPED_KNUMHTOGUIDCPE Caller - Mapping ERP Condition to GUID
CPEC_SD_FA_PROCCPE in SD: Determination of Procedure for Formula Assembly
CPEC_SD_VALFORMArea of Validity for Commodity Pricing Formula in SD
CPEC_SD_VALTERMArea of Validity for Commodity Pricing Term in SD
SD-BF-EC ( View full 2 Tables )
TableNote
/BEV1/ECCODEDialog Checks
/BEV1/ECMITDExtra Charge Reconciliation Accounts
SD-BF-FG ( View full 12 Tables )
TableNote
KONMATGRPXMaterial Grouping: Exceptions
KOTN203SalesOrg./SalesChan/Plant/BonusBuy/Material/SalesUnit
KONBBYHBonus Buys: Header
KONBBYTBonus Buys: Text
KOTN201Sales Org./Distr.Channel/Bonus Buy/Material/Sales Unit
SD-BF-PR ( View full 45 Tables )
TableNote
PIQC_PREP_FLD_CDefine Customer-Specific Sources
T684SCondition Exclusion: Procedure Assignment
T689Download Profile for the Conditions
PIQC_API_CALLERRegistration for callers of PriceInquiry API
VFPRCC_UERATTR_CRelevant attributes of pricing user exits (Customer)
SD-BF-SMI ( View full 7 Tables )
TableNote
SMI_HEADERSMI Header Data
SMI_MESSAGESSMI Customizable Messages
SMI_PROFILESMI Profile
SMI_BORDER_HISTSMI Limit History
SMI_ITEMSMI Item Data
SD-BF-TP ( View full 2 Tables )
TableNote
TSKDCustomer Taxes
TSKDTCustomer Taxes: Texts
SD-BF-TX ( View full 6 Tables )
TableNote
TTXFstatus transition diagram for tax document during pricing
TTXXtable to determine which tax law is used
TTXMlist of tax laws
TTXBfields that serve as base for maximum tax
TTXBTfields that serve as base (desriptions)
SD-BIL ( View full 4 Tables )
TableNote
SDFM_SF_AG_INDEXMANDT MANDTIndex Table for Update of Statistics (Agreements)
CRMC_FM_CO_EXPcustomizing table cost element to expense type for marketing
T077DFCustomer Group: FI-CA Integration (Distributed Systems)
SDFM_SF_INDEXIndex Table for Update of Statistics
SD-BIL-EM ( View full 23 Tables )
TableNote
/BEV1/EMLGKTOEmpties Account
/BEV1/EMVISFEmpties Customizing Selection for SIS fields
/BEV1/EMPPBWARTBWART for Tied Empties in PP Confirmation
/BEV1/EMDRKKZItem Categories That Are Not Printed
/BEV1/EMLGOFSEmpties - Billing Document Without Update
SD-BIL-GF ( View full 1 Tables )
TableNote
TLICTax Exemption License
SD-BIL-IV-CP ( View full 9 Tables )
TableNote
CMP_REASONCustomizing for Complaints Reasons
CMP_POSTYPItem Category Customizing Complaints Proc. Credit Memo Item
CMP_REASON_TXTComplaints Reasons: Texts
CMP_MAPMASSKSCHLMapping Condition ID <-> Condition Type
CMP_MAPKSCHL_TXTTexts for Mapping Condition ID <-> Condition Type
SD-BIL-IV-PC ( View full 12 Tables )
TableNote
CCARDECEncrypted Payment Card Numbers
TCCMTPayment cards: Merchant ID (text)
TCCMPayment cards: Merchant ID
FPLTCPayment cards: Transaction data - SD
TVCAATPayment Cards: Checking Groups - Sales Document (Text)
SD-BIL-IV-SBI ( View full 25 Tables )
TableNote
VSBEERError Types and Editable Fields
T665ESD Self-Billing Procedure: Tolerance Limits, Percentage
T665CSD Self-Billing Procedure: EDI Partner Inbound Parameters
VSBREFReferences: Self-Billing Procedure with Autom. Postings
VSBPLGProcessing Log: Self-Billing Procedure w. Autom. Postings
SD-BIL-IV-SM ( View full 22 Tables )
TableNote
PRSC_SCRVALEngagement mgmt: Sceen Values
PRSC_CAT_TEngagement mgmt: Categories Text table
PRSC_MATDETCATEngagement mgmt: Determine Categories for Materials
PRSC_METCOLEngagement mgmt: Metrics Columns
PRSC_CHAREngagement mgmt: Characteristics
SD-BIL-RB-ENH ( View full 7 Tables )
TableNote
BON_ENH_CSEQ_SExtended Rebate: VAKEY Structure, Shadow Table
BON_ENH_CDOCSettings for Indirect Billing Documents
BON_ENH_LEDGERReconciliation Accounts for Rebate Credit Memos
BON_ENH_CGENSettings for the Update of Indirect Sales
S469ES469 - Strukturinformationen
SD-BIL-RB-PL ( View full 45 Tables )
TableNote
/BEV4/PLDKART_TOrigin Indicator Translation - Pendulum List
/BEV4/PLPROTLogs Sales Pendulum List (Master Data)
/BEV4/PLDPERIODTPeriod Table - Translation - Pendulum Lists
/BEV4/PLCPGTPeriod Groups
/BEV4/PLDFAUFTRFunction Module Call for Order Creation
SD-CAS ( View full 1 Tables )
TableNote
T180LSD: Valid Logical Databases for Extended Search Help
SD-EDI ( View full 66 Tables )
TableNote
WRF_PRICOND_READDefine: Reading of Prices
WRF_PRICAT_PRE_CPrice Catalog Default Customizing for Client Level
WRF_PRICAT_002Assign External Material Group - SAP Material Group
PRICAT_K008PRICAT: Catalog item prices / conditions / taxes
PRICAT_K007PRICAT: Catalog item bills of material
SD-FT ( View full 33 Tables )
TableNote
/SAPSLL/TBTPR3GTS: ERP: Control Settings for BOM Transfer - Plant
/SAPSLL/TLER3BSLL: R/3 BS: Control: Call Customs Server: Doc. Types
/SAPSLL/TECOR3OPCustoms ID Assignment to Plant for Outward Processing
/SAPSLL/TBTCR3GTS: ERP: Control Settings for BOM Transfer - Country
/SAPSLL/TBTGR3GTS: ERP: Control Settings for BOM Transfer - Global
SD-FT-PRO ( View full 1 Tables )
TableNote
FTULOForeign Trade: Work Table for UPLOAD of Foreign Trade Data
SD-IS-DC ( View full 4 Tables )
TableNote
ANLY_SD_SETUPActivation of Functionality for SD Analytics
S264SD- Offer
S264BIW1S264BIW1 * SD - Quotation
S264BIW2S264BIW2 * SD - Quotation
SD-MD-AM-RAG ( View full 3 Tables )
TableNote
AGR_REL_KNUMA_CMAssignment: Agreement --> Campaign
AGR_MEM_INITIALAgreements: Buffer for Intial Upload
AGR_MAP_KNUMAConversion Table AG_GUID CRM <> KNUMA
SD-MD-CM ( View full 24 Tables )
TableNote
T681AConditions: Applications
MASTER_3000Condition Table for Campaign Determination
KOTD020EAN/GV Type/Sales org./Distr. Chl/Division/County/Customer
CND_MAPC_FIELDCondions Exchange: Convert Field Contents
CND_USAGE_PREFIXPrefix for Every Usage
SD-MD-MM ( View full 2 Tables )
TableNote
TVKMMaterials: Account Assignment Groups
TVKMTMaterial: Account Assignment Group Texts
SD-MD-MM-CS ( View full 24 Tables )
TableNote
WSDT_CBP_DHTEXTDisplay Hierarchy Text for Close-by Plants
WSD_PRICE_ELEMPredefined Price Elements
WSDT_PREL_C_OPTIdentification Option for Special Price Elements
WSD_KEYWORDKeyword Definition
WSDT_APPLTWSD Applications Descriptions
SD-POS ( View full 4 Tables )
TableNote
TWPIIStore phys. inventory control
WVFB2SRS: received external requirement numbers/phys. inv. nos
TWPIOStore order control
WVFBDRS Interface, Intermediate Buffer, Order Item FM
SD-POS-IN ( View full 1 Tables )
TableNote
WPOSN_CSGMTStock Determination Entries for Consignment Processing
SD-POS-OUT ( View full 3 Tables )
TableNote
WDLCOPYLOGError Log Table for IDoc Copy Management
WDLCOPYLog Table for IDoc Copy Management
TWPCOPYReference Ship-to Party for IDoc Copy Management
SD-SLS ( View full 41 Tables )
TableNote
ERP_SLS_SUBSETWorklist Subset
/CBAD/LINETYPE_TLine Types for Contract Subitems: Texts
/CBAD/CONTRACT_HAdvanced Order Processing and Billing: Header Data
LORD_XSTRINGLean Order: Temporary container for DOC/RTL content, XSTRING
ERP_SLS_WORKSETWorklist Workset
SD-SLS-API ( View full 1 Tables )
TableNote
FIORI_COMMON_CUSCommon oData Customizing Setting
SD-SLS-ES ( View full 1 Tables )
TableNote
PUR_B2B_TESTINGTesting tool for B2B service
SD-SLS-GF ( View full 5 Tables )
TableNote
TVARASales Document Archiving Control
T180VReporting: Default Values
T180UReporting: Display Variants - Headings
T180TReporting: Display Variants - Texts
T180CReporting: Totals Variants: Texts
SD-SLS-OA-SCH ( View full 1 Tables )
TableNote
ESD_TOPRMaintenance of Tolerance Profiles
SD-SLS-PLL ( View full 4 Tables )
TableNote
/BEV1/TSSVBFLPart Load Lift Orders: Fields to Be Displayed
/BEV1/TSSVBZBPart Load Lift Orders: Permitted Order Types Target Doc.
/BEV1/TSSVBEL2Part Load Lift Orders: Customizing Selection Sales Documents
/BEV1/TSSVBELPart Load Lift Orders: Customizing Selection Sales Documents
SD-SLS-PLL-OBS ( View full 1057 Tables )
TableNote
/BEV1/TSSEQFLDisplay Sales Routes Sequences Field per Customer
/BEV3/CHCDPTERMICDP: Contract Dates (Dates and PC)
/BEV3/CHCTMABRFTCustomizing Settlement Methods - Texts
/BEV1/TSSTMATSStatistics: Category/Material Status
/BEV3/CHCABZTPTFrom Time, Texts
SD-SLS-QUT ( View full 1 Tables )
TableNote
FIORI_MY_QUOTE_CMy Quotations Settings
SD-SLS-RE-SR ( View full 17 Tables )
TableNote
/BEV1/SRRUE02Sales Returns
/BEV1/SRINHContents
/BEV1/SR_MP_MT_MField Assignment Order -> Material Movement
/BEV1/SRBEFTAnalysis/Refunding Key Text
/BEV1/SRBSTYAssignment of BVS to Item Categories