Program Functional Specification

Program Functional Specification

Program Functional SpecificationAAINF001 Asset Master & Acquisition (AA507 Inbound & AA907 Outbound)ForJABATAN AKAUNTAN NEGARA MALAYSIA1GFMAS PROJECT

PROGRAM FUNCTIONAL SPECIFICATION

DEVELOPMENT PROFILE

Project1GFMAS

ModuleFI-AA

Ref. NoFI-AA-INF-001

DescriptionAsset master record & acquisition from SPLN to be created in 1GFMAS

Priority For This Program|X| High|_|Medium|_| Low

Complexity|_| High|X| Medium|_| Low

Program/Query/User Exit/ Function Module Name

Sap script / Smart form Name

Version Number0.1

Ticket Number-

CR Reference Number-

Process and Task IDAA507 Asset Master & Acquisition from SPLNSAA907 Asset Master & Acquisition to SPLN

ACCEPTANCE SUMMARY

iA Development Team

Prepared ByAshok RayalaSAP AA consultant

Approved ByRashdan Abd AzizAA Team Lead

JANM TEAM

Reviewed By

|_|Accept|_|Reject

Approved By

|_|Accept|_|Reject

Document AdministrationDocument Revision History VersionDateUpdated ByDescription of Change

0.105.09.2014Ashok RayalaDraft for AG discussion

TABLE OF CONTENTS

1.0Requirements PROGRAM Description/Purpose51.1.Description of Development51.2.Features and Functions52.0Requirement Data Definition82.1.SAP Tables Used82.2.Customized Table/Structure Specification82.3.Data Conversion Definition82.4.Interface (internal or external)93.0INput screen layout123.1.Input Screen Design123.2.Input Selection Screen Criteria124.0Processing Details134.1Specifications Details and Workflow (Entity Relationship Diagram)134.1.1.Process Flow diagram184.1.2.Decision tasks (for each task in diagram)184.1.3.Text objects184.1.4.Deadline events184.1.5.Workflow Error Handling184.2Portal Navigation / Group184.3Error Handling194.4Batch Processing204.5Application Security204.6Translation Elements205.0OUTPUT Specification216.0Appendix226.1Test data22

1.0 Requirements PROGRAM Description/Purpose

Description of Development This development enables to create Asset & Acquisition of an Asset in 1GFMAS by using SPLN external agency inbound file. This functionality interfaced to external systems such as SPLN on a scheduled or ad hoc basis. This Inbound interface file (Process AA507) from External system is place in Sap directory through Web methods. Thereafter, the file will be process in 1GFMAS,In case if any error occurs during the file execution, Error notification file(AA907) send back to SPLN.

Features and Functions

1. Program fulfills following functionalities by using Inbound file data: Create Asset Master data using AS01 Tcode Asset Acquisition through F-90 Tcode2. 1GFMAS receives following data from the external system,ANLA- ANLKLANLZ-GSBERANLZ-SEGMENTANLZ-KOSTLANLZ-FKBERANLZ-GEBERANLA- INVNRANLA-LIFNR etc.,

3. Selection Parameter

a. This interface program is to be scheduled on a daily basis (e.g. end-of-day) with the option to be executed manually on an ad hoc basis, if required.

b. The parameters in the File Specifications section are mandatory with the below logic:

Selection FieldProcessing LogicRemarks

Agency IDIf field not equal to blank, check value to Table ZAGENCY.Otherwise, determine all agency IDs from Table ZAGENCYCODE.Validate to Table ZAGENCY. If invalid, return error message Process ID ## invalid in Table ZAGENCYCODE.

Pejabat PerakaunanDefault to 1000 Ibu Pejabat JANM. If field not equal to 1000, check value against Table ZAGENCYCODE.Validate to Table TGSB. If invalid, return error message Pejabat Perakaunan ### is invalid.

Inbound File PathDefault to /ECP/1000/WM/INInput file will be cleared after execution in 1GFMAS

Process File PathDefault to /ECP/1000/WM/PROCESSOutput file is stored here until housekeeping carried out.

Error File PathDefault to /ECP/1000/WM/OUT

If any error occurs during the process, file submission to com. server

c. Perform selection parameter validation. If any of the field values in the File Specifications are invalid, stop program execution and return error message(s).

d. The parameters in the Detailed Specifications section provides the fields values to be submitted for the table extraction from the system into the output file:

Selection FieldProcessing LogicRemarks

Company Code (PA_BUKRS)Default to FOGMValidate Company Code to Table T001. If invalid, stop program execution and return error message Company Code is valid.

Entry date Default to sys date

1. The program will automatically transfer the outbound interface files using the customized Function Module based on the pre-defined naming convention.

2. The program will automatically transfer the outbound Interface Files into the OUT FOLDER and PROCESS FOLDER as per the File paths in the selection parameters.

2.0 Requirement Data Definition

1. SAP Tables Used

Table NameTable DescriptionInsertDeleteQueryUpdate

ANLAAsset Master Record SegmentX

ANLZTime-Dependent Asset AllocationsX

ANLBDepreciation termsX

BSEGAccounting Document SegmentX

BKPFAccounting Document HeaderX

Customized Table/Structure SpecificationN/A

Data Conversion DefinitionN/A

Interface (internal or external)

Interface NameAsset Master & Acquisition

DescriptionAsset master record & acquisition from SPLN to be created in 1GFMAS

SourceSPLNDestination1GFMAS - AA

Process IdAA507Message FormatFile - Variable length

MethodSFTPEncryptionY

Frequency1. Ad hoc 2. Daily (Time: ??)Transaction TypeMultiple

RemarksUse | symbol to separate the fields

FIELD NAMEDATATYPEDATASIZEDATA FORMATDESCRIPTION M(Y/N)

HEADER (1:1)

RECORD TYPEAN2Default to 01To indicate header recordY

RECORD COUNTN3Total record in the Asset Master DetailsY

ASSET MASTER DETAILS (1:N)

RECORD TYPEAN2Default to 02To indicate Asset Master Details recordY

TAHUN KEWANGANN4YYYYFinancial YearE.g. 2015Y

KOD AKAUN GLAN8E.g. B0111101Y

KOD PEJABAT PERAKAUNAN AN4Accounting Office CodeE.g. 1111Y

KOD PEGAWAI PENGAWAL DIPERTANGGUNGAN2The Charged Controlling Officer's Code E.g. B6Y

KOD PEGAWAI PENGAWAL PEMBAYARAN2The Paying Controlling Officer's CodeE.g. B6Y

KOD PTJ DIPERTANGGUNG AN8The Charged Responsibility Center's CodeFormat: Kumpulan PTJ(2) + PTJ(6)Y

KOD PTJ PEMBAYARAN8The Paying Responsibility Center's CodeFormat: Kumpulan PTJ(2) + PTJ(6)Y

VOTAN5Vot codeFor B,T,P & SFormat: Vot(3) + Kump PTJ(2) E.g. B1024, B1025, B1026

Blank if DANA is enteredN

DANAAN4Possible values:AXXX : Amanah

Blank for transaction with VOT.N

PROGRAM/AKTIVITIAN9Format: Vot(3) + Program/Aktiviti(6)

Blank if PROJEK/SETIA/SUB-SETIA/CP is filled.N

PROJEK/SETIA/SUB-SETIA/CPAN16Format: Vot(3) + Projek(5) + Setia(3) + SubSetia(4) + Cara Pembiayaan(1)

Blank if PROGRAM/AKTIVITI is filled.N

KOD BARANGCH18UNSPSC Code Y

NAMA PEMBEKAL ASETCH40Vendor NameN

TARIKH PEROLEHANN8DDMMYYYYDate of Purchase Order / Invoice DateY

NOMBOR PESANAN KERAJAANCH10Purchase Order No.N

NOMBOR GOODS RECEIVED NOTE (GRN) CH10Goods Received Note No. (if direct from AP, will use AP Invoice No.)N

AMAUNN13No decimal point and no thousand separators. Last 2 digits represent decimal.Value of assetY

PERIHAL ASETCH200Description of AssetY

RUJUKANCH12Reference Number (if any) E.g. File Reference No.Y

3.0 INput screen layout2. Input Screen Design Input Selection Screen CriteriaSelection TextTable-Field NameM / OS/P/C/RDefault ValueChecks/RuleAdditional criterion for selection

File specifications

Agency IDPA.AGENCYMTable ZAGENCYCODEIf there is no input for agency ID, then file upload to 1GFMAS for all agencies maintained in the table Zagencycode for the process ID AA507

Pejabat PerakaunanPA.GSBERMPTable TGSBDefault to 1000

Inbound File PathPA_FILEINMPDefault to \ECD\1000\WM\IN

Process File PathPA.PROCESSMPDefault to \ECD\1000\WM\PROCESSED

Error File pathPA.FILEOUTMPDefault to \ECD\1000\WM\IN

Detailed specifications

Company CodePA.BUKRSMPFGOMTable T001

Entry DatePA.DATUMMSDefault to System Date

M/O/C:M = Mandatory, O = Optional, C = ConditionalS/P/C/R :S = (select-options) from-to , P = (parameter) single value select, C = checkbox , R = radio button4.0 Processing Details

4. Specifications Details and Workflow (Entity Relationship Diagram)

1. Program definition

Program NameProgram Title/ DescriptionT-code

ZIAA507AA507: Asset Master & AcquisitionZIAA507

2. Processing LogicFIELD NAMEDATATYPEDATASIZESAP FIELD MAPPINGDESCRIPTION M(Y/N)SNO

TAHUN KEWANGANN4Mapped to ANLA- ZUJHRFinancial YearE.g. 2015YA1

KOD AKAUN GLAN8Mapped to ANLA- ANLKLE.g. B0111101YA2

KOD PEJABAT PERAKAUNAN AN4Mapped to ANLZ- GSBERAccounting Office CodeE.g. 1111YA3

KOD PEGAWAI PENGAWAL DIPERTANGGUNGAN2Mapped to ANLZ-SEGMENTThe Charged Controlling Officer's Code E.g. B6YA4

KOD PEGAWAI PENGAWAL PEMBAYARAN2Mapped to CEPC-SEGMENTThe Paying Controlling Officer's CodeE.g. B6YA5

KOD PTJ DIPERTANGGUNG AN8Mapped to CSKS-KOSTLThe Charged Responsibility Center's CodeFormat: Kumpulan PTJ(2) + PTJ(6)YA6

KOD PTJ PEMBAYARAN8Mapped to ANLZ - FKBERThe Paying Responsibility Center's CodeFormat: Kumpulan PTJ(2) + PTJ(6)YA7

VOTAN5Mapped to ANLZ.GEBERVot codeFor B,T,P & SFormat: Vot(3) + Kump PTJ(2) E.g. B1024, B1025, B1026

Blank if DANA is enteredNA8

DANAAN4Mapped to ANLZ.GEBERPossible values:AXXX : Amanah

Blank for transaction with VOT.N A9

PROGRAM/AKTIVITIAN9Mapped to ANLA. POSNRFormat: Vot(3) + Program/Aktiviti(6)

Blank if PROJEK/SETIA/SUB-SETIA/CP is filled.NA10

PROJEK/SETIA/SUB-SETIA/CPAN16Mapped to ANLA. POSNRFormat: Vot(3) + Projek(5) + Setia(3) + SubSetia(4) + Cara Pembiayaan(1)

Blank if PROGRAM/AKTIVITI is filled.NA11

KOD BARANGCH18Mapped to ANLA- INVNRUNSPSC Code YA12

NAMA PEMBEKAL ASETCH40Vendor NameNA13

TARIKH PEROLEHANN8Mapped to BKPF- BUDATDate of Purchase Order / Invoice DateDDMMYYYYYA14

NOMBOR PESANAN KERAJAANCH10Purchase Order No.NA15

NOMBOR GOODS RECEIVED NOTE (GRN) CH10Goods Received Note No. (if direct from AP, will use AP Invoice No.)NA15

AMAUNN13Mapped to BSEG-WRBTRValue of assetNo decimal point and no thousand separators. Last 2 digits represent decimal.YA17

PERIHAL ASETCH200Mapped to ANLA TXT50Description of AssetYA18

RUJUKANCH12Mapped to BKPF-XBLNRReference Number (if any) E.g. File Reference No.YA19

Steps:

1. Call BAPI_FIXEDASSET_CREATE to create fixed asset and pass following values from the above table

ANLA- ANLKL (A2)ANLA TXT50 (A18)ANLA-INVNR (A12)ANLZ-GSBER (A3)ANLZ-KOSTL(A6)ANLZ-FKBER (A7)ANLZ-GEBER (A8/A9) (If A8 is empty pass A9)ANLA-POSNR (A10/A11) (If A10 empty pass A11)

Rashdan needs to finalizeANLB-AFASL-Depreciation keyANLB-NDJAR- Useful life in yrsANLB-NDPER-Useful life in periods

Save. It will export Fixed asset number (ANLA _ANLN1 &ANLA-ANLN2). Store these values in internal table.

2. Call BAPI_VENDOR_CREATE pass following values (Is it mandatory create one time vendor or use dummy vendor of SPLN assets? Need to finalize by rashdan)

Company code RF02K-BUKRS- Default to FGOMPurchasing Organization RF02K- EKORG- Default to FGOM)Account Group- RF02K-KTOKK Rashdan need to finalizeName (A13)Search term:Industry:Recon account:Currency : default to RM

Save this vendor number in the internal table.

3. Use BDC to post F-90 transaction as following:

Document date: system datePosting date: A14Document type: KRPeriod: Current periodCompany code: FGOMCurrency :RMReference: A19Posting key: 31Vendor: Call value stored in internal tableEnterAmount: A17Text : SPLN Asset Acquisition through interface filePosting key:70Account : Asset number saved in internal tableATT: 100EnterAmount: A17 SAVE. Screen shots for BDC: Screen1:

Screen 2:

Screen 3:

a. Validate Process ID in filename against selection parameter

Check PROCESS_ID in file name to PA_PROCESS in selection parameters.

If Process ID is valid, proceed to the next validation.Otherwise, return error message Error: Invalid Process ID.3. The program will automatically submit the interface file into the PROCESS FOLDER and OUT FOLDER (Error file) as per the File Path in the selection parameters.

1. 2. 3. 4. 4.1. 4.1.1. Process Flow diagramN/A4.1.2. Decision tasks (for each task in diagram)N/A4.1.2.1. Agent assignmentN/A4.1.2.2. Pre-processing detailN/A4.1.2.3. Post processing detail N/A4.1.2.4. Cancellation detail

4.1.3. Text objects4.1.3.1. Task textsN/A4.1.3.2. Email texts N/A4.1.4. Deadline eventsN/A4.1.5. Workflow Error HandlingN/A4. Portal Navigation / GroupN/A

4. Error HandlingInterface file:Process ID AA907Interface NameError File for Notification

DescriptionError File for Notification 1. Asset Master & Acquisition from SPLN

Source1GFMAS AADestinationSPAmySPATASKALASPLN

Process IdAA907 Asset Master & Acquisition from SPLNMessage FormatFile - Variable length

MethodSFTPEncryptionY

Frequency1. Daily (Time : TBD)2. Ad hocTransaction TypeMultiple

Remarks1. Default to Daily but allow ad-hoc triggering when required2. External Systems will validate the record, if record exist, external system updates the data else external system creates the data3. Use | symbol to separate the fields

FIELD NAMEDATATYPEDATASIZEDATA FORMATDESCRIPTION M(Y/N)

HEADER (1:1)

RECORD TYPEAN2Default to 01To indicate header recordY

AGENCY CODECH6Unique agency code ID for external system.Y

TOTAL RECORD COUNTN3Total record in record details

Y

RECORD DETAILS (1:N)

RECORD TYPEAN2Default to 02To indicate Record DetailsY

REFERENCE NOCH12The key field is Asset Number / Reference Number (for SPLN)E.g. The Asset information provided should be tie up with the information in Asset master recordY

ERROR CODEAN6Error code generated in SAPY

ERROR DESCRIPTIONCH255Description of the error codeY

while processing inbound file, if error occurs during the process OUTBOUND error file need to generate as following naming convention.

4. Batch ProcessingN/A

4. Application SecurityAuthorization assignment is based on the user ID and available transaction codes assignment to user.RoleT-codeDescription

SAPALEMOTEZIAA507AA507 Asset Master & Acquisition

4. Translation ElementsN/A5.0 OUTPUT Specification

6.0 Appendix

6. Test data

TERHAD1GFMAS_AAINF-001Private & ConfidentialPage 22 of 22