您的应收账款 data 模板

SAP S/4HANA

您的应收账款 data 模板

本模板为您在 SAP S/4HANA 中映射催收和付款流程提供了一个全面的框架。它包括了一份精选的待收集核心属性列表、一系列需追踪的流程活动，以及从财务表中提取数据的技术指导。遵循此结构，您可以清晰地查看现金流周期，并识别发生人工干预或付款延迟的环节。

建议收集的属性
需要追踪的关键活动
提取指南

不熟悉事件日志？了解如何创建流程挖掘事件日志.

下载模板

应收账款属性

这些是推荐包含在事件日志中的数据字段和维度属性，用于对应收账款流程进行全面分析。

5 必填 10 推荐 5 可选

	名称	描述
	Event 时间 EventTime	活动发生的时间戳。
描述此属性记录活动发生的准确日期和时间。对于交易数据，这通常是抬头表中“输入日期 (CPUDT)”和“输入时间 (CPUTM)”的组合。它支持计算周期时间和吞吐时间。为何重要准确的时间戳对于计算 DSO 和识别瓶颈至关重要。获取方式 SAP 表 BKPF-CPUDT 和 BKPF-CPUTM 示例 2023-10-12T08:30:00Z2023-10-15T14:45:12Z2023-11-01T09:15:00Z
	发票编号 InvoiceNumber	发票或会计凭证的唯一标识符。
描述此属性作为应收账款流程的唯一案件 ID。它通常对应于 SAP FI 模块中的会计凭证编号 (BELNR) 或 SD 模块中的计费凭证 (VBELN)，具体取决于提取逻辑。它将所有后续活动（如付款、争议和清帐）与原始财务义务关联起来。为何重要它是重构每笔交易端到端流程流所需的中心键。获取方式 SAP 表 BKPF-BELNR 或 VBRK-VBELN 示例 1400000234900004321014000002351800000099
	活动 Activity	流程中执行的具体事件或操作。
描述此属性描述了 AR 流程中执行的步骤，例如“创建发票”、“过账部分付款”或“发票清帐”。它通常源自交易代码 (TCODE) 或变更日志表中记录的单据状态的具体变更。为何重要这对于绘制流程流向和确定事件顺序至关重要。获取方式源自 SAP TSTCT（事务码）或 CDHDR/CDPOS（更改文档）示例创建应收发票过账部分付款结清发票创建争议案件
	最后数据更新 LastDataUpdate	数据上次提取或刷新的时间戳。
描述此属性表示数据加载到流程挖掘工具的时间。它帮助用户了解“期末对账状态”等仪表板中所呈现的数据的新鲜度。为何重要确保分析人员清楚自己查看的是实时数据还是历史数据。获取方式 ETL 元数据示例 2023-11-05T00:00:00Z2023-11-05T06:00:00Z
	源系统 SourceSystem	数据来源的系统。
描述此属性标识创建该记录的特定 SAP S/4HANA 实例或外部系统。在拥有多个 ERP 实例的复杂环境中，它对于追踪数据谱系非常有用。为何重要支持在多系统环境下进行隔离分析。获取方式系统 ID (SY-SYSID) 或提取期间硬编码示例 SAP_S4H_PRODSAP_S4H_01LEGACY_ERP
	DSO（应收账款周转天数） DaysSalesOutstanding	从发票过账到清帐的时长。
描述该指标是通过已清项的“清帐日期”减去“过账日期”计算得出的。它是“应收账款周转天数 (DSO) 概览”仪表板的核心数值，也是衡量现金流效率的关键指标。为何重要应收账款 (AR) 流程的核心高管 KPI。获取方式计算方式：核销日期 - 过账日期示例 30天45天15 天
	付款条款 PaymentTerms	代表约定付款条件的键。
描述此属性 (ZTERM) 定义了客户必须遵守的付款条件，包括截止日期和现金折扣。它是“提前付款折扣优化”仪表板的主要数据源。为何重要用于计算到期日和分析现金折扣资格的基准。获取方式 SAP 表 BSEG-ZTERM 或 KNB1-ZTERM 示例 NT300001Z015
	公司代码 CompanyCode	发票所属的财务实体或业务单元。
描述公司代码 (BUKRS) 是 SAP 系统中外部会计的核心组织单位。它用于在不同业务单元之间对“客户付款行为画像”等 Dashboard 进行细分分析。为何重要对于过滤和比较不同法人实体间的表现至关重要。获取方式 SAP 表 BKPF-BUKRS 或 T001-BUKRS 示例 1000US01DE012000
	凭证类型 DocumentType	对会计凭证进行分类（例如：发票、付款、贷项通知单）。
描述凭证类型 (BLART) 对交易进行分类。例如：“DR”代表客户发票，“DZ”代表客户付款，“DG”代表贷项凭证。这对于过滤特定案件类型以进行“贷项凭证与修正分析”至关重要。为何重要将数据细分为发票、付款和调整。获取方式 SAP 表 BKPF-BLART 示例 DRDZDGRV
	到期日期 DueDate	计算出的发票必须支付的截止日期。
描述此属性代表净到期日。在 SAP 中，这通常由“基准日期 (ZFBDT)”加上“付款条件 (ZTERM)”中定义的细则计算得出。它是“催收合规与执行”仪表板的基准。为何重要判断付款是否逾期的基准点。获取方式源自 BSEG-ZFBDT 和 BSEG-ZTERM 示例 2023-11-302023-12-15
	客户编号 CustomerNumber	客户账户的唯一标识符。
描述此属性代表与发票关联的客户编号 (KUNNR)。它支持对付款行为进行详细分析，对于“客户付款行为画像”仪表板至关重要。为何重要支持下钻分析特定客户账户的表现。获取方式 SAP 表 BSEG-KUNNR 或 KNA1-KUNNR 示例 CUST100230001004500WALMART_US
	是否已自动化 IsAutomated	标记活动是否由系统用户执行。
描述此布尔属性基于“用户”属性计算得出。如果用户 ID 匹配已知的系统或批处理账户（例如 'BNK_BSM'），该标志将设为 true。它直接驱动“付款匹配自动化率”仪表板。为何重要衡量数字化转型和自动化成功程度的关键指标。获取方式源自用户属性示例 truefalse
	本币金额 AmountInLocalCurrency	以公司代码货币表示的发票或付款金额。
描述此属性 (DMBTR) 包含交易的财务金额。它用于计算未清发票、贷项凭证和付款的总价值。通过量化价值，它为“贷项凭证与修正分析”仪表板提供支持。为何重要用于财务影响分析及高价值催收的优先级排序。获取方式 SAP 表 BSEG-DMBTR 或 ACDOCA-DMBTR 示例 1500.00250.5010000.00
	用户名称 User	执行该活动的用户 ID。
描述此属性 (USNAM) 识别负责该事件的用户或系统代理。通过区分人工用户和系统批处理用户，分析并计算“自动付款匹配率”。为何重要对于确定自动化率和用户生产力至关重要。获取方式 SAP 表 BKPF-USNAM 或 CDHDR-USERNAME 示例 JSMITHBATCH_USERSAP_WFALEX_D
	结清日期 ClearingDate	发票清帐或结算的日期。
描述此属性 (AUGDT) 记录未清项何时被清帐（通常是通过付款）。它是核心 AR 流程周期的结束时间戳，也是应收账款周转天数 (DSO) 计算中的主要变量。为何重要标志着催收周期的完成。获取方式 SAP 表 BSEG-AUGDT 或 BSAD-AUGDT 示例 2023-11-012023-11-10
	争议案件 ID DisputeCaseId	与发票关联的任何争议案件的标识符。
描述此属性持有争议案件的 ID (UDM_CASE)（如果存在）。它将财务单据链接到争议管理模块。这是“争议解决周期效率”仪表板的必要项。为何重要将应收账款凭证连接至争议解决工作流。获取方式 SAP 表 FDM_DCPROC 或 UDM_CASE_ATTR 示例 0000056789DISP-2023-001
	催款等级 DunningLevel	发票当前的催收级别。
描述此属性 (MAHNS) 表示客户被提醒付款的次数。它跟踪催收力度的升级，并在“催收合规与执行”仪表板中进行可视化展示。为何重要监控逾期付款的严重程度以及对催收策略的执行情况。获取方式 SAP 表 MHNK-MAHNS 或 KNB5 (客户主数据催收) 示例 1230
	区域 Region	客户所在的州、省或地区。
描述此属性 (REGIO) 提供比国家更细致的地理视图。它有助于“贷项凭证与修正分析”识别区域性的处理问题。为何重要精细化的地理区域分析。获取方式 SAP 表 KNA1-REGIO 示例 CA纽约TXBY
	国家/地区 Country	客户所属国家。
描述此属性 (LAND1) 来自客户主数据。它允许对 KPI 进行地理维度细分，例如按地区或国家分析贷项凭证率。为何重要区域合规性与绩效分析。获取方式 SAP 表 KNA1-LAND1 示例 USDEFRJP
	是否为贷项通知单 IsCreditMemo	标记凭证是否为贷项通知单。
描述此布尔属性源自凭证类型（例如类型等于“DG”）。它允许快速过滤修正交易，以支持“修正性贷项凭证率”KPI。为何重要识别返工和开票错误。获取方式源自凭证类型示例 truefalse

必填推荐可选

应收账款活动

这些是事件日志中需要捕获的关键流程步骤和交易里程碑，用于准确的流程发现和瓶颈识别。

6 推荐 7 可选

	活动	描述
	创建应收发票	财务系统中客户发票单据的初始创建。这从单据抬头创建时间戳中捕获。
为何重要标志着应收账款流程的开始和账龄时钟的启动。是计算应收账款周转天数 (DSO) 的关键。获取方式表 BKPF（会计凭证抬头），字段 CPUDT（输入日期）和 CPUTM（输入时间）。按与客户发票相关的凭证类型 (BLART)（例如 DR、RV）进行过滤。捕获当交易提交至 BKPF 表时记录事件类型 explicit
	发送付款提醒	为逾期发票生成的催款通知或提醒信函。用于追踪组织的催收工作。
为何重要对于“催款合规率”KPI 至关重要。它能验证催收策略是否严格按照政策执行。获取方式表 MHND（催收数据），字段 LAUFD（催收运行日期）。通过公司代码和客户进行关联。捕获当催款运行 (F150) 执行时记录事件类型 explicit
	收到全额付款	收到完全覆盖未付发票金额的资金。这通常意味着客户义务的有效终结。
为何重要判定实际付款日期与到期日的关系。对于分析“付款条款偏离”和客户行为至关重要。获取方式表 BSEG，源自清帐凭证 (AUGBL)，其中清帐日期 (AUGDT) 已设置且余额归零。捕获当核销凭证过账时记录事件类型 explicit
	签发发票输出	生成输出消息（邮件、打印、EDI）以向客户发送发票的具体动作。这证实了客户已正式收到计费请求。
为何重要创建与发出之间的延迟会缩短客户的实际付款期限窗口。监控这一环节可确保发票不会卡在内部处理阶段。获取方式表 NAST（消息状态），使用与发票凭证编号匹配的对象键 (OBJKY)。时间戳来自 DATVR 和 UHRVR。捕获在输出生成时记录在 NAST 表中事件类型 explicit
	结清发票	未清项与付款或贷项匹配且状态变更为“已清帐”的技术会计步骤。
为何重要系统中流程实例的明确结束。是计算最终 DSO 指标的必要项。获取方式表 BSEG 或 ACDOCA。字段 AUGDT（清帐日期）已填充。使用 USNAM 确定是自动化还是人工执行。捕获当 AUGDT 字段被填充时记录事件类型 explicit
	过账部分付款	收到不足以覆盖全额发票金额的款项，导致账户中留有余额项。
为何重要影响少付解决周期。频繁的部分付款会增加复杂性和手动对账的工作量。获取方式表 BSEG。当清帐凭证 (AUGBL) 创建一个新的剩余项（参考单据与原始发票匹配）且留有余额时推导出。捕获源自带有余额项的核销凭证创建事件类型 inferred
	创建争议案件	针对发票开启争议案件（通常通过 SAP FSCM 争议管理）。这表明客户对账单提出了质疑。
为何重要停止标准催收计时，但启动争议解决周期计时。此类情况的高发会影响现金流的可预测性。获取方式表 UDM_CASE_ATTR（案件属性）或 UDM_DISPUTE（争议案件）。通过 CASE_GUID 链接到财务凭证键。捕获记录在 FSCM 争议管理表中事件类型 explicit
	开票冲销	由于根本性错误，原始发票在系统中被取消或冲销。
为何重要代表失败的流程实例。将其过滤掉或单独分析对于保障数据质量至关重要。获取方式表 BKPF，原始发票记录上的字段 STBLG（冲销凭证编号）已填充。捕获当 STBLG 字段被填充时记录事件类型 explicit
	更新争议状态	现有争议案件的状态发生变更，例如，从“新建”变为“处理中”或“审核中”。
为何重要提供争议解决 workflow 的细粒度分析，帮助识别审批或调查阶段的瓶颈。获取方式争议案件的更改文档（S/4HANA 案件管理日志）。分析 UDM_CASE_ATTR 的变更。捕获在案件历史中比较状态字段的变更事件类型 inferred
	核对银行对账单	银行对账单行项目成功与分类账中的付款凭证匹配，完成现金头寸结算。
为何重要追踪银行对账单核对的前置时间。此处的延误会影响财务结账的速度。获取方式表 FEBEP（电子银行对账单行项目）。将付款凭证与银行对账单交易进行匹配。捕获记录在 EBS 表中 (FEBEP/FEBKO) 事件类型 explicit
	解决争议案件	争议案件关闭，结果可能是贷项凭证、呆账核销或重新确认债务。这标志着异常处理的结束。
为何重要 “平均争议解决时间”KPI 的结束时间戳。此环节的效率提升能直接收回停滞的营运资本。获取方式表 UDM_CASE_ATTR，根据配置选择字段 ESCALATION_DATE 或 CLOSED_DATE。捕获当案件状态设置为已关闭/作废时记录事件类型 explicit
	记录承诺付款	催收人员记录下客户在特定日期前支付特定金额的正式承诺。
为何重要代表催收人员的成功活动。用于预测短期现金流和衡量催收人员的工作量。获取方式表 UDM_P2P（承诺付款），字段 CREATED_AT。通过案件 GUID 或单据键链接到发票。捕获记录在 FSCM 催收管理中事件类型 explicit
	过账贷项通知单	开具并关联至发票的贷项通知单，用于冲减应付金额。通常用于纠错或处理退货。
为何重要 “更正类贷项通知单率”KPI 的核心。高频出现通常意味着销售或计费等上游环节存在质量问题。获取方式表 BSEG，凭证类型为“DG”或“KG”。通过指向原始发票的“发票引用”(REBZG) 字段进行识别。捕获当贷项通知单凭证引用发票时记录事件类型 explicit

推荐可选

提取指南

如何从 SAP S/4HANA 获取您的数据

步骤

确定数据源：本次提取使用 SAP S/4HANA 标准核心数据服务 (CDS) 视图。核心视图为 I_JournalEntryItem，其中包含所有财务交易（包括发票、付款和核销事件）的细颗粒度行项目。
准备 SQL 环境：确保拥有访问 SAP HANA 数据库的 SQL 权限。可以通过 SAP HANA Studio、DBACOCKPIT 事务码，或配置了连接 S/4HANA 实例的 ODBC/JDBC 外部 ETL 工具来实现。
定义范围与过滤条件：确定需要提取的公司代码和会计年度。下方的查询语句包含这些值的占位符，以优化性能和数据相关性。
提取财务活动：查询的第一部分针对 I_JournalEntryItem 视图。通过筛选科目类型 'D'（客户）来隔离应收账款数据。根据财务科目类型和凭证类型区分发票、贷项通知单和付款。
提取核销与结算：通过对 I_JournalEntryItem 进行自连接或单独选择，识别发票的核销时间。根据核销时间戳创建“核销发票”和“收到全额付款”活动。
整合运营事件：为了捕获非财务活动（如“发送付款提醒”或“创建争议案件”），查询将关联专业视图，如 I_DunningHistory、I_DisputeCase 和 I_OutputRequestItem。请注意，争议管理和输出管理的可用性取决于您的 S/4HANA 具体配置。
处理银行对账：“银行对账单调节”活动源自 I_BankStatementLineItem，通过它将外部银行对账单与内部会计凭证关联起来。
标准化输出列：查询将所有时间戳转换为标准格式，并确保填充所有必需列（发票编号、活动、事件时间）。货币值将转换为通用的浮点数或小数格式。
执行与验证：先针对一小部分数据（如一个公司代码、一个月）运行查询以验证逻辑。检查行数是否符合预期的交易量。
导出数据：将结果集保存为 CSV 或 Parquet 文件。确保编码设置为 UTF-8，以处理用户名或文本描述中的特殊字符。
导入至 ProcessMind：将导出的文件上传到 ProcessMind。在导入配置期间，将“发票编号”列映射到 Case ID 字段，将“事件时间”映射到 Timestamp 字段。

配置

源视图：使用标准 S/4HANA CDS 视图（I_JournalEntryItem、I_DunningHistory、I_DisputeCase、I_OutputRequestItem）。
日期范围：建议提取过去 12 个月的数据，以覆盖未结清发票的完整生命周期。
过滤条件：通过公司代码 (CompanyCode) 和会计年度 (FiscalYear) 过滤，以控制数据量。
科目类型：严格过滤科目类型 AccountType = 'D'，确保仅提取客户/应收账款数据。
性能优化：CDS 视图是虚拟数据模型。对于极大量的数据，请考虑将结果实体化或在业务低峰期执行提取。
自定义配置：逻辑上默认使用 SAP 标准凭证类型（如发票 RV、付款 DZ）。如果贵司使用了自定义凭证类型，请相应调整查询中的 CASE 语句。

a 查询示例 sql

/* ACCOUNTS RECEIVABLE EXTRACTION - SAP S/4HANA CDS VIEWS */
/* METHOD: SQL Union of multiple CDS Views */

/* 1. Create AR Invoice */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Create AR Invoice' AS Activity,
    JE.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    JE.AccountingDocumentType AS DocumentType,
    JE.PaymentTerms,
    JE.NetDueDate AS DueDate,
    JE.ClearingDate,
    'False' AS IsAutomated,
    CASE 
        WHEN JE.ClearingDate IS NOT NULL THEN DAYS_BETWEEN(JE.PostingDate, JE.ClearingDate) 
        ELSE NULL 
    END AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.FinancialAccountType = 'D' -- Customer
  AND JE.AccountingDocumentType IN ('RV', 'DR') -- Invoice Types
  AND JE.Ledger = '0L' -- Leading Ledger
  AND JE.CompanyCode IN ('[Your Company Code]')
  AND JE.FiscalYear >= '[Your Start Year]'

UNION ALL

/* 2. Issue Invoice Output (Requires S/4 Output Management) */
SELECT 
    CAST(B.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Issue Invoice Output' AS Activity,
    O.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    B.CompanyCode,
    B.SoldToParty AS CustomerNumber,
    CAST(B.TotalNetAmount AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    O.CreatedByUser AS "User",
    B.BillingDocumentType AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_BillingDocument AS B
JOIN I_OutputRequestItem AS O ON O.BillingDocument = B.BillingDocument
WHERE B.CompanyCode IN ('[Your Company Code]')
  AND B.FiscalYear >= '[Your Start Year]'

UNION ALL

/* 3. Send Payment Reminder */
SELECT 
    CAST(D.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Send Payment Reminder' AS Activity,
    D.DunningDate AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    D.CompanyCode,
    D.Customer AS CustomerNumber,
    CAST(D.AmountInLocalCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    'System' AS "User",
    'Dunning' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DunningHistory AS D
WHERE D.CompanyCode IN ('[Your Company Code]')
  AND D.DunningDate >= '[Your Start Date]'

UNION ALL

/* 4. Create Dispute Case (Requires FSCM) */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Create Dispute Case' AS Activity,
    DC.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    DC.CompanyCode,
    DC.Customer AS CustomerNumber,
    CAST(DC.DisputedAmount AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    DC.CreatedByUser AS "User",
    'Dispute' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DisputeCase AS DC
JOIN I_JournalEntryItem AS JE ON DC.CompanyCode = JE.CompanyCode AND DC.Customer = JE.Customer
/* Note: Join logic simplified. Ideally link via Case ID reference in JE if configured */
WHERE DC.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 5. Update Dispute Status */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Update Dispute Status' AS Activity,
    DC.LastChangeDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    DC.CompanyCode,
    DC.Customer AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    DC.LastChangedByUser AS "User",
    'Dispute' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DisputeCase AS DC
JOIN I_JournalEntryItem AS JE ON DC.CompanyCode = JE.CompanyCode AND DC.Customer = JE.Customer
WHERE DC.LastChangeDateTime IS NOT NULL
  AND DC.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 6. Resolve Dispute Case */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Resolve Dispute Case' AS Activity,
    DC.ClosingDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    DC.CompanyCode,
    DC.Customer AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    DC.LastChangedByUser AS "User",
    'Dispute' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DisputeCase AS DC
JOIN I_JournalEntryItem AS JE ON DC.CompanyCode = JE.CompanyCode AND DC.Customer = JE.Customer
WHERE DC.ClosingDateTime IS NOT NULL
  AND DC.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 7. Record Promise To Pay */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Record Promise To Pay' AS Activity,
    PP.PromiseToPayDate AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    PP.CompanyCode,
    PP.Customer AS CustomerNumber,
    CAST(PP.PromiseAmount AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    PP.CreatedByUser AS "User",
    'Promise' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_PromiseToPay AS PP
JOIN I_JournalEntryItem AS JE ON PP.CompanyCode = JE.CompanyCode AND PP.Customer = JE.Customer
WHERE PP.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 8. Post Partial Payment (Logic: Payment Doc exists but invoice not fully cleared immediately) */
SELECT 
    CAST(JE_INV.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Post Partial Payment' AS Activity,
    JE_PAY.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE_PAY.CompanyCode,
    JE_PAY.Customer AS CustomerNumber,
    CAST(JE_PAY.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE_PAY.CreatedByUser AS "User",
    JE_PAY.AccountingDocumentType AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE_INV.ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE_PAY
JOIN I_JournalEntryItem AS JE_INV ON JE_PAY.ClearingJournalEntry = JE_INV.AccountingDocument 
     AND JE_PAY.CompanyCode = JE_INV.CompanyCode
     AND JE_PAY.FiscalYear = JE_INV.FiscalYear
WHERE JE_PAY.AccountingDocumentType IN ('DZ', 'ZP') -- Payment Types
  AND JE_INV.ClearingDate IS NULL -- Invoice still open
  AND JE_PAY.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 9. Post Credit Memo */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Post Credit Memo' AS Activity,
    JE.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    JE.AccountingDocumentType AS DocumentType,
    JE.PaymentTerms,
    JE.NetDueDate AS DueDate,
    JE.ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.FinancialAccountType = 'D'
  AND JE.AccountingDocumentType IN ('DG') -- Credit Memo
  AND JE.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 10. Receive Full Payment */
SELECT 
    CAST(JE_INV.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Receive Full Payment' AS Activity,
    JE_PAY.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE_PAY.CompanyCode,
    JE_PAY.Customer AS CustomerNumber,
    CAST(JE_PAY.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE_PAY.CreatedByUser AS "User",
    JE_PAY.AccountingDocumentType AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE_INV.ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE_PAY
JOIN I_JournalEntryItem AS JE_INV ON JE_PAY.ClearingJournalEntry = JE_INV.AccountingDocument 
     AND JE_PAY.CompanyCode = JE_INV.CompanyCode
     AND JE_PAY.FiscalYear = JE_INV.FiscalYear
WHERE JE_PAY.AccountingDocumentType IN ('DZ', 'ZP')
  AND JE_INV.ClearingDate IS NOT NULL -- Fully cleared
  AND JE_PAY.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 11. Clear Invoice */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Clear Invoice' AS Activity,
    CAST(JE.ClearingDate AS TIMESTAMP) AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    'Clearing' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE.ClearingDate,
    'True' AS IsAutomated,
    DAYS_BETWEEN(JE.PostingDate, JE.ClearingDate) AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.FinancialAccountType = 'D'
  AND JE.ClearingDate IS NOT NULL
  AND JE.AccountingDocumentType IN ('RV', 'DR')
  AND JE.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 12. Reconcile Bank Statement */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Reconcile Bank Statement' AS Activity,
    BS.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(BS.AmountInTransactionCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    BS.CreatedByUser AS "User",
    'BankStmt' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE.ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_BankStatementLineItem AS BS
JOIN I_JournalEntryItem AS JE ON BS.BankStatementShortID = JE.Reference1IDByBusinessPartner -- Check mapping in your system
WHERE JE.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 13. Reverse Invoice */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Reverse Invoice' AS Activity,
    JE.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    JE.AccountingDocumentType AS DocumentType,
    JE.PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.IsReversal = 'X' 
  OR JE.IsReversed = 'X'
  AND JE.CompanyCode IN ('[Your Company Code]')

步骤

确定数据源：本次提取使用 SAP S/4HANA 标准核心数据服务 (CDS) 视图。核心视图为 I_JournalEntryItem，其中包含所有财务交易（包括发票、付款和核销事件）的细颗粒度行项目。
准备 SQL 环境：确保拥有访问 SAP HANA 数据库的 SQL 权限。可以通过 SAP HANA Studio、DBACOCKPIT 事务码，或配置了连接 S/4HANA 实例的 ODBC/JDBC 外部 ETL 工具来实现。
定义范围与过滤条件：确定需要提取的公司代码和会计年度。下方的查询语句包含这些值的占位符，以优化性能和数据相关性。
提取财务活动：查询的第一部分针对 I_JournalEntryItem 视图。通过筛选科目类型 'D'（客户）来隔离应收账款数据。根据财务科目类型和凭证类型区分发票、贷项通知单和付款。
提取核销与结算：通过对 I_JournalEntryItem 进行自连接或单独选择，识别发票的核销时间。根据核销时间戳创建“核销发票”和“收到全额付款”活动。
整合运营事件：为了捕获非财务活动（如“发送付款提醒”或“创建争议案件”），查询将关联专业视图，如 I_DunningHistory、I_DisputeCase 和 I_OutputRequestItem。请注意，争议管理和输出管理的可用性取决于您的 S/4HANA 具体配置。
处理银行对账：“银行对账单调节”活动源自 I_BankStatementLineItem，通过它将外部银行对账单与内部会计凭证关联起来。
标准化输出列：查询将所有时间戳转换为标准格式，并确保填充所有必需列（发票编号、活动、事件时间）。货币值将转换为通用的浮点数或小数格式。
执行与验证：先针对一小部分数据（如一个公司代码、一个月）运行查询以验证逻辑。检查行数是否符合预期的交易量。
导出数据：将结果集保存为 CSV 或 Parquet 文件。确保编码设置为 UTF-8，以处理用户名或文本描述中的特殊字符。
导入至 ProcessMind：将导出的文件上传到 ProcessMind。在导入配置期间，将“发票编号”列映射到 Case ID 字段，将“事件时间”映射到 Timestamp 字段。

配置

源视图：使用标准 S/4HANA CDS 视图（I_JournalEntryItem、I_DunningHistory、I_DisputeCase、I_OutputRequestItem）。
日期范围：建议提取过去 12 个月的数据，以覆盖未结清发票的完整生命周期。
过滤条件：通过公司代码 (CompanyCode) 和会计年度 (FiscalYear) 过滤，以控制数据量。
科目类型：严格过滤科目类型 AccountType = 'D'，确保仅提取客户/应收账款数据。
性能优化：CDS 视图是虚拟数据模型。对于极大量的数据，请考虑将结果实体化或在业务低峰期执行提取。
自定义配置：逻辑上默认使用 SAP 标准凭证类型（如发票 RV、付款 DZ）。如果贵司使用了自定义凭证类型，请相应调整查询中的 CASE 语句。

a 查询示例 sql

/* ACCOUNTS RECEIVABLE EXTRACTION - SAP S/4HANA CDS VIEWS */
/* METHOD: SQL Union of multiple CDS Views */

/* 1. Create AR Invoice */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Create AR Invoice' AS Activity,
    JE.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    JE.AccountingDocumentType AS DocumentType,
    JE.PaymentTerms,
    JE.NetDueDate AS DueDate,
    JE.ClearingDate,
    'False' AS IsAutomated,
    CASE 
        WHEN JE.ClearingDate IS NOT NULL THEN DAYS_BETWEEN(JE.PostingDate, JE.ClearingDate) 
        ELSE NULL 
    END AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.FinancialAccountType = 'D' -- Customer
  AND JE.AccountingDocumentType IN ('RV', 'DR') -- Invoice Types
  AND JE.Ledger = '0L' -- Leading Ledger
  AND JE.CompanyCode IN ('[Your Company Code]')
  AND JE.FiscalYear >= '[Your Start Year]'

UNION ALL

/* 2. Issue Invoice Output (Requires S/4 Output Management) */
SELECT 
    CAST(B.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Issue Invoice Output' AS Activity,
    O.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    B.CompanyCode,
    B.SoldToParty AS CustomerNumber,
    CAST(B.TotalNetAmount AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    O.CreatedByUser AS "User",
    B.BillingDocumentType AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_BillingDocument AS B
JOIN I_OutputRequestItem AS O ON O.BillingDocument = B.BillingDocument
WHERE B.CompanyCode IN ('[Your Company Code]')
  AND B.FiscalYear >= '[Your Start Year]'

UNION ALL

/* 3. Send Payment Reminder */
SELECT 
    CAST(D.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Send Payment Reminder' AS Activity,
    D.DunningDate AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    D.CompanyCode,
    D.Customer AS CustomerNumber,
    CAST(D.AmountInLocalCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    'System' AS "User",
    'Dunning' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DunningHistory AS D
WHERE D.CompanyCode IN ('[Your Company Code]')
  AND D.DunningDate >= '[Your Start Date]'

UNION ALL

/* 4. Create Dispute Case (Requires FSCM) */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Create Dispute Case' AS Activity,
    DC.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    DC.CompanyCode,
    DC.Customer AS CustomerNumber,
    CAST(DC.DisputedAmount AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    DC.CreatedByUser AS "User",
    'Dispute' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DisputeCase AS DC
JOIN I_JournalEntryItem AS JE ON DC.CompanyCode = JE.CompanyCode AND DC.Customer = JE.Customer
/* Note: Join logic simplified. Ideally link via Case ID reference in JE if configured */
WHERE DC.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 5. Update Dispute Status */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Update Dispute Status' AS Activity,
    DC.LastChangeDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    DC.CompanyCode,
    DC.Customer AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    DC.LastChangedByUser AS "User",
    'Dispute' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DisputeCase AS DC
JOIN I_JournalEntryItem AS JE ON DC.CompanyCode = JE.CompanyCode AND DC.Customer = JE.Customer
WHERE DC.LastChangeDateTime IS NOT NULL
  AND DC.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 6. Resolve Dispute Case */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Resolve Dispute Case' AS Activity,
    DC.ClosingDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    DC.CompanyCode,
    DC.Customer AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    DC.LastChangedByUser AS "User",
    'Dispute' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_DisputeCase AS DC
JOIN I_JournalEntryItem AS JE ON DC.CompanyCode = JE.CompanyCode AND DC.Customer = JE.Customer
WHERE DC.ClosingDateTime IS NOT NULL
  AND DC.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 7. Record Promise To Pay */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Record Promise To Pay' AS Activity,
    PP.PromiseToPayDate AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    PP.CompanyCode,
    PP.Customer AS CustomerNumber,
    CAST(PP.PromiseAmount AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    PP.CreatedByUser AS "User",
    'Promise' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_PromiseToPay AS PP
JOIN I_JournalEntryItem AS JE ON PP.CompanyCode = JE.CompanyCode AND PP.Customer = JE.Customer
WHERE PP.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 8. Post Partial Payment (Logic: Payment Doc exists but invoice not fully cleared immediately) */
SELECT 
    CAST(JE_INV.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Post Partial Payment' AS Activity,
    JE_PAY.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE_PAY.CompanyCode,
    JE_PAY.Customer AS CustomerNumber,
    CAST(JE_PAY.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE_PAY.CreatedByUser AS "User",
    JE_PAY.AccountingDocumentType AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE_INV.ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE_PAY
JOIN I_JournalEntryItem AS JE_INV ON JE_PAY.ClearingJournalEntry = JE_INV.AccountingDocument 
     AND JE_PAY.CompanyCode = JE_INV.CompanyCode
     AND JE_PAY.FiscalYear = JE_INV.FiscalYear
WHERE JE_PAY.AccountingDocumentType IN ('DZ', 'ZP') -- Payment Types
  AND JE_INV.ClearingDate IS NULL -- Invoice still open
  AND JE_PAY.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 9. Post Credit Memo */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Post Credit Memo' AS Activity,
    JE.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    JE.AccountingDocumentType AS DocumentType,
    JE.PaymentTerms,
    JE.NetDueDate AS DueDate,
    JE.ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.FinancialAccountType = 'D'
  AND JE.AccountingDocumentType IN ('DG') -- Credit Memo
  AND JE.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 10. Receive Full Payment */
SELECT 
    CAST(JE_INV.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Receive Full Payment' AS Activity,
    JE_PAY.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE_PAY.CompanyCode,
    JE_PAY.Customer AS CustomerNumber,
    CAST(JE_PAY.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE_PAY.CreatedByUser AS "User",
    JE_PAY.AccountingDocumentType AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE_INV.ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE_PAY
JOIN I_JournalEntryItem AS JE_INV ON JE_PAY.ClearingJournalEntry = JE_INV.AccountingDocument 
     AND JE_PAY.CompanyCode = JE_INV.CompanyCode
     AND JE_PAY.FiscalYear = JE_INV.FiscalYear
WHERE JE_PAY.AccountingDocumentType IN ('DZ', 'ZP')
  AND JE_INV.ClearingDate IS NOT NULL -- Fully cleared
  AND JE_PAY.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 11. Clear Invoice */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Clear Invoice' AS Activity,
    CAST(JE.ClearingDate AS TIMESTAMP) AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    'Clearing' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE.ClearingDate,
    'True' AS IsAutomated,
    DAYS_BETWEEN(JE.PostingDate, JE.ClearingDate) AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.FinancialAccountType = 'D'
  AND JE.ClearingDate IS NOT NULL
  AND JE.AccountingDocumentType IN ('RV', 'DR')
  AND JE.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 12. Reconcile Bank Statement */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Reconcile Bank Statement' AS Activity,
    BS.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(BS.AmountInTransactionCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    BS.CreatedByUser AS "User",
    'BankStmt' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    JE.ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_BankStatementLineItem AS BS
JOIN I_JournalEntryItem AS JE ON BS.BankStatementShortID = JE.Reference1IDByBusinessPartner -- Check mapping in your system
WHERE JE.CompanyCode IN ('[Your Company Code]')

UNION ALL

/* 13. Reverse Invoice */
SELECT 
    CAST(JE.AccountingDocument AS VARCHAR(20)) AS InvoiceNumber,
    'Reverse Invoice' AS Activity,
    JE.CreationDateTime AS EventTime,
    'SAP S/4HANA' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    JE.CompanyCode,
    JE.Customer AS CustomerNumber,
    CAST(JE.AmountInCompanyCodeCurrency AS DECIMAL(19,2)) AS AmountInLocalCurrency,
    JE.CreatedByUser AS "User",
    JE.AccountingDocumentType AS DocumentType,
    JE.PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM I_JournalEntryItem AS JE
WHERE JE.IsReversal = 'X' 
  OR JE.IsReversed = 'X'
  AND JE.CompanyCode IN ('[Your Company Code]')

步骤

环境准备：确保提取机器上已安装 Python 3.x。通过 pip 安装 SAP NetWeaver RFC SDK（PyRFC 必需）以及 Python 库 pyrfc 和 pandas。
SAP 用户配置：验证 SAP 用户账号是否拥有 S_RFC（用于远程函数调用）和 S_TABU_DIS（用于表读取）权限。用户需要访问函数模块 RFC_READ_TABLE 的权限。
网络配置：确保运行脚本的机器能够访问 SAP 应用服务器端口（通常为 33xx），且防火墙允许此类通信。
脚本配置：打开“查询”部分提供的 Python 脚本。使用您具体的应用服务器主机 (ASHOST)、系统编号 (SYSNR)、客户端 (CLIENT)、用户名和密码更新 sap_config 字典。
定义过滤器：修改脚本中的 TARGET_BUKRS（公司代码）和 TARGET_GJAHR（会计年度）变量以限制数据范围。这对于防止读取 BSEG 等大表时出现超时至关重要。
执行脚本：通过命令行运行脚本（例如 python extract_ar.py）。脚本将验证连接并开始按顺序下载数据分块。
数据转换：脚本利用 Pandas 将 SAP 原始表（BKPF、BSEG、NAST、MHND、UDM 表、FEBEP）合并为统一的事件日志。它会处理日期转换，并根据核销逻辑区分“发布部分付款”与“收到全额付款”等活动。
CSV 输出：完成后，脚本将在当前目录下生成名为 AR_Event_Log.csv 的文件。
数据验证：打开 CSV 文件，验证 EventTime 和 Activity 列是否填充正确。检查特定的发票编号是否拥有对应其生命周期的多行记录（创建 -> 输出 -> 付款）。
导入至 ProcessMind：将 AR_Event_Log.csv 文件上传到 ProcessMind。将 InvoiceNumber 映射为 Case ID，Activity 映射为 Activity，并将 EventTime 映射为 Timestamp。

配置

RFC_READ_TABLE 限制：标准 SAP 函数模块存在行宽限制（通常为 512 字节）。本脚本通过显式选择必要列来确保不超出此限制。
会计年度筛选：在查询财务表（BKPF、BSEG）时，务必通过 GJAHR（会计年度）进行过滤，以保证查询性能。
公司代码：对于多实体的 SAP 实例，必须通过 BUKRS 进行范围限制。
数据分块：针对超大规模数据集，脚本可能需要在 read_table 函数中实现 ROWCOUNT 和 SKIP 选项进行分页处理（此处为简洁起见已省略，但在生产环境中建议使用）。
FSCM 可用性：脚本会尝试读取用于争议管理的 UDM_ 表。如果您的 S/4HANA 系统中未激活这些模块，脚本的相关部分将返回空数据框，或者应手动将其注释掉。
日期处理：SAP 日期以 YYYYMMDD 字符串格式存储。脚本会自动将其转换为 Python 的 datetime 对象。

a 查询示例 python

import pandas as pd
from pyrfc import Connection
from datetime import datetime

class=class="hl-string">"hl-comment"># === CONFIGURATION ===
sap_config = {
    class="hl-string">'user': class="hl-string">'YOUR_USER',
    class="hl-string">'passwd': class="hl-string">'YOUR_PASSWORD',
    class="hl-string">'ashost': class="hl-string">'192.168.0.1',  class=class="hl-string">"hl-comment"># SAP App Server IP
    class="hl-string">'sysnr': class="hl-string">'00',            class=class="hl-string">"hl-comment"># Instance Number
    class="hl-string">'client': class="hl-string">'100',          class=class="hl-string">"hl-comment"># Client
    class="hl-string">'lang': class="hl-string">'EN'
}

TARGET_BUKRS = class="hl-string">'1000'  class=class="hl-string">"hl-comment"># Company Code
TARGET_GJAHR = class="hl-string">'2023'  class=class="hl-string">"hl-comment"># Fiscal Year

class=class="hl-string">"hl-comment"># === HELPER FUNCTIONS ===
def read_table(conn, table_name, fields, options=[]):
    class="hl-string">"""Reads an SAP table via RFC_READ_TABLE."""
    print(fclass="hl-string">"Reading {table_name}...")
    try:
        result = conn.call(class="hl-string">'RFC_READ_TABLE',
                           QUERY_TABLE=table_name,
                           DELIMITER=class="hl-string">';',
                           FIELDS=[{class="hl-string">'FIELDNAME': f} for f in fields],
                           OPTIONS=[{class="hl-string">'TEXT': o} for o in options])
        data_str = result[class="hl-string">'DATA']
        headers = [f[class="hl-string">'FIELDNAME'] for f in result[class="hl-string">'FIELDS']]
        
        class=class="hl-string">"hl-comment"># Parse delimiter separated values
        rows = [row[class="hl-string">'WA'].split(class="hl-string">';') for row in data_str]
        df = pd.DataFrame(rows, columns=headers)
        return df
    except Exception as e:
        print(fclass="hl-string">"Error reading {table_name}: {e}")
        return pd.DataFrame(columns=fields)

def sap_date_to_datetime(date_str, time_str=class="hl-string">'000000'):
    class="hl-string">"""Converts SAP YYYYMMDD and HHMMSS strings to datetime."""
    try:
        return pd.to_datetime(date_str + time_str, format=class="hl-string">'%Y%m%d%H%M%S')
    except:
        return pd.NaT

class=class="hl-string">"hl-comment"># === MAIN EXTRACTION ===
def main():
    conn = Connection(**sap_config)
    
    class=class="hl-string">"hl-comment"># 1. Fetch Header Data (BKPF) - Invoices and Payments
    class=class="hl-string">"hl-comment"># Document Types for Invoices: DR (Customer Invoice), RV (Billing Doc)
    fields_bkpf = [class="hl-string">'BUKRS', class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BLART', class="hl-string">'CPUDT', class="hl-string">'CPUTM', class="hl-string">'USNAM', class="hl-string">'WAERS', class="hl-string">'STBLG']
    options_bkpf = [fclass="hl-string">"BUKRS = '{TARGET_BUKRS}' AND GJAHR = '{TARGET_GJAHR}'"]
    df_bkpf = read_table(conn, class="hl-string">'BKPF', fields_bkpf, options_bkpf)

    class=class="hl-string">"hl-comment"># 2. Fetch Segment Data (BSEG) - Customer Line Items (KOART = D)
    fields_bseg = [class="hl-string">'BUKRS', class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUZEI', class="hl-string">'KOART', class="hl-string">'KUNNR', class="hl-string">'WRBTR', class="hl-string">'AUGBL', class="hl-string">'AUGDT', class="hl-string">'ZLSPR', class="hl-string">'ZTERM', class="hl-string">'SKFBT']
    class=class="hl-string">"hl-comment"># Note: Querying BSEG directly can be slow. Ensure filters are strict.
    options_bseg = [fclass="hl-string">"BUKRS = '{TARGET_BUKRS}' AND GJAHR = '{TARGET_GJAHR}' AND KOART = 'D'"]
    df_bseg = read_table(conn, class="hl-string">'BSEG', fields_bseg, options_bseg)

    class=class="hl-string">"hl-comment"># Merge Header and Item to form base document list
    df_docs = pd.merge(df_bseg, df_bkpf, on=[class="hl-string">'BUKRS', class="hl-string">'BELNR', class="hl-string">'GJAHR'])
    
    class=class="hl-string">"hl-comment"># Filter strictly for AR Invoices (Simplification: Doc Types DR, RV)
    df_invoices = df_docs[df_docs[class="hl-string">'BLART'].isin([class="hl-string">'DR', class="hl-string">'RV', class="hl-string">'DG'])].copy()

    class=class="hl-string">"hl-comment"># === ACTIVITY GENERATION ===
    events = []

    class=class="hl-string">"hl-comment"># Activity 1: Create AR Invoice
    for _, row in df_invoices.iterrows():
        timestamp = sap_date_to_datetime(row[class="hl-string">'CPUDT'], row[class="hl-string">'CPUTM'])
        events.append({
            class="hl-string">'InvoiceNumber': row[class="hl-string">'BELNR'],
            class="hl-string">'Activity': class="hl-string">'Create AR Invoice',
            class="hl-string">'EventTime': timestamp,
            class="hl-string">'SourceSystem': class="hl-string">'SAP_S4',
            class="hl-string">'CompanyCode': row[class="hl-string">'BUKRS'],
            class="hl-string">'CustomerNumber': row[class="hl-string">'KUNNR'],
            class="hl-string">'AmountInLocalCurrency': row[class="hl-string">'WRBTR'],
            class="hl-string">'User': row[class="hl-string">'USNAM'],
            class="hl-string">'DocumentType': row[class="hl-string">'BLART']
        })

    class=class="hl-string">"hl-comment"># Activity 2: Issue Invoice Output (NAST)
    class=class="hl-string">"hl-comment"># Get unique Invoice numbers to filter NAST
    invoice_nums = df_invoices[class="hl-string">'BELNR'].unique().tolist()
    if invoice_nums:
        class=class="hl-string">"hl-comment"># NAST keys: KAPPL=class="hl-string">'V3' (Billing), OBJKY = Invoice Number
        class=class="hl-string">"hl-comment"># Note: In production, batch this query if list is long
        fields_nast = [class="hl-string">'OBJKY', class="hl-string">'KSCHL', class="hl-string">'DATVR', class="hl-string">'UHRVR', class="hl-string">'USNAM']
        options_nast = [class="hl-string">"KAPPL = 'V3'"] class=class="hl-string">"hl-comment"># Add OBJKY IN (...) logic for optimization
        df_nast = read_table(conn, class="hl-string">'NAST', fields_nast, options_nast)
        
        for _, row in df_nast.iterrows():
            if row[class="hl-string">'OBJKY'] in invoice_nums:
                events.append({
                    class="hl-string">'InvoiceNumber': row[class="hl-string">'OBJKY'],
                    class="hl-string">'Activity': class="hl-string">'Issue Invoice Output',
                    class="hl-string">'EventTime': sap_date_to_datetime(row[class="hl-string">'DATVR'], row[class="hl-string">'UHRVR']),
                    class="hl-string">'SourceSystem': class="hl-string">'SAP_S4',
                    class="hl-string">'User': row[class="hl-string">'USNAM']
                })

    class=class="hl-string">"hl-comment"># Activity 3: Send Payment Reminder (MHND/MHNK)
    fields_mhnd = [class="hl-string">'LAUFD', class="hl-string">'LAUFI', class="hl-string">'KUNNR', class="hl-string">'BUKRS', class="hl-string">'KOART']
    class=class="hl-string">"hl-comment"># MHND links dunning run to customer, difficult to link exact invoice item in RFC without join
    class=class="hl-string">"hl-comment"># We will approximate by reading MHND (Dunning Data) where KOART=D
    class=class="hl-string">"hl-comment"># To get Invoice link, we need to know if item is in dunning. 
    class=class="hl-string">"hl-comment"># Simplified: Assuming we can fetch MHND for our customers.
    options_mhnd = [fclass="hl-string">"BUKRS = '{TARGET_BUKRS}' AND KOART = 'D'"]
    df_mhnd = read_table(conn, class="hl-string">'MHND', fields_mhnd + [class="hl-string">'BELNR'], options_mhnd)
    
    for _, row in df_mhnd.iterrows():
        if row[class="hl-string">'BELNR'] in invoice_nums:
            events.append({
                class="hl-string">'InvoiceNumber': row[class="hl-string">'BELNR'],
                class="hl-string">'Activity': class="hl-string">'Send Payment Reminder',
                class="hl-string">'EventTime': sap_date_to_datetime(row[class="hl-string">'LAUFD']), class=class="hl-string">"hl-comment"># Dunning date
                class="hl-string">'SourceSystem': class="hl-string">'SAP_S4',
                class="hl-string">'User': class="hl-string">'SYSTEM'
            })

    class=class="hl-string">"hl-comment"># Activity 4, 5, 6: Dispute Management (UDM_CASE_ATTR)
    class=class="hl-string">"hl-comment"># Requires FSCM. Linking via UDM_RELATION or knowing CASE_GUID.
    class=class="hl-string">"hl-comment"># We assume class="hl-string">'FIN_DISPUTE' case type.
    fields_udm = [class="hl-string">'CASE_GUID', class="hl-string">'CASE_ID', class="hl-string">'FIN_KUNNR', class="hl-string">'CREATE_TIME', class="hl-string">'CLOSE_TIME', class="hl-string">'ESCAL_REASON', class="hl-string">'PROCESSOR']
    df_udm = read_table(conn, class="hl-string">'UDM_CASE_ATTR', fields_udm, options=[])
    
    class=class="hl-string">"hl-comment"># UDM_RELATION links Case to Object (Invoice)
    fields_rel = [class="hl-string">'CASE_GUID', class="hl-string">'OBJ_KEY']
    df_rel = read_table(conn, class="hl-string">'UDM_RELATION', fields_rel, options=[])
    
    class=class="hl-string">"hl-comment"># Merge Dispute info
    df_disputes = pd.merge(df_udm, df_rel, on=class="hl-string">'CASE_GUID')
    
    for _, row in df_disputes.iterrows():
        inv_num = row[class="hl-string">'OBJ_KEY'] class=class="hl-string">"hl-comment"># Needs parsing usually (RefKey), assuming raw match for simplicity
        if inv_num in invoice_nums:
            class=class="hl-string">"hl-comment"># 4. Create Dispute Case
            events.append({
                class="hl-string">'InvoiceNumber': inv_num,
                class="hl-string">'Activity': class="hl-string">'Create Dispute Case',
                class="hl-string">'EventTime': pd.to_datetime(row[class="hl-string">'CREATE_TIME']),
                class="hl-string">'SourceSystem': class="hl-string">'SAP_S4',
                class="hl-string">'User': row[class="hl-string">'PROCESSOR']
            })
            class=class="hl-string">"hl-comment"># 5. Update Dispute Status (Approximation via Change Time or attribute check)
            class=class="hl-string">"hl-comment"># Omitted for brevity: requires CDHDR/CDPOS lookup
            
            class=class="hl-string">"hl-comment"># 6. Resolve Dispute Case
            if pd.notna(row[class="hl-string">'CLOSE_TIME']) and row[class="hl-string">'CLOSE_TIME'] != class="hl-string">'0.0000000E+00':
                 events.append({
                    class="hl-string">'InvoiceNumber': inv_num,
                    class="hl-string">'Activity': class="hl-string">'Resolve Dispute Case',
                    class="hl-string">'EventTime': pd.to_datetime(row[class="hl-string">'CLOSE_TIME']),
                    class="hl-string">'SourceSystem': class="hl-string">'SAP_S4'
                })

    class=class="hl-string">"hl-comment"># Activities 8-11: Payments and Clearing
    class=class="hl-string">"hl-comment"># We look at the class="hl-string">'AUGBL' (Clearing Doc) in the Invoice BSEG row.
    for _, row in df_invoices.iterrows():
        if row[class="hl-string">'AUGBL'] and row[class="hl-string">'AUGBL'] != class="hl-string">'':
            clearing_doc = row[class="hl-string">'AUGBL']
            clearing_date = row[class="hl-string">'AUGDT']
            
            class=class="hl-string">"hl-comment"># 11. Clear Invoice
            events.append({
                class="hl-string">'InvoiceNumber': row[class="hl-string">'BELNR'],
                class="hl-string">'Activity': class="hl-string">'Clear Invoice',
                class="hl-string">'EventTime': sap_date_to_datetime(clearing_date),
                class="hl-string">'SourceSystem': class="hl-string">'SAP_S4',
                class="hl-string">'ClearingDate': sap_date_to_datetime(clearing_date)
            })
            
            class=class="hl-string">"hl-comment"># Analyze Clearing Document to determine if it was Payment or Credit Memo
            class=class="hl-string">"hl-comment"># Fetch the header of the clearing document
            class=class="hl-string">"hl-comment"># In a real run, batch these fetches. Here we simulate availability.
            class=class="hl-string">"hl-comment"># We check if we already fetched it in df_bkpf (if within same year)
            clear_header = df_bkpf[(df_bkpf[class="hl-string">'BELNR'] == clearing_doc) & (df_bkpf[class="hl-string">'BUKRS'] == row[class="hl-string">'BUKRS'])]
            
            if not clear_header.empty:
                doc_type = clear_header.iloc[0][class="hl-string">'BLART']
                class=class="hl-string">"hl-comment"># 8. Post Partial Payment / 10. Receive Full Payment
                if doc_type in [class="hl-string">'DZ', class="hl-string">'ZP']: class=class="hl-string">"hl-comment"># Payment Types
                    class=class="hl-string">"hl-comment"># Logic: If residual items exist, it's Partial. 
                    class=class="hl-string">"hl-comment"># Check if clearing doc created new open items. Complex in basic script.
                    class=class="hl-string">"hl-comment"># Simplified: Assume Full Payment for standard clearing.
                    events.append({
                        class="hl-string">'InvoiceNumber': row[class="hl-string">'BELNR'],
                        class="hl-string">'Activity': class="hl-string">'Receive Full Payment',
                        class="hl-string">'EventTime': sap_date_to_datetime(clearing_date),
                        class="hl-string">'SourceSystem': class="hl-string">'SAP_S4',
                        class="hl-string">'DocumentType': doc_type
                    })
                class=class="hl-string">"hl-comment"># 9. Post Credit Memo
                elif doc_type == class="hl-string">'DG':
                     events.append({
                        class="hl-string">'InvoiceNumber': row[class="hl-string">'BELNR'],
                        class="hl-string">'Activity': class="hl-string">'Post Credit Memo',
                        class="hl-string">'EventTime': sap_date_to_datetime(clearing_date),
                        class="hl-string">'SourceSystem': class="hl-string">'SAP_S4'
                    })

    class=class="hl-string">"hl-comment"># Activity 12: Reconcile Bank Statement (FEBEP)
    class=class="hl-string">"hl-comment"># Check for Electronic Bank Statement items matching the Payment Doc
    class=class="hl-string">"hl-comment"># Requires knowing the Payment Doc number (AUGBL from invoice)
    fields_febep = [class="hl-string">'KUKEY', class="hl-string">'ESNUM', class="hl-string">'NBBLN']
    options_febep = [fclass="hl-string">"BUKRS = '{TARGET_BUKRS}'"] 
    df_febep = read_table(conn, class="hl-string">'FEBEP', fields_febep, options_febep)
    
    for _, row in df_invoices.iterrows():
        payment_doc = row[class="hl-string">'AUGBL']
        if payment_doc:
            match = df_febep[df_febep[class="hl-string">'NBBLN'] == payment_doc]
            if not match.empty:
                events.append({
                    class="hl-string">'InvoiceNumber': row[class="hl-string">'BELNR'],
                    class="hl-string">'Activity': class="hl-string">'Reconcile Bank Statement',
                    class="hl-string">'EventTime': sap_date_to_datetime(row[class="hl-string">'AUGDT']), class=class="hl-string">"hl-comment"># Proxy time
                    class="hl-string">'SourceSystem': class="hl-string">'SAP_S4'
                })

    class=class="hl-string">"hl-comment"># Activity 13: Reverse Invoice
    class=class="hl-string">"hl-comment"># Check if STBLG (Reversal Doc) is filled in header
    for _, row in df_invoices.iterrows():
        if row[class="hl-string">'STBLG'] and row[class="hl-string">'STBLG'] != class="hl-string">'':
             events.append({
                class="hl-string">'InvoiceNumber': row[class="hl-string">'BELNR'],
                class="hl-string">'Activity': class="hl-string">'Reverse Invoice',
                class="hl-string">'EventTime': sap_date_to_datetime(row[class="hl-string">'CPUDT']), class=class="hl-string">"hl-comment"># Using updated time
                class="hl-string">'SourceSystem': class="hl-string">'SAP_S4'
            })

    class=class="hl-string">"hl-comment"># 7. Record Promise To Pay (UDM_P2P_ATTR)
    class=class="hl-string">"hl-comment"># Similar to Dispute, requires P2P table fetch
    class=class="hl-string">"hl-comment"># Implementation logic similar to UDM_CASE_ATTR

    class=class="hl-string">"hl-comment"># === EXPORT ===
    df_events = pd.DataFrame(events)
    df_events[class="hl-string">'LastDataUpdate'] = datetime.now()
    
    print(fclass="hl-string">"Extracted {len(df_events)} events.")
    df_events.to_csv(class="hl-string">'AR_Event_Log.csv', index=False)

if __name__ == class="hl-string">'__main__':
    main()

步骤

先决条件验证：确保您已安装 Theobald Xtract Universal Designer，并配置了指向 SAP S/4HANA 源系统的有效连接。验证所用的 SAP 用户账号拥有表 BKPF、BSEG、BSAD、NAST、MHND、SCMG_T_CASE_ATTR、UDM_P2P_ATTR 和 FEBEP 的读取权限（S_TABU_DIS 或 S_TABU_NAM）。
创建新提取：打开 Xtract Universal Designer。点击 New 创建提取任务。命名为 AR_Process_Mining_EventLog。选择您的 SAP 源系统。
选择组件类型：选择 Custom SQL 组件类型。这允许我们通过执行 UNION ALL 查询，一次性从不同的 SAP 表中提取各类活动。
定义查询：复制本指南“查询”部分提供的代码。将其粘贴到 Xtract Universal Designer 的 SQL 编辑器窗口中。
配置参数：在提取任务的“Parameters”选项卡中，定义一个名为 YEAR_START（例如 '20230101'）的参数，用于过滤数据并优化性能。如果希望脚本具有动态性，请更新 SQL 脚本中的 WHERE 子句以引用此参数，或者手动替换脚本中的占位日期。
设置输出目标：配置您期望的目标端（如本地 CSV、Azure Blob、AWS S3 或 SQL Server）。将 SQL 中定义的输出列（InvoiceNumber、Activity 等）映射到目标字段。如果目标端有特定格式要求，请确保日期字段格式化为 YYYY-MM-DD，时间戳格式化为 YYYY-MM-DD HH:MM:SS。
处理大数据量：对于首次加载，建议按块运行提取（例如按会计年度）。对于每日增量提取，修改 WHERE 子句以根据相对于系统日期的 CPUDT（输入日期）或 AEDAT（更改日期）进行过滤（例如 BKPF.CPUDT >= sy-datum - 1）。
预览与验证：点击 Xtract Universal 中的 Run 或 Preview 按钮获取前 100 行数据。验证 Activity 列是否包含“创建 AR 发票”和“核销发票”等值。检查 InvoiceNumber 是否填充一致。
执行提取：执行完整提取。监控 Xtract Universal 日志以排查任何超时或内存错误。
后续处理：将生成的文件导入 ProcessMind。在导入映射期间，将 InvoiceNumber 设置为 Case ID，Activity 设置为 Activity Name，并将 EventTime 设置为 Timestamp。

配置

提取类型：Custom SQL（旧版）或 Table Join。建议优先选择 Custom SQL，以便直接在源系统中构建事件日志。
数据包大小：建议将数据包大小设置为 20,000 到 50,000 行。虽然 SAP S/4HANA 支持更大量的数据抓取，但网络稳定性往往是主要的瓶颈。
超时设置：如果提取的是大规模的历史数据，请将标准超时时间增加到 600 秒或更长。
Where 子句筛选：
- 通过 BUKRS（公司代码）进行过滤，将数据限制在相关的业务实体内。
- 通过 GJAHR（会计年度）进行过滤，以限制历史数据范围。
列类型转换：确保在目标设置中将 AmountInLocalCurrency 设置为 Decimal/Double 类型，以保留分币精度。
增量逻辑：对于增量加载，如果支持，请在 Custom SQL 逻辑中使用 SAP 服务器变量 @sy-datum，或从调用的 workflow 工具中传递动态参数。

a 查询示例 config

SELECT 
    BKPF.BELNR AS InvoiceNumber,
    'Create AR Invoice' AS Activity,
    CONCAT(BKPF.CPUDT, BKPF.CPUTM) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    BKPF.BUKRS AS CompanyCode,
    BSEG.KUNNR AS CustomerNumber,
    BSEG.DMBTR AS AmountInLocalCurrency,
    BKPF.USNAM AS "User",
    BKPF.BLART AS DocumentType,
    BSEG.ZTERM AS PaymentTerms,
    BSEG.ZFBDT AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    0 AS DaysSalesOutstanding
FROM BKPF
INNER JOIN BSEG ON BKPF.BUKRS = BSEG.BUKRS AND BKPF.BELNR = BSEG.BELNR AND BKPF.GJAHR = BSEG.GJAHR
WHERE BKPF.BLART IN ('DR', 'RV', 'RE') 
  AND BSEG.KOART = 'D' 
  AND BKPF.GJAHR >= '2023' -- [Configure based on your system]

UNION ALL

SELECT 
    LEFT(NAST.OBJKY, 10) AS InvoiceNumber,
    'Issue Invoice Output' AS Activity,
    CONCAT(NAST.DATVR, NAST.UHRVR) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    NAST.KAPPL AS CompanyCode,
    NAST.PARNR AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    NAST.USNAM AS "User",
    NAST.KSCHL AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM NAST
WHERE NAST.KAPPL = 'V3' 
  AND NAST.OBJKY IS NOT NULL
  AND NAST.DATVR >= '20230101' -- [Configure based on your system]

UNION ALL

SELECT 
    MHND.BELNR AS InvoiceNumber,
    'Send Payment Reminder' AS Activity,
    CONCAT(MHND.LAUFD, '120000') AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    MHND.BUKRS AS CompanyCode,
    MHND.KUNNR AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    NULL AS "User",
    MHND.MANSP AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM MHND
WHERE MHND.KOART = 'D'
  AND MHND.LAUFD >= '20230101' -- [Configure based on your system]

UNION ALL

SELECT 
    SCMG.EXTERNAL_KEY AS InvoiceNumber,
    'Create Dispute Case' AS Activity,
    CONCAT(SUBSTRING(SCMG.CREATE_TIME, 1, 8), SUBSTRING(SCMG.CREATE_TIME, 9, 6)) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    NULL AS CompanyCode,
    NULL AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    SCMG.CREATE_USER AS "User",
    SCMG.CASE_TYPE AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM SCMG_T_CASE_ATTR AS SCMG
WHERE SCMG.CASE_TYPE = 'F_01'

UNION ALL

SELECT 
    SCMG.EXTERNAL_KEY AS InvoiceNumber,
    'Update Dispute Status' AS Activity,
    CONCAT(SUBSTRING(SCMG.CHANGE_TIME, 1, 8), SUBSTRING(SCMG.CHANGE_TIME, 9, 6)) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    NULL AS CompanyCode,
    NULL AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    SCMG.CHANGE_USER AS "User",
    SCMG.STAT_ORDERNO AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM SCMG_T_CASE_ATTR AS SCMG
WHERE SCMG.CASE_TYPE = 'F_01' AND SCMG.CHANGE_TIME > SCMG.CREATE_TIME

UNION ALL

SELECT 
    SCMG.EXTERNAL_KEY AS InvoiceNumber,
    'Resolve Dispute Case' AS Activity,
    CONCAT(SUBSTRING(SCMG.CHANGE_TIME, 1, 8), SUBSTRING(SCMG.CHANGE_TIME, 9, 6)) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    NULL AS CompanyCode,
    NULL AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    SCMG.CHANGE_USER AS "User",
    SCMG.STAT_ORDERNO AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM SCMG_T_CASE_ATTR AS SCMG
WHERE SCMG.CASE_TYPE = 'F_01' AND SCMG.STAT_ORDERNO >= '30' -- [Adjust status code for Closed]

UNION ALL

SELECT 
    P2P.INVOICE_REF AS InvoiceNumber,
    'Record Promise To Pay' AS Activity,
    CONCAT(SUBSTRING(P2P.PROMISE_TIME, 1, 8), SUBSTRING(P2P.PROMISE_TIME, 9, 6)) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    NULL AS CompanyCode,
    P2P.CUSTOMER AS CustomerNumber,
    P2P.AMOUNT_PROMISED AS AmountInLocalCurrency,
    P2P.USER_CREATED AS "User",
    P2P.STATE AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM UDM_P2P_ATTR AS P2P

UNION ALL

SELECT 
    BKPF.BELNR AS InvoiceNumber,
    'Post Partial Payment' AS Activity,
    CONCAT(BKPF.CPUDT, BKPF.CPUTM) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    BKPF.BUKRS AS CompanyCode,
    BSEG.KUNNR AS CustomerNumber,
    BSEG.DMBTR AS AmountInLocalCurrency,
    BKPF.USNAM AS "User",
    BKPF.BLART AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM BKPF
INNER JOIN BSEG ON BKPF.BUKRS = BSEG.BUKRS AND BKPF.BELNR = BSEG.BELNR AND BKPF.GJAHR = BSEG.GJAHR
WHERE BKPF.BLART = 'DZ' AND BSEG.XREF3 IS NOT NULL -- [Assumption: XREF3 implies partial link, or customize logic]

UNION ALL

SELECT 
    BSEG.REBZG AS InvoiceNumber, -- Reference to original invoice
    'Post Credit Memo' AS Activity,
    CONCAT(BKPF.CPUDT, BKPF.CPUTM) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    BKPF.BUKRS AS CompanyCode,
    BSEG.KUNNR AS CustomerNumber,
    BSEG.DMBTR AS AmountInLocalCurrency,
    BKPF.USNAM AS "User",
    BKPF.BLART AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM BKPF
INNER JOIN BSEG ON BKPF.BUKRS = BSEG.BUKRS AND BKPF.BELNR = BSEG.BELNR AND BKPF.GJAHR = BSEG.GJAHR
WHERE BKPF.BLART = 'DG' AND BSEG.REBZG IS NOT NULL

UNION ALL

SELECT 
    BSAD.BELNR AS InvoiceNumber,
    'Receive Full Payment' AS Activity,
    CONCAT(BKPF.CPUDT, BKPF.CPUTM) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    BKPF.BUKRS AS CompanyCode,
    BSAD.KUNNR AS CustomerNumber,
    BSAD.DMBTR AS AmountInLocalCurrency,
    BKPF.USNAM AS "User",
    BKPF.BLART AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    BSAD.AUGDT AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM BKPF
INNER JOIN BSAD ON BKPF.BUKRS = BSAD.BUKRS AND BKPF.BELNR = BSAD.AUGBL AND BKPF.GJAHR = BSAD.AUGGJ
WHERE BKPF.BLART = 'DZ' -- Customer Payment

UNION ALL

SELECT 
    BSAD.BELNR AS InvoiceNumber,
    'Clear Invoice' AS Activity,
    CONCAT(BSAD.AUGDT, '235959') AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    BSAD.BUKRS AS CompanyCode,
    BSAD.KUNNR AS CustomerNumber,
    BSAD.DMBTR AS AmountInLocalCurrency,
    NULL AS "User",
    BSAD.BLART AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    BSAD.AUGDT AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM BSAD
WHERE BSAD.AUGDT >= '20230101' -- [Configure based on your system]

UNION ALL

SELECT 
    BSEG.BELNR AS InvoiceNumber,
    'Reconcile Bank Statement' AS Activity,
    CONCAT(FEB.BUDAT, '120000') AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    FEB.BUKRS AS CompanyCode,
    NULL AS CustomerNumber,
    FEB.KWERT AS AmountInLocalCurrency,
    NULL AS "User",
    'EBS' AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'True' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM FEBEP AS FEB
INNER JOIN BSEG ON FEB.BELNR = BSEG.BELNR AND FEB.BUKRS = BSEG.BUKRS
WHERE FEB.BUDAT >= '20230101' -- [Configure based on your system]

UNION ALL

SELECT 
    BKPF.BELNR AS InvoiceNumber,
    'Reverse Invoice' AS Activity,
    CONCAT(BKPF.CPUDT, BKPF.CPUTM) AS EventTime,
    'SAP_S4' AS SourceSystem,
    CURRENT_TIMESTAMP AS LastDataUpdate,
    BKPF.BUKRS AS CompanyCode,
    NULL AS CustomerNumber,
    NULL AS AmountInLocalCurrency,
    BKPF.USNAM AS "User",
    BKPF.BLART AS DocumentType,
    NULL AS PaymentTerms,
    NULL AS DueDate,
    NULL AS ClearingDate,
    'False' AS IsAutomated,
    NULL AS DaysSalesOutstanding
FROM BKPF
WHERE BKPF.STBLG IS NOT NULL AND BKPF.STBLG <> ''

您的应收账款 data 模板

您的应收账款 data 模板

应收账款属性

应收账款活动

提取指南

标准 SAP S/4HANA CDS 视图数据提取

步骤

配置

a 查询示例 sql

针对 ACDOCA 表的直接 SAP HANA SQL 查询

步骤

配置

a 查询示例 sql

使用 PyRFC 连接器的 Python 提取脚本

步骤

配置

a 查询示例 python

Theobald Xtract Universal SAP 连接器使用

步骤

配置

a 查询示例 config

准备好开始了吗？

优化 SAP S/4HANA 应收账款，提升现金流

您的应收账款 data 模板

您的应收账款 data 模板

应收账款属性

应收账款活动

提取指南

标准 SAP S/4HANA CDS 视图数据提取

步骤

配置

a 查询示例 sql

针对 ACDOCA 表的直接 SAP HANA SQL 查询

步骤

配置

a 查询示例 sql

使用 PyRFC 连接器的 Python 提取脚本

步骤

配置

a 查询示例 python

Theobald Xtract Universal SAP 连接器使用

步骤

配置

a 查询示例 config

我们重视您的隐私

准备好开始了吗？

优化 SAP S/4HANA 应收账款，提升现金流