sap table account assignment sales order

Account assignment category in sales order Table in SAP

• T163A Table for Check Item Category/Account Assignment Category Table Type : POOL Package : ME Module : SRM-EBP
• 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
• T163KS Table for Assignment of Tax Indicator to Account Assignment Category Table Type : TRANSP Package : ME Module : SRM-EBP
• CIF_VMISD Table for Confirmation of Sales Area Data and Order Category for VMI Table Type : TRANSP Package : CIF Module : SCM-BAS
• 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
• ACCASSTYPE00 Table for Account Assignment Category Table Type : TRANSP Package : FINB_GL_ACCOUNT Module : FIN-FB
• ACCASSTYPE0C Table for Account Assignment Category Table Type : TRANSP Package : FINB_GL_ACCOUNT Module : FIN-FB
• ACCASSTYPE0T Table for Account Assignment Category Table Type : TRANSP Package : FINB_GL_ACCOUNT Module : FIN-FB
• BBP_C_ACC Table for Customizing Table Account Assignment Category Table Type : TRANSP Package : BBP_PRODOC_C Module : SRM-EBP
• CRMD_ACC_PL_PCAT Table for Account Planning assignment of product category Table Type : TRANSP Package : CRM_ACCOUNT_PLANNING Module : CRM-ACP-APL
• TFMFG_MM_AACT Table for Document Type for Account Assignment Category Table Type : TRANSP Package : FMFG_MM_E Module : PSM-FG
• UPA_MCB_03 Table for Assignment Budget Category to Order Attributes Table Type : TRANSP Package : UPA_MCB Module : BW-BCT-PLA-MCB
• UPA_MCB_05 Table for Assignment of Business Category to Order Attributes Table Type : TRANSP Package : UPA_MCB Module : BW-BCT-PLA-MCB
• CCIHC_QT04 Table for EHS: Assignment Table Amount Category - Meas. Value Category Table Type : TRANSP Package : CBIH Module : EHS-IHS
• FICOB_COND_AMT Table for Assignment Condition Category - Amount Category Table Type : TRANSP Package : FICO Module : CA-FIM-FCO
• FICOB_COND_DATE Table for Assignment Condition Category - Date Category Table Type : TRANSP Package : FICO Module : CA-FIM-FCO
• FICOB_COND_DIFF Table for Assignment Condition Category - Differentiation Category Table Type : TRANSP Package : FICO Module : CA-FIM-FCO
• TICL254 Table for Assignment Damage Category Object Category Table Type : TRANSP Package : ICL_FNOL Module : FS-CM
• /XNFE/PROCITEM Table for Assignment of Process Category to Allowed Item Category Table Type : TRANSP Package : /XNFE/APPB2B Module : SLL-NFE-MGM
• 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
• KNTBU Table Data element for Account assignment category: unknown account assignment
• 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
• FM_CIACC Table Data element for Assignment of FM account assignment to account is binding
• CO_KAKDA Table Data element for Account Assignment Type: Sales Order
• 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

Account assignment category in sales order 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.

• ABAP Snippets
• Top SAP Courses
• Top SAP Books

SAP and ABAP Free Tutorials

Account assignment in SAP Purchasing (MM) – FAQ

This note provides answers to frequently asked questions regarding account assignment in purchasing documents. This post is based on Snote 496082.

Table of Contents

FAQ: Account Assignement in SAP Purchasing

Account assignement : g/l account for a sales order.

Question: Why is the G/L account for a sales order with nonvaluated individual sales order stock different from the account with valuated indivi dual sales order stock?

Answer: See Note 458270.

Multiple Account Assignment in Purchasing

Question: Can you create several assets at the same time in the new purchasing transactions?

Answer: You can create several assets at the same time. However, you must first ensure that at least as many account assignment lines have bee n created as the number of assets that you want to create. You can do this very easily using the copy function.

G/L Account is not saved if switch to a material group

Question: You create a purchase order with account assignment using transaction ME22. You enter a material group, from which a G/L account is de termined using the valuation class. If you then switch to a material group that does not determine a G/L account via the valuation class, the system deletes the previous G/L account and prompts you to enter a G/L account. If you cancel the account assignment screen and change the material group back on the item detail screen, the previously determined G/L account is not determined again. Why is this ?

Answer: Unfortunately, this system behavior cannot be changed. First, enter any G/L account, so that the item is valid. If you then switch to the old material group again, the system also determines the correct G/L account again.

Entering the same account assignments for different items

Question: Is there an easy way of entering the same account assignments for different items in the new EnjoySAP transactions?

Answer: Ensure that Note 315676 has been implemented in your system and follow the procedure described there

Repeat account assignment function not work in the new EnjoySAP

Question: Why does the repeat acc. assignment function not work in the new EnjoySAP transactions when you create new account assignments in multiple acc. assign. ?

Solution: Use the copy function in multiple acc. assignment to create identical account assignment lines. You can use the repeat account assi gnment function to create similar account assignments for different items with the same account assignment category. To do this, proce ed as described in the answer to question 4.

Issue message KI 161 “Cost center &/& does n ot exist on &

Question: When you change the account assignment of an existing purchase order, why does the system issue message KI 161 “Cost center &/& does n ot exist on &” ? The same phenomenon occurs for other account assignment objects (for example, profit center).

Solution: Refer to Note 193371.

Can you create assets from the single account assignment screen?

Solution: Assets can only be created from the multiple account assignment screen (“Account assignment” tab). You can switch between single account assignment and multiple account assignment on the “Account assignment” tab page by clicking the icon above on the left.

Why does the system not display an account assignment tab page even though you have entered an account assignment category?

Solution: After you have implemented Note 520149, the account assignment tab is not displayed until all the required information is available, for example, the company code.

Why are account assignment objects derived in some situations, even though the relevant field on the account assignment tab page is hidden?

Solution: Refer to Note 619203.

ME 453 “Changing consump. or spec. stock indicator not allowed

You create a purchase order with reference to a subcontracting purchase requisition. This purchase requisition was created with an unknown account assignment, that is, account assignment category “U”. When you change the account assignment category in the purchase order, the system issues error message ME 453 “Changing consump. or spec. stock indicator not allowed (subcontracting)”.

Solution: See Note 205597

Select a valuated goods receipt together with multiple account assignment

Why can you not select a valuated goods receipt together with multiple account assignment in a purchase order or purchase requisition?

Solution: See Note 204252.

EBAN-FISTL, -GEBER, -KBLNR, -GRANT and -FKBER (as in table EKPO) empty

Funds Management is active. Why are the fields EBAN-FISTL, -GEBER, -KBLNR, -GRANT and -FKBER (as in table EKPO) empty? Solution: These fields are only filled if the account assignment category is set to “blank”. If you maintain an account assignment category in t he purchasing document, the system adds the information from these fields to the EBKN table (as in EKKN).

AA 334 “You cannot post to this asset (Asset & & blocked for acquisitions)

You try to change a purchase order item with acc. assignment category “A”, which contains a locked asset. The system issues error message AA 334 “You cannot post to this asset (Asset & & blocked for acquisitions)”. Solution: This is the standard system design. To make changes to this purchase order item, you have the following two options:

a) If you no longer require the purchase order item with the blocked asset, delete the purchase order item. b) Otherwise, you must activate the asset, make the required changes to the purchase order item, and then block the asset again.

The indicator for the account assignment screen

Question: What is the meaning of the indicator for the account assign. screen that you can set in Customizing for single account assignment/m ultiple account assignment? Solution: The indicator determines which account assignment screen is used by default for maintaining the account assign. for a purchase orde r item. For the EnjoySAP transactions, this value is simply a proposal that you can change in the purchasing document. For the old transactions, this value is the only one that you can use.

Question: Is there an unknown account assign. for standard purchase orders?

Solution: This is generally not allowed, and the system issues message ME 069 “Unknown account assignment not defined for use here”. There is an exception in the case of service items that are created with item category D (service) or B (limit).

Acc. Assignment check is not performed when Purchase Order is updated

Question: You change data in a purchase order item (for example, purchase order value, delivery date, and so on). Why does the system not perform another acc. assignment check?

Solution: This is the standard system design. When you created the purchase order item, if the system already checked the acc. assignment and there were no errors, another acc.?assignment check only takes place if you change a field that is relevant to account assign.?(for example, quantity, material number, and so on). If this system response does not meet your requirements, implement the account assignment check in the BAdI ME_PROCESS_PO_CUST. The BA dI is called each time the purchase order is changed.

“In case of account assignment, please enter acc. assignment data for item”

Question: If you delete all the account assign?lines that were entered in the account assignment screen, the system exits the account assign. tab page and goes to the material data. In addition, the system issues the error message “In case of account assignment, please enter acc. assignment data for item”.

Answer: In the current system design, if you delete all the account assignment lines, the system assumes that you do not want to maintain any account assignment data. This conflicts with the account assignment category and the system issues error message 06 436. You can then remove the account assignment indicator. Procedure: If you want to delete all the account assignment data that was entered, see the answer to question 24.

Third-party order processing (CS) and individual purchase order processing (CB)

Question: Which account assignment categories should you enter in schedule line categories for third-party order processing (CS) and individual purchase order processing (CB)? Solution: See Note 210997.

G/L Account is not transfered from Valuation class

Question: In a blanket purchase order or blanket purchase requisition with account assignment, you subsequently change the material group. Even though the new material group is assigned to another G/L account via the valuation class, the system does not redetermine the account assignment for the relevant item. The old G/L account remains.

Solution: See Note 449216.

Customizing Account assignment fields as required entry, optional entry, or display fields

Question: In Customizing, you can set the, or as completely hidden fields, depending on the account assignment category. These settings also determine whether the system deletes or retains the values for the account assignment fields when you change the account assignment category in a purchase order item.

Answer: In Customizing for materials management (MM), when you maintain account assignment categories (IMG: Materials Management-> Purchasing -> Account Assignment-> Maintain Account Assignment Categories), you can control the different account assignment fields as follows: Required entry: You must make an entry in the field, otherwise the system issues error message ME 083.

• Optional entry: Entry in this field is optional.
• Display: The field is displayed, but it is not ready for input.
• Hidden: The field is hidden. Example:

The acc. assignment category is K, the cost center is an optional entry field and it is filled with the value 1000. You change the acc. assignment category to P. Subject to the field settings for the cost center for the acc. assignment category P, the system response is as follows: The cost center is a required entry or an optional entry field: The system transfers the value 1000 for the cos t center.The cost center is a display field: First, the value 1000 for the cost center is deleted. If the system can determine a value again after you enter the changed acc. assignment category, this value is transferred. The cost center is a hidden field: The system deletes the value 1000 for the cost center.

System ignores the acc. assignment data of the purchase requisition for the second schedule line.

Question: You create a purchase order item assigned to an account with reference to a purchase requisition. For this purchase order item, you create a second schedule line with reference to another purchase requisition. The system ignores the acc. assignment data of the purchase requisition for the second schedule line. Solution: This is the standard system design. The system does not generate multiple acc. assignment in the purchase order item, even if the t wo referenced purchase requisitions are assigned to different CO objects. Refer to Note 47150 for the old transactions and to Notes 422609 and 771045 for the EnjoySAP transactions.

Undelete an item in a purchase requisition if assignment data is no longer valid

Question: Why can you undelete an item in a purchase requisition if the corresponding acc. assignment data is no longer valid? Solution: When you undelete an item in a purchase requisition, the system does not perform a new acc. assignment check. Therefore, the accoun t assignment data is not checked again. Nevertheless, errors occur if you try to create a purchase order with reference to this purchase requisition. When you undelete an item in a purchase order, however, the system does perform another acc. assignment check.

Transfer of Acc. Assign. with Reference Document

Question: You create a purchasing document with reference to a reference document. What account assig. data is transferred? Solution: The acc. assignment data is derived from the reference document. If you delete the acc.?assignment category and enter it again, a new automatic general ledger account determination takes place.

Question What is the correct procedure for changing acc. assignment data?

– If, for example, you want to change the acc. assignment category: Note that you MUST first delete all existing acc. assignment data for the relevant item. You can do this by initializing (deleting) the acc. assignment category and confirming by choosing ENTER. Following this, you can enter the new acc. assignment category and the relevant acc. assignment data.

– If you want to change acc. assignment data for the relevant item: For example, you want to change the main acc. assignment objects such as cost center, G/L account, sales order, network, or WBS ele ment, and so on. Here also, we recommend deleting all existing acc. assignment data by initializing (deleting) the account assignme nt category and confirming by choosing ENTER.If you are working with contracts, you must delete the acc. assignment line on the acc. assignment screen and enter a new line t o ensure that the data is derived correctly again. You MUST NOT change the current settings. For example, in some circumstances, the requirements type (OVZH) or the valuation of the requirements class (OVZG) is changed after th e purchasing document is created. This can cause errors in a valuation of goods movements (goods receipt, for example) and MUST BE AVOIDED.

Read more on? Account Assignment

Related Posts

The Most Important SAP Payment Terms Tables (ZTERM, Text…)

October 21, 2018 March 24, 2021

SAP Batch Management: User-exits and BAdIs

June 17, 2017 January 21, 2022

SAP Batch Management Tcodes, Tables and Customizing (SAP Batch Management)

June 16, 2017 January 21, 2022