Code Editor for app.py

import streamlit as st
import pandas as pd

st.title("SAP ECC Control Testing Framework")

# Risk input section
st.header("Risk Assessment")
risk_area = st.selectbox(
    "Select Risk Area",
    ["Financial Reporting", "Access Management", "Change Management", "Master Data", "Procure to Pay", "Order to Cash"]
)

risk_description = st.text_area("Risk Description", placeholder="Describe the risk that needs to be addressed...")

# Control definition section
st.header("Control Definition")
control_id = st.text_input("Control ID", placeholder="Enter control identifier...")

control_type = st.selectbox(
    "Control Type",
    ["Preventive", "Detective", "Corrective"]
)

control_frequency = st.selectbox(
    "Control Frequency",
    ["Daily", "Weekly", "Monthly", "Quarterly", "Annually", "Ad-hoc"]
)

control_description = st.text_area("Control Description", placeholder="Describe the control activity...")

# Test procedures section
st.header("Test Procedures")
sample_size = st.number_input("Sample Size", min_value=1, value=25)
test_period = st.date_input("Test Period")

test_steps = st.text_area("Test Steps", placeholder="List the steps to test this control...")

# Results tracking
st.header("Test Results")
status = st.selectbox(
    "Test Status",
    ["Not Started", "In Progress", "Completed", "Issues Identified"]
)

if status == "Issues Identified":
    issues = st.text_area("Describe Issues Found", placeholder="Detail any issues or exceptions identified...")
    remediation = st.text_area("Remediation Plan", placeholder="Describe steps to address identified issues...")

# Save control definition
if st.button("Save Control Definition"):
    control_data = {
        "Risk Area": risk_area,
        "Risk Description": risk_description,
        "Control ID": control_id,
        "Control Type": control_type,
        "Control Frequency": control_frequency,
        "Control Description": control_description,
        "Sample Size": sample_size,
        "Test Period": test_period,
        "Test Steps": test_steps,
        "Status": status
    }
    
    st.success("Control definition saved successfully!")
    st.write("Control Summary:")
    st.write(pd.DataFrame([control_data]).T)

# Display helpful information
with st.expander("SAP Control Testing Guidelines"):
    st.markdown("""
    ### Best Practices for SAP Control Testing
    1. Ensure control activities are clearly documented
    2. Maintain evidence of control execution
    3. Document test procedures in detail
    4. Track exceptions and remediation efforts
    5. Regular review and updates of control design
    
    ### Common SAP Controls
    - User access reviews
    - Segregation of duties
    - Change management approvals
    - Master data modifications
    - Critical transaction monitoring
    - Reconciliation procedures
    """)