Set-SapTableColumn.ps1

#Requires -Version 5.1
<#
.SYNOPSIS
    Fills consecutive rows of a SAP GuiTableControl from a list of values.

.DESCRIPTION
    PowerShell port of src/vbs/SapTableInput.vbs.

    GuiTableControl.GetCell(row, column) is zero based and addresses the visible
    window of the control, so the first visible row is index 0 after every scroll.
    The control has to be resolved again after each scroll because SAP GUI
    rebuilds its child elements when the viewport moves.

.PARAMETER Session
    A GuiSession, e.g. the object returned by Connect-SapGui.ps1.

.PARAMETER TableId
    findById path of the table control.

.PARAMETER Value
    Values to write, one per row. Accepts pipeline input.

.PARAMETER ColumnIndex
    Zero based column index inside the table control. Default 0.

.PARAMETER ConfirmPopup
    Press the save button of the modal popup (wnd[1]) once every value is written.

.EXAMPLE
    '1000','1010','1020' |
        .\Set-SapTableColumn.ps1 -Session $session -TableId 'wnd[1]/usr/tblX' -ConfirmPopup
#>
[CmdletBinding()]
param(
    [Parameter(Mandatory)]
    $Session,

    [Parameter(Mandatory)]
    [ValidateNotNullOrEmpty()]
    [string]$TableId,

    [Parameter(Mandatory, ValueFromPipeline)]
    [string[]]$Value,

    [ValidateRange(0, 255)]
    [int]$ColumnIndex = 0,

    [switch]$ConfirmPopup
)

begin {
    Set-StrictMode -Version Latest
    $ErrorActionPreference = 'Stop'
    $rowIndex = 0
}

process {
    foreach ($item in $Value) {
        $Session.FindById($TableId).VerticalScrollbar.Position = $rowIndex

        $table = $Session.FindById($TableId)
        $table.GetCell(0, $ColumnIndex).Text = $item.Trim()

        Write-Verbose "row $rowIndex = $($item.Trim())"
        $rowIndex++
    }
}

end {
    if ($ConfirmPopup) {
        $Session.FindById('wnd[1]/tbar[0]/btn[8]').Press()
    }
    Write-Verbose "wrote $rowIndex row(s)"
}