The ways to editing tables

Here are listed powerful hacks which can be used to change even the standard tables and even in a production environment (if you have CHANGE access in Debugger). You should think twice before using them.
You can track changes made in SE16N by &SAP_EDIT (GD-SAPEDIT) option in SE16N_CD_KEY table.
With a right authorization concept in place you would not be allowed to debug in production. So end users should be restricted with debugging authorizations.

1. Go to SE16N, type the table name, turn on the debugger (type /H in the command field), press F8. In the debugger set the values of GD-EDIT and GD-SAPEDIT to ‚X‘ and press F8.
2. Execute the function module SE16N_INTERFACE. Set parameters i_tab to table name and i_edit to ‚X‘ and press F8.
3. Carry out the transaction UASE16N (obsolete, but sometimes still in use). Type &SAP_EDIT in the command field.

SE16N: Abschalten von &SAP_EDIT – SAP Note 1420281

LSMW upload classification

On the next screen, if you press the button „Object overview“ you see next fields:

So in this case
KLART – 001 (Material Master)
OBJEK – material master number
CLASS – Class name
ATNAM – Characteristic name
ATWRT – Characteristic value

Save it.

Specify files:

Window of „Start direct input program“:

If no error, you will see the deliberate error (that was added in last line)

After loading it in, you can verify the data in the table AUSP where class type = 001:

Working with the Material Master Data

In the SAP MM module, material master data refers to all the material master records that are stored in the system. In other words, material master data consists of the description of all the materials that an organization not only purchases but also produces and keeps in its stock. The material master data acts as a central database of information for the materials in an organization.

Maintaining the details of all the materials at a central location not only minimizes the risk of data redundancy but also allows other departments of the organization to share this data among themselves. The other departments of the organization can use the material master data to perform various tasks, such as invoice verification and inventory management. The material master record is used by different departments of an organization, and each department requires different information about the material. For example, the purchasing department might require only the price of the material to perform price control functions; whereas, the sales department might require the sales data to prepare the sales graph of a given period of time.

To facilitate locating the relevant data, various fields have been provided in the Create Material (Initial Screen). Every department can easily locate and access the data required by it by entering the relevant details in these fields.
Read the rest of this article

Quiz for SD (TSCM60)

Attached are four pdf documents with sample questions and answers that can be of use when you do you SAP Sales and Distribution Certification exam:

quiz

Quiz TSCM60 set A questions.pdf
Quiz TSCM60 set A answers.pdf
Quiz TSCM60 set B questions.pdf
Quiz TSCM60 set B answers.pdf

© Willem Hoek

What are Enjoy transactions in SAP?

sap_enjoy

An enjoy transaction is one that was released with the mysap.com release, which is also know as the „Enjoy“ release.
Enjoy transactions are the new transactions (from rel. 4.6A, which is nearly 10 years old now) were created to „make life easier“ for the endusers and performs all the operations performed by its classical counterpart in one screen only. All clickable elements have 3D qualities, while the input and output fields remain 2D for simplified reading.
A lot of transactions have been rewritten to use the new control framework. All Enjoy transactions are having ‚N‘ character at the suffix of the transaction (ME21N, VL02N etc). These transactions „replaced“ older transactions. The sap enjoy transactions typically are much more user friendly in appearance, support custom controls, ALV tree and ALV grids, docking containers, node structures, picture controls in them. But transactions ending with „N“ doesn’t qualify them as eNjoy. May be „N“ was used to indicate „New“, SE43 & SE43N – neither of them are eNjoy transactions.

sap-enjoy

As example described data can be found in the t-code ME21N (completely writting in OOPS ABAP). The old ME21 transaction uses the classic dynpro technology without using the control framework.
Enjoy sap controls are containers that can built dunamically using objects/classes. In general batch input is not possible for those screens. The SAP material BC412 contains all about this. It’s all about ABAP Screen programming.

Today the term „Enjoy“ is not common anymore.

„SAP software works the way I do.“

P.S. MCV9 transaction:

MCV9

What Is Outline and Scheduling Agreement

Please give the difference between Purchase Order, Outline Agreement
and Scheduling Agreement.

PO is normal where you issue the PO to a vendor and expect the delivery.
The PO is termed completed when the vendor has delivered the PO quantity
or when you have preclosed the PO when the vendor has delivered partial
quantity and he has agreed not to send anymore with ref to the PO.

Outline Agreement can be of 2 types:- Contract and SA.

Contract is where you have a contract with the vendor,may be a for a
predetermined quantity or predefined value. So everytime you need the matl,
you need to make PO ref the contract asking for the delivery of the matl.
In such instance when PO is ref with contract its called contract release
orders or call off orders.

Scheduling agreement is a long term purchase agreement, where you will
keep issuing the delivery schedules whenever there is a change in requirement
or at predetermined time intervals. The delivery schedule can be on hour/daily/weekly/monthly
basis. But it will contain different zones viz. firm/tradeoff/Forecast.
Firm zone schedules are confirmed requirement and need to be taken by ordered
party. Tradeoff zone requirement is to purchase the raw materails and ordering
party is liable to pay raw material cost, in case of requirement cancellation.
Forecast zone requirement is to help the vendor to plan his requirements.

SA is also an agreement with the vendor for the supply of matl, may
be a quanity or value. The delivery dates will be maintained in ME38 ref
the SA which are called delivery schedules.So you can maintain the delivery
schedule and communicate the vendor on Forecase basis or JIT basis. And
when you need some more matl then will only create SA deliveries using
ME38. SA could be of 2 types:- without release documentation-system will
transmit the delivery info to the vendor once you save the document.

With release documentation- after creating the delivery schedules you
need to create SA release using ME84.

The main difference between contract and SA is volume of docs generated
would be higher in contract since everytime you need to make a PO ref the
contract and its time consuming, whereas SA can be integrated with MRP
such that it automatically creates delivery schedules during MRP run provided
if there is a requirement to the matl.

Error SSFCOMPOSER 152 solution

Last week we have found an error in our Z-Smartform, which says nothing except „SSFCOMPOSER 152: Events are already defined.“
It didn’t say what data related to the error, or even which part of the smartform acted wrong.

After a bit debugging we’ve found the module with the proper position for a breakpoint:

1. Open SE80 and „Function groups“ inside it.
2. Functional group STXBC.
3. Open the subroutines folder.
4. Set a breakpoint in ERR_WRITE routine.

Now, carry out the smartform and we will get all the data related to the error with all the parameters.

© Programador Sergio Paton

100 interview Questions and Answers

  1. What do you mean by drop shipment?
    A drop shipment is based on an order from a customer to a Distributor. The distributor initiates the shipment by Informing the wholesaler.
  2. What is the use of sales area?
    Sales area is the geographical aspect of that particular Company code, from there we can generate the reports.
  3. How does the rule MALA decide the picking location?
    1) Shipping point
    2) Plant
    3) Storage condition
    4) Storage location
  4. What is the difference between customization and configuration?
    Customization word used for Master Data maintenance. And Configuration word used for pricing Procedure Determination.
  5. Is it possible to do delivery without shipping point?
    No. Shipping point is the destination of the goods, how we can ship the goods. It is like mailing letter without TO address.
  6. Explain about smart forms?
    Smart form – it is a form. Basically it is using in output.
  7. How sales document is structured?
    Header responsible for all the documents
    Item for materials
    Schedule line for quantity and delivery
  8. In sales order how system does picks up plant?
    We assign particular material master to particular Plant it picks up from there.
  9. Without delivery can you do billing?
    Without delivery invoice is not possible.
  10. Could you explain about sales deals?
    Company has launched a new product, for a that material you want to have a promotion – for this you will creating a sales deal and assign it to sales promotion and you maintain condition groups.
  11. What is the use of pricing date in condition type?
    It shows date of calculation of pricing procedure for that particular document. So that in future you can see the date on which pricing calculated for that particular document.
  12. What does A/C group control customer?
    Account Group is like a control parameter for the customer master. Most of the fields in the customer master are controlled using field selection, which is internal function of Account Group.
  13. Could you explain about Higher-level item category and item usage?
    Sales Document Type (OR)
    +
    Item Category Group (NORM)
    +
    Item Usage (FREE)
    +
    Higher Level Item Category (TAN)
    +
    Item Category of Free Goods (TANN)
  14. Why do you need project IMG?
    IMG is required for the purpose of customizing and Configuration. There is no role of functional consultant without it.
  15. How we assigned sales organization to delivering plant?
    Path: SPRO/IMG > Enterprise Structure > Assignment > SD > Assign Plant to Sales Organization/Dist.Channel
    T-code OVX6
  16. How to extend material and customer to other sales areas?
    Sales area is a combination of Sales Org, Dist. channel & Division. Division is a logical grouping of products. So you cannot extend material to other sales areas. But you can extend customer to other sales areas through common Distribution channel & Division.
  17. How can we process outbound deliveries without shipping point?
    Shipping point is a required Organizational unit for outbound delivery process.
  18. While I am creating a customer in ship to party account group you have shipping and billing partner function tab pages, client wants to shift all important fields in billing like payment terms, incoterms and tax classification into shipping tab page. He wants only shipping partner function only, how does you customize?
    Field Selection will help you maintain the fields relevant to shipping. Ship-to-party function will be able to see only shipping related fields.
  19. Why do I use condition indexes? How do you activate them?
    Condition Index is used to search all the conditions Records for a particular condition type (e.g. PR00). We activate condition index in the customizing screen of the Condition type.
    Menu Path: SPRO > Sales & Distribution > Basic Functions > Pricing > Pricing Control > Define Condition Types > Maintain Condition Types > Enter PR00
  20. Is it possible to release change request, without releasing task?
    Once we can release the task, then only we can release the Change/customizing request.
  21. What does Product attributes means?
    Product attributes is nothing but the features of product.
  22. Can one have multiple packing for delivery?
    Yes, we can have multiple packing for a single delivery.
  23. Explain EDI and its usage?
    EDI – it helps for data transfer.
    That means from SAP-system or non SAP to SAP-system.
  24. To extend material from one plant to another plant what are the configuration you done in your project?
    We have to create in new plant as we have followed for first plant, where as in first plant system will give internal number but for second plant we have to mention material number.
  25. What is the client specific data? Give two examples of client specific data?
    1) master data
    2) transaction data.
  26. How to stop PGI?
    In credit management we stop the PGI by through credit limit or through cusomization.
  27. Can we assign multi distribution channel to a single customer in sap SD sales process. If yes then how?
    While creating customer we need to assign the customer to the respective sales area, we should copy from previous sales area in XD01 through reference.
  28. What is the difference among sales deal promotion price, price agreement?
    Sales deal promotion – specific product for a period of time price will be less than MRP.
    Price agreement – means an agreement between customer and Vendor for a specific product or with a specific price mentioned in their agreement.
  29. What is the difference between inbound and outbound delivery?
    Outbound delivery – is Post goods Issue (PGI)
    Inbound delivery – is Post Goods Received (PGR)
    PGI will come under Sales Area
    PGR will come under MM Module
    PGI decreases physical stock and PGR increases.
  30. From Which Tcode can I view customer wise back order (Open Order)?
    V_RA
  31. What is retroactive billing? Who will create this?
    Retroactive billing means rebate process. When ever the customer reaches the target quantity or volume in specified time period, we issue the credit memo for the customer.
  32. Where do you assign Movement Type?
    We assign movement type in schedule line category.
  33. Can anyone explain about Purchase Order & Purchase Requisition?
    In third party if a customer places an order if the Material is not available in our company if the order Document is saved automatically purchase is raised. It is created with the help of this purchase group.
    Purchase requisition – for production of material raw Materials are required, but materials are not available on stock, then the production dept. request send to the MM manage simply request him to arrange Materials for production of finished materials.
  34. It is possible to maintain two different pricing procedures for 2 materials in one sales order?
    No, you cannot maintain 2 separate pricing procedure for same Material in single order. But you can change the price Manually by selecting the material and then the conditions tab. You can also see the changed status as manually later.
  35. List the Basic Steps for SD configuration.
    1) Enterprise structure
    2) Partner determination
    3) Master data
    4) Business process customization
    5) Pricing
    6) Output determination.
  36. How you can extend the rebate? what are the procedures, what is the customization for it?
    The transaction code for extend rebate is „VB(D“ in that You should fill the field like recipient and rebate agreement.
    For customization same as create condition tables but Already there are standard tables and define accessequence And assign condition types. There are already standards are There like b001, b002, b003, b004 then assign pricing Procedure to condition type, next create account keys and assign to rebate process type.
  37. What is accounting group?
    Accounting group is simply the classification of customers, whether it’s sp, sh, bp, or py, and it also controls the fields in CMR.
  38. What are the differences between invoice and billing document?
    Billing document is the broadview. Invoice (F2) is one of type of billing doc.
  39. What is pricing? How will it affects the billing procedure?
    Pricing has the basic price of the item. It also has the Discounts, Taxes, Rebates, & also the Cost of the item.
  40. What is account key? And how it works? Normally how many pricing procedures do in implementation?
    Account key determine a correct G/L account to be posted the data corresponding G/L accounts. You need to assign a G/L account to account key that is assigned to a condition type in a pricing procedure.
  41. Tell me account key and accruals?
    A/c keys determine a correct G/L account to be posted the data corresponding G/L a/c. All customer Rebate accounts are posted in accruals.
  42. What is the document flow?
    Inquiry
    Quotation
    Sales Order
    Delivery
    Transfer Order
    Post Goods Issue
    Billing
    Accounting
  43. What is the transfer order?
    Transfer order is basically picking order where you pick the material from storage and loading area or picking area.
  44. What is the purpose of text determination, account determination, partner determination, output determination, storage location determination?
    1) Text determination: for transferring information from material or customer to order/delivery or invoice (and anything in-between)
    2) Account determination: for transferring financial and costing information to proper financial documents
    3) Partner determination: who is legally responsible for A/R, who the goods are going to and whatever else you drive through this functionality.
    4) Output Determination: What type of Output (Fax/Mail, etc) is required, where and in what Format (ABAP Customization may be required in some cases especially Invoices).
    5) Storage Location Determination: depends on Plant, Shipping Point and Storage Conditions.
  45. What are the five important fields to be maintained in account determination?
    Sales org., A/c keys, condition type, a/c group for the customer, a/c group for the material
  46. What is meant by transfer of data from legacy code to SAP?
    Before installation of SAP, data maintained by company is called Legacy Data. At the time of installation, it is required to transfer data from legacy to SAP like Masters (Material/Customer, etc).
  47. What and where types of copy controls we change?
    Copy Control – is basically meant so that data is copied from preceding document to subsequent one. In general case of Standard Order, it will be Copy Control (Order to Delivery) from OR to LF.
  48. How to and where to maintain copy controls?
    Sales Document types and Delivery Document Types.
  49. What is purpose of maintaining common distribution channels and common division?
    Common Distribution Channel and Common Division are maintained so that if any master data like customer or material maintained with respect to one distribution channel can be used in other DCh. It prevents the multiplication of master record.
  50. Can you tell the deference between contract and scheduling agreement?
    Scheduling Agreement – is an agreement between consumer and company having fixed delivery dates and fixed quantity.
    Contract – is an agreement between company and consumer for certain period of time.
  51. What is PMIN?
    PMIN is a Condition type to define minimum prices. It can be Control minimum prices below which a material should not be sold to the customer.
  52. What is client requirement in Schedule Line Category?
    Schedule line category is nothing but delivery date and delivery quantity is must.
  53. Where we can block the Sales Document?
    Sales document can be blocked at three places depending on the customer risk categories, they are:
    1) Sales order level (high risk customer)
    2) Delivery level (medium risk customer)
    3) Goods issue level (low risk customer).
  54. What is the Difference between Reconciliation A/C and Normal Posting A/C?
    Manual entries can be posted in the normal G/L account and the same is not possible in the Reconciliation account, as these are automatically updated.
  55. What happens if we check „exclusive“ indication in access sequence, and what happens if we don’t check?
    Basically access sequence finds the exact condition record in cond.table by search statuary with the help of exclusive indication.
  56. Can anyone tell about types of free goods?
    1) In toothpaste: 25% extra more – it’s inclusive
    2) When you buy paste you get a brush free, it’s exclusive.
  57. What are the 16 steps in the pricing procedure?
    Step,
    Counter,
    Condition type,
    Description,
    Form,
    To,
    Manual,
    Mandatory
    Statistics,
    Print
    Subtotal,
    Requirement,
    Alt condition type,
    Alt condition base value,
    Act key and
    Accruals.
  58. Do you have any link for customer master and credit management?
    We can maintain individual customer credit limit in customer Master. In transaction FD32 we can define the total credit limit for sales area and credit limit for individual sales area.
  59. Explain about sales order cycle?
    Inquiry
    Quoatation
    Order
    Delivery
    Billing
  60. What is the relation between sales organization and company codes?
    Many to one.
  61. Sales order is created 1st November for 200 toothpastes 100 brushes free of goods (2+1 free goods). At the time of delivery on 15th November you have shortage of brushes by 40. Offer closed on 15th November. How do you solve in this scenario?
    At 15 Th Nov 40 shortage tooth paste have given 100% free goods discount. Condition type is R100.
  62. What is the difference between cash sales and rush order?
    In rush order if a customer places an order delivery will take place immediately billing will be letter.
    In cash sale if a customer places an order delivery and Billing will be on the same day.
  63. How system picks up pricing while doing billing?
    From Sales Order.
  64. Difference between business sale cycle and customer sale cycles?
    Contract is the business sale cycle and schedule line is the customer sale cycle.
  65. How do we control the credit checks with specific to distribution channel and division?
    By assigning credit control area to specific sales area.
  66. Can you configure two different free goods items for one single item? E.g. – on purchasing of item „A“ you want to give item „B“ and „C“ for free. Is it possible? How?
    Yes it is possible by exclusive free goods.
  67. Can you delete order?
    You can delete the order but there should not be any transactions on the particular order.
  68. MWST? Please explain it detailed?
    MWST is Tax Condition Category which will be Assigned to country RU (& other).
  69. How to do customization of rebate processing in the SD module?
    1) Activate rebate in customer master data
    2) Selling material should be activated in MM data
    3) Sales org. should be activated
    4) Billing document should be activated.
  70. Which partner function realent for credit limit?
    Sold to party is relevant for credit limit.
  71. Name three areas/processes which use condition technique in SD?
    Material determination, pricing determination, output determination, account determination.
  72. Explain what a condition table and an access sequence are and the relationship between them?
    Condition table defines the combination of fields (the key) that identifies an individual condition record.
    Access sequence is a search strategy that the system uses to find valid data for a particular condition type.
  73. What is a condition type? What are the two main groups of condition types?
    Condition type is a representation in the system of your daily pricing activities. Fixed Amount & Percentage.
  74. Which partner function is relevant when it comes to tax calculation in the sales order?
    Ship to party.
  75. Where would you specify that a condition type is a discount or a surcharge?
    In condition type details screen.
  76. You want to list all condition records for a certain material or a certain sales organization. How would you do that?
    By creating pricing Reports.
  77. Can you explain what a statistical condition is? Give an example for a statistical condition?
    VPRS.
  78. For what do you use customer hierarchies?
    Pricing, Rebate.
  79. Name the influencing factors for pricing procedure determination during sales order entry?
    Customer, Sales Document Type and Sales Area.
  80. Can you copy condition records? If yes, are there any restrictions?
    Yes. Field specific.
  81. Tax jurisdiction processing is a close link between which two modules?
    FI and SD.
  82. Can you delete an invoice?
    No. You can cancel it and create cancellation document.
  83. When you create an invoice can you carry out pricing again?
    Yes.
  84. From which documents can you create a Proforma invoice (pro forma)?
    Sales order or delivery.
  85. When you create a credit memo request do you always have to refer to a sales order or any other previous document?
    Only sales order.
  86. Can you combine orders into one invoice?
    Yes.
  87. Can you split deliveries into several invoices? When would you do that?
    Yes. If the data from the related reference the system will automatically split the invoice.
  88. Can one business area be valid for several company codes?
    Yes.
  89. There is an interface between SD and FI in invoicing. Can you think of another interface between SD and FI?
    Credit check, Tax calculation and Cost estimate.
  90. Can you partially settle rebate accruals?
    Yes.
  91. Is it possible to link R/3 projects to the MS project?
    Yes.
  92. What two ways of number assignment for documents or master data do you know? Explain the difference between them.
    Internal & External.

© sapsdiq.blogspot.de

Связать счет FI со сбытом

Глосса: AAG – Account assingment group
AAG материала задается в мастер данных материала (MM02):

откуда потом подтягивается в сбытовой ордер:

(может быть изменено в процессе фактурирования).

AAG клиента и облагается ли продажа клиенту НДС или нет (можно установить 0 или 1) – в VD02:

В транзакции VKOA указываем, на какой счет пойдет комбинация Account assingment group клиента (AAG) и AAG материала:

Костинг равен цене, профита – 0:

Указываем в OKB9 контроллинговый объект для счета:

Таблицы

> Transactions
> SAP FAQ

AGR_USERS – список ролей юзера
UST04 – список профилей авторизации юзера
USGRP_USER – список групп юзера
USR02 – SUPER CLASS

TSTC – список всех транзакций (фильтр, маска)
CDHDR / CDPOS – просмотреть удаленную поставку (* OBJECTID *)
T030 – сопоставленный счету класс оценки
C001 – сопоставленный счету Acct assignment grp
MBEW – valuation, average prices
MBEWH – история изменений MBEW
TNAPR – NACE какой output тип к какой condition привязан
D010TAB – по имени таблицы найти в каких транзакциях/программах эта таблица используется
SMEN_BUFFC – „Избранное“, Favorites SAP Menu
SE16N_CD_KEY – SE16N changelog (SE16N_CD_DATA – данные)

Output type tables (B0XX…):

B000 $ Sample Table for output control
B001 Sales Organization/Customer Number
B002 Output Control: Sample Structure for Output Data
B005 Sales Organization/Order Type
B006 SOrg/DstCh/Division/Customer
B007 Order Type
B008 Output Control: Sample Structure for Output Data
B009 Output Control: Sample Structure for Output Data
B010 Shipping Point/Route
B011 Output Control: Sample Structure for Output Data
B012 Output Control: Sample Structure for Output Data
B013 Output Control: Sample Structure for Output Data
B014 Output Control: Sample Structure for Output Data
B015 Credit Control Area/Cred.Representative Group/Risk Category
B016 Labeling
B017 Transport type
B018 Sales Organization/Receiving Country
B020 Shipping material type
B021 DlvType/Shipping Point
B022 TrspPlPoint and Shipment Type
B023 TrspPlPoint, TrspProcessingType and Service Agent
B025 Purchasing Output Determination: Doc.Type/PurchOrg/Vendor
B026 Purchasing Output Determination: Document Type
B027 Purchasing Output Determination: Purch. Org./Vendor for EDI
B028 Ship-to party/shipping mat.
B030 Specification Department
B031 Area of Responsibility
B032 Application Area: Output Number
B033 MRP Controller
B034 Planner Group
B035 Plant
B040 Document Type/Document Status
B046 CoCode, Blocking reason: Price
B048 CoCode, Vendor
B049 Company code
B050 Output Control: Sample Structure for Output Data
B055 C Status, Laboratory
B060 PM Message – Plant Maintenance
B061 Purchasing Group
B062 Laboratory/Engineering and Design Office
B063 Planner Group
B064 Capacity Planner
B065 MRP Controller
B066 Cost center
B070 Event/print vers./print ind./label type/label form
B071 GR Output
B072 Event/Print Vers./Print Ind.
B073 Event/Print Vers./Print Ind./SHKZG
B074 Missing Parts
B075 Kanban Cards for GR
B100 Output Determination: DocumentType/Purch.Org./Material Group
B120 Condition tables for Output Nota Fiscal
B121 OutputDev.
B150 Doc.Type/Sales Org./Customer
B160 Sales Organization/Condition Granter
B161 SOrg/Distr.Channel/Division/Rebate Recipient
B170 Purchasing Organization/Invoicing
B171 Sales Organization/Distribution Channel/Division/Payer
B172 Company Code/Invoicing
B173 Company Code/Payer

sd-relations