Appendix: Transaction Codes and Database Tables
This appendix recaps the transaction codes presented in the book. We have also listed database tables and transaction codes not covered in the chapters. Although the arrangement of the transaction codes in the appendix corresponds to the chapters of the book, the database tables are grouped in logical sequence based on the nature of data that is stored in the table. For example, Table A-16 lists all the database tables that store master data information such as customer master, material master, and so on, whereas Table A-17 lists all the database tables that store SD transaction data such as sales order data, delivery document data, and so on. You use transaction code SE16 and SE16N to browse the data stored in the database tables. To make it easier to search the data from the tables, standard SAP also provides composite views on database tables. For example, rather than browsing KNA1 and KNVV separately, you can use KNA1VV to browse KNA1 and KNVV data together. Table A-19 lists the composite database views that are available in SAP SD.
For the database tables that store condition record data, SAP follows a naming convention. Pricing tables start with A, account determination tables start with C, material determination tables start with D, and so on. So if you would like to browse pricing condition table 901 where you maintained the customer-specific price (for example), use table name A901 in the data browser transaction (SE16N). Table A-20 lists the naming conventions for condition tables based on various determination techniques.
Table A-1 through Table A-14 recap the transaction codes used in this book, as well as additional ones.
Table A-1 Codes Related to Chapter 1, “Introduction to Sales and Distribution”
| Tcode | Description |
| SEARCH_SAP_MENU | Transaction to Search Transactions in SAP Easy Access Menu |
| SPRO | Transaction to Access IMG Menu |
| SE10 | Transport Organizer |
| SE01 | Transport Organizer (Extended View) |
| SE11 | ABAP Dictionary |
| SE16 | Data Browser |
| SE16N | Data Browser—General Table Display |
| SE38 | ABAP Editor |
Table A-2 Codes Related to Chapter 2, “Enterprise Structure”
| Tcode | Description |
| OVX3 | Assign Sales Organization to Company Code |
| OVX3N | Assign Sales Organization to Company Code |
| OVX4 | Define Sales Group |
| OVX5 | Define Sales Organization |
| OVX6 | Assign Plants to Sales Org./Distr.Channel |
| OVX6N | Assign Plants to Sales Org./Distr.Channel |
| OVX7 | Loading Points |
| OVX8 | Check Report Organization Sales |
| OVX8N | Check Report Organization |
| OVXA | Assign Division to Sales Organization |
| OVXAN | Assign Division to Sales Organization |
| OVXB | Divisions |
| OVXC | Assign Shipping Point to Plant |
| OVXD | Shipping Points |
| OVXG | Define Sales Areas |
| OVXGN | Define Sales Areas |
| OVXI | Distribution Channels |
| OVXJ | Assign Sales Group to Sales Office |
| OVXJN | Assign Sales Group to Sales Office |
| OVXK | Assign Distribution Channels to Sales Organization |
| OVXKN | Assign Distribution Channels to Sales Organization |
| OVXM | Assign Sales Office to Sales Area |
| OVXMN | Assign Sales Office to Sales Area |
| OVXT | Transportation Planning Points |
| OVZ4 | Maintain Factory Calendar |
| OX09 | Customize Storage Locations |
| OX10 | Customize Plant |
| OY05 | Factory Calendar |
| SCAL | Factory Calendar with GUI |
| VOR1 | Common Distribution Channel |
| VOR2 | Common Division |
Table A-3 Codes Related to Chapter 3, “Master Data in SD”
| Tcode | Description |
| VD01 | Create Customer (Sales View) |
| VD02 | Change Customer (Sales View) |
| VD03 | Display Customer (Sales View) |
| VD04 | Customer Changes (SD) |
| VD05 | Block Customer (Sales View) |
| VD06 | Mark Customer for Deletion (Sales View) |
| FD01 | Create Customer (Accounting View) |
| FD02 | Change Customer (Accounting View) |
| FD03 | Display Customer (Accounting View) |
| FD04 | Display Customer Account Changes (Accounting View) |
| FD05 | Block Customer (Accounting View) |
| FD06 | Mark Customer for Deletion (Accounting View) |
| XD01 | Create Customer (Centrally) |
| XD02 | Change Customer (Centrally) |
| XD03 | Display Customer (Centrally) |
| XD04 | Customer Changes (Centrally) |
| XD05 | Block Customer (Centrally) |
| XD06 | Mark Customer for Deletion (Centrally) |
| XD07 | Change Customer Account Group |
| XD99 | Customer Master Mass Maintenance |
| XDN1 | Maintain Number Ranges (Customer) |
| OVT0 | Define Account Group and Field Selection for Customer |
| OB20 | Define Transaction-Dependent Screen Layout |
| VAP1 | Create Contact Person |
| VAP2 | Change Contact Person |
| VAP3 | Display Contact Person |
| V-12 | Create Customer Hierarchy Node |
| OVH1 | Define Hierarchy Type |
| OVH2 | Allowed Account Group Assignment for Customer Hierarchy |
| OVH3 | Allowed Sales Area Assignment for Customer Hierarchy |
| OVH4 | Hierarchy Type for Pricing |
| VDH1 | Customer Hierarchy Maintenance (SD) |
| VDH1N | Display/Maintain Customer Hierarchy |
| VDH2 | Display Customer Hierarchy |
| VDH2N | Display Customer Hierarchy |
| MM01 | Create Material Master |
| MM02 | Change Material Master |
| MM03 | Display Material Master |
| MM04 | Display Material Changes |
| MM06 | Flag Material for Deletion |
| MM16 | Schedule Material for Deletion |
| MMAM | Change Material Type |
| MMPV | Close Material Period |
Table A-4 Codes Related to Chapter 4, “Partner, Text, and Output Determination”
| Tcode | Description |
| VOPAN | Customizing Partners |
| VOTXN | Maintain Text Customizing |
| V/56 | Create Output Condition Table (Sales Document) |
| V/57 | Change Output Condition Table (Sales Document) |
| V/58 | Display Output Condition Table (Sales Document) |
| V/48 | Maintain Output Access Sequences (Sales Document) |
| V/30 | Maintain Output Types (Sales Document) |
| V/32 | Maintain Output Determination Procedure (Sales Document) |
| V/59 | Create Output Condition Table (Delivery Document) |
| V/60 | Change Output Condition Table (Delivery Document) |
| V/61 | Display Output Condition Table (Delivery Document) |
| V/50 | Maintain Output Access Sequences (Delivery Document) |
| V/34 | Maintain Output Types (Delivery Document) |
| V/36 | Maintain Output Determination Procedure (Delivery Document) |
| V/77 | Create Output Condition Table (Shipment & Transport) |
| V/78 | Change Output Condition Table (Shipment & Transport) |
| V/79 | Display Output Condition Table (Shipment & Transport) |
| V/80 | Maintain Output Access Sequences (Shipment & Transport) |
| V/82 | Maintain Output Types (Shipment & Transport) |
| V/84 | Maintain Output Determination Procedure (Shipment & Transport) |
| V/93 | Create Output Condition Table (Packaging) |
| V/94 | Change Output Condition Table (Packaging) |
| V/95 | Display Output Condition Table (Packaging) |
| V/96 | Maintain Output Access Sequences (Packaging) |
| V/97 | Maintain Output Types (Packaging) |
| V/99 | Maintain Output Determination Procedure (Packaging) |
| V/62 | Create Output Condition Table (Billing Document) |
| V/63 | Change Output Condition Table (Billing Document) |
| V/64 | Display Output Condition Table (Billing Document) |
| V/54 | Maintain Output Access Sequences (Billing Document) |
| V/40 | Maintain Output Types (Billing Document) |
| V/42 | Maintain Output Determination Procedure (Billing Document) |
| VV11 | Create Output Condition Records: Sales |
| VV12 | Change Output Condition Records: Sales |
| VV13 | Display Output Condition Records: Sales |
| VV21 | Create Output Condition Records: Shipping |
| VV22 | Change Output Condition Records: Shipping |
| VV23 | Display Output Condition Records: Shipping |
| VV31 | Create Output Condition Records: Billing |
| VV32 | Change Output Condition Records: Billing |
| VV33 | Display Output Condition Records: Billing |
| VV61 | Create Output Condition Records: Handling Units |
| VV62 | Change Output Condition Records: Handling Unit |
| VV63 | Display Output Condition Records: Handling Unit |
| VV71 | Create Output Condition Records: Transportation |
| VV72 | Change Output Condition Records: Transportation |
| VV73 | Display Output Condition Records: Transportation |
| VF31 | Output from Billing Documents |
| VL70 | Output from Picking Lists |
| VL71 | Output from Outbound Deliveries |
| VL72 | Output from Groups of Deliveries |
| VL74 | Output from Handling Units |
| VL75 | Shipping Notification Output |
| VT70 | Output for Shipments |
| SO10 | Standard Text Maintenance |
Table A-5 Codes Related to Chapter 5, “Pricing and Tax Determination”
| Tcode | Description |
| OV24 | Field Catalog for Pricing Condition Table |
| V/03 | Create Pricing Condition Table |
| V/04 | Change Pricing Condition Table |
| V/05 | Display Pricing Condition Table |
| V/07 | Maintain Pricing Access Sequence |
| V/06 | Maintain Pricing Condition Type |
| OVB2 | Define Upper and Lower Limit for Pricing Conditions |
| V/08 | Maintain Pricing Procedure |
| OVKI | Define Document Pricing Procedure |
| OVKJ | Assign Document Pricing Procedure to Sales Document |
| OVTP | Assign Document Pricing Procedure to Billing Documents |
| OVKP | Define Customer Pricing Procedure |
| OVKK | Define Pricing Procedure Determination |
| OVKO | Pricing for Item Categories |
| VCHECKT683 | Customizing Check Pricing Procedure |
| VCHECKT685A | Customizing Check Condition Types |
| VK11 | Create Pricing Condition Record |
| VK12 | Change Pricing Condition Record |
| VK13 | Display Pricing Condition Record |
| VK31 | Condition Maintenance: Create |
| VK32 | Condition Maintenance: Change |
| VK33 | Condition Maintenance: Display |
| OV23 | Condition Exclusion Indicator |
| OV30 | Condition Exclusion: Procedure Assignment |
| OV31 | Maintain Exclusion Group |
| OV32 | Maintain Condition Types for Exclusion Group |
| VOK8 | Maintain Condition Exclusion for Pricing Procedure |
| OVSI | Price List Categories |
| OVSJ | Material Condition Group |
| OVSL | Pricing Groups for Customers |
| V/LA | Create Pricing Report |
| V/LB | Change Pricing Report |
| V/LC | Display Pricing Report |
| V/LD | Execute Pricing Report |
| V/LE | Generate Pricing Reports |
| V/N1 | Maintain Accesses (Free Goods—sls) |
| V/N2 | Create Free Goods Table |
| V/N3 | Display Free Goods Table (SD) |
| V/N4 | Free Goods Types—Sales |
| V/N5 | Free Goods: Procedure for SD |
| V/N6 | Free Goods Procedure Determ. SD |
| V-45 | Create Price List |
| V-46 | Create Price List w/Ref. |
| V-47 | Change Price List |
| V-48 | Display Price List |
| V_NL | Edit Net Price List |
| S_ALR_87100142 | Price List Report |
| S_ALR_87100160 | Price List Report |
| OVK1 | Taxes: Tax Catg./Country |
| OVK2 | Taxes: Regions |
| OVKF | US Tax—Set Up Ctry/Region/County |
| OVKG | US Tax—Set Up Ctry/Region/City |
| OVK3 | Taxes: Customer Taxes |
| OVK4 | Taxes: Material Taxes |
| FTXP | Maintain Tax Code |
| OVKB | Tax Record Conditions VK11—Selection by Country |
| OVKC | Tax Record Conditions VK12—Selection by Country |
| OVKD | Tax Record Conditions VK13—Selection by Country |
| OVKE | Tax Record Conditions VK14—Selection by Country |
Table A-6 Codes Related to Chapter 6, “Availability Check, Transfer of Requirements, and Backorders”
| Tcode | Description |
| OVZ0 | Activate AC & TOR at Requirement Class Level |
| OVZG | Activate AC & TOR at Requirement Class Level |
| OVZH | Requirement Class Assignment to Requirements Types |
| OVZI | Rules for Determining Requirement Type Using Transactions |
| OVZ8 | Availability Check Procedure by Schedule Line Category |
| OVZ2 | Define Checking Group |
| OVZ9 | Define Scope of Availability Check |
| OVZ3 | Define Checking Group Default Value |
| OVZJ | Default Values for Availability Check by Sales Area |
| OVZ1 | Define Material Block for Other Users |
| OVZ7 | Block Quantity Confirmation in Delivery Block |
| OVZK | Procedure per Delivery Item Category |
| OMIH | Check. Rule for Updating Backorders |
| CO09 | Availability Overview |
| MB53 | Display Plant Stock Availability |
| MD04 | Display Stock/Requirements Situation |
| MMBE | Stock Overview |
| V.15 | Display Backorders |
| V_R1 | List of Backorders |
| V_R2 | Display List of Backorders |
| V_RA | Backorder Processing: Selection List |
| V_V2 | Updating Sales Documents by Material |
Table A-7 Codes Related to Chapter 7, “Sales”
| Tcode | Description |
| VA00 | Initial Sales Menu |
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VA03 | Display Sales Order |
| VA05 | List of Sales Orders |
| VA05N | List of Sales Orders |
| VA11 | Create Inquiry |
| VA12 | Change Inquiry |
| VA13 | Display Inquiry |
| VA14L | Sales Documents Blocked for Delivery |
| VA15 | Inquiries List |
| VA15N | Inquiries List |
| VA21 | Create Quotation |
| VA22 | Change Quotation |
| VA23 | Display Quotation |
| VA25 | Quotations List |
| VA25N | List of Quotations |
| VA26 | Collective Processing for Quotations |
| VA31 | Create Scheduling Agreement |
| VA32 | Change Scheduling Agreement |
| VA33 | Display Scheduling Agreement |
| VA35 | List of Scheduling Agreements |
| VA35N | List of Scheduling Agreements |
| VA41 | Create Contract |
| VA42 | Change Contract |
| VA43 | Display Contract |
| VA45 | List of Contracts |
| VA45N | List of Contracts |
| VA46 | List of Contracts for Subsequent Processing |
| VOV6 | Maintain Schedule Line Categories |
| VOV7 | Maintain Item Categories |
| VOV8 | Document Type Maintenance |
| VTAA | Copy Control—Sales Document to Sales Document |
| VTAF | Copy Control—Billing Document to Sales Document |
| OVAO | Allowable Sales Document by Sales Area—Combine Sales Organization |
| OVAM | Allowable Sales Document by Sales Area—Combine Distribution Channels |
| OVAN | Allowable Sales Document by Sales Area—Combine Divisions |
| OVAZ | Assign Sales Order Type permitted for Sales Area |
| OVAU | Define Order Reasons |
| OVAS | Define Blocking Reasons |
| OVAL | Assign Blocking Reasons to Sales Document Types |
| OVAG | Define Rejection Reasons |
| OVA0 | Define Status Groups for Incompletion Procedure |
| OVA2 | Define Incompletion Procedure |
| V_UC | Incomplete Sales Documents |
| V.00 | List of Incomplete Documents |
| V.01 | List of Incomplete SD Documents |
| V.02 | List of Incomplete Sales Orders |
| V.03 | List of Incomplete Inquiries |
| V.04 | List of Incomplete Quotations |
| V.05 | List of Incomplete Scheduling Agreements |
| V.06 | List of Incomplete Contracts |
| V23 | Sales Documents Blocked for Billing |
| VCHECKTVCPF | Customizing Check Copying Control |
| VCU3 | Display Incompletion Log |
| VOVL | Cancellation Rules |
| VOVM | Cancellation Procedures |
| VOVN | Assignment Rules/Cancellation Proc. |
| VOVO | Val. Period. Category |
| VOVP | Rule Table for Date Determination |
| VOVQ | Cancellation Reasons |
Table A-8 Codes Related to Chapter 8, “Shipping and Transportation”
| Tcode | Description |
| VL01N | Create Delivery Document |
| VL02N | Change Delivery Document |
| VL03N | Display Delivery Document |
| VL10 | User-Specific Delivery Scenario |
| VL10A | Sales Order, Fast Display |
| VL10B | Purchase Order, Fast Display |
| VL10C | Sales Order Item Display |
| VL10D | Purchase Order Item Display |
| VL10E | Sales Orders, Schedule Lines |
| VL10F | Purchase Order Item Schedule Lines |
| VL10G | Sales and Purchase Orders Fast Display |
| VL10H | Sales and Purchase Order Items Fast Display |
| VL10I | Sales and Purchase Order Schedule Lines |
| VL06P | Outbound Deliveries for Picking |
| LT03 | Create Transfer Order |
| LT21 | Display Transfer Order |
| LT12 | Confirm Transfer Order |
| LT15 | Cancel Transfer Order |
| HUPAST | Packing Station |
| VT01N | Create Shipment |
| VT04 | Collective Processing of Shipments |
| VT02N | Change Shipment |
| VT03N | Display Shipment |
| VT70 | Output for shipment |
| VL06G | Outbound Deliveries for Goods Issue |
| VL09 | Cancel Goods Issue |
| VTRK | Parcel Tracking |
| 0VLK | Define Delivery Types |
| 0VLP | Define Item Categories for Deliveries |
| 0184 | Define Item Category Determination |
| VTLA | Define Copy Controls for Deliveries |
| OVLP | Maintain Delivery Item Categories for Picking |
| 0VTC | Define Routes And Stages |
| MCTA | Customer Analysis Report |
| MCTC | Material Analysis |
| MCTE | Sales Organization Analysis |
| MCTK | Shipping Point Analysis |
| MCTI | Sales Employee Analysis |
| MCTG | Sales Office Analysis |
| MCYI | Exception Analysis |
| MCSI | User-Defined Analysis |
| MC/Q | Create Exception |
| MC/R | Change Exception |
| MC/S | Display Exception |
Table A-9 Codes Related to Chapter 9, “Billing”
| Tcode | Description |
| VF01 | Create Billing Document |
| VF02 | Change Billing Document |
| VF03 | Display Billing Document |
| VF04 | Maintain Billing Due List |
| VF05 | List Billing Documents |
| VF05N | List of Billing Documents—New Worklist in ECC |
| VF06 | Batch Billing |
| VF08 | Billing for External Delivery |
| VFRB | Retro-Billing |
| VF11 | Cancel Billing Document |
| VF21 | Create Invoice List |
| VF22 | Change Invoice list |
| VF23 | Display Invoice List |
| VF24 | Edit Work List for Invoice Lists |
| VF25 | List of Invoice Lists |
| VF26 | Cancellation Invoice List |
| VFX2 | Display Blocked Billing Documents |
| VFX3 | List Blocked Billing Documents |
| VOEX | Incompleteness: Billing Document |
| VOF1 | Configuration: Collective Billing |
| VOF2 | Configuration Invoice List Info |
| VOF3 | Edit Work List for Invoice Lists |
| VOFA | Billing Doc: Document Type |
| VOFM | Configuration for Requirements, Formulae |
| VOFS | Billing: Document Types |
| OVV7 | Assign Invoice List to Billing Documents |
| OVV4 | Billing Blocking Reasons |
| OVVA | Sales Organization Assignment to Intercompany Customer Number |
| OVV8 | Sales Order Types to Intercompany Billing Document Type Assignment |
| OVVR | Processing Groups for Invoice List |
| VTFF | Copy Control from Billing Document to Billing Document |
| VTFL | Copy Control from Delivery to Billing Document |
| VTFA | Copy Control from Order Document to Billing Document |
| CMP_PROCESSING | Complaint Processing |
| SCAL | Billing Schedule |
| OVBI | Maintain Billing Plan Type for Periodic Billing |
| OVBO | Maintain Billing Plan Type for Milestone Billing |
| OVBM | Maintain Date Proposals for Billing Plan |
| OVBJ | Maintain Date Category for Billing Plan Type |
| OVBL | Assign Date Category Proposal for Billing Plan |
| OVBS | Maintain Rule for Date Determination |
| OVBP | Assignment of Billing Plan Type |
| OVBR | Assignment of Billing Plan Type to Item Category |
| OVBN | Maintain Date IDs |
| VCHECKVOFA | Customizing Check Billing Types |
| VBO1 | Create Rebate Agreement |
| VBO2 | Change Rebate Agreement |
| VBO3 | Display Rebate Agreement |
| OVB3 | Reorganization of Billing Index for Rebates |
| OVB1 | Rebate Activation at Sales Organization Level |
| VB(1 | Rebate Number Ranges |
| VB(2 | Set Up Rebate Agreement Type |
| VB(3 | Rebate Condition Type Groups Overview |
| VB(4 | Condition Types in Condition Type Groups |
| VB(5 | Assignment Condition -> Condition Type Group |
| VB(6 | Rebate Group Maintenance |
| VB(7 | Rebate Agreement Settlement |
| VB(8 | List Rebate Agreements |
| OV20 | Create Condition Table for Rebates |
| OV21 | Change Condition Table for Rebates |
| OV22 | Display Condition Table for Rebates |
| OV28 | Field Catalog for Rebates |
| VCHECKBONUS | Customizing Check for Rebate |
| FCRD | Payment Card User Menu |
| FKPC | Payment Card Processing |
| FPPCSL | Log Display for Payment Card |
| FPPCTC | Payment Card—Items to Be Invoiced |
| FPPCAI | PCARD: Items in Card Account |
| FPPCAS | PCARD: Invoiced items |
| FPPCBP | PCARD: Business Partner with Cards |
| FPPCDL | PCARD: Delete Logs |
| FPPCDS | PCARD: Perform Invoicing |
| FPPCLI | PCARD: Log (Paid Items) |
| FPPCLP | PCARD: Log (Payments) |
| FPPCSF | PCARD: Display Invoicing File |
| OV80 | Create Condition Table for Payment Card Account Determination |
| OV81 | Change Condition Table for Payment Card Account Determination |
| OV82 | Display Condition Table for Payment Card Account Determination |
| OV83 | Field Catalog for Condition Tables for Payment Card Account Determination |
| OV84 | Access Sequence for Payment Card Account Determination |
| OV85 | Condition Type for Payment Card Account Determination |
| OV86 | Condition Procedure for Payment Card Account Determination |
| OV87 | Credit Card Accounts |
| OV88 | Assign Billing Type to Credit Card Procedure |
| OV9A | Card Authorization Requirements |
| PACC1 | Verification Rule for Card Numbers |
| PACC2 | Maintain Payment Card Type |
| VCC1 | Payment Cards Worklist |
| S_ALR_87014369 | Payment Card Authorization in Background |
Table A-10 Codes Related to Chapter 10, “Account Assignment and Revenue Recognition”
| Tcode | Description |
| OVK5 | Material Account Assignment Groups |
| OVK8 | Customer Account Assignment Groups |
| OV25 | Field Catalog |
| V/12 | Create Account Determination Condition Table |
| V/13 | Change Account Determination Condition Table |
| V/14 | Display Account Determination Condition Table |
| V/10 | Maintain Access Sequence for Account Determination |
| V/09 | Maintain Condition Types for Account Determination |
| V/11 | Maintain Account Determination Procedure |
| VKOA | Assign GL accounts for Account Determination |
| OVUR | Assign Accounts for Unbilled Receivables |
| OVEP | Set Revenue Recognition for Item Categories |
| VF44 | Revenue Recognition Worklist |
| VF45 | Revenue Report |
| VF46 | Revenue Recognition Cancellation |
| VF47 | Revenue Recognition Consistency Check |
| VF48 | Revenue Recognition Compare Report |
Table A-11 Codes Related to Chapter 11, “Credit Management”
| Tcode | Description |
| F.28 | Customers: Reset Credit Limit |
| F.31 | Credit Management—Overview |
| F.32 | Credit Management—Missing Data |
| F.33 | Credit Management—Brief Overview |
| F.34 | Credit Management—Mass Change |
| F.35 | Credit Master Sheet |
| FCV1 | Create A/R Summary |
| FCV2 | Delete A/R Summary |
| FCV3 | Early Warning List |
| FD10N | Customer Balance Display |
| FD11 | Customer Account Analysis |
| FD24 | Credit Limit Changes |
| FD32 | Change Customer Credit Management |
| FD33 | Display Customer Credit Management |
| FD37 | Credit Management Mass Change |
| FDK43 | Credit Management—Master Data List |
| OB01 | Define Risk Categories |
| OB12 | Define Credit Management Groups |
| OB45 | Define Credit Control Area |
| OB51 | Define Credit Representative |
| OBY6 | Assign Credit Control Area to Company Code |
| OBZJ | Define Client Specific Setting for Credit Management—AR Summary and DSO Calculation Setup |
| OBZK | Permitted Credit Control Area for Company Code |
| OVA6 | Define Credit Groups |
| OVA7 | Credit Relevancy of Item Categories |
| OVA8 | Automatic Credit Checks |
| OVAD | Assign Credit Groups to Delivery Document Type |
| OVAK | Assign Credit Groups to Sales Order Type |
| OVBD | Assign Credit Control Area |
| OVFL | Assign Credit Control Area to Sales Area |
| S_ALR_87012214 | Customers with Missing Credit Data |
| S_ALR_87012215 | Display Changes to Credit Management |
| S_ALR_87012216 | Credit Limit Overview |
| S_ALR_87012217 | Credit Overview |
| S_ALR_87012218 | Credit Master Sheet |
| S_ALR_87012219 | Credit Mgmt: Early Warning List |
| S_ALR_87012220 | Reset Credit Limit for Customers |
| S_ALR_87012221 | Credit Limit Data Mass Change |
| VKM1 | Credit Management—Process Blocked SD Documents |
| VKM2 | Credit Management—Process Released SD Documents |
| VKM3 | Credit Management—Process Sales Documents |
| VKM4 | Credit Management—Process SD Documents |
| VKM5 | Credit Management—Process Delivery Documents |
Table A-12 Codes Related to Chapter 12, “Material Determination, Listing, Exclusion, and Proposals”
| Tcode | Description |
| OV05 | Material Listing/Exclusion—Condition Table Create |
| OV06 | Material Listing/Exclusion—Condition Table Change |
| OV07 | Material Listing/Exclusion—Condition Table Display |
| OV27 | Material Listing/Exclusion—Field Catalog |
| OV01 | Access Sequence Maintenance for Material Listing/Exclusion |
| OV02 | Condition Type Maintenance for Material Listing/Exclusion |
| OV03 | Determination Procedure for Material Listing/Exclusion |
| OV04 | Procedure to Sales Document Type Assignment |
| VB01 | Create Material Listing/Exclusion |
| VB02 | Change Material Listing/Exclusion |
| VB03 | Display Material Listing/Exclusion |
| VB04 | Reference Material Listing/Exclusion |
| OV16 | Create Condition Table for Material Determination |
| OV17 | Change Condition Table for Material Determination |
| OV18 | Display Condition Table for Material Determination |
| OV11 | Material Determination Access Sequence |
| OV12 | Material Determination Condition Type |
| OV13 | Material Determination Procedure |
| OV14 | Material Determination Procedure Assignment to Sales Document |
| OV26 | Material Determination Field Catalog |
| OVRQ | Material Determination Substitution Reasons |
| VB11 | Create Material Substitution |
| VB12 | Change Material Substitution |
| VB13 | Display Material Substitution |
| VB14 | Reference Material Substitution |
| VA51 | Create Item Proposal |
| VA52 | Change Item Proposal |
| VA53 | Display Item Proposal |
| VA55 | List of Item Proposals |
| VD51 | Create Customer-Material Info Record |
| VD52 | Change Customer-Material Info Record |
| VD53 | Display Customer-Material Info Record |
| VD54 | Display Customer-Material Info Records |
| VD59 | List of Customer-Material Info Records |
Table A-13 Codes Related to Chapter 13, “Serial Numbers and Batch Management”
| Tcode | Description |
| OIS2 | Maintain Serial Number Profile |
| OIS1 | Global Parameters for Serial Numbers |
| IQ01 | Create Material Serial Number |
| IQ02 | Change Material Serial Number |
| IQ03 | Display Material Serial Number |
| IQ04 | Create Material Serial Number (List Entry) |
| IQ08 | Change Material Serial Number (Serial Number Selection) |
| IQ09 | Display Material Serial Number (Serial Number Selection) |
| MSC1N | Create Batch |
| MSC2N | Change Batch |
| MSC3N | Display Batch |
| MSC4N | Display Change Documents for Batch |
| MSC5N | Mass Processing for Batch |
| MSC6N | Batch Worklist |
| OMAB | Initial Status of a New Batch (Material Type) |
| OMAC | Definition Initial Status Batch (Plant and Material Type) |
| OMAD | Number Ranges for Batch Numbers |
| OMCZ | Activate Batch Number Allocation |
| OMCE | Define Batch Level |
| OMCS | Activate Batch Status Management |
| OMCT | Batch Definition |
| V/C1 | Maintain Strategy Types for SD Batch Determination |
| V/C2 | Maintain Access Sequence for SD Batch Determination |
| V/C3 | Batch Determination: Procedure for SD |
| V/C5 | Batch Search Procedure Determination |
| V/C6 | Field Catalog for Batch |
| V/C7 | Create Condition Table for SD Batch |
| V/C8 | Change Condition Table for SD Batch |
| V/C9 | Display Condition Table for SD Batch |
| V/CA | Automatic Batch Determination in Sales Order |
| V/CL | Automatic Batch Determination in Delivery |
| VCH1 | Create Batch Search Strategy |
| VCH2 | Change Batch Search Strategy |
| VCH3 | Display Batch Search Strategy |
Table A-14 Codes Related to Chapter 14, “Advanced Techniques”
| Tcode | Description |
| BAPI | BAPI Repository |
| WE02 | Display IDOC |
| WE20 | Set Up EDI Partner Profile |
| WE19 | Test Tool for IDOC Processing |
| WEDI | EDI/IDOC Basis |
| WE60 | Documentation for IDOC Types |
| BD87 | Process Failed IDOCs |
| SM37 | Job Selection Screen |
| SM36 | Define Background Job |
| SE37 | Function Builder |
| SM35 | Process BDC Session |
| SCAT | Computer Aided Test Tool |
| SECATT | Extended Computer Aided Test Tool |
| SHDB | Transaction Recorder |
| LSMW | Legacy System Migration Workbench |
| SQ01 | Create User |
| SQ02 | Create Infoset |
| SQ03 | ABAP Query |
| SQVI | ABAP Query—Quick Viewer |
| SMOD | SAP Enhancements |
| CMOD | Project Management for SAP Enhancements |
| SE18 | BADI Builder |
| SE11 | ABAP Dictionary |
| SE16 | Data Browser |
| SE16N | Data Browser—General Table Display |
| SE38 | ABAP Editor |
| SE80 | ABAP Development Workbench |
| SE93 | Maintain Transactions |
| /h | Activate Debugging from a Transaction |
| SFW5 | Switch Framework Customizing |
| MASS | Mass Update |
| MC21 | Create Info Structure |
| MC22 | Change Info Structure |
| MC23 | Display Info Structure |
| OVRA | Maintain Statistics Group for Customer |
| OVRF | Maintain Statistics Group for Materials |
| OVRN | Maintain Statistics Group for Document and Item Categories |
| MC24 | Maintain Update Rules |
| MC25 | Change Update Rules |
| MC26 | Display Update Rules |
| OVRO | Assign Update Group at Header Level |
| OVRP | Assign Update Group at Item Level |
Table A-15 General Utility Tables
| Table | Description |
| TSTC | Transaction Code with Corresponding Program Names |
| TSTCT | Text for TSTC Table Entries |
| TBTCP | Program Names with Corresponding Batch Job Names |
Table A-16 Master Data Tables
| Table | Description |
| MARA | Material Master—General Material Data |
| MAKT | Material Master—Material Descriptions |
| MARC | Material Master—Plant Data for Material |
| MARD | Material Master—Storage Location Data for Material |
| MARM | Material Master—Units of Measure for Material |
| MDTB | Material Master—MRP Table |
| MLAN | Material Master—Tax Classification for Material |
| MVKE | Material Master—Sales Data for Material |
| STKO | BOM Header |
| STOP | BOM Item |
| STPU | BOM Subitem |
| STAS | BOMs Item Selection |
| STPN | BOM Follow-up Control |
| STPF | Structure Tree of the Exploded BOM |
| STST | Standard BOM Link |
| MAST | Material to BOM Link |
| KNA1 | Customer Master—General Data |
| KNB1 | Customer Master—Company Code Data |
| KNVV | Customer Master—Sales Area Data |
| KNBK | Customer Master—Bank Details |
| KNVP | Customer Master—Partner Functions |
| KNVA | Customer Master—Loading Points |
| KNVS | Customer Master—Shipping Data |
| KNVT | Customer Master—Sales Text |
| KNVK | Customer Master—Contact Person |
| KNVH | Customer Master—Customer Hierarchy |
| KNVI | Customer Master—Tax Indicator |
| KNMT | Customer-Material Info Record Data |
| KNMTK | Customer-Material Info Record Header |
| KNKK | Customer Credit Master Data |
| KNKKF1 | FI Status Data |
| KNKKF2 | Open Items by Days in Arrears |
| KONP | Pricing Condition Values |
Table A-17 Tables Storing SD-Related Transaction Data
| Table | Description |
| VBAK | Sales Document Header |
| VBAP | Sales Document Item |
| VBEP | Sales Document Schedule Line Category |
| VBPA | Sales Document Partners Data |
| VBKD | Business Data |
| VBBE | Sales Requirements: Individual Records |
| VBBS | Sales Requirement Totals Record |
| KONV | Sales Document Pricing Conditions—Transaction Data |
| VBFA | Sales Document Flow |
| VBUK | Sales Document Header Status |
| VBUP | Sales Document Item Status |
| VEDA | Contract Data |
| KDST | Sales Order to BOM Link |
| CDHDR | Change Record for SD Documents—Header |
| CDPOS | Change Record for SD Documents—Items |
| LIKP | Delivery Document Header |
| LIPS | Delivery Document Item |
| MKPF | Material Document—Header |
| MSEG | Material Document—Item |
| LTAK | Transfer Order—Header |
| LTAP | Transfer Order—Item |
| VTTK | Shipment Header |
| VTTP | Shipment Item |
| VTTS | Stage in Transport |
| VTSP | Stage in Transport per Shipment Item |
| VTPA | Shipment Partners |
| VEKP | Handling Unit—Header Table |
| VEPO | Handling Unit—Item Table |
| VTFA | Shipment Document Flow |
| VBRK | Billing Document Header |
| VBRP | Billing Document Item |
| VBOX | Rebate Index |
| VBREVK | Revenue Recognition—Control Lines |
| VBREVE | Revenue Recognition Lines |
| VBRL | Invoice List |
| FPLTC | Payment Card Data |
| CCARDEC | Payment Card Encryption Data |
| SER00 | General Header Table for Serial Number Management |
| SER01 | Document Header for Serial Number for Deliveries |
| SERI | Serial Numbers |
| MCHA | Batches |
| MCH1 | Batches (If Batch Management Cross Plant) |
| MCHB | Batch Stocks |
| MCHBH | Batch Stocks: History |
| MCHP | Batch Record for a Batch |
Table A-18 Miscellaneous Tables
| Table | Description |
| NAST | Output Message Control—Status |
| NACH | Printer Determination for Output |
| TNAPR | Processing Program for Outputs |
| STXB | SAPscript: Texts in Non-SAPscript Format |
| STXH | SAPscript Text File Header |
| STXL | SAPscript Text File Lines |
| EDIDC | Control Record (IDOC) |
| EDIDD | Data Record (IDOC) |
| EDIDS | Status Record (IDOC) |
| EDPAR | Convert External < > Internal Partner Number |
| EDPVW | Partner Functions Allowed for EDI |
| EDPI1 | EDI: Partner Profiles (Inbound) |
| EDPO1 | EDI Table for Partner Profiles (Outbound), Level 1 |
| EDPO3 | EDI Table for Partner Profiles (Outbound), Level 2 |
Table A-19 Composite Views on Database Tables
| Table | Description |
| VB_DEBI | View of KNA1, KNB1, and BSID |
| KNA1VV | View of KNA1 and KNVV Table |
| MAPOV | View of MARA, MAKT, and MVKE Table |
| MAWEV | Material/Plant/Sales View (MARA, MARC, MLAN Table) |
| VBAKUK | View of VBAK and VBUK Table |
| LIKPUK | View of LIKP and VBUK |
| LIPSUP | View of LIPS and VBUP |
| VIVEDA | View of VBAK and VBAP |
Table A-20 Condition Tables
| Table | Description |
| Axxx | Pricing Condition Tables |
| Bxxx | Output Condition Tables |
| Cxxx | Account Determination Condition Tables |
| Dxxx | Material Determination Condition Tables |
| Exxx | Rebate Condition Tables |
| Gxxx | Material Listing/Exclusion Condition Tables |
| Hxxx | Batch Determination Condition Tables |
| Nxxx | Free Goods Determination Condition Tables |
The following are some additional resources:
- SAP SDN website: http://sdn.sap.com
- SAP Help website: http://help.sap.com
- SAP service marketplace website: http://service.sap.com
- For supplementary information, updates, and useful tips and tricks:http://sapsdbook.wordpress.com