SAP T-Codes & Technical Architecture

EXIST Existing SAP Customizations

✅ Payment Request Screen (ABAP Custom)

Naga Limited already has a custom ABAP Payment Request screen in SAP. This will be integrated with the new Fund Request Workflow to avoid duplication and leverage existing development.

Current: Division users submit payment requests via custom screen
Enhancement: Add SAP Workflow integration for maker-checker
Integration: Link to TR-CM for cash position impact
Benefit: No re-training needed for existing users

What Exists Leverage

Payment Request custom screen (ABAP)
Fiori Launchpad configured (/UI2/FLP)
SAP TRM license activated
House banks setup (AX300, etc.)
G/L accounts for treasury
Profit centers for 7 divisions

What We Build New

TR-CM Cash Management config
TR-LO Loans Management config
Interest rate linkage (REPO/MCLR)
Maker-checker workflow
Silo-loan pledge integration
8 Fiori dashboard tiles
5 custom ABAP reports

TR-CM Cash Management T-Codes

SAP Cash Management module for real-time cash position and liquidity management across 7 divisions and 11+ bank accounts.

T-Code	Description	Current Process (Excel)	SAP Process
FF7A	Cash Position	2-3 hours daily to compile from bank portals & Excel	Real-time view across all 11+ banks, auto-refreshed
FF7B	Liquidity Forecast	No forecast capability - only daily position known	Short/medium term forecast with planned loan repayments
FLQC	Cash Management Position	Manual division-wise breakdown in Excel (10 sheets)	Division-wise, bank-wise view in single screen
FI12	Bank Account Master	Bank details in Excel (AXIS, SBI, HDFC, KVB, etc.)	Centralized bank master with limits & utilization
FF_5	Expected Cash Flows	No visibility into upcoming inflows/outflows	Auto-projection from open AR/AP items
S_ALR_87012082	Bank Balance Display	Login to 11+ bank portals separately	Consolidated view with last updated timestamp

🔄 Daily Cash Position Process Flow

FI12 Bank Master (11+ banks)

→

FF7A Cash Position

→

FLQC 7 Divisions View

→

Fiori Dashboard @ 8 AM

🎯 Naga-Specific Configuration

Cash Management will be configured for your specific structure:

Company Code: 9200
Business Place: TN01
7 Divisions: NLFD, NLCD, NLMD, NLDV, NLLD, NLSD, NLIF
STL Limits: Rs 535 Cr tracked
Primary Bank: AXIS (AX300)
Planning Levels: Division + Bank

TR-LO Loans Management T-Codes

SAP Loans Management for all 9 loan types with automatic interest calculation and repayment scheduling.

CC Cash Credit

Working capital facility with variable utilization

Banks: Axis, SBI, HDFC, KVB

WCDL Working Capital Demand Loan

Short-term loan with rollover option

Banks: Multiple

WHR Warehouse Receipt

Commodity-backed financing (12-13 silos)

Banks: Linked to silo pledges

LTL Long Term Loan

Term loans (Rs 287 Cr outstanding)

Banks: Multiple lenders

NFB Non-Fund Based (BG)

Bank Guarantees with expiry tracking

36 active BGs

FCNRB Foreign Currency Loan

USD-denominated borrowing

Banks: Select partners

GECL Emergency Credit Line

Government scheme loans

Banks: PSU banks

VL Vehicle Loan

Asset-backed vehicle financing

Banks: Various

CTL Corporate Term Loan

Medium-term corporate borrowing

Banks: Private banks

T-Code	Description	Current Process (Excel)	SAP Process
FNEQ	Create Loan Contract	Add to 5+ Excel sheets manually (400+ columns total)	Single entry creates contract with all conditions
FNE2	Change Loan Contract	Update multiple sheets, risk of formula breakage	Controlled changes with full audit trail
FNE3	Display Loan Contract	Search across 10 Excel worksheets	Complete loan view in single screen
FNIP	Interest Condition	57 columns for MCLR tracking, manual updates	Interest master with auto-propagation to all loans
FNRP	Repayment Schedule	Rep Sheet (138 rows), manual calculation	Auto-generated payment schedule
FNI5	Interest Calculation Run	Formula-based Excel, error-prone	Scheduled job runs nightly
FNBG	Bank Guarantee	NFB sheet (36 records), manual expiry tracking	BG master with 30/7/3 day expiry alerts
FNL1	Loan Rollover	Manual WCDL renewal, no system tracking	System-guided rollover with new conditions

💰 Loan Creation to FI Posting Flow

FNEQ Create Loan

→

FNIP Set Interest (REPO/MCLR)

→

FNRP Payment Schedule

→

FNI5 Interest Calc

→

FV50 Park Doc (Maker)

→

FBV0 Post (Checker)

✅ Interest Rate Auto-Propagation

Your current pain point: 57 columns of MCLR tracking with manual updates. SAP solution:

FNIP - Create reference rate master (REPO, SBI MCLR, HDFC MCLR, etc.)
Loan Contract - Link loan to reference rate + spread (e.g., REPO + 1.5%)
Rate Update - Update master rate once, all linked loans auto-update
FNI5 - Scheduled job recalculates interest for all loans

Result: 57 columns → 1 update propagates to all loans instantly

SILO Silo Pledge Integration (Custom)

Custom development to link 12-13 silos with WHR loans for ground operations visibility. This addresses your requirement for ground team to know which silos are pledged against loans.

🏢 Current Problem

Ground team (Vedasandur, Dindigul) doesn't know which silos are pledged
Risk of releasing pledged inventory
No link between Excel loan data and material master
Manual communication required for every release

✓ SAP Solution Custom

Custom field "Silo ID" in loan contract (FNEQ)
Link to MM material master (plant/storage location)
Status indicator: "Pledged" / "Available"
Alert if pledged silo stock is being consumed
Fiori tile showing all pledged silos

📍 Silo-Loan Pledge Process

FNEQ Create WHR Loan

→

+Silo ID Link Silo (Custom)

→

MM03 Material Updated

→

Fiori Ground Ops View

⚠ Moratorium Period Tracking

Per your requirement, we will implement moratorium period tracking:

Custom Field: Moratorium start/end date in loan contract
Logic: No repayment schedule generated during moratorium
Alert: Notification 30 days before moratorium ends
Report: Loans under moratorium dashboard

WF Workflow & Maker-Checker (KPMG)

SAP Workflow for fund request approvals and maker-checker process as per KPMG audit requirement.

T-Code	Description	Usage in Naga
SWDD	Workflow Builder	Define fund request workflow (Division → Treasury → HOD)
SBWP	SAP Business Workplace	User inbox for pending approvals (also in Fiori)
SWI5	Workflow Status	Track approval status and complete audit trail
PFCG	Role Maintenance	Roles: Z_NAGA_DIV_USER, Z_NAGA_TREASURY, Z_NAGA_CHECKER, Z_NAGA_HOD
FV50	Park Document	Maker creates document in parked status
FBV0	Post Parked Document	Checker reviews and posts to FI
FBV3	Display Parked Document	View document before posting

👤 Fund Request Workflow

Division User creates fund request (existing screen + workflow)
Auto-routed based on amount thresholds:

< Rs 5 Lakhs: Treasury Team direct
Rs 5-50 Lakhs: Treasury + HOD approval
> Rs 50 Lakhs: Treasury + HOD + Management

Treasury Team reviews and processes
Auto email notification at each step

🔒 Maker-Checker Process (KPMG)

Maker creates document via FV50

Loan disbursement posting
Repayment posting
Interest posting

Document saved in "Parked" status
Checker receives inbox notification
Checker validates and posts via FBV0
Complete audit trail: who created, who approved, when

⚠ KPMG Audit Compliance

As per your KPMG auditor's recommendation, every FI posting related to treasury must follow maker-checker:

Current: Email-based approvals with no audit trail
SAP: System-enforced segregation of duties
Evidence: Transaction logs for every document (SM21, STAD)
Report: Audit trail report for external auditors

RPT Reports & Analytics

Standard SAP reports + 5 custom ABAP reports to match your current PDF format.

T-Code / Report	Type	Description	Replaces Excel Sheet
FNL_REPORT	Standard	Loan Portfolio Report	LTL-Unit, LTL-Bank sheets
FNMR	Standard	Loan Maturity Report	Repayment tracking from Rep Sheet
FN_INT_REPORT	Standard	Interest Calculation Report	Interest calculation sheets
Z_DAILY_CASHFLOW	Custom	Daily Cash Flow Report	Your current daily PDF format
Z_WACC_REPORT	Custom	WACC Analysis (STL & LTL)	WACC-STL, WACC-LTL sheets
Z_BG_EXPIRY	Custom	BG Expiry Alert Report	NFB sheet expiry tracking
Z_DIV_CREDIT	Custom	Division Credit Utilization	Division-wise credit summary
Z_SILO_PLEDGE	Custom	Silo Pledge Status Report	New - for ground operations

📅 Scheduled Report Delivery (SM36/SM37)

Reports auto-run and email to management:

Daily 8:00 AM: Cash Flow Report to Treasury Team
Daily 8:00 AM: Maturity Alert (loans due in 7 days)
Weekly Monday: WACC Analysis to HOD
Weekly: BG Expiry Alert (BGs expiring in 30 days)
Monthly 1st: Division Credit Utilization
Daily: Silo Pledge Status to Ground Ops

UI Fiori Dashboards (8 Tiles)

SAP Fiori provides modern, mobile-friendly dashboards accessible via /UI2/FLP (already configured in your system).

💰

Cash Position

Real-time bank balances across 11+ banks

📈

Loan Portfolio

All 9 loan types at a glance

🔔

Maturity Alerts

Upcoming repayments (7/3/1 day)

📊

WACC Trend

Cost of capital STL & LTL

🏢

Division Cash

NLFD, NLCD, NLMD, NLDV, NLLD, NLSD, NLIF

🏦

Bank Utilization

Rs 535 Cr STL limits vs usage

📋

Fund Requests

Pending approvals inbox

📍

Silo Pledges

12-13 silos pledge status

INT Integration Architecture

SAP TRM Integration Points - Naga Limited (Company Code 9200)

SAP FI

G/L, Bank Accounting

Existing

↔

SAP TRM

TR-CM, TR-LO

New Config

↔

SAP MM

Silo/Material Master

Existing

↓

Payment Request

Custom ABAP

Existing + Enhance

Fiori Launchpad

/UI2/FLP

8 New Tiles

SAP Workflow

SWDD

New

FI Integration Native

Auto G/L posting for disbursement
Auto G/L posting for repayments
Interest accrual postings
Bank account balance sync
Profit center assignment (92005000)

MM Integration Custom

Custom field: Silo ID in loan
Link to material master
Plant: Vedasandur
Storage locations: 12-13 silos
Pledge status indicator

Workflow Integration Native

Fund request approval flow
Maker-checker for FI docs
Email notifications
Fiori inbox integration
SBWP Business Workplace

OUT OF SCOPE

MIG Data Migration from Excel

⚠ Not Included in Current Proposal

Data migration is excluded from this engagement. The information below is provided for reference only and can be discussed as a separate scope item if required.

Migration of existing treasury data from 10 Excel worksheets (400+ columns) to SAP TRM.

Excel Sheet	Columns	SAP Target	Migration Approach
STL Master	~50 columns	TR-LO Loan Contracts	LSMW / BAPI upload
LTL-Unit	~40 columns	TR-LO Loan Contracts	LSMW / BAPI upload
LTL-Bank	~35 columns	Bank Master (FI12)	Direct entry / template
Rep Sheet	138 rows	Payment Schedules (FNRP)	Auto-generated from contracts
NFB Sheet	36 BGs	Bank Guarantee (FNBG)	Template upload
WACC-STL	~30 columns	Custom Report (Z_WACC)	Calculated from loan data
WACC-LTL	~30 columns	Custom Report (Z_WACC)	Calculated from loan data
MCLR Tracking	57 columns	Interest Rate Master (FNIP)	Reference rate setup
Division Credit	7 divisions	Profit Center / Business Area	Already exists (92005000)
Daily Cash Flow	PDF format	Z_DAILY_CASHFLOW report	Format matching

📄 Data Quality Requirements (For Future Reference)

If data migration is added to scope, we would need:

Clean Excel data with consistent formatting
Loan reference numbers standardized
Bank account numbers validated
Interest rate history for active loans
Outstanding principal and interest as of cutover date

CFG Key Configuration Items

Company Code

9200 - Naga Limited

Client

900 - Production client

Business Place

TN01 - Tamil Nadu

7 Business Areas