KEMBAR78
AA SAP T-Codes - Example - Config Reference | PDF | Accounts Payable | Withholding Tax
100% found this document useful (1 vote)
4K views97 pages

AA SAP T-Codes - Example - Config Reference

Uploaded by

dbambros
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
100% found this document useful (1 vote)
4K views97 pages

AA SAP T-Codes - Example - Config Reference

Uploaded by

dbambros
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 97

SAP baseline configurations

IMG Area T-Code Config(C )


Description Transaction(T)

Create Company Code OX02 C


Enterprise Structure
èDefinitionè Financial
Accountingè Maintain
Company Code

Enterprise structure / OX01 C


assignment / materials
management
Create chart of account OB13 C
Financial Accountingè
General Ledgerè G/L
Accounts è Master Data è
G/L Account Creationè Two
Level ManualèCreate Chart
of account

Allocate Company Code to OB62 C


chart of account
Financial Accountingè
General Ledger Accountingè
G/L Accounts è Master Data
è G/L Account Creationè
Two Level Manualè Allocate
Company Code to COA

Define account creation screen OBD4 C


layout
Financial Accountingè
General Ledger Accountingè
G/L Accounts è Master Data
è G/L Account Creationè
Two Level Manualè

Define screen layout

Enter Global Parameters OBY6 C


OBY6
Financial
AccountingèFinancial
Accounting Global Settingsè
Company Codeè Enter Global
Parameters

VAT registration ID OY01 C

Define retained earning OB53 C


account
Accountingè General
Ledger Accountingè G/L
Accounts è Master Data è
G/L Account Creationè Two
Level Manualè

Create Controlling Area OX06 C


Enterprise
StructureèControllingè
Maintain Controlling Area

Maintain Controlling Area OKKP C


Controllingè
Controlling Generalè
Organizationè Maintain
Controlling area
Basic Data
Activate components OKKP C
Controllingè
Controlling Generalè
Organizationè Maintain
Controlling Area
Activate Comp. / Controll
Indicators
Assign Company Codes to OKKP C
Controlling Area
Controllingè
Controlling Generalè
Organizationè Maintain
Controlling area
Assignment of Co. Code
Create accounts FS01 C

Create costcenter KS01 C


Create costelement KA01 C
KA02 C
Financial Accounting - OBY6 C
Financial Accounting Global
Settings - Company Code –
Enter Global Parameters

Financial Accounting - OB22 C


Financial Accounting Global
Settings - Parallel Currencies -
Define additional local
currencies

Financial Accounting - OBBO C


Financial Accounting Global
Settings - Documents -
Posting Periods – Define
Variants for open posting
periods -

Financial Accounting - OBBP C


Financial Accounting Global
Settings - Documents -
Posting Periods – Assign
Variants to Company Code

Open Posting Periods OB52 C


Financial Accounting - FBN1 C
Financial Accounting Global
Settings - Document –
Document number ranges

OBH1 C
OBH2 C
Document Types ObA7 table t003 C
Document Types ObA7 table t003

Financial Accounting - OBA4 C


Financial Accounting Global
Settings – Line Item – Define
tolerance groups for employee

OBA3 C
Validation Rules
Financial Accounting – GGB0 C
Special Purpose Ledger –
Tools – Maintain
Validation/Substitution/Rules –
Maintain Validation

Financial Accounting - OB28 C


Financial Accounting Global
Settings - Document – Line
Item – Define validations for
posting
Revaluation
Financial Accounting- OBA1 C
Finanicial General Ledger-
Business transactions –
Closing – Valuate – Foreign
currency valuation - Prepare
automatic postings – Exch.rate
diff.for forgn.curr.balances

Exchange rate difference for OBA1 C


open items

Controlling – Overhead Cost OKB9


Controlling - Cost Center
accounting – Actual Postings –
Manual actual postings –
Maintain automatic account
assignment

Global Settings-Currencie- OBBS C


Define Translation Ratios for
Currency Translation
Cross application OB72 C
componentsèDistribution
Aleèstandard ale business
processèglobal organizational
unitsèset up cross system
company code

Financial Accounting - OBY6 C


Financial Accounting Global
Settings - Company Code –
Enter Global Parameters

Controlling – Overhead Cost OKB9 C


Controlling - Cost Center
accounting – Actual Postings –
Manual actual postings –
Maintain automatic account
assignment

Financial Accounting- spro C


>Financial Accounting Global
Settings->Company Code-
>Enter Global Parameters-
>VAT Registration Numbers
(VAT Reg.No.)--> Define
Foreign VAT Registration
Numbers

Field status OBC4 C

Financial Accounting / OBC5 C


Financial Accounting Global
Settings / Document / Line
item / Controls
Settings / Document / Line
item / Controls

Assign Cross System Co Code OBV7 C


to Chart of accounts
Allocate Co Code to Non- OBCL C
Taxable Transactions),
okeo C
Tests: Post with Cost Center

Post with Profit Center


Post with default profit Center

Revaluation on open items

Additional Configuration
Completed: OBV7 (Assign
Cross System Co Code to
Chart of accounts), OBCL
(Allocate Co Code to Non-
Taxable Transactions), updated
table ZSEN (entity/sub-entity)
with G1/00.

Enterprise Structure > OX10 C


Definition>Logistics
General>Maintain Plant

Enterprise IMG button – OX18 C


Enterprise
Structure>Assignment>Logisti
cs General>Assign Plant to
Company Code

Enterprise IMG button – OMGJ C


Materials
Management>Invoice
Verification>Define Tax
Jurisdiction Code

SM30 C

Enterprise OX17 C
Structure>Assignment>Materi
als Management>Assign
Purchasing Organization to a
Plant

Logistics – General>Logistics OMS2 C


Master Data: Material
Master>Material>Control
Data>Define Attributes of
Material Types
Logistics – General>Logistics OMS2
Master Data: Material
Master>Material>Control
Data>Define Attributes of
Material Types

Check all plants on table SE16


T159L

Materials Management / OMJ8 C


Inventory Management /
Goods Receipt

Materials Management / OMB3 C


Inventory Management /
Goods Receipt/ Create Storage
Location Automatically

Enterprise OX09 C
Structure>Definition>
Materials
Management>Maintain
Storage Location
Materials OMWD C
Management>Valuation and
Account Assignment>Account
Determination>Group
Enterprise structure / OX08 C
definition / materials
management
Enterprise structure / OX14 C
Definition / Logistics –
General / Define Valuation
Level

Financial Accounting / OB63 C


Financial Accounting Global
Settings / Document / default
values for editing documents

Create Purchasing Groups OME4 C

Materials management /
purchasing
Define account group screen OBD3 C
layout (vendor)
Financial Accounting/
Accounts Receivable and
Accounts Payable/
Vendor Accounts/Master
Records/
Preparations for Creating
Vendor Master Records/
Define Account Groups with
Screen Layout (Vendors)
Define company code- OB24 C
dependent screen layout
(vendor)
Financial Accounting/
Accounts Receivable and
Accounts Payable/
Vendor Accounts/Master
Records/
Preparations for Creating
Vendor Master Records/
Define Screen Layout per
Company Code (Vendors)
Define activity dependent OB23 C
screen layout (vendor)
Financial Accounting/
Accounts Receivable and
Accounts Payable/
Vendor Accounts/Master
Records/
Preparations for Creating
Vendor Master Records/

Define Screen Layout per


Activity (Vendors)
Create number range for XKN1 C
vendor account
Financial Accounting/
Accounts Receivable and
Accounts Payable/
Vendor Accounts/
Master Records/
Preparations for Creating
Vendor Master Records/
Create Number Ranges for
Vendor Accounts
Allocate number ranges to OBAS C
vendor account groups
Financial Accounting/
Accounts Receivable and
Accounts Payable/
Vendor Accounts/
Master Records/
Preparations for Creating
Vendor Master Records/
Assign Number Ranges to
Vendor Account Groups
Update global company code OB72 C
for ALE link
OB72

Cross-Application
components / distribution
(ALE) / standard ALE business
processes / global organization
units

Set up payment methods by FBZP C


country

Financial Accounting/
Accounts Receivable and
Accounts Payable/
Business Transactions/
Outgoing Payments/
Automatic Outgoing
Payments/
Payment Method/Bank
Selection/
Configure Payment Program/

Select 'Payment
Methods/country"
Financial Accounting/ FBZP C

Accounts Receivable and


Accounts Payable/

Business Transactions/
Outgoing Payments/
Automatic Outgoing
Payments/
Payment Method/Bank
Selection/
Configure Payment Program/

Select 'Payment
Methods/company code’
Financial accounting / OBB8 C
accounts receivable and
accounts payable / business
transactions / outgoing
invoices credit memos /
maintain terms of payment

Financial Accounting / OB88 C


financial accounting global
settings / company code / vat
registration no.
Financial Accounting / OB41 C
Financial Accounting Global
Settings / Document / Line
item / Controls

Financial Accounting / OB71 C


Financial Accounting Global
Settings / Document / Line
item / Controls

Financial Accounting / OXK1 C


Financial Accounting Global
Settings / Document / Line
item / Controls

Financial Accounting / OB28 C


Financial Accounting Global
Settings / Document /
document header

Financial Accounting / OBBH C


Financial Accounting Global
Settings / Document /
document header

Financial Accounting / OB56 C


Financial Accounting Global
Settings / Document / Line
item

Financial Accounting / OB68 C


Financial Accounting Global
Settings / Document / default
values for editing documents

Logistics - General / logistics OMSY C


master data material master /
material / control data/
Maintain company codes for
material management

MMPV C

MMPI C

?? MMRV C
Materials management / OMEU C
purchasing / purchase order/
Set tolerance limits for price
variance for purchasing

Materials management / OMC0 C


inventory management / goods
receipt/ Set tolerance limits on
GR

Materials management / OMSK C


valuation and account
assignment / account
determination

Materials management / OBYC C


valuation and account
assignment / account
determination/ Create
automatic postings

Materials management / OMR6 C


invoice verification / invoice
block/ Set Tolerance limits on
invoice
Materials management / OMRH C
invoice verification / invoice
block / item amount check/
Activate item amount check

Materials management / OMRI C


invoice verification / invoice
block / item amount check

Materials management / OMR5 C


invoice verification / clearing
account maintenance
Materials management / OMR3 C
invoice verification / clearing
account maintenance/ Set
default values for account
maintenance - Pre setting for
write-off
Materials management / OMRB C
invoice verification /
authorization management
Check table T169V Se16

Materials management / OMY6 C


Purchasing / Purchase Order/
Define number ranges
Materials management / OMG1 C
purchasing / foreign trade
custom / Basic data for foreign
trade/ Define commodity code

Materials management / OMG2 C


purchasing / foreign trade
custom / transportation data
Define customs offices

Materials management / OMG3 C


purchasing / foreign trade
custom/ transportation data

Materials management / OMG4 C


purchasing / foreign trade
custom/ Basic data for foreign
trade/ Define business
transaction type

aterials management / OMG5 C


purchasing / foreign trade
custom/ Basic data for foreign
trade/ Define default values for
business transaction types
Materials management / OMG6 C
purchasing / foreign trade
custom/ Basic data for foreign
trade

Financial accounting / OBCA C


accounts receivable and
accounts payable / Business
transactions / incoming
invoices credit memos / EDI/
Allocate company-code

Financial accounting / OBCB C


accounts receivable and
accounts payable / Business
transactions / incoming
invoices credit memos / EDI

/ Assign GL accounts for EDI


procedure

Financial accounting / OBCC C


accounts receivable and
accounts payable / Business
transactions / incoming
invoices credit memos / EDI/
Assign additional account
assignment for EDI procedure

Financial accounting / OBCD C


accounts receivable and
accounts payable / Business
transactions / incoming
invoices credit memos / EDI/
Allocate tax codes

Financial accounting / OBCE C


accounts receivable and
accounts payable / Business
transactions / incoming
invoices credit memos / EDI/
Enter program parameters for
EDI incoming invoices
accounts payable / Business
transactions / incoming
invoices credit memos / EDI/
Enter program parameters for
EDI incoming invoices

Financial Accountingè OBCN C


Financial Accounting Global
Settings è Tax on
Sales/Purchases è Basic
Settings èCheck and Change
Settings for Tax Processing

Financial Accountingè OBQ1 C


Financial Accounting Global
Settings è Tax on
Sales/Purchases è Basic
Settings èCheck Calculation
Procedure èDefine Condition
Types (one of three choices)
è Choose (icon)

Tax Procedure Financial OBQ3 C


AccountingèFinancial
Accounting Global Settings è
Tax on Sales/Purchases è
Basic Settings èCheck
Calculation Procedure
èDefine Procedures (one of
three choices) è Choose
(icon)
Financial OBBG C
AccountingèFinancial
Accounting Global Settings è
Tax on Sales/Purchases è
Basic Settings èAssign
Country to Calculation
Procedure

Financial Accountingè FTXP C


Financial Accounting Global
Settings è Tax on
Sales/Purchases è Calculation
èDefine Taxes on
Sales/Purchases

Financial OB40 C
AccountingèFinancial
Accounting Global Settings è
Tax on Sales/Purchases è
Posting èDefine Tax
Accounts (double click on
transaction code and enter
COA)

Tax category FS01 –create C


Financial FS02 – change C
AccountingèAccounts
Receivable and Accounts
Payable è Business
Transactions è Incoming
Payments èIncoming
Payments Global Settings
èDefine Accounts for Cash
Discount Granted

FS03 - display C
Financial OBXI C
AccountingèAccounts
Receivable and Accounts
Payable è Business
Transactions è Incoming
Payments èIncoming
Payments Global Settings
èDefine Accounts for Cash
Discount Granted

Financial Accountingè OBC8 C


Financial Accounting Global
Settings è Tax on
Sales/Purchases è Calculation
èChange Foreign Currency
Translation

Exchange rate difference OBYY C


Financial
AccountingèFinancial
Accounting Global Settings è
Tax on Sales/Purchases è
Posting èDefine Account for
Exchange Rate Difference
Posting

Extended withholding

Activate WHT for the SPRO C


Company Code Financial
AccountingèFinancial
Accounting Global Settings
è Company Code è
Activate Extended
Withholding Tax
Activate WHT to Tax SPRO C
Countries: Financial
Accounting èFinancial
Accounting Global Settings
è Withhold Tax è
Extended Withholding
TaxèBasic
SettingsèCheck
Withholding Tax Countries

WHT Official Tax Code SPRO C


Financial Accountingè
Financial Accounting
Global Settings è
Withholding
TaxèExtended
Withholding TaxèBasic
SettingsèDefine Official
Withholding Tax Codes

Withholding Tax Types SPRO C


Financial Accountingè
Financial Accounting
Global Settings è
Withholding
TaxèExtended
Withholding
TaxèCalculationsèWithh
olding Tax TypeèDefine
Withholding Tax Type for
Payment Posting
WHT Codes Financial SPRO C
Accountingè Financial
Accounting Global Settings
è Withholding
TaxèExtended
Withholding
TaxèCalculationèè
Withholding Tax Codes è
Define Withholding Tax
Codes

Formulas for calculating SPRO C


WHT tax Financial
Accountingè Financial
Accounting Global Settings
è Withholding
TaxèExtended
Withholding
TaxèCalculationèè
Withholding Tax Codes è
Define Formulas for
Calculating Withholding
Tax

Check Recipient Types SPRO C


Financial Accountingè
Financial Accounting
Global Settings è
Withholding
TaxèExtended
Withholding TaxèBasic
Setting à Check Recipient
Type
Min/Max by Tax Type SPRO C
Financial Accountingè
Financial Accounting
Global Settings è
Withholding
TaxèExtended
Withholding
TaxèCalculationsèMinim
um and Maximum Amounts
èDefine Min/Max
Amounts for Withholding
Tax Types

Tax Types to Company SPRO C


Codes
Financial Accountingè
Financial Accounting
Global Settings è
Withholding
TaxèExtended
Withholding Taxè

Company CodeèAssign C
Withholding Tax Types to
Company Codes
Postings Financial OBWW C
Accountingè Financial
Accounting Global Settings
è Withholding
TaxèExtended
Withholding Taxè

Postingsè Accounts for


Withholding TaxèDefine
Accounts for Withholding
Tax to be Paid Over

PPOM C
SU01D
SM04
FEBA T
FBRA T
FI12 T
se09 C
SE10 C
WE20 C
WE21 C
WE09 T

we02 T
we60 T
wedi T

we05 T
fb03 T

fb01 T
fb02 T
we19 T
bd87 T
fbl1 T

fk10 T
fd10 T
FS10, FS10N T
SQ01

se36 c
okb2 c
okb3 c
se38

se84
se11
se12
mr02
ggb1
AL11

ME25 T
me21 T
me22 T
me23 T
MR1M T

MR01 T

fb08 T

mr08 T

f110 T

obyr C

f-43 T

VF44 T

VF11 T
FBL3N T

VF48 T

VA02/VA42 or VA03/VA43T

VF45 T

F.13 T

VF46 T

VF47 T

V48 T

fd01 T
FD02 T
FD03 T
SEARCH_SAP_MENU
SE93 T
SM01 T

VLPOD T
xd01 T
xd02 T
xd03 T
xk01 T
xk02 T
xk03 T
fk01 T
fk02 T
fk03 T
VOV6 C
VOV7 C
VOV8 C
VOVR C

OVBS C

OVBI C
OVBO C
SE17
VKOA
VD51
SE93
Configuration Data NTK, Notes GL Plant Vendor
Description/keywords 1 2 3

Enter company code data Create Company code, maintain 1 1


company code, company code
maintenance,

Assigning purchasing organization to company code Porg to company code 7

Chart of account: COCD 2

Length of GL Account 10 digits


COCDè COCD 3

Chart of account 4

Asset group

From acct #
To account#
Description
ASST 16000000991999ZZZZ99
Long term assets

Fiscal year Variant: HP 5 9


5 9
Field Status Variant: WWOO

Posting Period Variant: IL00

Vat Registration ID: - Withholding tax id Additional


data filed ‘TIK NIKUIY ISRAELI’ (NESS package is
needed)

For VAT Reg# for none EU countries 6


1. Need to select the EU country flag (OY01) for the
country
2. Insert vat reg no via OBY6 for the company code,

3. Remove EU country flag(OY01).

S Account# 7

X Account#

Controlling Area: COCD 8


CoCDèCO area : 2

Currency Type: 30
COA -> COCD
Fiscal Year Variant -> HP

Basic data 9

Create Prime Hierarchy


COCD- Prime

10
>Activate components/control indicators

Costcenter: 2

Other indicators:

All currencies: x
CompCode: validation x
>Assignment of company code(s) 11

Maintain controlling area: COCD

Account#, company code, balance sheet or P&L, 12


account group, currency, tax category, recon account,
filed status group, etc
create cost center 13
create cost element, is the same as a gl account 14
change cost element, maintain cost center
• Set flags “prop. Fiscal year’ 15
• Prop. Value date,
• No foreign exchange rate when clearing in loc.
Currency
• Crcy transl. For tax: 1
• Cctyp: Group currency as first parallel currency è 16
10-ILS
• Ex. Rt. Type :use M-rateè M
• Srce: translate from transaction currency è1
• Translation date: use translation dateè 3
• Copy OB22 for IL10 as a reference co code.
• Posting Period assign to IL00 17

Allocate comp. Code COCD to posting period variant 18


IL00.

Manual activity 19
Manual activity Document Number ranges 20 10

AP Direct Document types 21


Description
Doc Type Doc type reversal
Account Clearing
AB(06) AB(06)
Document types 21

Copy tolerance groups for employees from IL10 to 22


COCD.

Define Customer/Vendor tolerance Tolerance group, FI

Change validations 23
IL1001 – standard set (This can be copied to COCD01)

Application area : FI
Call Point 2

Assign COCD WW0001 Call point 1 24


Assign COCD COCD01 Call point 2
Assign COCD WW0003 Call point 3

Exchange rate. difference key “blank” for comp. Code 25


COCD
“blank” 3723009999 (for all Balanced Managed
accounts)

For each open Item managed account create link for


‘xxxxRVxxxx’ account with differences to 3723009999

Table T030H

Maintain table T030H for exchange rate differences 26


from open items for individual accounts in company
Code XXXX
Expense Account,
E/R gains acct
Created default cost center XX for accounts 27

3723009999 -> E200000000


3855009999-> e200000000
3801009999->E200000000
3807009999->E200000000
3740009999->E200000000

NEED COST CENTERS (KA01) ACCOUNTS


CREATED

Currency relationship table TCURF Refer to ILS 28


Currency Relationship spreadsheet for entries
Create Company Code COCD 29

Assign cross company codes COCD to Company Code 30


COCD

VP related account assignments: 31


-Price variance accounts per valuation area
3723**
-3702 cash discount earned
-3899 system rounding differences
-
RM related account assignments
-4610 Bad debts
-4630 Bad debts recover

VAT - 513726026 32

Create field status group ‘TAX1 in WW00. Copy 33


‘TAX’. Select Additional data… , change Cost
Center and Quantity to ‘optional’.
Assign company code to field status variants Company code field status, line
item
COCD à CoCd 34

CoCd à X0 tax 35

Hierarchy cost center group Hierarchy 36


Gl notes

Enter Plant details plant 1 2


•Plant – Number (EN/SE)
•Name 1 – Name of Plant (description)
•Language Key - Language Code
•Street
•Postal Code – Zip Code
•City
•Country Key – Country Code
•Region - Enter two digit State (For US Only)
Assign plant to company code Plant to company code 2 6

Tax jurisdiction code plant 3

Add table data, update table data plant, update table data 4
New Plant to the ZSEN Table
Purchasing Organization to a Plant Porg, plant, purchasing 5 8

Valuation Area = Plant Valuation area, plant 6

Default value ‘HALB’.


Valuation area, plant 6

CLICK ON “CHANGE” enter 'HALB' , click on


“quantity value””, then “diff valuation areas”, search
for plant and 'Qty Update' and 'Update value' flags
ON for Valuation area
New Plant to Table T159L Plant, t159l, werks, auto, sloc, 7
storage location, view table data,
see table data, view table data
Prerequisite task before to turn the OMJ8
transaction.
Do not transportable.
New Plant to Table T159L Plant, t159l, werks, auto, sloc, 8 12
storage location, Plant
parameters
Check – ‘Create Sloc. Automat.
Check – ‘Create Sloc. Automat. MM, Storage location

Default Storage Location Storage location, MM 9 3

Group Together Valuation Areas Valuation area 10


Valuation Group Code = Company Code
Include company name
Maintain purchasing organization Porg, purchasing organization 4

Valuation area is assigned to plant 5

Added the flag to 'Y' for 'Propose Fiscal Year'. (see also 11
OBY6) for company code

MM, Create Purchasing Groups 13

Set vendor data screen filed status display, suppress, vendor field status 14
optional, required.
Field status values are optional when the Account Company code vendor field 15
Group is the primary control status

Otherwise enter values as designed for the company


code

Field status values are optional when the Account Vendor field status by activity 16
Group is the primary control.

Otherwise enter values as designed for the company


code

HP uses the ‘Centrally’ maintenance approach. The


create and change are to be optional. The Display
option is set to display.

Maintain vendor number ranges Vendor number ranges, account 17


groups

Number ranges to account groups Vendor number ranges, account 18


groups

Prerequisite

account groups (OBD3) numbers(XKN1)

Set up for company code ALE 19


Set up for company code ALE 19

Set up payment methods by country Create payment methods, change 20


payment methods, maintain
payment methods

Set up payment methods by company code Company code payment methods, 21

Create payment methods, change


payment methods, maintain
payment methods

Set up payment terms Create Payment terms, delete 22


payment terms, change payment
terms, maintain payment terms

Define domestic VAT registration numbers ONLY FOR


EC COUNTRIES
Define posting keys FI, GL, Define posting keys

Select screen variant for document entry GL, document entry

Maintain subscreens for coding blocks Subscreen blocks, GL,

Define validations for posting GL validations

Define substitution in accounting documents Substitution, document header

Define texts for line items

Define default value date

Initialize MM posting period – table MARV MM

Maintain company codes for material management

This is need to perform mm posting period updates.


MMPV, MMRV
update MM posting period MM
program RMMMPERI
Table MARV
Initialize MM posting period – table MARV, program MM
RMMMINIT
table MARV
Update MM Posting period, Step one period at a time MM,
to desired period
Set tolerance limits for price variance for purchasing MM,

‘PE’ and “SE”

Set tolerance limits on GR MM

AP Direct only MM

Create automatic postings MM, automatic posting

DIF:
rules – debit/credit
account = 3723009999
posting key
debit =40 credit = 50

KDM:
rules – debit/credit
account = 3723009999
posting key
debit =40 credit = 50

WRX: GR/IR clearing acct


rules – debit/credit
account = 2390AP9999
posting key debit = 86
credit = 96
Set Tolerance limits on invoice Invoice tolerance limits

Tolerance limit for invoice price discrepancy is 5%


and 500$ (2000 ISL) – still to be defined, it will depend
on company code currency

The tolerance limit for quantity discrepancy is 0


Limit AN: do not check
Limit AP: do not check
Limit BD: do not check
Limit BR: do not check
Limit BW: do not check
Limit DQ: The tolerance limit for quantity discrepancy
is 0

Limit DW: do not check


Limit KW: do not check
Limit LA: do not check
Limit LD: do not check
Lower limit 90 days
Upper limit 90 days
Limit PP:
Currency = USD
Check abs.lower % = 5%
Check abs. upper % = 5%
Limit PS: do not check
Limit SK: do not check
Limit ST: do not check
Limit VP: do not check
Limit WI: do not check
Limit ZD: do not check
Limit ZL: do not check

Activate item amount check MM, item check, item amount


check,

Set item amount check - Determine if GR following is MM, item check, item amount
needed check,

Set the flag “Goods receipt” to OFF


Maintain document types and number ranges MM, GL

MM, write off


Determine tolerance groups MM,

Cgeck contents of a table This table is updated by the MM, Check table contents
OMxx shortcut keyes, so this task in mainly to check
this table.
Put a sample record to explain whatever needs to be
checked.

If the table needs updated,


Update table T169V using SM30 (V_169V) for posting
keys f.
Update table T169V using SM30 OMR2 or SM30
(V_169V_ST) for tax codes.
Purchasing document number ranges MM, Purchasing document
numbers

Commodity code MM
Country: ‘IL’
Comm/imp code no: ‘APDEFAULT’
Description: ‘Default for A / P’ (‘Country’)

Ctry: IL MM

Customs office: APDEF


Description: Default for A / P (‘Country’)

Ctry: IL MM

Mode of Transport: 3 – Road


Ctry key:IL MM

Bus transaction type: 11 - Definite purchase/sale


Part of baseline MM
Part of baseline MM

Used for EDI s link to SWAN for IDOC interface EDI, SWAN , interface, partner
profile
Partner type LS
Partner no WF_EU_FI
Company-code name in the invoice(max 17 chars)
“XXXXXXXXXXXXXXXXX”
Ccode COCd

Used for EDI s link to SWAN for IDOC interface EDI, SWAN , interface

Partn type LS
Partn number WF_EU_FI
Company-code CoCd
Goods/services no. *
Company-code CoCd

Used for EDI s link to SWAN for IDOC interface EDI, SWAN , interface

Partn type LS
Partn number WF_EU_FI
Company-code CoCd
Acct assgmt ID *
Controlling area XXXX

Tax code setup for EDI s link to SWAN for IDOC EDI, SWAN , interface,
interface

There is an entry for each tax code by partner number.

Communicate the tax codes and scenarios to SWAN IT


for SWAN setup.

Setup for EDI s link to SWAN for IDOC interface for


invoice processing Partn type LS
Partn number WF_US_MM
Company-code IL00
G/L db.pstg ky 40
G/L cr.pstng ky 50
Vend.deb.pstng ky 21
Vend.cred.pstng ky 31
Tax-ex.tax code X0
Invoice doc.type WF
Cred.memo doc.type KG
Standard unit EA

Accounting Key VAT, processing keys

Set up internal processing keys as needed; they


determine accounts or posting keys for line items that
are created automatically

Condition Type VAT

Set up condition types as needed; they determine the


calculation rule and the side of the posting
Tax Procedure VAT

Set up a tax procedure for each country


Assign a Tax Procedure Vat, tax procedure

Link the tax procedure to a country


Configure Tax Codes Vat, Tax codes,

Tax G/L Accounts Vat, tax gl accounts, tax posting


keys

1) Link the tax codes to a G/L tax account

2) Set rules

3) Set Posting keys


Ensure the ‘tax category’ in the G/L account set up is Gl account, VAT
correct
Discount Account Gl discount account

Link the tax code to a G/L discount account


Exchange rate

Exchange Rate:
Set manual exchange rate entry possible
Exchange Account:

Define account for exchange rate difference posting


This is a separate section due to the lack of specific t-
codes. Most of withholding is via SPRO menu path.

Activate the extended WHT for a company code


Include country keys for country withholding tax

Set up Official WHT key for country. Used for


Reporting

Set up Withholding tax type and related Extended withholding,


information by country
Set up tax codes

Table: T059Z
Table: T059F

The tax base and withholding tax rate is defined in


the withholding tax code. The withholding tax
code is a 2-digit code in SAP. It is configured at
the country level and linked to a withholding tax
type. Therefore, one can define as many
withholding tax codes as required for each
withholding tax type.

To avoid other impacts, it is recommended one tax


code per one tax type
Set limits for withholding tax Withholding limits, withholding
tolerance

Assign the withholding tax types to company Extended withholding


codes

Assign accounts to Withholding type/code Withholding GL accounts,


combinations, enter posting keys debit and credit, withholding accounts

Workflow, Organizational plan


User Maintenance
User List, helps with identifying transport owners
Outstanding item
Reverse cleared documents, reverse documents
house bank setup, bank accounts
see transports
see transports
partner profiles
port definition
find idocs, best used to find idocs with specific data by
segment and element, Can use we60 to see idoc type
structure
find idocs
idoc type structures
find idocs, this is an inclusive t-code for we02, we05,
we60, we20, we21, we46
find idoc
display documents, a good assistant is the 'LIST' button

Post a document
change a document
copy an idoc
play an idoc, rerun an idoc, run idoc, process idoc
see vendor transactions see vendor transactions see
vendor line items
Vendor account balance Vendor account balance
Customer account balance Customer account balance
General Ledger Account Balance
user groups, query for user groups user groups query for user groups

logical databse builder


automatic cost center generation maintain cost center
controlling area
used to edit programs, run programs, programs, variants, program
documentation, abap
database, programs,
change Table structures, create table structures
displ;ay Table structures
release an invoice item, invoice item release
change substitution
Review SAP directories, progarm rswatch0 review directories, see
directories

create a purchase order, PO


create a purchase order, PO
change a purchase order, PO
display purchase order, PO
PO Invoicing, enter invoice against a PO, used in SWAN invoicing

MM invoicing used for goods receipt, GR/IR

reverse invoice - nonpo

reverse invoice related to BPO

Payment trancode

Accounting Configuration for Special General Ledger Indicator

Accounts payable invoice processing

Revenue Recognition SD

invoice cancellation SD
show the line items of an accrual account FI

compare the FI and SD values created by the SD


billing process

to view the sales document flow.

displays the deferred revenues,the unbilled SD


receivables, the billed and the realized
amounts

automatic clearing process in FI with Related to Revenue


transaction Recognition

revenue cancellation was posted

shows inconsistencies between the revenue SD


recognition tables VBREVK, VBREVE and
VBREVR and the appropriate sales
documents

compare report serves to explain the balance


of an accruals account used in the Revenue
Recognition
Create a customer master record
Change a customer master record
View a customer master record
find the menu path of a transaction
custom transaction code shows transactions
to view transactions (Be careful with this one
as its used to lock transactions. To browse
the transactions start typing the transaction
and hit enter. The cursor goes to the entry
starting with what you typed. Hit enter to page
down from there.

Standard - proof of delivery POD


Maintain Centrally, Create Customer Master
Maintain Centrally, Change Customer Master
Maintain Centrally, Display Customer Master
Maintain Centrally, Create Vendor Master
Maintain Centrally, Change Vendor Master
Maintain Centrally, Display Vendor Master
Create Vendor Master
Change Vendor Master
Display Vendor Master

Maintain Item categories


Document Type Maintenance,
sales document type, order type
Contract data table TVVD, used dates
from t-code OVBS and
validity period Category
Date determination, Contract Data table tvrg, needed for
Contract Data(t-code
VOVR)
Billing Plan Types for Periodic Billing Table fpla
Billing Plan Types for Milestone Billing
Read only database tables
Assign GL Account
Sales material information record
custom transaction code
Engine/ VAT EWHT CWHT Banking Revenue
Invoice 5 6.1 6.2 / Pay’ts Recognition
Verify
4

9
9
11

12
12

20

21
14

15
2

26
26

27

29

28

33

23

30
1

10
13

16

17

18

19

22

24

25

X
31

32

34

35

36
37

38

39

40
41

42

43

44

45

46

47

48
49

50

51

52

53 11

54
1

3
4

7
8

10

1
2

4
5

7
8

10

4
3
contract data
aaaaaaaaaaaa 10/5/2009
ADRC address data
bkpf invoice header, AP Posted Invoice Header
BNKA Bank country/key table
bsak AP closed items
bseg invoice line item, AP Posted Invoice Detail
BSIK AP Open Items Table
BSIP AP Duplicate Invoice checking table
e071 show transports, see transports, see objects
e071k show transports, see transports, see objects
edidc idoc data
edidd idoc data
edids idoc processing status
effn PO account assignment, purchase order
eket PO additional information, purchase order
ekko PO header data, purchase order
ekpo PO item data, PO line item, purchase order
GB90 Substitution rule data, transaction code OBBH to populate
kna1 customer master
knb1 customer master extended to company code
KN* Customer Master data
KNVV customer master sales data
KONP vat tax condition type
LFA1 Country level vendor data
LFB1 company code vendor data
LFBK Bank country/key table
LFBW vendor extended withholding
LIKP Duplicate ship ID checking - autovoucher
MSEG Table for Query with good receipt looking for PO and FI info
rgblo
SKA1 General ledger master, GL
SKB1 General ledger account extended to company code
T001Q Contains substitution association with the company code
T001W Plant/company code Information
t001wt withholding tax type and recipient type by company code
T001-XGJRV Fiscal Year Parameters - company code
T007A VAT tax codes
T030K vat tax code gl accounts data
T052 payment terms
t059c withholding tax type and recipient type by country
t059d withholding tax type and recipient type by language by country
T059p withholding tax types by country
T059u withholding tax types by language by country
t059z withholding tax types and codes by country, withholding percentage
t059zt withholding tax type and code by language by country
T066 Document Entry Screen Variant
T076M EDI converion of external tax obcd
Table Description
tspa organizational unit, sales division
TSTC trancodes, programs, Use transaction SE16 to access table and find out program associated with transaction
tvko organizational unit, sales organization data
tvtw organizational unit, distribution channels
USR10 Security Profile Description
UST04 Security Table
VBKPF AP Parked Invoice Header
VBSEG AP Parked Invoice Detail
With_item Withholding tax item
YMaUVCHRDT Auto voucher detail
YMAUVCHRHDAuto voucher header
YMMTTRK Material Tracking Table
YMT001L USE SM30, query by content to get plant assoc. w/cost center
reguh payment header data
regup payment detail data
VBREVK revenue recognition tables - control line
VBREVE revenue recognition tables - revenue lines
VBREV revenue recognition tables - reference lines
KNA1 General Data in Customer Master
KNA1VV Customer Master View KNA1 KNVV
KNAS Customer master (VAT registration numbers
KNAT Customer Master Record (Tax Groupings)
KNB1 Customer Master (Company Code)
KNB4 Customer Payment History
KNB4_AEDAT BW FI: KNB4 Extraction using AEDAT
KNB5 Customer master (dunning data)
KNBK Customer Master (Bank Details)
KNBW Customer master record (withholding tax ty
KNC1 Customer master (transaction figures)
KNC1_AEDAT BW FI: KNC1 Extraction using AEDAT
KNC3 Customer master (special G/L transaction f
KNC3_AEDAT BW FI: KNC3 Extraction usign AEDAT
KNEA Assign Bank Details and Payment Methods to
KNEX Customer Master: Legal Control - Sanctione
KNKA Customer master credit management: Central
KNKA_AEDAT BW FI: KNKA Extraction using AEDAT
KNKK Customer master credit management: Control
KNKK_AEDAT BW FI: KNKK Extraction usign AEDAT
KNKKF1 Credit Management: FI Status Data
KNKKF2 Credit Management: Open Items by Days in A
KNKO Assignment of Cost Est. Number to Config.
KNMT Customer-Material Info Record Data Table
KNMT_REF Test - Search Help for KNMT
KNMTK Customer-Material Info Record Header Table
KNMT_REF Test - Search Help for KNMT
KNMTK Customer-Material Info Record Header Ta
KNOB Assignment of Cost Est. Number to Confi
KNVA Customer Master Unloading Points
KNVD Customer master record sales request fo
KNVH Customer Hierarchies
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions
KNVS Customer Master Shipping Data
KNVT Customer Master Record Texts for Sales
KNVV Customer Master Sales Data
KNZA Permitted Alternative Payer

VBAG Sales Document: Release Data by Schedule L


VBAK Sales Document: Header Data
VBAP Sales Document: Item Data
VBBE Sales Requirements: Individual Records
VBBS Sales Requirement Totals Record
VBDATA Update data
VBEH Schedule line history
VBEP Sales Document: Schedule Line Data
VBEPDG Appendix Table for Dangerous Goods Data
VBEPDGAP DG: Appendix Table for VBEPDG
VBERROR Update error information
VBEX SD Document: Export Control: Data at Item
VBFA Sales Document Flow
VBFS Error Log for Collective Processing
VBHDR Update header
VBKA Sales Activities
VBKD Sales Document: Business Data
VBKFZ Cumulative Quantity Corrections
VBKK SD Doc.Export Letter of Credit
VBKOF SD index: Open sales activities by partner
VBKPA SD index: Sales activities by partner func
VBKPF Document Header for Document Parking
VBLB Sales document: Release order data
VBLK SD Document: Delivery Note Header
VBMOD Update function modules
VBMUE Sales Document: Characteristic Overview
VBMUET Sales Document: Characteristic Overview De
VBMUEZ Sales Document: Characteristic Overview As
VBOX SD Document: Billing Document: Rebate Inde
VBPA Sales Document: Partner
VBPA2 Sales document: Partner (used several time
VBPA3 Tax Numbers for One-Time Customers
VBPK Sales Document: Product Proposal Header
VBPM Supplement for Sales Document Items: Techn
VBPV Sales Document: Product Proposal
VBREF SD Object Link to Item References
VBREVAC Revenue Recognition:
Revenue Recognition:
CompressionCompression
of FI Revenue
of FI Postings
Rev
VBREVC RevenueRevenue
Recognition:
Recognition:
Worklist of
Worklist
Changedof Changed
Sales Documents
S
VBREVE RevenueRevenue
Recognition:
Recognition:
RevenueRevenue
Recognition
Recognition
Lines L
VBREVK RevenueRevenue
Recognition:
Recognition:
Control Lines
Control Lines
VBREVR RevenueRevenue
Recognition:
Recognition:
Reference Reference
Document Document
Lines Li
VBRK Billing Document: Header Data
VBRL Sales Document: Invoice List
VBRP Billing Document: Item Data
VBSEC Document Parking One-Time Data Document Se
VBSEGA Document Segment for Document Parking - As
VBSEGD Document Segment for Customer Document Par
VBSEGK Document Segment for Vendor Document Parki
VBSEGS Document Segment for Document Parking - G/
VBSET Document Segment for Taxes Document Parkin
VBSK Collective Processing for a Sales Document
VBSN Change status relating to scheduling agree
VBSP SD Document Item for Models of Material St
VBSS Collective Processing: Sales Documents
VBUK Sales Document: Header Status and Administ
VBUP Sales Document: Item Status
VBUST
VBUSTINTER
VBUV Sales Document: Incompletion Log
VBWF01 Company Code-Dependent Release Data
VBWF02 Workflow Procedure
VBWF03 Release Approval Paths
VBWF04 Line Item Fields Reversal Release
VBWF05 Determination of Release Approval Path
VBWF06 Subworkflow Determination
VBWF07 Release Groups
VBWF08 Release Groups
VBWF09 People with Release Authorization for Docu
VBWF10 Release Approval Paths (Texts)
VBWF11 Objects for Full Release
VBWF12 Objects for Full Release (Texts)
VBWF15 People with Release Authorization for Docu
VBWF16 Relevant Document Types for Releasing Paym
VBWRK Update: Worklist for mass processing

SEARCH_SAP_MENU

FPLA Billing Plan, related revenue recognition, sales orders ,


TVAK Sales Order Types
TVAKT Sales Document Type text
TVVD Contract data
TVRG Date determination
TVLZ Valid period Category
MVKE Sales Data for material
TVVW item usage
tptm item category group material master
T184 sales document item category determination
tauum sales order types language key
TVKM Material Account Assignment Group
TVAP Sales Document: Item Categories
tfpla Billing Plan data
VEDA Contract Data
TVAST Sales Document Blocking reason: Text
Mara
TVAU Sales Documents: Order Reasons
TVAUT Sales Documents: Order Reasons: Texts
TVFS Billing Block Reasons
TVCLK Blocking reason
TVKTT Customers: Account Determination Groups: Texts
tstc SAP transaction codes
tstct SAP transaction codes

ZVLPOD Proof of delivery at item level


ogram associated with transaction
sales order header
sales order item
contract data, order management, sales document type

contract data, order management, related to date determination


Contract data Order management, contract start date, contract end date
Contract data Order management
Material Account Assignment Group
used for sales document item category determination
used for sales document item category determination
used for item category assignment table

maag

Transactional data tied to the sales document


Billing Block reason
Billing
Billing
caag

pod
MM MODULE

CYCLE:
Purchase Requisition (PR) Request for Quotation (RFQ) (Vendor Evaluation)
Purchase Order (PO) Goods Receipt Note (GRN) Invoice Verification Data to FI

Tables and important Fields.

LFA1 – vendor data (LIFNR)


LFB1 -- Company Code Segment : Vendor Data(LIFNR, BUKRS)
LFC1 -- FI Related Vendor Data (LIFNR, BELNR)
LFM1 – Pur. Orgn. Related Vendor Data (LIFNR, EKORG)

MARA – Material Master (MATNR)


MARC – Material Master with Plant Data (MATNR, WERKS)
MARD – Material Master with Storage Location Data (MATNR, LGORT, WERKS)
MAKT – Material Master Material Descriptions (MATNR, MATKL)
MBEW – Material Valuation Data (MATNR, BWTAR)
MVKE – Material Master : Sales related Data
MDKP, MDTB – MRP related Data( Header, Item)
MCHA, MCHB – Material Batches (Header, Item) (MATNR, WERKS, LGORT, CHARG)

EBAN – Pur. Req. Data( BANFN, BNFPO, BADAT, MATNR)


EINA – Purchase Info. Record(General Data)(INFNR, MATNR, LIFNR)
EINE – Purchase Info. Record (pur. Orgn. Data) (INFNR, EKORG)
ELBK, ELBN, ELBP – Vendor Evaluation Related Data
EKKO – PO Data (Header) (EBELN, BSTYP, BSART)
EKPO – PO Data (Item) (EBELN, EBELP, MATNR)
Pur. Req., RFQ and PO are differentiated by Doc Type (BSTYP) in EKKO table.
For RFQ it is ‘A’ and for PO it is ‘F’
MKPF – GRN Data (Header) (EBELN, BLDAT, BUDAT, XBLNR, BKTXT)
MSEG – GRN Data(Item) MBLNR, BWART, LIFNR, MATNR, EBELN)
Apart from this there are lot of tables which begin with ‘M’ & ‘E’, but we
use the following very often.
EQUK – Quota (Header)(QUNUM, MATNR)
EQUP – Quota (Item) (QUNUM, QUPOS, LIFNR)
EKBE – PO History Data (EBELN, EBELP, BELNR, BLDAT, MATNR, VGABE)
EKBZ – PO History with Delivery Costs(EBELN, BELNR, LIFNR, XBLNR)
EKET – Schedule lines data of a PO(EBELN, EINDT, SLFDT)
EKES – Vendor Confirmations Data (EBELN, EBTYP, EINDT, XBLNR)
T163F – Confirmation Texts (EBTYP, EBTXT)
T156 – Movement Types (BWARE)
T024 – Purchasing Groups
T024E – Purchase Organizations
T163 – Item Category’s in Purchasing Documents(PSTYP)
T149D – Valuation Types
T134 – Material Types
FVLK – Delivery Types
STKO, STPO – BOM(Bill Of Material) related Data (Header & Item)
STPU, STPN, STST, STZU – BOM Related Tables
RKPF, RBKP, RSEG (Header & Item) – MM – FI Related Data
KONO, KONH – Pricing data
T006 – Basic Unit Of Measurements
SALES & DISTRIBUTION MODULE RELATED TABLES :

Cycle:
Enquiry  Quotation  Sales Order  Delivery(Picking, Packing, Post Goods Issue and Shipment)  Billing  Data to FI.

TABLES and Important Fields :


VBAK : Sales Document(Header Data) (VBELN)
VBAP : Sales Document(Item Data) (VBELN, POSNR, MATNR, ARKTX, CHARG)
Enquiry, Quotation, Sales Order are differentiated based on Doc.
Type(VBTYP Field) in VBAK, VBAP Tables for Enquiry VBTYP = A, for Quotation ‘B’ & for Order it is ‘C’.)
LIKP : Delivery Table(Header Data) (VBELN, LFART, KUNNR, WADAT, INCOL)
LIPS : Delivery Table(Item Data)(VBELN, POSNR, WERKS, LGORT, MATNR, VGBEL)
(LIPS – VBGELN = VBAK- VBELN, LIPS-VGPOS = VBAP-POSNR)
VTTK : Shipment Table(Header Data) (TKNUM)
VTTP : Shipment Table (Item Data)(TKNUM, TPNUM, VBELN)
(VTTP – VBELN = LIKP – VBELN)
VBRK : Billing Table(Header Data) (VBELN, FKART, BELNF)
VBRP : Billing Table(Item Data) (VBELN, POSNR, FKIMG, NEWR, VGBEL, VGPOS)
(VERP – AUBEL = VBAK- VBELN, VBRP – VBEL = LIKP – VBELN)
Apart from these tables there are lot of other tables which starts with ‘V’, but we use the
following tables frequently.
VBUK: All Sales Documents status & Admn. Data(Header) (VBELN, VBTYP)
VBTYP = ‘C’ (Sales Order) VBTYP = ‘L’(Delivery) VBTYP = ‘M’(Invoice)
VBUP: Sales Documents status & Admin. Data(Item) (VBELN, POSNR)
VBEP : Sales Document Schedule Lines Data (VBELN, POSNR, EDATU, WMENG)
VBKD: To get sales related Business data like Payment terms etc.(VBELN, ZTERM)
VBFA: Sales Document flow data(VBELV, VBELN, POSNV, VBTYP)
VBPA: Partner functions Data(VBELN, PARVW, KUNNR, LIFNR)
TVLKT: Delivery Type: Texts(LFART, VTEXT)
KNA1, KNB1, KNC1 : Customer Master Data and Other Partner’s Data(KUNNR,
NAME1,LAND1)
KNVK: Customer Master Contact Person(PARNR, KUNNR)
KNVV: Customer Master Sales Data.
LFA1, LFB1, LFC1: Vendor Master Data(To get Transporter data)(LIFNR, NAME1, ORT01)
MARA, MARC, MARD : Material Master Data(Basic, Plant, St. Location Views)
TVKO: Sales Organizations(VKORG)
TVKOV: Distribution Channels(VTWEG)
TVTA: Divisions(SPART)
TVKBZ: Sales Office(VKBUR)
TVBVK: Sales Group(VKGRP)
T077D: Customer Account Group(KTOKD)
T001W: Plants(WERKS)
T001L: Storage Locations(LGORT)
TWLAD: To get address of Storage Location and Plant(LGORT, ADRNR)
TVAU: Sales Document (Order) Types
KONV: Condition Types (pricing) (KNUMV, KSCHL, KWETR)
T685T: Condition Types Texts.
ADRC: To get Addresses of Partners
VBBE, VBBS: Sales Requirements Data
VBKA: Sales Activities Data
VBPV: Sales Document Product Proposal
PP & PM Module

AFKO: PP Order Header Data


AFPO: PP Order Item Data
AFVV: Order Operations Data Qty/Date/Values
AFVC: Operations within an Order
AFRU: Order Completion Confirmation
CSLA: Activity Types Master Data
CSLT: Activity Types Texts
KAKO: Capacity Header Segment
CRHD: Work Center Header Data
AUFK: Order Master Data
AFIH: Maintenance Order Header
AUFM: Goods Movement For Order
EQUI: Equipment Master Data
EQKT: Equipment Texts
ILOA: PM Object Location
T024I: Maintenance Planner Groups
T357: Plant Section
IFLO: Functional Location Text
IHSG: Permits in PM
IHGNS: Permit segment in PM
T357G_T: Permit Text
RESB: Reservation / Dependent requirement
V_EQUI: View for Equipment description
VIAUFKS: View for Order and Equipment Data
CAVFVD: Work Center Text.
VIQMEL: Notification Header View
VIQMFEL: PM Notification View
VIQMMA, VIQMSM : Views for Activities and Tasks

FI/CO Module

T001: Company Codes


T002: Language Keys
T003: FI Document Types
T004: Chart Of Accounts
T005: Country Keys
T007A: Tax Keys
T012: House Banks
TKA01: Controlling Areas
SKA1, SKB1: G/L Account Master data
SKAT : G/L Accounts Texts
KNBK: Customer Master(Bank Details)
LFBK: Vendor Master (Bank Details)
BKPF: Accounting Doc. Header
BSEG: Accounting Doc. Item(Cluster Table)
BSIS: G/L Open Items
BSAS: G/L Closed Items
BSID: Customer Open Items(Account Receivables)
BSAD: Customer Closed Items)(Account Receivables)
BSIK: Vendor Open Items(Account Payables)
BSAK: Vendor Closed Items(Account Payables)
BKPF and BSEG Tables consists of data from BSIS, BSAS, BSID, BSAD, BSIK, and BSAK tables.
BSET: Tax Information
BSEC: One Time Vendor Records
CSKS: Cost Center Master
CSKT: Cost Center Texts
CSSK: Cost Center/ Cost Element Relations
GLPCA: EC-PCA: Actual Line Items
GLPCT: EC-PCA: Totals Table
COEP: Co-Object Line Items by Period
COST: Co-Object Price Totals
CSSL: Cost Center- Activity Type
CRCO: Work Center- Cost Center Assignment
CSLA: Activity Types Master(LSTAR)
CSKB: Cost Elements(KSTAR, KOKRS)
COSS: Cost Totals(OBJNR, KSTAR)
COBL: Coding Block
CEPC: Profit Center Master Data
BNKA: Master Records of banks
TBSL: Posting Keys
KEKO: Product Costing Header Data
ANLH: Main Asset Number
ANLA, ANLB, ANLC : Segment Assets Masters
Careers at Detering
Submit Resume
vicesSolutionsConsultingAboutCareersContactSitemap
ject AdjectiveCopyright © 2007 Detering Consulting, Inc.
ing  Data to FI.
Sample configurations: (In sequence to be performed)

Company code and GL configurations:

C:\DBAData\Non
Standards to4_5\APIndirect\Wave3\IL10Sales, IL60Indigo, IL97Services, IL00Labs\IL00

Plant configuration:

C:\DBAData\Non
Standards to4_5\AP Indirect\Wave3\IL10Sales, IL60Indigo, IL97Services, IL00Labs\IL

Vendor configuration:

C:\DBA Data\Non
Standards to 4_5\AP Indirect\Wave 3\IL10 Sales, IL60 Indigo, IL97 Services

SAP engine/ Invoice verification configuration:

C:\DBA Data\Non
Standards to 4_5\AP Indirect\Wave 3\IL10 Sales, IL60 Indigo, IL97 Serv

SAP VAT tax configuration:

C:\DBA Data\Non
Standards to 4_5\AP Indirect\Wave 3\IL10 Sales, IL60 Indigo, IL97 Services
C:\DBA Data\Non
Standards to 4_5\AP Indirect\Wave 3\IL10 Sales, IL60 Indigo, IL97 Services

SAP Extended Withholding Tax

C:\DBA Data\Non
Standards to 4_5\AP Indirect\Wave 3\IL10 Sales, IL60 Indigo, IL97 Services, IL00
Use trancode se38
Input the program name
select display the code
Position cursor on line of code for the program to stop
Press the 'STOP' sign (a stop sign displays)
exit the code

When running the program the code will process to the 'STOP' sign
You now have the options to step through the code (F6)
You can view the variables by curtting from the code and pasting the table

The 'STOP' sign is removed upon program termination.


Step 1 verify the fields are available to be used in the substitution.
SE16 and view table GB01, Check to make sure the 'Exclude' column is blank.
IF an 'X' is there use program zupdgb01 to set the field value removing the 'X'.
Transport the step

Step 2 If aIf user


a user
exit
exit
is is
needed
needed
forfor
thethe
substitution,
substitutionedit
add the sub-routine to ZGGBS000(this is for all financial documents, invoices, payments)

Step 3 - configure the substititution


Use OBBH
Navigation is varied here depending on what is needed. Work with it.
To create a new substitution select "Environment" "Substitution"
Add entries as needed to the new substition or to an existing substitution via a copy. .
Simulate ' the substitution
The process tabs are helpful for the operation needed.
Create a transport

NOTE: Check the target system for the company code associated to the
substitution rule using OGGH (table T001Q). If not, then create a transport to
associate the substitution to the company code using OBBH at the top level
selecting the line item and following the process. Remember to select the line item
using the 'include in request ' button.

Other trancodes - GGB1 - Change substitution

Debug notes
use 'STOP' function in program using se38 F6 steps through the code.

The program needs to be available before the OBBH substitution is configured.


Transports

Release transports -

******Include target system '/US5/'

To see transport log


Logon to desired system.
se10 on source system - look at tranpsort log and note the tranport log path/file name
on target system as indicated on the file name noted above, se38 enter program rswatch0 (AL11 if you
navigate to path/file name noted above

MM posting period update

Initialize MM posting period - table MARV with trancode OMSY


Maintain company codes for material management
This is need to perform mm posting period updates. MMPV, MMRV

Field status hierarchy(highest to lowest), Hide, Display, Required, Oprtional

VAT taxes
1. FTXP to enter taxes
2. OB40 fo GL accounts assigned to tax codes
3. Transport rates using export/import

Payment Config
1. FBZP for payment methods to company and country, …
2. FI12 Bank configuraion
3. we20 partner profile configuration
4. we21 port definition port assignment
5. Archscripts and directories

To find T-codes
Table: TSTC - Tcodes, TSTCT - Tcode Texts
SE93 shows transactions
I also use SM01 to view transactions (Be careful with this one as it's used to lock transactions. To browse the transactions start typing the
Use transaction SEARCH_SAP_MENU to find the menu path of a transaction

While SAP doesn’t provide real technical documentation, you can still do a lot to get the information about SAP data model an
is published as one of the articles in the ABAP Knowledge Corner from Richard Harper. Apart from that, lots of information is s
For the function modules’, the best way is to use the www.se37.com – a searchable library of documentation. If you want to (tr
output to be printed on screen and in the popup window (coming after F8 – Run) check all the checkboxes to get the documen
normally all older tables (master data and core transaction data tables) are more or less documented, you get a report.
t log path/file name
enter program rswatch0 (AL11 if you have access)

pdates. MMPV, MMRV

browse the transactions start typing the transaction and hit enter. The cursor goes to the entry starting with what you typed. Hit enter to page down from the

formation about SAP data model and the sources of data for your programs. A trick you can do if you have no idea where the data is comin
part from that, lots of information is stored right in the SAP system, as standard documentation for programs, functions and ABAP Dictionar
y of documentation. If you want to (try to) get a document from SAP for a database table, here’s the trick: you run the report RSSDOCTB, s
the checkboxes to get the documentation not only for the table but also for relationships and data elements. If you are lucky enough, mean
ocumented, you get a report.
ou typed. Hit enter to page down from there.

ave no idea where the data is coming from. It


rams, functions and ABAP Dictionary objects.
k: you run the report RSSDOCTB, select the
ments. If you are lucky enough, meaning that
Cost Center and Cost element configuration

GL Hierarchy

ksh1
okeo
ks01
ka01

Steps to build cost centers and cost elements


1. Create/verify GL accounts - FS01/FS03
2. Create Cost Center KS01
3. Create Cost Element KA01
Program Description

zpapf030_new israel invoice payment report, payment proposal

rswatch0 See transport log files

zggbs000 Financial document substitution

SDRR* Revenue Recognition Programs(Reports)

You might also like