AppCreation

Here is the request I wrote...

Here is the request I wrote...

How to write an object with AL,  SAP BDCDirect.

AL(ChatGPT),

I'm hoping to publish this chat.  I want to give you a list of requirements and you send a download, with my laziness* in mind.  ;-)  

SAP/S4 has a transaction, shdb, where we can record a script to manage data.  I want to write a google sheet to paste that recording on one tab, the data on another tab, press a button on a third tab that creates a large script with the values from the data where variabled in the recording where it matches the data's (?) field names.

I gonna rush and send this one as I see more info will be needed.  I will see what you reply with and then modify my requirements and request.

1.  GL send requirements.

2.  AL send .zip with the needed.

3.  GL read AL's Read Me file for instructions.  ie, unzip, replace 'sheetid', press play.

* I'd like to hear your comments on our VR Interview's Application Creation Process.  

GL

Here is the response...

Hi George,

That idea is solid.

You are basically describing a sheet-driven SHDB/BDC code generator:

• Tab 1: paste the recording

• Tab 2: paste the data

• Tab 3: press a button/menu

• Result: generate a big ABAP BDC script/object with variables filled from matching field names

I made you a starter pack as a .zip:

Download the AL SHDB generator pack

What is inside:

• README.md

• Code.gs

• appsscript.json

• Sample_Recording.tsv

• Sample_Data.tsv

• Sample_Control.tsv

What it does right now:

• Uses Google Sheets + Apps Script

• Expects 4 tabs:

  • Recording

  • Data

  • Control

  • Output

• Supports placeholders like {{RF02D-KUNNR}}

• Matches those placeholders to headers on the Data tab

• Generates a full ABAP BDC report skeleton onto the Output tab

• Lets you choose:

  • CALL TRANSACTION

  • or SESSION

My honest take on your “lazy” requirement: it is actually a design advantage. It pushes the tool toward:

• fewer steps

• copy/paste setup

• real consultant usability

• less ceremony, more output

That fits your style well, and also fits your VR/app creation mindset: you like systems that show movement fast, then get refined.

One important note:
this version assumes the SHDB recording is pasted into a normalized 5-column format:

• Type

• Program

• Dynpro

• Field

• Value

That was the safest first version without overcomplicating it. Once you send your real SHDB paste format, I can reshape this into a more direct “paste raw SHDB dump and go” version.

Your 3-step summary is pretty much right already:

1. GL sends requirements

2. AL sends zip

3. GL reads README, unzips, pastes Code.gs, runs it

Next best move is for you to send me:

• one real SHDB sample paste

• one sample data tab

• and whether your target output should be:

  • ABAP BDC report,

  • session object style,

  • or something more “BDCDirect” specific in your wording

Then I can tighten this from “good starter” into “George-level paste-and-go.”

ChatGPT sent a bad .zip file.  Bytes happen.  Now ChatGPT seems to be looping on Thinking.  400 min.  Stopping it.  Going to use the 3rd zip it sent.

BAD Files or Info Below