- ABAP Snippets
- Top SAP Courses
- Top SAP Books
SAP and ABAP Free Tutorials
SAP Sales Order Tables in SAP SD
SAP Sales Order Table post will contain the list of important tables for Sales Order.
First we will list the main tables, then the whole list of Sales Document related tables in SAP.
Table of Contents
SAP Sales Order Table
Main sap order tables.
The main tables for Sales Order Tables are:
- VBAK : Sales Order Document Header
- VBAP : Item for Sales Order Data
- VBPA : SAP Sales Document Partners
All SAP Order Table List
The following SO SAP Tables List contains all related tables for Sales Order.
These Tables store all the information for Sales Order.
Here the list of Sales Order Tables in SAP SD (Sales and Distribution).
Source: Sales Order Tables (scn)
Further reading for SAP Sales Order
If you want to go further on Sales Order in SAP, check the following Books
- How To Implement SAP SD- Sales Order-To-Billing Process For ICT Service Corporation (SAP ERP for ICT Service Corporation Book 2)
- ABAP Development for Sales and Distribution in SAP: Exits, BAdIs, and Enhancements (Sap Essentials)
Related Posts
The Most Important SAP ISU Tables
December 22, 2020 November 7, 2021
The Main SAP Dunning Transaction Codes
November 28, 2019 January 21, 2020
SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP AP Tcodes & SAP AR Tcodes)
August 1, 2019 May 5, 2020
Sap sales order account assignment Table in SAP
- CRMC_ACC_MAP Table for Assignment of Account Assignment Group to Account Table Type : TRANSP Package : CRM_LEASING_SRM Module : CRM-LAM-BTX
- SMOTVAKZ Table for Sales Documents: Allowed Order Types per Sales Org. 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
- /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
- T460C Table for Order/Purchase order types for planned order Table Type : TRANSP Package : MD Module : CRM
- T460D Table for Order/Purchase order types for planned order Table Type : POOL Package : MD Module : CRM
- 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
- SDEMO_SO_SI Table for SAP NetWeaver Demo Model - Sales Order Item Status Table Type : TRANSP Package : S_NWDEMO_MODEL_SALES_ORDER Module : BC-SRV-NWD
- SDEMO_SO_SL Table for SAP NetWeaver Demo Model - Sales Order Item Schedule Line Table Type : TRANSP Package : S_NWDEMO_MODEL_SALES_ORDER Module : BC-SRV-NWD
- SDEMO_SO_ST Table for SAP NetWeaver Demo Model - Sales Order Header Status Table Type : TRANSP Package : S_NWDEMO_MODEL_SALES_ORDER Module : BC-SRV-NWD
- ACCRAC Table for Assignment of Acr./Def. G/L Account to Accruals Account Table Type : TRANSP Package : ACCR Module : FI
- BKK610 Table for Account Hierarchy: Assignment of Root Account to Tree Number Table Type : TRANSP Package : FKBR Module : IS-B-BCA-MD
- KOMU Table for Account Assignment Templates for G/L Account Items Table Type : TRANSP Package : FFE Module : FI
- PKOMU Table for Personal Account Assignment Templates for G/L Account Items Table Type : TRANSP Package : FFE Module : FI
- TIVSCTRANSACC Table for Assignment of Clearing Account to Cost Account Table Type : TRANSP Package : RE_SC_BC Module : RE-FX-SC
- TZB27 Table for Assignment of G/L account to account group Table Type : TRANSP Package : FVVD_PAYMENT Module : FS-CML-AC-RPM
- CRMD_CO_HEADER Table for CO Account Assignment of Sales Transactions Table Type : TRANSP Package : CRM Module : CRM
- CRMD_CO_ITEM Table for CO Account Assignment of Sales Items Table Type : TRANSP Package : CRM Module : CRM
- TJJAF Table for IS-M/AM: Account Assignment Group for Sales Agent Contract Table Type : TRANSP Package : JAS Module : IS-M
- TJJAG Table for Account Assignment Group for Sales Agent Contract - Text Table Type : TRANSP Package : JAS Module : IS-M
- TOIAF Table for Sales Fee Account Assignment Table Type : TRANSP Package : OIA Module : CRM
- TCOKT Table for Account assignment categories for order Table Type : TRANSP Package : CO Module : CRM-CIC
- /BEV1/RSFFROR Table for Order Information for Account Assignment Table Type : TRANSP Package : /BEV1/RS Module : SD-SLS-PLL-OBS
- JJTVT Table for Requirement - Sales Area Assignment (Media Sales Agent) Table Type : TRANSP Package : JAS Module : IS-M
- VISRTMMSBSB Table for Assignment of a Sales Rule to a Peak Sales Rule Table Type : TRANSP Package : RE_SR_TM Module : RE-FX-SR
- JHAGVX Table for IS-M/AM: Order Sales Agent Assignment Settlement Index Table Type : TRANSP Package : JAS Module : IS-M
- JHAGVZ Table for IS-M/AM: Order Sales Agent Assignment Table Type : TRANSP Package : JAS Module : IS-M
- KANZ Table for Assignment of Sales Order Items - Costing Objects Table Type : TRANSP Package : CKJ1 Module : CO-PC-PCP
- JKSDPORDERFLOW Table for IS-M: Assignment of Purchase Order Book to Purchase Order Table Type : TRANSP Package : JSDI Module : IS-M
- N1CORDTTR Table for IS-H: Order Filler-to-Order Type Assignment Table Type : TRANSP Package : N1CORDMG Module : IS-H-PM
- /ISDFPS/BSART_CS Table for Assignment Order Type => Tech. Recipient Order Type Table Type : TRANSP Package : /ISDFPS/MM_CS Module : IS-DFS-MM
- FAGLFLEX03 Table for General ledger: SAP additional account assignment Table Type : TRANSP Package : FAGL_DB_PERSISTENCY Module : FI-GL
- FAGLFLEX06 Table for General ledger: Sender SAP additional account assignment Table Type : TRANSP Package : FAGL_DB_PERSISTENCY Module : FI-GL
- FMGLFLEX03 Table for General ledger: SAP additional account assignment Table Type : TRANSP Package : FMGL Module : PSM-FA
- FMGLFLEX06 Table for General ledger: Sender SAP additional account assignment Table Type : TRANSP Package : FMGL Module : PSM-FA
- GLFLEX03 Table for General ledger: SAP additional account assignment Table Type : TRANSP Package : GLT0 Module : FI-GL
- GLFLEX06 Table for General ledger: Sender SAP additional account assignment Table Type : TRANSP Package : GLT0 Module : FI-GL
- JVGLFLEX03 Table for General ledger: SAP additional account assignment Table Type : TRANSP Package : GJVA_FAGL Module : CA-JVA
- JVGLFLEX06 Table for General ledger: Sender SAP additional account assignment Table Type : TRANSP Package : GJVA_FAGL Module : CA-JVA
- BKK600 Table for Account Hierarchy: Account Relationships Table Type : TRANSP Package : FKBR Module : IS-B-BCA-MD
- BSACC_HIST_GRP Table for Account Groups for Account History Table Type : TRANSP Package : FIN_BS_DIALOG Module : FI-GL-GL
- BSACC_HIST_GRPT Table for Account Groups for Account History Table Type : TRANSP Package : FIN_BS_DIALOG Module : FI-GL-GL
- CRMD_ACC_PL_ATTR Table for Account Planning account plan attributes Table Type : TRANSP Package : CRM_ACCOUNT_PLANNING Module : CRM-ACP-APL
- ICRC02 Table for Account Groups for G/L Account Reconciliation Table Type : TRANSP Package : FBAS Module : CRM
- ICRC03 Table for Account Groups for G/L Account Reconciliation - Name Table Type : TRANSP Package : FBAS Module : CRM
- ICRC04 Table for Account Groups for G/L Account Reconciliation - User Assgnmt Table Type : TRANSP Package : FBAS Module : CRM
- IDCN_ALGACCGRP Table for Account Level Hierarchy: Account Levels Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
- IDCN_ALGACCGRPT Table for Account Level Hierarchy: Account Levels (Text) Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
- IDCN_ALGACCHIER Table for Account Level Hierarchy: Account Level Hierarchy (Top Level) Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
- FM_CIACC Table Data element for Assignment of FM account assignment to account is binding
- KNTBU Table Data element for Account assignment category: unknown account assignment
- CO_KAKDA Table Data element for Account Assignment Type: Sales Order
- KTYP_KAUF Table Data element for Account assignment category for sales order stock
- NET_KAUF Table Data element for Third-Party Req. for Sales Order Account Assignment Category
- MAT_KDAUF Table Data element for Sales order number of valuated sales order stock
- MAT_KDPOS Table Data element for Sales Order Item of Valuated Sales Order Stock
- SMO3MAT_K Table Data element for Sales order number of valuated sales order stock
- SMO3MAT_K1 Table Data element for Sales order item of valuated sales order stock
- KNTBE_D Table Data element for Account assig.type: account for sales order, no special stck
- J_CO_AUFNR Table Data element for Order number of internal CO order for account assignment
- J_RK_AUFNR Table Data element for Order Number of RK Order for Account Assignment
Sap sales order account assignment 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.
Popular Table Searches
Latest table searches.
IMAGES
VIDEO
COMMENTS
Pick the data element of any field and enter them in SE11 and check the 'where used' list of these fields chosing 'Tables' Checkbox. You will get a long list of tables. You need to filter the correct one by checking data in Se16 or reading through table definitions. Eg: Data element for FISTL is FISTL itself.
07-15-20105:16 AM. 0 Kudos. Hiii. Account Assignment object is basically assigned in sales order header/Item tab "Account Assignment" by Assigning WBS element (Project System Object) or Internal order or it derrived from material master General Sales Plant data View as Profit Center (CO object). Regards.
I am struggling to find the table where the data on subscreen at Sales Order - > Item -> Account assignment tab - > AcctAssignt button is stored. When I go to the account assignment tab on the sales order I see a button AcctAssignt which leads me to a subscreen where the Fund centre and functional area values are found which I think are ...
Check the sales order procurement tab. You will find the requirement type. Go to OVZI, check the item category for your sales order. The requirement type is determined by 3 ways as below. ( Source field) Check OVZG how requirement class determines the Account assignment category. Best regards.
Here the list of Sales Order Tables in SAP SD (Sales and Distribution). Tables. SAP SALES ORDER TABLE. VBSK. Collective Processing for a Sales Document. VBSN. Change status relating to scheduling agreement. VBSP. SD Document Item for Models of Material.
SD - Sales: Transparent Table 9 : VBKD: sales Document: Business Data SD - Sales: Transparent Table 10 : VBRP: Billing Document: Item Data SD - Billing: Transparent Table 11 : BSEG: account ing Document Segment FI - Financial Accounting: Cluster Table 12 : AUFK order master data CO - Overhead Cost Orders: Transparent Table 13 : CDHDR Change ...
A table contains several fields and some of the fields will be key fields. List of Sap sales order account assignment tables in SAP. CRMC_ACC_MAP for Assignment of Account Assignment Group to Account. SMOTVAKZ for Sales Documents: Allowed Order Types per Sales Org.. TJAKT for Sales Order: Texts for Sales Document Types.
Use. You can assign one or more account assignments to an item. Multiple account assignment allows you to apportion the costs covered by a purchase order partly to your own cost center and partly to others, for example. You specify which account assignment object is to be charged via the account assignment category. Account Assignment Category.
Account assignment in sales order ... then use user exit USER_EXIT_MOVE_FIELD_TO_COBL in program MV45AFZB. You may need to create a z-table for maintaining the combination of sales person/profit center combination. ... Unique contract determination and automatic contract assignment in Enterprise Resource Planning Blogs by SAP Friday; Why the ...
The system can post entries in the billing documents automatically to the relevant accounts. To do this, it must first carry out account assignment. It can do this depending on the following elements: The system carries out account assignment using the condition technique. This means that you can define the account assignment to suit your needs.
Transparent Table 22 : AFKO order header data PP order s PP - Production Orders: Transparent Table 23 : BKPF account ing Document Header FI - Financial Accounting: Transparent Table 24 : AFPO order item: PP - Production Orders: Transparent Table 25 : MARC Plant Data for Material Logistics - Material Master: Transparent Table 26 : MSEG Document ...
Account Assignment is the specification of the objects ( for example cost center, sales order, project) that are charged in the case of a purchase order for a material that is intended for direct usage or consumption. A purchase order item can be assigned to a single account or to several accounts. Costs can be distributed on a percentage basis.
Technical name: 0ACCNT_ASGN. Use. The account assignment groupto which the customer is assigned. Available as from Release. 2.0. Reference Characteristic. N/A. External hierarchy. N/A.
Organization of an Enterprise in the SAP System. Purchasing Menu. Purchasing Document. Master Records from the Purchasing View. Purchasing Applications in Single-Screen Transactions: Purchase Requisition and Purchase Order. Purchase Requisitions (MM-PUR-REQ) RFQ and Quotation (MM-PUR-RFQ) Outline Purchase Agreements with Vendors (MM-PUR-OA)
Account Assignment Database Tables in SAP (66 Tables) Login; Become a Premium Member; TCodes; ... account assignment Fields in Purchase Order (Change Toolbar) MM - Purchasing: Structure 13 : ... Sales: Transparent Table 34 : BKPF: account ing Document Header FI - Financial Accounting: Transparent Table 35 :
This internal Order type is used to determine Profit center (present in Account assignmnet tab). As per my knowledge determination of internal order in Sales order is not standard.You can use userexit for determination. However you can also manually add value in that tab. No,it is not not using Sales Order type.
Transparent Table 8 : VBEP: sales Document: Schedule L in e Data SD - Sales: Transparent Table 9 : VBKD: sales Document: Bus in ess Data SD - Sales: Transparent Table 10 : VBRP: Bill in g Document: Item Data SD - Billing: Transparent Table 11 : BSEG: account in g Document Segment FI - Financial Accounting: Cluster Table 12 : AUFK order master ...
Hi all, I would like to know if there is any function module to get sales order number from Purchase order. The sales order number is in Account assignment item, from my point of view when you create a Purchase order from a Purchase requisition account assignment item appears and sales order number is in.
How can I create a Flight Booking Screen in Sales order screen . The sales order screen will have custom fields related to the flight booking. For example , passenger name , meal type , origin city etc. The requirement is to get certain fields to pop up when specific field has been given input. SAP Managed Tags: SAP S/4HANA Cloud ABAP Environment.