General SAP Tables of GL Master Data

The following are the table names of G/L Master data:
   
Table name :  SKB1 : G/L Account Master ( Company Code)
Fields:

BUKRS : Company Code
SAKNR : G/L Account

 
   
Table name :  SKA1 : G/L Account Master ( Chart of Accounts )
Fields:   

KTOPL : Char of Accounts
SAKNR : G/L Account

  
Table name :  SKAT : G/L Account Master Record ( Chart of Accounts : Description )
Fields:

SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account

Viewed 18323 times by 4036 viewers

SDN SAP: Control Data of Document Types

December 18, 2009 by mySAP · 1 Comment
Filed under: General Ledger Configuration 

SDN SAP: Document Type Definition

Document types are created for customer, vendor and general ledger business transactions in SAP Financial Accounting. The document types in SAP differentiate business transactions and control filing.

A number range is specified for each document type. Document numbers are chosen from this number range. One number range can be used for several document types.

 

Contol Data of Document Types Setting:

  • Net document type indicator
  • Cust/vend check
  • Negative Postings Permitted
  • Inter-company postgs
  • Enter trading partner

Read more

Viewed 12384 times by 4569 viewers

Difference between transaction key KDB and KDF

April 20, 2009 by mySAP · Leave a Comment
Filed under: General Ledger Configuration 

What is the difference between SAP transaction key KDB and KDF?

Both transaction keys determine which account will be posted when there is gain/loss from exchange rate conversion.

Exch. Rate Diff. using Exch. Rate Key (Transaction Key: KDB)
Exchange Rate Dif.: Open Items/GL Acct (Transaction Key: KDF)

  Read more

Viewed 6081 times by 2868 viewers

SAP Document Number Ranges

April 14, 2009 by mySAP · 1 Comment
Filed under: General Ledger Configuration, SAP Tutorial 

Document Number Ranges are defined per Company Code in SAP system and be assigned to each SAP Document Type in the SAP system.

 

SAP Document Number Ranges can be maintained by:

  • Maintaining intervals: Create and change Number Ranges
  • Changing the status: Intentionally change the Current Number field

 

SAP Number Ranges are valid based on the fiscal year. If year specific Document Numbers are not desired, a future year must be specified in the Year field.

Read more

Viewed 8892 times by 4327 viewers

SAP Document Type

Each SAP document is characterized by a Document Type.

 

The SAP Document Type is a two-character alphanumeric key that identifies documents.

  • The SAP Document Type distinguishes between types of business transactions that are posted

SA: General Ledger Accounting Document
DR: Customer Invoice
DZ: Customer Payment

Read more

Viewed 11327 times by 5324 viewers

VAT Registration Number (TH Country Version)

April 1, 2009 by mySAP · Leave a Comment
Filed under: General Ledger Configuration 

In Thailand the following Customizing settings is required for the company code global data in the IMG:

The following steps need to be done for SAP VAT Registration Number.

  • Maintain the company’s VAT Registration number as the format ‘THxxxxxxxxxx’ in SAPThailand is using the VAT registration field in the company code global data master to store the company’s VAT registration number.However this field can only be used if the company code is in a EU country. Thus you have to activate the ‘EU country’ field in the country definition of “TH” – Thailand through…

SAP Menu Path:
IMG > General Settings > Set countries > Define countries

After maintaining the company’s VAT registration number in the company code global data, you then need to deactivate this ‘EU country’ field again in the country definition of “TH”.

The prefix “TH” is a required then followed by the company’s VAT registration number.

Read more

Viewed 7553 times by 3480 viewers

Page 1 of 3123

mySAP ERP | SAP Business | SAP Tutorial | SAP Help