240 likes | 256 Views
This practice session covers various tasks related to accounts payable, accounts receivable, and asset accounting in SAP TERP10. Topics include entering vendor invoices, displaying open items, running automatic payment, creating customer master data, and more.
E N D
SAP TERP10 Preparation Practice 11 Dr. Gábor Pauler, Associate Professor, Private Entrepeneur Tax Reg. No.: 63673852-3-22 Bank account: 50400113-11065546 Location: 1st Széchenyi str. 7666 Pogány, Hungary Tel: +36-309-015-488 E-mail: pauler@t-online.hu
Content of the Practice • Checking Home Assignment 10: TravelingCost • 9. Financial Accounting Scenario (Continued) • 9.7. AccountsPayable • 9.7.1. FI:Enter VendorInvoice:Vend=100304 10000EUR to CCMSD-Name:FB60 • 9.7.2. FI:Display openitemsatVendorInvoice:Comp=1000,Vend=100304:FBL1N • 9.7.3. FI:Automaticpaymentrun:Comp=1000,Vend=100304, NextMo:F110 • 9.7.4. FI:Display cleareditems:Comp=1000,Vend=100304:FBL1N • 9.7.5. FI:Display cleareditems:ReconcAcct161010:FAGLB03 • 9.8. AccountsReceiveable • 9.8.1. FI:Display customerwithincompletemasterdata:Comp=1000, Cust=CName:F.32 • 9.8.2. FI:Create Credit Management Master:Cust=CName, TotLim=500000EUR, LimCredContArea=1000, Limit=10000EUR:FD32 • 9.8.3. SD:CreateSalesOrder:Cust=CName, Mat=MiniBike-Name, Quant=10PC, Plant=1000, SalOrg=1000, Chnl=10:VA01 • 9.8.4. FI:ReleaseBlocked SD Document:Cust=CName:VKM1 • 9.9. Asset Accounting • 9.9.1. FI:CreateAsset Master Record:Asset=Forklift-Name,CostCtr=CCMSD-Name:AS01 • 9.9.2. FI:Display assetin P&L statement:Comp=1000, BuisArea=3000:S_ALR_87011965 • 9.9.3. FI: Display assetinBalanceSheet:Comp=1000, BuisArea=3000:S_ALR_87012284 • 9.9.4. FI:Post AssetAcquisition:BuyForklift-NamefromVendor=1000for35000EUR+10%Tax:F-90 • 9.9.5. FI:Asset Explorer:Comp=1000, 3414 0 (Forklift-Name):AW01N • 9.10. BalanceSheet and Profit&LossStatement • 9.10.1. FI:ModifyBalanceSheet and P&L Reportstructure:Acct=90NumbinStatementINT:FSS0 • 9.10.2. FI:CreateBalanceSheet and P&L Report:Comp=1000 • 9.11.Process Overview and Data Dependencies • 9.12.Data StreamOverview • Home Assignment 11: Export BalanceSheet and P&L Report • References • ObjectSymbols • GUI Symbols
9. FI Scenario| 9.7.Accounts Payable| 9.7.1.Enter Vendor Invoice Click • 9.7.Accounts Payable • 9.7.1.FI:Enter VendorInvoice:Vend=10030410000EUR to CostCtr=CCMSD-Name: FB60 • Acct|FI|AcctPayabl|Doc entry|FB60 Invoice| • 9.7.1.1.SCR:Start • DDN:Company = 1000 • 9.7.1.2.SCR:Main • 9.7.1.2.1.TAB:Basic data • DDN:Vendor = 100304 • DDN:Invoice date = Yesterday • DDN:Posting date = Now • TBX:Amount = 10000 • TBX:Tax amount = 0 • DDN:Tax code = 0I(income tax 0%) • TBX:Text = RentName • 9.7.1.2.1.1.FRM:Lines • Line:01: • DDN:G/L account = 470000 • DDN:D/C = S(Debit) • DDN:Amount in doc. curr = 10000 • DDN:Cost center = CCMSD-Name • 9.7.1.2.2.BTN:Save( ) • Take note of vendor invoice number: Click Click Click FSP0: Create Account C/A: CONS|INT 312600| 900001 Click Click FSS0: Create Account Comp 1000: 900001 Click Click FB50: Enter G/L AcctDoc Cmp1000 900001 Deb:5000 Click FS10N: Check Account Comp 1000: 900001 FB60: Enter Invoice: Vendor 100304 CostCtr CCMSD- Paul 10000EUR 1900000000
9. FI Scenario| 9.7.Accounts Payable| 9.7.2.Display open items • 9.7.2.FI:Display open items at Vendor Invoice:Comp=1000, Vend=100304:FBL1N • Acct|FI|AcctPayabl|Acct|FBL1N Display/Change line item| • 9.7.2.1.SCR:Start • DDN:Vendor account = 100304 • DDN:Company code = 1000 • DDN:Open items = True • DDN:Open to key date = Now • BTN:Run( ) • 9.7.2.2.SCR:Main • LIN:Text = Rent Name, 10000EUR|DoubleClick|SCR:Detail| • DDN:Reconc Acct = 161010:The whole vendor subledger (100304) communicates with G/L through 161010foreign vendor reconciliation account FSS0: Create Account Comp 1000: 900001 Click Click FB50: Enter G/L AcctDoc Cmp1000 900001 Deb:5000 Click Click Click FS10N: Check Account Comp 1000: 900001 Click FB60: Enter Invoice: Vendor 100304 CostCtr CCMSD- Paul 10000EUR Click Click FBL1N: Display OpenItem: Vendor 100304 Comp 1000 Click Click
9. FI Scenario| 9.7.Accounts Payable| 9.7.3.Payment Run Click • 9.7.3.FI:Automatic payment run:Comp=1000, Vend=100304, NextMo:F110 • Acct|FI|AcctPayabl|Periodic proc|F110 Payments| • 9.7.3.1.SCR:Start • DDN:Run date = Now • TBX:Identification = PName • 9.7.3.1.1.TAB:Parameters • DDN:Posting date = Now • DDN:Documents entered up to = Now • DDN:Company code = 1000 • DDN:Pmnt meths = S(Check) • DDN:Next p/date = Now+1Month • DDN:Vendor = 100304 • 9.7.3.1.2.BTN:Save( ) • 9.7.3.1.3.TAB:Status|BTN:Proposal|SCR:Create Proposal • CHK:Start immediately = True • KEY:Enter Wait 1 minute! • 9.7.3.1.4.BTN:Update status • TBX:Status = Payment proposal created • 9.7.3.1.5.BTN:Display proposal|SCR:View Proposal • In case of error Edit|Proposal|Delete, retry! • The „Red LED” is not error signal here, it shows open payment position! • 9.7.3.1.6.TAB:Status| BTN:Payment run|SCR:Create payment run • CHK:Start immediately = True • KEY:Enter • 9.7.3.1.7.BTN:Update status • TBX:Status = Payment run has beeen carried out Click Click Click FB50: Enter G/L AcctDoc Cmp1000 900001 Deb:5000 Click FS10N: Check Account Comp 1000: 900001 Click FB60: Enter Invoice: Vendor 100304 CostCtr CCMSD- Paul 10000EUR FBL1N: Display OpenItem: Vendor 100304 Comp 1000 Click Click F110: Payment Run: Vendor 100304 Comp 1000 Click Click
9. FI Scenario| 9.7.Accounts Payable| 9.7.4.Display cleared items • 9.7.4.PRACTICE: FI:Display cleared items:Comp=1000, Vend=100304:FBL1N • Acct|FI|AcctPayabl|Acct|FBL1N Display/Change line item| • 9.7.4.1.SCR:Start • DDN:Vendor account = 100304 • DDN:Company code = 1000 • DDN:All items = True • DDN:Posting date = Empty! • BTN:Run( ) • 9.7.4.2.SCR:Main • LIN:Text = Rent Name, 10000EUR, Clearing doc = Empty!(Not cleared yet) • 9.7.5.FI:Display cleared items:ReconcAcct=160000:FAGLB03 • Acct|FI|G/L|Acct|FAGLB03 Display balances| • 9.7.5.1.SCR:Start • DDN:Account Number = 161010 • DDN:Company = 1000 • DDN:Fiscal Year = CurrYr • BTN:Run( ) • 9.7.5.2.SCR:Main • LIN:Month:Balances are influenced by all vendors assigned to 161010 reconciliation account! FB60: Enter Invoice: Vendor 100304 CostCtr CCMSD- Paul 10000EUR FBL1N: Display OpenItem: Vendor 100304 Comp 1000 Click F110: Payment Run: Vendor 100304 Comp 1000 Click Click Click Click Click FBL1N: Display ClrdItem: Vendor 100304 Comp 1000 FAGLB03: Display ClrdItem: ReconAcct 161010
Content of the Practice • Checking Home Assignment 10: TravelingCost • 9. Financial Accounting Scenario (Continued) • 9.7. AccountsPayable • 9.7.1. FI:Enter VendorInvoice:Vend=100304 10000EUR to CCMSD-Name:FB60 • 9.7.2. FI:Display openitemsatVendorInvoice:Comp=1000,Vend=100304:FBL1N • 9.7.3. FI:Automaticpaymentrun:Comp=1000,Vend=100304, NextMo:F110 • 9.7.4. FI:Display cleareditems:Comp=1000,Vend=100304:FBL1N • 9.7.5. FI:Display cleareditems:ReconcAcct161010:FAGLB03 • 9.8. AccountsReceiveable • 9.8.1. FI:Display customerwithincompletemasterdata:Comp=1000, Cust=CName:F.32 • 9.8.2. FI:Create Credit Management Master:Cust=CName, TotLim=500000EUR, LimCredContArea=1000, Limit=10000EUR:FD32 • 9.8.3. SD:CreateSalesOrder:Cust=CName, Mat=MiniBike-Name, Quant=10PC, Plant=1000, SalOrg=1000, Chnl=10:VA01 • 9.8.4. FI:ReleaseBlocked SD Document:Cust=CName:VKM1 • 9.9. Asset Accounting • 9.9.1. FI:CreateAsset Master Record:Asset=Forklift-Name,CostCtr=CCMSD-Name:AS01 • 9.9.2. FI:Display assetin P&L statement:Comp=1000, BuisArea=3000:S_ALR_87011965 • 9.9.3. FI: Display assetinBalanceSheet:Comp=1000, BuisArea=3000:S_ALR_87012284 • 9.9.4. FI:Post AssetAcquisition:BuyForklift-NamefromVendor=1000for35000EUR+10%Tax:F-90 • 9.9.5. FI:Asset Explorer:Comp=1000, 3414 0 (Forklift-Name):AW01N • 9.10. BalanceSheet and Profit&LossStatement • 9.10.1. FI:ModifyBalanceSheet and P&L Reportstructure:Acct=90NumbinStatementINT:FSS0 • 9.10.2. FI:CreateBalanceSheet and P&L Report:Comp=1000 • 9.11.Process Overview and Data Dependencies • 9.12.Data StreamOverview • Home Assignment 11: Export BalanceSheet and P&L Report • References • ObjectSymbols • GUI Symbols
9. FI Scenario| 9.8.Accounts Recieveable| 9.8.1.Display customer Click • 9.8.Accounts Recieveable • 9.8.1.FI:Display customer with incomplete master data:Comp=1000, Cust=CName:F.32 • Acct|FI|AcctReciev|Credit mngmt|Credit mngmt Info Sys|F.32 Incomplete data| • 9.8.1.1.SCR:Start • DDN:Company = 1000, BTN:Run( ) • 9.8.1.2.SCR:Main • LIN:Cust = CName: Credit master should be empty! • 9.8.2.FI:Create Credit Management Master:Cust=CName, TotLim=500000EUR, CredContArea=1000, Limit=10000EUR:FD32 • Acct|FI|AcctReciev|Credit mngmt|Master|FD32 Change| • 9.8.2.1.SCR:Start • DDN:Customer = CName • DDN:Credit control area = 1000 • CHK:Central data = True • CHK:Status = True • 9.8.2.2.SCR:Main • 9.8.2.2.1.SCR:Central data • TBX:Total amount = 500000 • TBX:Individual limit = 100000(In one order) • DDN:Currency = EUR, BTN:Next( ) • 9.8.2.2.2.SCR:Status data • TBX:Credit limit = 10000(In one order, one credit control area) Don’t press Enter here! • DDN:Risk category = 001(Low) • DDN:Credit rep. group = 001 • 9.8.2.2.3.BTN:Save( ) Click Click Click F110: Payment Run: Vendor 100304 Comp 1000 Click Click Click FBL1N: Display ClrdItem: Vendor 100304 Comp 1000 FAGLB03: Display ClrdItem: ReconAcct 161010 Click Click F.32: Display CustCred: Comp 1000 Cust CPaul Click Click Click Click Click Click FD32: Create CustCred Master: Cust CPaul 500KEUR 10KEUR
9. FI Scenario| 9.8.Accounts Recieveable| 9.8.3.Create Sales Order • 9.8.3.PRACTICE:SD:Create Sales Order:Cust=CName, Mat=MiniBike-Name, Quant=10PC, Plant=1000, SalOrg=1000, Chnl=10:VA01 • LO|SD|Sales|Order|VA01 Create • 9.8.3.1.SCR:Start • DDN:Order type = OR(Standard order) • DDN:SalOrg = 1000 • DDN:DistChan = 10 • DDN:Division = 00 • 9.8.3.2.SCR:Main • 9.8.3.2.1.FRM:Head • DDN:Standard order = Empty! • DDN:Sold-to-party = CName • TBX:PO Number = OName • 9.8.3.2.2.TAB:Sales • DDN:Req. deliv.date = Now+1Week • 9.8.3.2.2.1.FRM:Item LIN Material Order quantity 01 MiniBike-Name 10PC • BTN:Conditions|SCR:Cond|LIN:New|CnTy=PR01,Amount=3000 • 9.8.3.2.3.BTN:Save( ) • 9.8.3.2.3.1.ERR:Dynamic credit check exceeded! • This is normal because 10 MiniBike-Name costs 30000EUR which is biggerthanthe10000EUR limit • KEY:Enter • Take note of sales order number: FBL1N: Display ClrdItem: Vendor 100304 Comp 1000 FAGLB03: Display ClrdItem: ReconAcct 161010 F.32: Display CustCred: Comp 1000 Cust CPaul FD32: Create CustCred Master: Cust CPaul 500KEUR 10KEUR VA01: Create SalOrd: Cust CPaul MiniBike -Paul 10PC Plnt1000 SOrg1000 Chnl10 • 13535
Content of the Practice • Checking Home Assignment 10: TravelingCost • 9. Financial Accounting Scenario (Continued) • 9.7. AccountsPayable • 9.7.1. FI:Enter VendorInvoice:Vend=100304 10000EUR to CCMSD-Name:FB60 • 9.7.2. FI:Display openitemsatVendorInvoice:Comp=1000,Vend=100304:FBL1N • 9.7.3. FI:Automaticpaymentrun:Comp=1000,Vend=100304, NextMo:F110 • 9.7.4. FI:Display cleareditems:Comp=1000,Vend=100304:FBL1N • 9.7.5. FI:Display cleareditems:ReconcAcct161010:FAGLB03 • 9.8. AccountsReceiveable • 9.8.1. FI:Display customerwithincompletemasterdata:Comp=1000, Cust=CName:F.32 • 9.8.2. FI:Create Credit Management Master:Cust=CName, TotLim=500000EUR, LimCredContArea=1000, Limit=10000EUR:FD32 • 9.8.3. SD:CreateSalesOrder:Cust=CName, Mat=MiniBike-Name, Quant=10PC, Plant=1000, SalOrg=1000, Chnl=10:VA01 • 9.8.4. FI:ReleaseBlocked SD Document:Cust=CName:VKM1 • 9.9. Asset Accounting • 9.9.1. FI:CreateAsset Master Record:Asset=Forklift-Name,CostCtr=CCMSD-Name:AS01 • 9.9.2. FI:Display assetin P&L statement:Comp=1000, BuisArea=3000:S_ALR_87011965 • 9.9.3. FI: Display assetinBalanceSheet:Comp=1000, BuisArea=3000:S_ALR_87012284 • 9.9.4. FI:Post AssetAcquisition:BuyForklift-NamefromVendor=1000for35000EUR+10%Tax:F-90 • 9.9.5. FI:Asset Explorer:Comp=1000, 3414 0 (Forklift-Name):AW01N • 9.10. BalanceSheet and Profit&LossStatement • 9.10.1. FI:ModifyBalanceSheet and P&L Reportstructure:Acct=90NumbinStatementINT:FSS0 • 9.10.2. FI:CreateBalanceSheet and P&L Report:Comp=1000 • 9.11.Process Overview and Data Dependencies • 9.12.Data StreamOverview • Home Assignment 11: Export BalanceSheet and P&L Report • References • ObjectSymbols • GUI Symbols
9. FI Scenario| 9.9.Asset Accounting| 9.9.1.Create Asset Click • 9.8.4.FI:Release Blocked SD Document:Cust=CName:VKM1 • Acct|FI|AcctReciev|Credit mngmt| Exceptions|VKM1 Release blocked doc| • 9.8.4.1.SCR:Start • DDN:Credit control area = 1000 • DDN:Representative group = 001 • DDN:Credit account = CName • BTN:Run( ) • 9.8.4.2.SCR:Main • LIN:CCArea = 1000, CredAcct = CName|Select • BTN:Release • BTN:Save( ) • 9.9.Asset Accounting • 9.9.1.FI:Create Asset Master Record:Asset=Forklift-Name,CostCtr=CCMSD-Name:AS01 • Acct|FI|Fixed assets|Asset|Create|AS01 Asset| • 9.9.1.1.SCR:Start • DDN:Asset class = 3100(Vehicles) • DDN:Company code = 1000 • DDN:Number of similar assets = 1 • BTN:Master data • 9.9.1.2.SCR:Main • TBX:Descr = Forklift-Name • 9.9.1.2.1.TAB:Time.-dependent • DDN:Business Area = 3000(Automotive) • DDN:Cost Center = CCMSD-Name • DDN:Plant = 1000 • 9.9.1.2.2.BTN:Save( ) • Take note of asset number: Click Click Click F.32: Display CustCred: Comp 1000 Cust CPaul Click Click Click Click FD32: Create CustCred Master: Cust CPaul 500KEUR 10KEUR Click VA01: Create SalOrd: Cust CPaul MiniBike -Paul 10PC Plnt1000 SOrg1000 Chnl10 Click Click Click Click Click Click VKM1: Release SalOrd: Cust CPaul Click AS01: Create Asset: Forklift- Paul CostCtr CCMSD- Paul 3405 0
9. FI Scenario| 9.9.Asset Accounting| 9.9.2.Display asset in P&L • 9.9.2.FI:Display asset in P&L statement:Comp=1000, BuisArea=3000:S_ALR_87011965 • Acct|FI|Fixedassets|InfoSys|Reports Asset Acct| AssetBalance |Balance List| AssetBalance|S_ALR_87011965 • 9.9.2.1.SCR:Start • DDN:Company = 1000 • DDN:Business area = 3000 • BTN:Run( ) • 9.9.2.2.SCR:Main • Asset cannot be found in list because asset master was not posted! • 9.9.3.PRACTICE: FI: Display asset in Balance Sheet:Comp= 1000, BuisArea=3000:S_ALR_87012284 • Acct|FI|G/L|InfoSys|G/L Reports|Balacesheet| General Actual/Actualcomp|S_ALR_87012284 Balancesheet and P&L statem| • 9.9.3.1.SCR:Start • DDN:Chart of accounts = INT • DDN:Company Code = 1000 • DDN:Business Area = 3000 • DDN:Financial statement version = INT • BTN:Run( ) • 9.9.3.2.SCR:Main • Asset is not in list because asset master was not posted! VA01: Create SalOrd: Cust CPaul MiniBike -Paul 10PC Plnt1000 SOrg1000 Chnl10 Click Click Click Click Click Click Click Click Click VKM1: Release SalOrd: Cust CPaul Click AS01: Create Asset: Forklift- Paul CostCtr CCMSD- Paul S_ALR: Display Asset In P&L Comp 1000 BuisAre 3000 S_ALR: Display Asset In Balanc Comp 1000
9. FI Scenario| 9.9.Asset Accounting| 9.9.4.Post Asset Acquisition Click • 9.9.4.FI:Post Asset Acquisition:Buy Forklift-Name from Vendor=1000 for 35000EUR+10%Tax:F-90 • Acct|FI|Fixed assets|Posting|Aquisition|External|F-90 With vendor| • 9.9.4.1.SCR:Main • 9.9.4.1.1.FRM:Header • DDN:Document date = Now • DDN:Posting date = Now • 9.9.4.1.2.FRM:Line item 1 • DDN:Posting key(Pstky) = 31(Invoice) • DDN:Vendor Account = 1000 • 9.9.4.1.2.1.KEY:Enter • TBX:Amount = 38500 • TBX:Tax amount = 3500 • DDN:Tax Code = 1I(Income tax 10%) • 9.9.4.1.3.FRM:Line item 2 • DDN:Posting key (Pstky) = 70(Assets debit) • DDN:Account = 3405 0(Forklift-Name) • DDN:Transaction type = 100(External acquisition) • DDN:New Company Code = Empty! • 9.9.4.1.3.1.KEY:Enter • DDN:Amount = 35000 • DDN:Tax Code = 1I(Income tax 10%) • 9.9.4.1.4.BTN:Save( ) • Take note of asset document number: • Asset should show upnow in P&L statement and balance! Click Click Click VKM1: Release SalOrd: Cust CPaul Click Click Click AS01: Create Asset: Forklift- Paul CostCtr CCMSD- Paul S_ALR: Display Asset In P&L Comp 1000 BuisAre 3000 S_ALR: Display Asset In Balanc Comp 1000 F-90: Post Asset Aquisition Forklift- Paul Vendor 1000 35KEUR 10%Tax 1900000021
9. FI Scenario| 9.9.Asset Accounting| 9.9.5.Asset Explorer • 9.9.5.PRACTICE:FI:Display AssetinAsset Explorer:Comp=1000, 3405 0(Forklift-Name):AW01N • Acct|FI|Fixed assets|Asset|AW01N Asset explorer| • 9.9.5.1.SCR:Main • DDN:Company = 1000 • DDN:Asset = 3405 0(Forklift-Name) • 9.9.5.2.SCR:Main • 9.9.5.2.1.FRM:UpLeft • LIN:DeprecArea = 01(Book depreciation US-GAAP)|Select • 9.9.5.2.2.FRM:Right • 9.9.5.2.2.1.TAB:Planned values • LIN:Months • COL:Depreciation = 2333 • 9.9.5.2.2.2.TAB:Posted values • LIN:Months • COL:Depreciation = 0(Will be computedonlyafter depreciation run!) AS01: Create Asset: Forklift- Paul CostCtr CCMSD- Paul S_ALR: Display Asset In P&L Comp 1000 BuisAre 3000 S_ALR: Display Asset In Balanc Comp 1000 F-90: Post Asset Aquisition Forklift- Paul Vendor 1000 35KEUR 10%Tax AW01N: Asset Explorer Comp 1000 Forklift- Paul
Content of the Practice • Checking Home Assignment 10: TravelingCost • 9. Financial Accounting Scenario (Continued) • 9.7. AccountsPayable • 9.7.1. FI:Enter VendorInvoice:Vend=100304 10000EUR to CCMSD-Name:FB60 • 9.7.2. FI:Display openitemsatVendorInvoice:Comp=1000,Vend=100304:FBL1N • 9.7.3. FI:Automaticpaymentrun:Comp=1000,Vend=100304, NextMo:F110 • 9.7.4. FI:Display cleareditems:Comp=1000,Vend=100304:FBL1N • 9.7.5. FI:Display cleareditems:ReconcAcct161010:FAGLB03 • 9.8. AccountsReceiveable • 9.8.1. FI:Display customerwithincompletemasterdata:Comp=1000, Cust=CName:F.32 • 9.8.2. FI:Create Credit Management Master:Cust=CName, TotLim=500000EUR, LimCredContArea=1000, Limit=10000EUR:FD32 • 9.8.3. SD:CreateSalesOrder:Cust=CName, Mat=MiniBike-Name, Quant=10PC, Plant=1000, SalOrg=1000, Chnl=10:VA01 • 9.8.4. FI:ReleaseBlocked SD Document:Cust=CName:VKM1 • 9.9. Asset Accounting • 9.9.1. FI:CreateAsset Master Record:Asset=Forklift-Name,CostCtr=CCMSD-Name:AS01 • 9.9.2. FI:Display assetin P&L statement:Comp=1000, BuisArea=3000:S_ALR_87011965 • 9.9.3. FI: Display assetinBalanceSheet:Comp=1000, BuisArea=3000:S_ALR_87012284 • 9.9.4. FI:Post AssetAcquisition:BuyForklift-NamefromVendor=1000for35000EUR+10%Tax:F-90 • 9.9.5. FI:Asset Explorer:Comp=1000, 3414 0 (Forklift-Name):AW01N • 9.10. BalanceSheet and Profit&LossStatement • 9.10.1. FI:ModifyBalanceSheet and P&L Reportstructure:Acct=90NumbinStatementINT:FSS0 • 9.10.2. FI:CreateBalanceSheet and P&L Report:Comp=1000 • 9.11.Process Overview and Data Dependencies • 9.12.Data StreamOverview • Home Assignment 11: Export BalanceSheet and P&L Report • References • ObjectSymbols • GUI Symbols
9. FI Scenario| 9.10.Balance Sheet and P&L| 9.10.1.Modify stucture • 9.10.Balance Sheet and Profit&Loss Statement • 9.10.1.FI:Modify Balance Sheet and P&L Report structure:Acct=90Numb FinancialStatement=INT:FSS0 • Acc|FI|G/L|Master|G/L Acc|Individ Proc|FSS0 In Company| • 9.10.1.1.SCR:Start • TBX:G/L account = 90Numb • DDN:Company = 1000 • 9.10.1.1.1.BTN:Modify • 9.10.1.2.SCR:Main • 9.10.1.2.1.BTN:Edit FinStatemt version|SCR: Edit FinStatemt| • DDN:FinStatemt = INT • By default all unassigned account arein 8000000 Unassigned node • 9.10.1.2.1.1.LIN:3000000 • LIN:3080000 • LIN:3082000 • LIN:3082090|Select • BTN:AssignAccts|SCR:Change Accts| • LIN:New(Scroll down to firstempty line) FromAcctToAcct Debit Credit 90Numb90Numb Yes Yes • There can be only 40 accounts in 1 node, if no more free space, modify an existing account! • 9.10.1.2.2.BTN:Save( )|SCR:Change request| • BTN:New( ) • TBX:Description = ChangeReq-Name • BTN:Save( ) S_ALR: Display Asset In Balanc Comp 1000 Click Click Click Click Click F-90: Post Asset Aquisition Forklift- Paul Vendor 1000 35KEUR 10%Tax Click Click Click Click Click AW01N: Asset Explorer Comp 1000 Forklift- Paul Click FSS0: Insert 900001 Into INT Click Click S_ALR: Report Balance And P&L Comp 1000 INT
9. FI Scenario| 9.10.Balance Sheet and P&L| 9.10.2.Create report • 9.10.2.PRACTICE:FI:Create Balance Sheet and P&L Report:Comp=1000, FinancialStatement=INT:S_ALR_87012284 • Acct|FI|Fixedassets|InfoSys|ReportsAssAcct|… • 9.10.2.1.SCR:Start • DDN:Company Code = 1000 • DDN:FinStatmt = INT • DDN:Fiscal year = ActYr • DDN:Period = ActMo • BTN:Run( ) • LIN:NewSelection|Select • 9.10.2.2.SCR:Main • 9.10.2.2.1.FRM:Right • 9.10.2.2.1.1.LIN:Balance sheet • LIN:P&L statement • LIN:Other operating charges • LIN:Other operating charges • LIN:Other operating charges • LIN:Expenses SD&M Name = 5000EUR • 9.10.2.2.2.BTN:Save( ) S_ALR: Display Asset In Balanc Comp 1000 F-90: Post Asset Aquisition Forklift- Paul Vendor 1000 35KEUR 10%Tax AW01N: Asset Explorer Comp 1000 Forklift- Paul FSS0: Insert 900001 Into INT S_ALR: Report Balance And P&L Comp 1000 INT
9. FI Scenario: 9.11.Process Overview and Data Dependencies • We overview processes of FI describing data dependencies across transactions: • Precondition (Előfeltétel): , Data dependency (Adatfüggés): SPRO: Display Currency Comp 1000: EUR SPRO: Display Fiscal Year Variant Comp 1000: K4 SPRO: Display Operating Concern ContrAr 1000: IDEA SPRO: Display Cost Center ContrAr 1000: H1 SPRO: Display Chart of Accounts CONS|INT SPRO: Display Chart of Accounts Comp 1000: INT|GKR SPRO: Display Chart of Accounts ContrAr 1000: INT F.10: Display Account C/A: INT 140000 FSP0: Create Account C/A: CONS|INT 312600| 900001 FSS0: Create Account Comp 1000: 900001 FBL1N: Display ClrdItem: Vendor 100304 Comp 1000 FAGLB03: Display ClrdItem: ReconAcct 161010 FB60: Enter Invoice: Vendor 100304 CostCtr CCMSD- Paul 10000EUR FBL1N: Display OpenItem: Vendor 100304 Comp 1000 F110: Payment Run: Vendor 100304 Comp 1000 FS10N: Check Account Comp 1000: 900001 FB50: Enter G/L AcctDoc Cmp1000 900001 Deb:5000 VA01: Create SalOrd: Cust CPaul MiniBike -Paul 10PC Plnt1000 SOrg1000 Chnl10 F-90: Post Asset Aquisition Forklift- Paul Vendor 1000 35KEUR 10%Tax FD32: Create CustCred Master: Cust CPaul 500KEUR 10KEUR AS01: Create Asset: Forklift- Paul CostCtr CCMSD- Paul S_ALR: Display Asset In P&L Comp 1000 BuisAre 3000 F.32: Display CustCred: Comp 1000 Cust CPaul VKM1: Release SalOrd: Cust CPaul S_ALR: Report Balance And P&L Comp 1000 INT S_ALR: Display Asset In Balanc Comp 1000 FSS0: Insert 900001 Into INT AW01N: Asset Explorer Comp 1000 Forklift- Paul
9. FI Scenario: 9.12.Data Stream Overview 1 • Click for zoom: FIADD.docx, for image: FI.jpg, for Preziguide:FIPrezi.pdf
9. FI Scenario: 9.12.Data Stream Overview 2 • Click for zoom: FIADD.docx, for image: FI.jpg, for Preziguide:FIPrezi.pdf
Home Assignment 11: Export Balance Sheet and P&L Report • Export Balance Sheet and P&L Report generated in Step 9.10.2. in Excel and upload the file tho the Facebook group of the course! (5points)
References • http://www.sap-img.com/abap.htm • http://erpgenie.com/ • http://help.sap.com/search/sap_trex.jsp • http://sap.ittoolbox.com/groups/technical-functional/sap-abap/
Object Symbols Partner (Partner) Anyag (Material) Sarzs (Batch) Bevitt anyag (Partner material) Készlet (Inventory) Raktár (Deposit) Gyári szám (Serial number) Darabjegyzék (Bill of materials) Szortiment (Sortiment) Anyagmeghatá-rozás (Material Identification) Árazás (Pricing) Engedmény (Allowance) Fizetési mód (Payment Method) Számla (Invoice) Bizonylat (Voucher) Értékesítés támogatás (Sales Promotion) Direkt mail (Direct mail) Ajánlat (Offer) Árazás (Pricing) Rendelés (Order) Validáció (Validation) Szerződés (Contract) Szállítás (Transport) Hitel (Credit) Ütemezés (Scheduling) Szerviz (Service) Vevőszolgálat (Customer Service) Kattintás (Click) Dupla kattintás (Double Click) Adatbevitel (Write) Csak olvasható (Read Only) • Cég (Company) • Gyár (Plant) • Értékesítési szervezet (Sales Department) • Üzletkötő csoport (Sales Representative Group) • Értékesítési integráció (Sales Integration) • Csatorna (Channel) • Földrajzi hely (Geographic Location) • Kiszállítási hely (Delivery Location) • Szállítási mód (Transportation Mode) • Rakodási pont (Loading Point) • Árucsoport (Product Group) • Értékesítési terület (Sales Area) Click Right Click
GUI Symbols • To make GUI usage descriptions more short and straightforward, we will use standardized denotions of GUI controls, which can be nested into each other: • DEF:-definition, • PRC:-process, • ALT:-alternatives, • CYC:-cycle, • -follows, • -(dis)advantage, • Aaa|Bbb|-Menu/Submenu, • SCR:-Screen, • FRM:-Frame, • ID-UniqueID, • BTN:-Button, • TXB:-Textbox, • DDN:-Dropdown, • TAB:-Page tab, • CHK:-Checkbox (any of them can be checked) • RAD:-Radiobox (one can be checked only), • LIN:-Tableline, • KEY:-Hotkey, • WRN:-Warning box • ERR:-Errorbox