Showing posts with label FI. Show all posts
Showing posts with label FI. Show all posts

Monday, September 29, 2014

Changing Customer Master Data for Payment Term

There are situation that you need to edit the Customer Master Data in SAP.

In this situation, we want to edit the payment term in of the customer under Company Data.

Basically before you are trying to use any BAPI that changing the data, run the BAPI that get the detail from the system. As for this I'm using BAPI_CUSTOMER_GETDETAIL1.


In this BAPI you will need to enter the appropriate data to get the detail of the Customer.

Then you will get the data of that specific customer
Based on the data that you receive follow that and fill up in the BAPI_CUSTOMER_CHANGEFROMDATA1.
IMPORTANT to change the data, you need to fill up in PI_PERSONALDATA field LASTNAME, CITY, COUNTRY, COUNTRYISO, LANGUP, LANGUP_ISO, CURRENCY, CURRENCY_ISO.

And the field that you need to change (in this case we changing Payment Term). Fill up the first PI_OPT_PERSONALDATA. In that table you just need to fill up the field that you want to change (Payment Term) and also table below it PI_OPT_PERSONALDATAX.

Then fill up the SALESORG, DIVISION, DIVISION_CHANNEL and CUSTOMER No.. Then run it.
If the return is 000, then you BAPI is execute with no error and now you can check using tcode XD03.

Have Fun...!! :)



Wednesday, April 23, 2014

How to Add Customized Filed (KOB1) Actual Cost Line Items SAP Notes 325546



This guide or how to is following SAP Note 325546.



Assumption: 

1. Enhancement on existing SMOD - COOMEP0
2. Using CI_RKPOS
3. Add ZZAUGBL (Clearing Document) customized field.

Steps:

1. Add the customized field in the CI_RKPOS structure.
2. Data Element should follow AUGBL field from BSEG.



3. Enhance the user exit EXIT_SAPLKAEP_001 (ZXKAEPU01)
4. Add line of code to read the data from table to be populated in customized field

IF i_rep_object = 'OR'.
  
SELECT SINGLE  augdt augbl FROM bseg
    
INTO (cs_record-zzaugdt,cs_record-zzaugbl)
    
WHERE bukrs = cs_record-bukrs
          
AND belnr = cs_record-refbn
          
AND gjahr  = cs_record-gjahr.
*        buzei =

  
SELECT SINGLE xblnr FROM bkpf INTO cs_record-zzxblnr
      
WHERE bukrs = cs_record-bukrs AND belnr = cs_record-refbn
      
AND gjahr = cs_record-gjahr.
ENDIF.

5. Open SM34 to edit the view table V_TKALV.

6. Choose "Field Catalog Information"  and in change mode, add New Entries. For this customized field refer below figure.

Field Structure : KAEP_COAC
Field Name: ZZAUGBL
Field Group: 'K' - for customized field



7. Run back the program the customized should appear in the layout selection.



Monday, September 26, 2011

GL Account Long Text Number

Refer to table  SKAT - GL account long text number














SAP-FICO: Company Codes and the Chart of Accounts

SAP-FICO: Company Codes and the Chart of Accounts

ConfigurationThough you can have multiple Charts of Accounts in SAP, company codes are assigned to only one chart of accounts. This is done in configuration (SPRO) (T-code: OB62 – Assign Company Code -> Chart of Accounts).
T-Code for Chart of Accounts
  • T-code: F.10 – Chart of Accounts
    Report of accounts in a chart of accounts. Lots of ways to limit your results, but can’t limit by Company Code! You will definitely want to limit by chart of accounts.
  • T-code: OB62 – Assign Company Code -> Chart of Accounts
    SAP: OBY2
  • T-code: OBY2 – Copy Company Code: G/L Accounts
    When creating a new Company Code, just assigning it to a chart of accounts in OB62 doesn’t automatically create those accounts for the new company code. I.e. you won’t be able to post any entries until you’ve created the accounts for the company code. OBY2 lets you copy all of the accounts that were created for another company code to your new one.
  • GL Postings are assigned to only 1 company code
    You can do “cross-company code” postings (i.e. DR CoCde A and CR CoCde B), but SAP will automatically generate the off-setting entries within each company code so that their books stay in balance (debits = credits). There is config around Intra-company postings to determine where you want those offsets to go.
  • T-code: FS00 – Edit G/L Account Centrally
    This is usually the preferred t-code for manually creating GL Accounts since it allows you to create both the chart of accounts piece and the company code pieces.
  • In FS00, you may need to create an account for multiple company codes. This can be done by changing the CoCde and using the “Create with reference button” in FS00.
    SAP: FS00
  • T-code: FSS0 – Edit Accounts in Company Code
    FSS0 allows you to edit just the Company Code (CoCde) portion of the GL Account.
  • T-code: FSP0 – Edit Account in Chart of Accounts
    FSP0 allows you to edit just the Chart of Accounts portion of the GL Account.
  • T-code: CX16 - Consolidation Chart of Accounts – Hierarchy Display
    CX16 allows you to create/edit financial statement items (FS Items) and their hierarchy for the Consolidated Chart of Accounts used in the EC-CS consolidation system.
    SAP: CX16

Credit to : http://www.whypad.com/posts/sap-fico-company-codes-and-the-chart-of-accounts/81/