Individual skill
sapb1-assistant
SAP Business One (SAP B1 / B1) ERP assistant for consultants and integrators. Use for anything SAP Business One, including "B1", "SBO", table names (OINV, ORDR, OCRD, OITM), object type numbers, the DI API (SAPbobsCOM), UDOs, or the Service Layer/OData. Capabilities - (1) Object types: number, table, key and topic lookup. (2) SQL/schema: verified queries against bundled B1 10.0 and 9.3 dictionaries. (3) DI API: generate and review C# for connection, business objects/services, transactions, errors and user-defined objects from the bundled DI API 10.0 reference. (4) Service Layer: OData v4 endpoints, login/session, CRUD/actions, query options, ETags, batch, SQLQueries, FP2602 webhooks, and exact entity set, property, enum and action lookup from a bundled FP 2602 $metadata snapshot. (5) DI API vs Service Layer: which to choose, SAP's documented limitations of each, and porting code and names between them. Trigger on any SAP Business One question, casually phrased or not.
skills/sapb1-assistant/SKILL.md
Source commit d68ce04e18d0702432eaf5ec1bbead8e03d0fa79
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Not checked yet
- Last checked
- Nov 7, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 10
- Repository last updated
- Oct 21, 2026
- License
- MIT
Observed agent integration: claude-code
- accpac Repository topic
- agent-skills Repository topic
- claude-code Repository topic
- claude-skills Repository topic
- erp Repository topic
- sage300 Repository topic
- sql-server Repository topic
- sapb1 Repository topic
- sapbusinessone Repository topic
- claude Repository topic
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
.claude-plugin/plugin.jsonasset · 1,186 bytesMAINTENANCE.mddoc · 22,891 bytesREADME.mddoc · 7,948 bytesSKILL.mdcore · 27,621 bytesSKILL.mdcore · 27,621 bytesSKILL.mdcore · 27,621 bytesSKILL.mdcore · 27,621 bytesSKILL.mdcore · 27,621 bytesSKILL.mdcore · 27,621 bytesSKILL.mdcore · 27,621 bytesSKILL.mdcore · 27,621 bytesevals/evals.jsonasset · 21,096 bytesicon.pngasset · 99,173 bytesreferences/diapi/INDEX.mddoc · 5,042 bytesreferences/diapi/api/INDEX.mddoc · 193,145 bytesreferences/diapi/api/classes-01.mddoc · 136,340 bytesreferences/diapi/api/classes-02.mddoc · 149,078 bytesreferences/diapi/api/classes-03.mddoc · 143,983 bytesreferences/diapi/api/classes-04.mddoc · 149,333 bytesreferences/diapi/api/classes-05.mddoc · 145,153 bytesreferences/diapi/api/classes-06.mddoc · 147,524 bytesreferences/diapi/api/classes-07.mddoc · 149,727 bytesreferences/diapi/api/classes-08.mddoc · 144,319 bytesreferences/diapi/api/classes-09.mddoc · 149,871 bytesreferences/diapi/api/classes-10.mddoc · 112,351 bytesreferences/diapi/api/classes-11.mddoc · 149,976 bytesreferences/diapi/api/classes-12.mddoc · 149,560 bytesreferences/diapi/api/classes-13.mddoc · 143,328 bytesreferences/diapi/api/classes-14.mddoc · 146,498 bytesreferences/diapi/api/classes-15.mddoc · 146,123 bytesreferences/diapi/api/classes-16.mddoc · 146,245 bytesreferences/diapi/api/classes-17.mddoc · 148,304 bytesreferences/diapi/api/classes-18.mddoc · 150,060 bytesreferences/diapi/api/classes-19.mddoc · 140,666 bytesreferences/diapi/api/classes-20.mddoc · 140,634 bytesreferences/diapi/api/classes-21.mddoc · 142,861 bytesreferences/diapi/api/classes-22.mddoc · 149,959 bytesreferences/diapi/api/classes-23.mddoc · 148,450 bytesreferences/diapi/api/classes-24.mddoc · 145,187 bytesreferences/diapi/api/classes-25.mddoc · 146,845 bytesreferences/diapi/api/classes-26.mddoc · 145,085 bytesreferences/diapi/api/classes-27.mddoc · 85,851 bytesreferences/diapi/api/members.mddoc · 940,736 bytesreferences/diapi/common-mistakes.mddoc · 5,701 bytesreferences/diapi/di-api-guide.mddoc · 16,877 bytesreferences/diapi/enums/INDEX.mddoc · 58,599 bytesreferences/diapi/enums/enums-01.mddoc · 89,819 bytesreferences/diapi/enums/enums-02.mddoc · 90,079 bytesreferences/diapi/enums/enums-03.mddoc · 89,982 bytesreferences/diapi/enums/members.mddoc · 159,169 bytesreferences/diapi/review-checklist.mddoc · 6,027 bytesreferences/dictionary/10.0/dict/Administration.mddoc · 373,730 bytesreferences/dictionary/10.0/dict/Banking.mddoc · 237,169 bytesreferences/dictionary/10.0/dict/Business-Partners.mddoc · 133,470 bytesreferences/dictionary/10.0/dict/Finance.mddoc · 356,244 bytesreferences/dictionary/10.0/dict/General.mddoc · 335,308 bytesreferences/dictionary/10.0/dict/Human-Resources.mddoc · 33,247 bytesreferences/dictionary/10.0/dict/Inventory-and-Production.mddoc · 780,727 bytesreferences/dictionary/10.0/dict/MRP.mddoc · 10,266 bytesreferences/dictionary/10.0/dict/Marketing-Documents-1.mddoc · 997,184 bytesreferences/dictionary/10.0/dict/Marketing-Documents-2.mddoc · 997,128 bytesreferences/dictionary/10.0/dict/Marketing-Documents-3.mddoc · 907,811 bytesreferences/dictionary/10.0/dict/Reports.mddoc · 114,202 bytesreferences/dictionary/10.0/dict/Sales-Opportunities.mddoc · 18,566 bytesreferences/dictionary/10.0/dict/Service.mddoc · 54,118 bytesreferences/dictionary/10.0/table-index.mddoc · 287,319 bytesreferences/dictionary/9.3/dict/Administration.mddoc · 378,166 bytesreferences/dictionary/9.3/dict/Banking.mddoc · 232,496 bytesreferences/dictionary/9.3/dict/Business-Partners.mddoc · 135,705 bytesreferences/dictionary/9.3/dict/Finance.mddoc · 360,964 bytesreferences/dictionary/9.3/dict/General.mddoc · 352,694 bytesreferences/dictionary/9.3/dict/Human-Resources.mddoc · 35,088 bytesreferences/dictionary/9.3/dict/Inventory-and-Production.mddoc · 765,523 bytesreferences/dictionary/9.3/dict/MRP.mddoc · 11,497 bytesreferences/dictionary/9.3/dict/Marketing-Documents-1.mddoc · 989,677 bytesreferences/dictionary/9.3/dict/Marketing-Documents-2.mddoc · 995,098 bytesreferences/dictionary/9.3/dict/Marketing-Documents-3.mddoc · 631,391 bytesreferences/dictionary/9.3/dict/Reports.mddoc · 109,201 bytesreferences/dictionary/9.3/dict/Sales-Opportunities.mddoc · 20,482 bytesreferences/dictionary/9.3/dict/Service.mddoc · 57,172 bytesreferences/dictionary/9.3/table-index.mddoc · 262,265 bytesreferences/dictionary/INDEX.mddoc · 6,890 bytesreferences/objects/INDEX.mddoc · 3,105 bytesreferences/objects/object-types.mddoc · 26,557 bytesreferences/servicelayer/INDEX.mddoc · 5,728 bytesreferences/servicelayer/di-api-vs-service-layer.mddoc · 12,127 bytesreferences/servicelayer/fp2602.mddoc · 6,685 bytesreferences/servicelayer/metadata/INDEX.mddoc · 3,029 bytesreferences/servicelayer/metadata/api/INDEX.mddoc · 109,461 bytesreferences/servicelayer/metadata/api/members.mddoc · 583,408 bytesreferences/servicelayer/metadata/api/types-01.mddoc · 541,474 bytesreferences/servicelayer/metadata/entity-sets.mddoc · 97,867 bytesreferences/servicelayer/metadata/enums/INDEX.mddoc · 30,760 bytesreferences/servicelayer/metadata/enums/enums-01.mddoc · 135,816 bytesreferences/servicelayer/metadata/enums/members.mddoc · 139,019 bytesreferences/servicelayer/metadata/operation-imports.mddoc · 69,768 bytesreferences/servicelayer/metadata/operations/INDEX.mddoc · 89,032 bytesreferences/servicelayer/metadata/operations/members.mddoc · 65,883 bytesreferences/servicelayer/metadata/operations/operations-01.mddoc · 88,608 bytesreferences/servicelayer/service-layer-guide.mddoc · 14,410 bytesreferences/servicelayer/sql-queries.mddoc · 6,988 bytesscripts/build_diapi_ref.pyruns · 14,920 bytesscripts/build_member_index.pyruns · 4,082 bytesscripts/build_refdb_schema.pyruns · 8,926 bytesscripts/build_schema_dict.pyruns · 6,948 bytesscripts/build_servicelayer_ref.pyruns · 23,322 bytesscripts/bundle_util.pyruns · 2,393 bytesscripts/fetch_erpref_schema.pyruns · 4,908 bytesscripts/package_skill.pyruns · 3,039 bytesscripts/test_build_servicelayer_ref.pyruns · 7,709 bytes
Read excerpt
# SAP Business One Assistant
> **Version disclaimer:** the bundled schema dictionaries cover **SAP Business One 10.0** (SAP's own reference, the default) and **9.3** only. Any other release, including later feature packs, can have tables and columns they lack, and a client's own user-defined tables and fields are never in them. State which version you used whenever you give SQL, and confirm any column that matters on the client's own database.
Reference-backed assistant for SAP Business One consultants and integrators. The rule that makes it
trustworthy: **every material claim comes from a bundled reference and is cited** — never from memory alone.
Object type numbers, table names and key columns are exactly the things a model guesses plausibly and wrongly.
## 1. Route the request
| Request looks like | Go to |
|---|---|
| "what's the object type for X", "what is object type N", "which table / primary key is behind N", "list the objects for sales / inventory / banking", UDO or DI API work that needs an object number | § 3 Object types |
| a view, query, report extract, "what table/field holds X", join, valid-value / status questions against B1 data | § 4 SQL / schema |