_{[关于我](#zh-about) · [个人笔记](#zh-notebook) · [项目矩阵](#zh-projects) · [核心方法论](#zh-methodology) · [参考文档](#zh-references)}

• 四大IT审计背景（DTT2year、KPMG2year），现专注审计数据分析与自动化工具建设 _{Big-4 IT audit background (2 yrs DTT, 2 yrs KPMG), now focused on audit data analytics and automation tooling.}
• 把审计逻辑沉淀为可复用的数据工具，覆盖采购 / 销售三单匹配、SAP 取数、多源对账 _{Turning audit logic into reusable data tools — purchase / sales three-way matching, SAP data extraction, multi-source reconciliation.}

收录于 gvmeakiss-notebook 仓库内的四个独立项目。

⚠️ 数据合规声明 / Data Compliance Disclaimer

本主页仅用于技术交流，分享**无收益分成（no-revenue-sharing）**的通用代码处理逻辑。所有公开内容已依据下列法律法规进行脱敏处理：

• 《中华人民共和国个人信息保护法》第五十一条、第七十三条 — 对涉及的个人信息采取 去标识化（de-identification） 处理（删除直接标识符，使信息在不借助额外信息时无法识别特定自然人），并尽量达到 匿名化 标准；
• 《中华人民共和国数据安全法》第二十一条、第二十七条 — 对数据实行 分类分级保护，并针对公开内容采取相应的技术保护措施，保障数据安全；
• 《中华人民共和国反不正当竞争法》第九条 — 对原项目中的 商业秘密（客户名称、法律实体、内部标识、经营数据等）予以剔除与脱敏，避免不当披露。

脱敏范围：客户名称、法律实体、内部标识/代号、真实地址、支付与账户信息、订单/商品编码、财务数据及任何客户底稿（xlsx / sql / zip 等）。任何财务数据与客户工作底稿均不在本主页及其仓库中存储或上传。

_{All content shared here is for technical exchange only, on a no-revenue-sharing basis, and has been desensitized in accordance with the PIPL (de-identification / anonymization), the Data Security Law (classification, graded protection & technical safeguards), and the Anti-Unfair-Competition Law (trade-secret protection). No financial data or client working papers are stored or uploaded.}

29 个公开仓库，按能力域分组；★ 为核心可复用工具（建议先看），「类型」标注其适用边界（通用底座 / 具体客户项目）。 _{29 public repos grouped by capability; ★ marks core reusable tools (start here). The 类型 column marks the scope: generic foundation vs. client-specific project.}

sap-abap-data-extraction 是执行三单匹配与序时账核对的基础。按 FI / MM / SD 三个模块配置 KAAP 取数脚本，分别支撑财务核算、采购与销售三单匹配。

通用三单匹配逻辑：采购订单（PO）× 收货（GR）× 发票（IR）三方核对，按 (EBELN, EBELP) 关联，输出四大类十三子类差异分析与可复核审计底稿。下列为核心可复用工具包；客户专属落地版见折叠。

通用三单匹配逻辑：销售订单 × 交货单 × 发票三方核对，覆盖 SAP SD（(VKORG, VBELN, POSNR) / AUBEL,AUPOS）与 OMS / DMS 双源，输出 13 场景 / 5 类差异。下列为核心可复用工具包；客户专属落地版见折叠。

工具类仓库按「一个仓库 = 一组相关工具」组织；下表按子工具 / SQL 模板逐条拆分，并链接至具体文件，便于检索与复用。

• 三单匹配（Three-Way Matching）：采购订单 / 收货单 / 发票 三方核对，定位差异并分类 _{Three-way matching: cross-check purchase order / goods receipt / invoice; locate and classify variances.}
• 多源数据对账：OMS / DMS / SAP 系统间数据一致性校验 _{Multi-source reconciliation: consistency checks across OMS / DMS / SAP.}
• 可复核输出：每个结论附带口径说明、源数据逻辑与运行记录，支撑审计留痕 _{Reviewable output: every result ships with its basis, source-data logic and run records for audit trail.}

项目逻辑（三单匹配 / 序时账-余额核对 / 多源对账）依赖各 ERP 系统的标准数据结构与接口规范，以下为各厂商官方说明文档，作为数据口径与字段映射的权威依据。 _{The reconciliation logic relies on each ERP's standard data structures and interfaces. Official vendor docs below serve as the authoritative basis for data scoping and field mapping.}

• SAP Help Portal — SAP 官方帮助门户，覆盖 ECC / S/4HANA 全模块文档
• SAP ERP (ECC) 文档 — MM / SD / FI 模块标准配置与底表结构
• SAP S/4HANA 文档 — S/4HANA 总账（ACDOCA）与凭证架构
• ABAP 关键字文档 / 数据字典 — 标准底表（BKPF / BSEG / EKPO / VBAK …）字段与域定义

• 用友开发者中心 — U8 / U9 / NC 开放接口与开发文档
• 用友 U8 产品与文档 — U8 存货 / 供应链 / 财务模块说明

• 金蝶开放平台 — 金蝶云·苍穹 / K/3 开放 API 与集成规范
• 金蝶开发者社区 — 苍穹 PaaS 平台开发文档与数据模型
• 金蝶官网 — 产品与模块总览

_{[About](#en-about) · [Notebook](#en-notebook) · [Projects](#en-projects) · [Methodology](#en-methodology) · [References](#en-references)}

• Big-4 IT audit background (2 yrs DTT, 2 yrs KPMG); now focused on audit data analytics and automation tooling
• Turning audit logic into reusable data tools — purchase / sales three-way matching, SAP data extraction, multi-source reconciliation

Four standalone projects under one repo: gvmeakiss-notebook.

⚠️ Data Compliance Disclaimer

Content shared here is for technical exchange only, on a no-revenue-sharing basis, and has been desensitized in accordance with:

• PIPL (Art. 51, 73) — personal information is de-identified (direct identifiers removed so individuals cannot be identified without additional info) and, where possible, anonymized;
• Data Security Law (Art. 21, 27) — data is subject to classification & graded protection, with technical safeguards applied to public content;
• Anti-Unfair-Competition Law (Art. 9) — trade secrets from original engagements (client names, legal entities, internal identifiers, operating data, etc.) are removed or desensitized.

Desensitization scope: client names, legal entities, internal codes, real addresses, payment/account info, order/product codes, financial data and any client workpapers (xlsx / sql / zip, etc.). No financial data or client working papers are stored or uploaded on this profile or in its repos.

29 public repos grouped by capability; ★ marks core reusable tools (start here). The scope column marks generic foundation vs. client-specific projects.

sap-abap-data-extraction is the foundation for three-way matching and journal-ledger checks. KAAP extraction scripts are configured per module — FI / MM / SD — to support financial accounting, purchase and sales matching.

Purchase order (PO) × goods receipt (GR) × invoice (IR), joined on (EBELN, EBELP), producing 4 major / 13 sub variance classes with reviewable audit workpapers. Core reusable toolkits below; client-specific deployments are folded.

Sales order × delivery × invoice, covering SAP SD ((VKORG, VBELN, POSNR) / AUBEL, AUPOS) and OMS / DMS dual sources — 13 scenarios / 5 variance classes. Core reusable toolkits below; client-specific deployments are folded.

Utility repos are organized as "one repo = one family of tools". The Chinese section above breaks these into per-tool / per-SQL-template tables with direct links; the table below lists each repo with its highlights.

• Three-Way Matching: cross-check purchase order / goods receipt / invoice; locate and classify variances
• Multi-source Reconciliation: consistency checks across OMS / DMS / SAP
• Reviewable Output: every result ships with its basis, source-data logic and run records for audit trail

The reconciliation logic relies on each ERP's standard data structures and interfaces. Official vendor docs below serve as the authoritative basis for data scoping and field mapping.

• SAP Help Portal — official help portal covering all ECC / S/4HANA modules
• SAP ERP (ECC) Docs — standard configuration and table structures for MM / SD / FI
• SAP S/4HANA Docs — S/4HANA general ledger (ACDOCA) and document architecture
• ABAP Keyword / Data Dictionary — fields & domains of standard tables (BKPF / BSEG / EKPO / VBAK …)

• Yonyou Developer Center — open APIs & dev docs for U8 / U9 / NC
• Yonyou U8 Product & Docs — U8 inventory / supply chain / finance module guides

• Kingdee Open Platform — Kingdee Cloud·Cosmic / K/3 open APIs & integration specs
• Kingdee Developer Community — Cosmic PaaS development docs & data models
• Kingdee Official Site — product & module overview