SAP Sales and Distribution (SD) Tables

TableDescriptionModule
SCEKBRuntime Version of SCE Knowledge BaseSD
SCENUMNumeric CharacteristicsSD
SCEMATMaterialsSD
TVROPTSD - Report OptimizationSD
SCECNTControl Knowledge (Tasks and Events)SD
SCEDEPDependencies (Basic Data)SD
SCECUSDInterface Design - Grouping StructureSD
SCEPROFProfile of Knowledge Base (Starting Point of Configuration)SD
SCETASKTasks (SCE)SD
SCEKBTXLanguage-Dependent Description for SCE Knowledge BaseSD
IPCDESTmeters for Destinations"SD
SCECUCOInterface Design - Sequence of Characteristics in a GroupSD
IDFITYPTax Type: Possible EntriesSD
SCECUHDInterface Design - Header DataSD
SCECLVTXLang.-Dependent Descs of Vals of Alphanum. Chars of ClassesSD
SCECHATXLanguage-Dependent Description of CharacteristicSD
SCECLVALValues Assigned to Characteristics of a ClassSD
SCECNTTXLanguage-Dependent Descriptions of Control KnowledgeSD
SCECUSDTInterface Design - Description of GroupingsSD
SCEDEPTXLanguage-Dependent Descriptions for DependenciesSD
SCEDESCRLanguage-Dependent Descriptions of KB Object/Task/EventSD
SCEEVENTEvents (SCE)SD
SCEKBOBJKnowledge-Base Object (SCE)SD
SCEOCLTXLanguage-Dependent Descriptions of OO ClassesSD
SCESUPERClass Hierarchy of Knowledge BaseSD
IDFITYPTTax Type: Texts for Possible EntriesSD
SCEVALTXLanguage-Dependent Descriptions of Values of Alphanum. CharsSD
IDCN_EXCPErrors for Prenumbered DocumentsSD
SCECHADEPAssignment: Classic Dependencies to Chars of ClassesSD
IDCN_VOIDVoid ReasonsSD
SCEDEPVARVariables of DependenciesSD
ZIFPORDERPurchase Order HeaderSD
SCEDOCKEYStorage Location of Document KeySD
SCEDOCOBJLink Between Documents and ObjectsSD
SCEHASCHACharacteristics of OO ClassSD
SCEHASDECAssignment of Decomposition to OO ClassSD
SCEHASPRTComponents of Decomposition (BOM and so on)SD
SCEINVIEWAllocation of Characteristic of Class to Org. AreaSD
IDCN_LOMALots for Prenumbered DocumentsSD
SCEDEPSRCSource Code of DependencySD
SCEKMTDEPAssignment: Dependencies for Configurable MaterialsSD
SCELNGTXTStorage Location for Long TextsSD
IDCN_DOTYCountry-Specific Document ClassesSD
SCENUMDOMAllowed Values of Numeric CharacteristicSD
SCEOCLASSOO Classes of SCE Knowledge BaseSD
IDCN_BOMABooks for Prenumbered DocumentsSD
ZZDEA_MSTDrug Enforcement Administration (DEA)SD
SCEPROFTXLanguage-Dependent Description of Knowledge-Base ProfileSD
SCEPRTDEPAssignment of Dependencies to Components (of BOM)SD
SCESTRDOMAllowed Values for Alphanumeric CharacteristicsSD
SCESTRINGAlphanumeric CharacteristicsSD
ZZDEA_QTYDEA quantity limits per customer and materialSD
SCEDEPPATPattern of DependencySD
SCECHAINPNo User Entry for Characteristic of ClassSD
SCECHAPOSPosition of Characteristic in ClassSD
SCECHARACCharacteristicsSD
SCECHAREFReference of Reference CharacteristicSD
SCETABFUNValue Assignment Alternatives for Variant Table and FunctsSD
SCECHAVISCharacteristic of Class Hidden/ShownSD
SCECLACOMCompilation for Classic DependenciesSD
SCECLNDOMAllowed Values for Numeric Characteristic of ClassSD
SCECLPRECPrecedence List for OO ClassesSD
SCECLSDOMAllowed Values of Alphanumeric Characteristic of ClassSD
SCEVACONDAssignment of Variant Condition to Char. Value in SCE KBSD
SCEVALDEPAssignment of Dependencies to Char. Values of ClassesSD
SCEVALSYMSymbol Table for Characteristic ValuesSD
SCECNTDEPAssignment of Dependencies to Control KnowledgeSD
SCECONFPRConfiguration ProfilesSD
SCEVARVALValues in Variant TablesSD
SCEDECOMPDecomposition (BOM and so on)SD
SCEDEPCOMCompilation of Dependency NetsSD
SCEDEPDNNDNNs of DependencySD
SCEDEPDOCDocumentation for DependenciesSD
SCEDEPSPNSPNs of DependencySD
IDCN_DOTYTCountry-Specific Document Classes - TextsSD
IDCN_BOMATBooks for Prenumbered Documents - TextsSD
IPM_RAWRECDue Pre-List for Product SalesSD
IDCN_LOMATLots for Prenumbered Documents - TextsSD
SCEPROFILEKnowledge-Base Profiles (SCE)SD
IDCN_VOIDTVoid Reasons - TextsSD
ZZDEA_SCHEDDEA Drug SchedulesSD
IPM_VAL_MAPAssignment Table for Generic Value MappingSD
IDCN_ODN_TRPrenumbered ODN for multiple print pagesSD
ZIFPORDERPOSPurchase Order ItemsSD
ZQUIZ_MASTERQuiz TableSD
J_1USEXTRACTHEXTRACTHSD
J_1USEXTRACTDEXTRACTDSD
IPM_ATTR_MAP2Assignment Table for Generic Attribute MappingSD
IPM_ATTR_MAP1Assignment Table for Generic Attribute MappingSD
IDVKBUR_BUPLAAssignment of Business Place to Sales OfficeSD
IDCNTRY_CHECKCountry specific checksSD
ZZDEA_BUS_TYPEDEA Business Activity CodesSD
ZZDEA_MAT_SCHDDEA Schedule of MaterialSD
IDCNTRY_CHECK_VCountry-specific check valuesSD
J_1USEXTRACTD_MMEXTRACTD_MMSD
IPM_TRANSFER_STAKeeps track of the transfer status of billing itemsSD
CMSC_RFC_DES_QUECMS Table for storing RFC destination & que no rangeSD
Show More SAP SD Tables

SAP Master Data Tables

TcodeDescriptionModule
A000Condition Table for Pricing $SD-MD
A001Not Used in StandardSD-MD
A002Country/Customer Classification/Material ClassificationSD-MD
A003Tax ClassificationSD-MD
A004MaterialSD-MD
A005Customer/MaterialSD-MD
A006Price List Type/Currency/MaterialSD-MD
A007Division/CustomerSD-MD
A008Plant/Additional selling plantSD-MD
A009Additional Selling Plant/EANSD-MD

Full List of SAP Master Data Tables


SAP Basic Functions Tables

TcodeDescriptionModule
NACHDetailed output dataSD-BF
T180Screen Sequence Control: Transaction Default ValuesSD-BF
T190Product Allocation: ControllingSD-BF
FPLTBilling Plan: DatesSD-BF
KNMTCustomer-Material Info Record Data TableSD-BF
B024Shipping pointSD-BF
B200Overall Status - Credit CheckSD-BF
QTCHProduct Allocation: Feature DirectorySD-BF
QTVBProduct Allocation: Allocation used by Customer OrderSD-BF
KNVHCustomer HierarchiesSD-BF

Full List of SAP Basic Functions Tables


SAP Sales Tables

TcodeDescriptionModule
B090SEPA Mandate - Payment MethodSD-SLS
S467Indirect Order UpdateSD-SLS
T176Sales Documents: Customer Order TypesSD-SLS
TPRGDate display formatSD-SLS
T663Delivery interval:Sched.agreements for component suppliersSD-SLS
T476Parameterization of the Configuration EditorSD-SLS
TCSPCross-Selling Profile: DefinitionSD-SLS
T184Sales Documents: Item Category DeterminationSD-SLS
TPVDProduct Proposal: Definition of Customer ProcedureSD-SLS
TPVHProduct Proposal: Definition of Source IndicatorSD-SLS

Full List of SAP Sales Tables


SAP Foreign Trade Tables

TcodeDescriptionModule
A121Legal Control: Values for Calculating Foreign PercentageSD-FT
A300Statistical Value of Subcontracting ComponentsSD-FT
A301Info Record Type and IncotermsSD-FT
A310Duty Rate Customs Exemption: Importing Ctry/Code/MaterialSD-FT
A315Cust.Duty Anti-dumping: Import/Code/Orig.ctry/Manu./Exp./MatSD-FT
A316Anti-dumping Duty Rate: Imp.Ctry/Code/Orig.Ctry/Anti-d. CodeSD-FT
A317Anti-dumping Duty Rate: Imp.Cntry/Code Number/Cntry of Orig.SD-FT
A320Third country Duties: Import ctry/Code/Orig.ctry/Ship.ctrySD-FT
A321Third Country Duty Rate: Import Country/CodeSD-FT
A325Duties Pharma. Products: Import country/Code/CAS/MaterialSD-FT

Full List of SAP Foreign Trade Tables


SAP Billing Tables

TcodeDescriptionModule
A144Sales Deal Basic DataSD-BIL
A145Sales Deal - Customer/MaterialSD-BIL
A146Customer HierarchySD-BIL
A147Customer Hierarchy (Sales Deal)SD-BIL
A148Product HierarchySD-BIL
A149Customer-dependent data determinationSD-BIL
A399Withholding tax code - country-specificSD-BIL
S071Condition UpdateSD-BIL
KNVICustomer Master Tax IndicatorSD-BIL
KNVLCustomer Master LicensesSD-BIL

Full List of SAP Billing Tables


SAP Sales Support Tables

TcodeDescriptionModule
TVC4Sales Activity Outcome AnalysisSD-CAS
TVC3Sales Activity StatusSD-CAS
TVC2Reasons for Sales ActivitiesSD-CAS
TVCASales Activity Description 01SD-CAS
TVC6Sales Activity Status GroupsSD-CAS
TVC7Sales Activities: Assigning Outcome Analysis to Act.ReasonSD-CAS
TVC1Sales Activity OutcomeSD-CAS
TVC5Sales Activities: Allowed Statuses by Status GroupSD-CAS
TVCBSales Activity Description 02SD-CAS
TKSFValue Table: Statistics Grp for Sls Activ. Procg in HeaderSD-CAS

Full List of SAP Sales Support Tables


SAP Information System Tables

TcodeDescriptionModule
S020SIS: Customer Potential AnalysisSD-IS
S131Doc. Payment Guarantee: Update Letter of Credit Values (LIS)SD-IS
S135Value contract, target/release order valueSD-IS
S264SD- OfferSD-IS
TVSGSales Statistics GroupsSD-IS
TVSFKUpdate Group: Statistics (Header)SD-IS
S020ES020 - Structure InformationSD-IS
TVSFPUpdate Group: Statistics (Item)SD-IS
TKSFKUpdate Sequence: Sales Activity Processing Statistics: HeadrSD-IS
TMCW2Administrative Data for SIS Re-SetupSD-IS

Full List of SAP Information System Tables


SAP Electronic Data Interchange Tables

TcodeDescriptionModule
EDPARConvert External < > Internal Partner NumberSD-EDI
EDPSTTranslation table EDI Int. Doc. <--> SD item categoriesSD-EDI
EDPVWPartner Functions Allowed for EDISD-EDI
EDSDCAssignment of EDI Partner by Sales Org., Distrib.Ch.,Div.SD-EDI
PRICAT_001PRICAT inbound: Assignment of ILN - Vendor - Purch. groupSD-EDI
PRICAT_002PRICAT inbound: Assignment of ILN mat. group - SAP mat. grpSD-EDI
PRICAT_003PRICAT inbound: Assignment of SAP mat. group - purch. groupSD-EDI
PRICAT_004PRICAT: ID for Supply of Data to Catalog per Material GroupSD-EDI
PRICAT_005PRICAT: ID for Supply of Data to Catalog per MaterialSD-EDI
PRICAT_006PRICAT: Template for Non-ERP Fields to Catalog ItemSD-EDI

Full List of SAP Electronic Data Interchange Tables


SAP POS Interface Tables

TcodeDescriptionModule
A134VendorSD-POS
C007VendorSD-POS
WVFBDRS Interface, Intermediate Buffer, Order Item FMSD-POS
T6WL4Check table - label formSD-POS
TWPIFTransaction type-dependent control of POS financial trans.SD-POS
TWPBRDefinition of the Check Rules for POS UploadSD-POS
WVFB2SRS: received external requirement numbers/phys. inv. nosSD-POS
TWPDZAssignment of credit card institute to customerSD-POS
TWPEKPOS outbound: Condition typesSD-POS
TWPFIPOS outbound profileSD-POS

Full List of SAP POS Interface Tables