应付账款发票处理数据模板

SAP ECC

← 返回改进指南

应付账款发票处理属性(21) 应付账款发票处理活动(13) 数据提取指南(4)

应付账款发票处理数据模板

此数据模板涵盖有效分析应付账款发票处理所需的关键信息，包括应收集的重要数据属性、应跟踪的核心流程活动，以及直接从SAP ECC系统提取数据的实用指南。使用此模板可确保收集完整的分析数据，深入了解流程情况。

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

刚接触事件日志？了解如何创建流程挖掘事件日志.

下载模板

应付账款发票处理属性

以下是建议纳入事件日志的数据字段，可用于全面分析应付账款发票处理流程。

3 必填 9 建议填写 9 选填

	名称	说明
	事件时间 EventTime	特定活动或事件发生的准确日期和时间。
说明事件时间是与流程中每项活动关联的时间戳，对于按时间顺序排列事件和开展所有基于时间的分析都至关重要。在SAP中，此信息通常存储在创建字段（如BKPF-CPUDT）或更改日志表（CDHDR-UDATE和CDHDR-UTIME）中。此属性是计算周期时间、处理时间和活动间等待时间等关键绩效指标的基础。它支持按时间分析流程表现，帮助识别瓶颈出现的时间，也可用于检查是否符合服务级别协议（SLA）或付款条件。重要性此时间戳是计算所有基于时长的指标（包括周期时间和瓶颈）的关键，也是绩效分析的基础。获取途径来自SAP表，例如BKPF（创建时间为CPUDT/CPUTM）或CDHDR（变更时间为UDATE/UTIME）。示例 2023-10-01T10:00:00Z2023-10-02T14:35:10Z2023-10-15T09:12:00Z
	发票 InvoiceNumber	每张发票凭证的唯一标识符，也是跟踪发票从接收到付款全过程的主要案例标识。
说明发票编号是一个复合键，通常由SAP中的公司代码（BUKRS）、凭证编号（BELNR）和会计年度（GJAHR）组合而成。这个唯一组合可确保每张发票在整个系统中都能被准确识别。在流程挖掘中，此属性至关重要。它将创建、过账、审批和付款等相关事件与活动关联起来，形成一个完整的流程实例。按发票分析，可以端到端查看发票生命周期，这对于计算周期时间、识别流程变体和了解返工循环都不可或缺。重要性这是关键的案例ID，可关联所有发票相关活动，从而完整分析每张发票的应付账款端到端流程。获取途径由SAP表BKPF（会计凭证抬头）中的BUKRS、BELNR和GJAHR字段构成。示例 1000-1900000001-20232000-5100000055-20231000-1900000042-2024
	活动 Activity	发票处理生命周期中发生的特定业务步骤或事件的名称。
说明此属性描述应付账款流程中的单项任务或状态变更，例如“发票已暂存”“发票已提交审批”或“发票已通过付款清账”。这些活动构成流程图的基本要素，通常从SAP中的更改日志、状态字段或工作流日志中提取。分析这些活动的顺序和持续时间是流程挖掘的核心。它有助于呈现流程顺序、识别步骤间的瓶颈、衡量返工循环的频率，并将实际流程执行情况与标准操作规程进行比较。活动定义的粒度会直接影响分析所能达到的深度。重要性活动构成流程图的基础，可用于呈现流程顺序、识别瓶颈和分析偏差。获取途径根据发票凭证的变更，从事务代码（BKPF-TCODE）、工作流日志（SWW_WI2OBJ）或更改日志（CDHDR/CDPOS表）中提取。示例发票凭证已创建发票已批准发票已通过付款清账已设置付款冻结
	付款冻结原因 PaymentBlockReason	说明发票被冻结付款原因的代码。
说明发票存在差异或正在审核时，可以设置付款冻结，防止其纳入付款批次。此属性记录冻结原因，例如数量不符或价格差异。此信息对于异常分析至关重要，有助于归类付款延迟和返工的根本原因，并支持“异常与差异分析”仪表板。了解最常见的冻结原因，有助于有针对性地改进流程，减少异常。重要性揭示付款延迟的根本原因，支持有针对性的分析，以减少异常和返工并缩短发票处理时间。获取途径来自SAP表BSEG（会计凭证段）的ZLSPR字段。示例 RIA
	付款条件 PaymentTerms	定义付款条件的代码，例如到期日和可享受的折扣。
说明付款条件是SAP中预先定义的规则，用于确定发票到期日和现金折扣的计算方式。它们可分配给供应商主数据，也可指定给单张发票。此属性是“付款合规与折扣”仪表板和“提前付款折扣获取率”KPI的重要依据。通过分析付款条件，企业可以发现获取折扣的机会，了解付款安排的财务影响，并确保合规。重要性定义付款到期日和折扣规则，对财务优化和合规监控至关重要。获取途径来自SAP表BSEG（会计凭证段）的ZTERM字段。示例 Z0010001NT30
	供应商名称 VendorName	提交发票的供应商名称。
说明此属性包含供应商的正式名称。在SAP中，供应商主数据（表LFA1）通过凭证抬头或行项目中存储的供应商编号（LIFNR）与发票凭证关联。按供应商分析对于“供应商付款绩效”仪表板至关重要。它可以跟踪特定供应商的发票处理时间、付款及时率和异常率。这些洞察有助于管理供应商关系、识别发票质量持续不佳的供应商，并协商更有利的条款。重要性支持按供应商分析绩效，帮助管理供应商关系并识别特定供应商相关问题。获取途径来自SAP表LFA1的NAME1字段，通过BKPF或BSEG中的供应商编号（LIFNR）关联。示例环球办公用品公司科技解决方案有限责任公司可靠物流公司
	公司代码 CompanyCode	代表SAP组织中某个法人实体或公司的唯一键。
说明公司代码是SAP财务管理中的基础组织单元，代表独立的会计核算单位。包括发票在内的所有财务交易都记入特定公司代码。此属性对于按法人实体划分流程分析至关重要。它支持比较企业不同部分的流程绩效、合规率和效率。对于拥有多个子公司的大型跨国企业，这一点尤为重要。重要性支持按法人实体划分流程分析，从而比较不同业务单元的绩效。获取途径来自SAP表BKPF（会计凭证抬头）的BUKRS字段。示例 10002100US01
	发票到期日 InvoiceDueDate	根据付款条件计算出的发票应付款日期。
说明发票到期日是按约定条款向供应商付款的期限。在SAP中，这通常不是单独存储的字段，而是根据凭证基准日期（BSEG-ZFBDT）和发票对应的付款条件（BSEG-ZTERM）计算得出。此日期是“付款合规与折扣”仪表板的关键数据，可用于计算逾期付款率等KPI，并识别有逾期风险的发票。根据此日期开展分析，有助于安排工作优先级并改善供应商关系。重要性这是监控付款合规、计算逾期KPI和获取提前付款折扣的关键日期。获取途径根据到期日计算基准日期（BSEG-ZFBDT）和付款条件键（BSEG-ZTERM）得出。示例 2023-10-312023-11-152024-01-10
	发票总金额 InvoiceGrossAmount	发票的含税总额，包括税费和其他费用，币种为原始凭证币种。
说明此属性表示发票的总金额，是了解待处理发票财务影响和特征的重要数据。在SAP中，具体金额所在的表取决于凭证类型，例如财务凭证金额可从BSEG中获取。分析时，可根据发票金额确定高价值发票的处理优先级、了解应付账款流程的财务处理量，并对分析进行细分。例如，可以分析高价值发票的周期时间是否更长，或是否需要经过不同的审批路径。它也是计算财务KPI的基础。重要性为流程分析提供财务背景，支持按金额分析、优先处理高价值发票以及计算财务KPI。获取途径来自SAP行项目表，例如BSEG的WRBTR字段（凭证币种金额）。可能需要将多个行项目汇总至抬头级别。示例 1500.0012550.75980.50
	处理人员用户 ProcessorUser	执行过账或更改发票等活动的员工SAP用户名。
说明此属性用于识别负责执行特定流程步骤的用户。在SAP中，这可能是创建凭证的用户（如BKPF-USNAM），也可能是进行特定更改的用户（如CDHDR-USERNAME）。按处理人员用户分析，有助于了解团队绩效和工作量分布。通过跟踪每位用户处理的发票数量和平均活动耗时，可构建“应付账款处理人员工作量分布”仪表板。这有助于发现培训需求、识别表现突出的员工，并支持公平分配任务。重要性支持工作量分析、用户间绩效比较，以及培训机会或资源分配失衡问题的识别。获取途径来自SAP表CDHDR的USERNAME字段（用于更改），或BKPF的USNAM字段（用于凭证录入）。示例 AJONESSMITHBCWILLIAMS
	审批人 Approver	负责批准发票付款的用户或角色。
说明此属性用于识别执行“发票已批准”活动的人员。在SAP中，审批通常由工作流系统管理，审批人ID会记录在工作流历史记录中。按审批人分析是“发票审批瓶颈分析”仪表板的核心。它有助于衡量个人或团队的审批时间、识别持续处理缓慢的审批人，并了解审批层级中的工作量分布。这些数据对于优化审批工作流至关重要，因为审批环节往往是主要瓶颈。重要性识别负责审批的人员，支持按个人或团队分析审批周期时间和瓶颈。获取途径通常可在SAP Business Workflow表（如SWW_WI2OBJ、SWWLOG）中找到：将工作流项目与发票对象关联，并识别审批步骤的执行用户。示例 DMARTINLCHENFINMAN_ROLE
	采购订单编号 PurchaseOrderNumber	与发票对应的采购订单标识符。
说明采购订单（PO）编号将发票与采购流程关联起来。对于基于采购订单的发票，这一关联是采购订单、收货单和发票三方匹配的关键。此属性是“采购订单/收货单匹配绩效”仪表板的重要依据。分析采购订单是否存在及其匹配情况，有助于区分不同发票类型（基于采购订单与非采购订单），并衡量匹配流程的效率。此环节的延迟是常见的流程瓶颈。重要性将发票与采购流程关联，支持分析基于采购订单与非采购订单的发票，以及三方匹配流程的效率。获取途径来自SAP表BSEG（FI发票）或RSEG（MM发票）的EBELN字段。示例 450001712345000175894500018330
	上次数据更新 LastDataUpdate	表示此记录的数据上次从源系统刷新时间的时间戳。
说明此属性标记最近一次从SAP ECC提取或更新数据的日期和时间。它不是事务数据本身的一部分，而是在数据载入过程中添加的元数据。在分析中，它主要用于说明所查看数据的新旧程度。这对仪表板和报告至关重要，可让用户了解分析数据的时效性，并帮助合理预期近期交易是否已纳入。重要性显示数据集的时效性，这对于了解流程洞察和仪表板数据是否及时至关重要。获取途径这是在数据提取、转换和加载（ETL）过程中生成并添加的元数据。示例 2024-05-21T02:00:00Z2024-05-22T02:00:00Z2024-05-23T02:00:00Z
	凭证币种 DocumentCurrency	开具发票所用的币种代码，例如USD、EUR。
说明此属性指定发票金额所用的币种，在SAP中存储于凭证抬头级别。凭证币种对于正确解读金额的财务分析至关重要。它支持按币种筛选流程分析，也是将金额换算为统一本币以进行标准化报告和汇总的前提。重要性为解读财务金额提供必要背景，并支持按币种分析或换算为标准币种。获取途径来自SAP表BKPF（会计凭证抬头）的WAERS字段。示例 USDEURGBP
	凭证类型 DocumentType	SAP中用于对会计凭证分类并控制其处理方式的代码。
说明凭证类型用于区分不同业务交易，例如供应商发票（KR）、贷项凭证（KG）或MM发票（RE）。此分类会影响编号范围以及可过账的科目类型等方面。在流程挖掘中，按凭证类型筛选可让分析对象更加一致。例如，标准供应商发票（KR）的流程可能与贷项凭证（KG）有很大差异。分别分析可避免汇总结果产生误导，并更准确地了解特定子流程。重要性支持按交易类型（如发票与贷项凭证）细分分析，从而获得更准确、更相关的流程洞察。获取途径来自SAP表BKPF（会计凭证抬头）的BLART字段。示例 KRREKG
	折扣损失 DiscountLost	计算标记：如果未享受可用的提前付款折扣，则为true。
说明此属性用于识别符合提前付款折扣条件、但付款时间晚于折扣期限的发票。系统会将付款日期与根据“付款条款”计算出的折扣到期日进行比较。这是“提前付款折扣获取率”的关键财务KPI，可揭示降低成本的机会损失。分析折扣未能获取的原因（如审批周期过长、付款被冻结），有助于论证流程改进项目的投资回报。重要性揭示错失的财务机会，直接支持“提前付款折扣获取率”KPI，并为流程改进提供明确的经济动因。获取途径计算字段：如果（付款条款提供了折扣）且（付款日期>折扣到期日），则为TRUE；否则为FALSE。示例 truefalse
	收货单编号 GoodsReceiptNumber	与基于采购订单的发票相关的收货凭证标识符。
说明对于涉及实物商品的发票，收货单（GR）凭证用于确认供应商已交付货物。此编号将发票与具体交付事件关联起来。此属性用于“采购订单/收货单匹配绩效”仪表板。从收货过账到发票过账的时间是一项关键指标。分析这一关联，有助于了解完整的三方匹配流程，并识别实物交付与财务结算之间的延迟。重要性补全采购订单、收货单和发票的三方匹配信息，支持分析货物交付与发票处理之间的延迟。获取途径来自SAP表RSEG（凭证项目，收货发票）的LFBNR字段（参考凭证编号）。示例 500000123450000015675000002100
	是否已冲销 IsReversed	用于标记发票凭证是否已冲销的布尔值。
说明此属性用于标记已取消或冲销的发票，这通常意味着发生了严重错误或流程故障。在SAP中，已冲销凭证会关联一张冲销凭证。识别已冲销发票有助于了解流程质量和失败率。它可以将这些最终异常从主流程中单独筛出，并支持专门开展根因分析，了解冲销原因及预防方法。重要性标记已取消的发票，这是流程失败的重要信号，有助于分析重大错误的根本原因。获取途径检查凭证编号（BKPF-BELNR）是否出现在其他凭证的BKPF-STBLG（冲销凭证）字段中。示例 truefalse
	是否自动处理 IsAutomated	用于标记活动由系统或批处理用户执行，而非人工用户执行。
说明此布尔属性用于区分自动执行的活动（例如由批处理作业、EDI或OCR系统执行）和用户手动执行的活动。通常根据与活动关联的用户名判断。此属性是“手动与自动处理”仪表板的基础。它有助于衡量自动化举措的成效、计算人工干预率KPI，并发现进一步减少人工操作的机会。了解人工与系统参与流程的环节，是提升效率的关键。重要性有助于衡量流程自动化程度、识别人工处理瓶颈，并跟踪自动化举措的影响。获取途径检查用户ID（如CDHDR-USERNAME）是否属于预定义的系统、批处理或服务账户列表，据此得出。示例 truefalse
	是否逾期 IsOverdue	如果发票在计划到期日之后付款，则此计算标记为真。
说明此布尔属性通过比较“发票已通过付款清账”活动日期与“发票到期日”得出。如果付款日期晚于到期日，则此标记为真。此属性直接支持“逾期付款率”KPI和“付款合规与折扣”仪表板。它便于筛选和统计逾期付款，帮助量化问题规模。分析逾期发票的特征（例如按供应商或公司代码）有助于发现根本原因。重要性直接衡量付款条款的执行情况，也是逾期付款率KPI的计算依据，有助于改善供应商关系并避免罚款。获取途径计算字段：如果（付款日期>发票到期日），则为TRUE；否则为FALSE。示例 truefalse
	源系统 SourceSystem	标识提取数据的SAP ECC源系统。
说明此属性用于指定记录系统，例如发票处理数据的来源SAP系统ID（SID）。对于拥有多个ERP实例或混合使用多种系统的组织，这一点尤为重要。在流程挖掘分析中，它有助于区分不同系统的数据，因为各系统可能采用不同配置或流程变体。这样既能比较不同系统，也能确保数据沿袭清晰，这对数据治理和验证至关重要。重要性确保数据可追溯，并支持在拥有多个SAP实例或其他源系统的环境中开展流程分析。获取途径通常是表示源ECC实例SAP系统ID（SID）的固定值，在数据提取过程中添加。示例 ECC_PROD_EUSAP_US_01E5P

必填建议填写选填

应付账款发票处理活动

以下是建议记录在事件日志中的关键流程步骤和里程碑，可用于准确发现并分析发票处理工作流。

6 建议填写 7 选填

	活动	说明
	发票凭证已创建	表示发票凭证已在SAP中创建，可以是暂存凭证，也可以是已完整过账的凭证。这通常是发票的第一个带时间戳事件，也是流程分析的起点。该事件根据BKPF表中的凭证录入日期和时间记录。
重要性此活动是发票处理流程的主要开始事件。分析从此时起的耗时，有助于衡量端到端总周期时间，并找出初始数据录入延误。获取途径此事件根据会计凭证抬头记录的创建时间戳推断。具体而言，录入日期（BKPF-CPUDT）和录入时间（BKPF-CPUTM）共同构成该时间戳。采集使用凭证抬头表BKPF中的创建时间戳（CPUDT、CPUTM）。事件类型 inferred
	发票已冲销	已通过创建冲销凭证取消已过账的发票凭证。此操作抵消原发票的财务影响。这是流程的另一种结束方式，通常意味着负面结果。
重要性冲销通常意味着发生了错误，例如数据录入有误或发票重复。跟踪冲销频率和原因，有助于发现提升数据质量和一次做对率的机会。获取途径从凭证抬头表BKPF中识别此事件。原凭证的冲销凭证编号（BKPF-STBLG）字段会有值。事件时间为冲销凭证的过账日期。采集在BKPF.STBLG中查找冲销凭证，并使用冲销凭证的过账日期作为时间戳。事件类型 explicit
	发票已批准	指定审批人已确认发票有效，可以付款。此事件可以直接来自工作流系统，也可以根据付款冻结的解除情况推断。这是付款前的重要里程碑。
重要性这是解除发票付款冻结的关键里程碑。此步骤前后的延迟反映不同类型的问题，例如审批人无法及时处理或付款批次安排不当。获取途径在工作流系统中，这是一个明确事件。否则，通常根据付款冻结的解除情况推断，并通过BSEG-ZLSPR字段的更改日志（CDHDR/CDPOS）捕获。采集从工作流系统获取事件，或从付款冻结解除的更改日志中获取。事件类型 explicit
	发票已过账	发票已正式记入总账，形成财务负债。暂存凭证会转为已过账凭证，也可以从一开始就创建为已过账凭证。这是财务会计中的基础步骤。
重要性过账是重要里程碑，意味着发票成为正式负债。它将数据录入阶段与流程中的主动付款管理阶段区分开来。获取途径从凭证抬头表BKPF中识别。已过账凭证的凭证状态（BKPF-BSTAT）为空，且过账日期（BKPF-BUDAT）有效。事件时间为过账日期。采集对于BKPF.BSTAT不为“V”（暂存），或“V”状态已更改的凭证，使用BKPF.BUDAT。事件类型 explicit
	发票已通过付款清账	发票已全额付款，未清项目已与付款凭证清账。这标志着该发票的应付账款流程成功完成。可通过清账凭证信息捕获此事件。
重要性这是成功路径的主要结束事件。到达此活动所需的时间是衡量整体流程效率的重要指标，也是计算付款及时率和折扣获取情况的关键依据。获取途径当供应商行项目中填入清账凭证编号（BSEG-AUGBL）和清账日期（BSEG-AUGDT）时，即可识别此事件。清账日期就是事件时间戳。采集当清账凭证（BSEG.AUGBL）已填入时，使用清账日期（BSEG.AUGDT）。事件类型 explicit
	已创建付款建议	发票已纳入付款批次（事务代码F110）的付款建议清单。虽然这不代表最终付款，但表明计划付款。系统根据到期日和付款条件选择发票。
重要性这是自动付款流程的第一步。付款建议生成后到最终执行付款之间的延迟，可能表明付款批次审批或安排存在问题。获取途径在REGUP等付款建议表（付款程序已处理项目）中查找发票凭证，即可识别此事件。可将批次日期（REGUP-LAUFD）用作事件时间。采集在REGUP表中查找发票，并使用付款批次日期（LAUFD）。事件类型 explicit
	付款冻结已解除	此前设置的发票付款冻结已解除，发票因此符合付款条件。这通常表示差异已解决或审批已通过。可从更改凭证表中捕获此事件。
重要性此活动表示异常已解决或审批已完成。冻结生效期间的耗时反映返工或等待时间，是流程改进的重要切入点。获取途径通过跟踪付款冻结键字段（BSEG-ZLSPR）的更改来捕获此事件。表CDHDR和CDPOS中的更改日志会记录该字段何时被清空。采集跟踪CDHDR/CDPOS中的更新记录，确认字段BSEG-ZLSPR已更改为空白。事件类型 explicit
	到期未付款	当前日期超过发票净到期日且发票尚未清账时，会触发此计算事件。它用于标记有逾期风险或已经逾期的发票。这不是直接来自系统的事件。
重要性此活动对于监控逾期付款率KPI至关重要。它能提前标记需要立即处理的发票，帮助避免逾期付款费用和供应商关系受损。获取途径这是一个计算事件。通过比较当前日期与所有未清（未清账）发票行项目的净到期日（BSEG-ZFBDT）得出。事件时间为到期日。采集比较当前日期与未清项目的BSEG.ZFBDT得出。事件类型 calculated
	发票已提交审批	发票已正式提交至审批工作流。此活动通常依赖外部工作流系统，或SAP中的特定状态变更。这通常是审批子流程的起点。
重要性此事件标记审批周期的开始。从此事件到“发票已批准”的耗时，是计算发票审批周期时间KPI和识别审批人相关瓶颈的关键依据。获取途径如果使用SAP Business Workflow，可从工作流日志（如SWWLOG）中提取此事件。否则，这属于概念性步骤，通常根据因审批原因设置付款冻结来推断。采集从工作流日志中提取，或根据特定付款冻结的设置情况推断。事件类型 explicit
	发票已暂存	表示发票已录入SAP，但尚未过账至总账。这是一个明确的操作，允许稍后补全或审批。抬头表中的凭证状态字段可用于判断发票是否已暂存。
重要性暂存表示流程有意暂停，通常是为了审核或等待缺失信息。跟踪此活动有助于找出发票正式过账前发生延误的原因。获取途径在凭证抬头表BKPF中，当凭证状态（BKPF-BSTAT）为“V”（暂存）时，即可识别该事件。事件时间为凭证创建时间（BKPF-CPUDT、BKPF-CPUTM）。采集筛选BKPF.BSTAT = 'V'的凭证。事件类型 explicit
	已设置付款冻结	发票当前处于付款冻结状态，通常是因为存在差异、等待审批或其他问题。这是明确设置在发票行项目上的状态。可从更改凭证表中捕获此事件。
重要性此活动标记异常或审批等待期的开始。分析付款冻结的频率和持续时间，有助于发现并解决流程瓶颈和争议。获取途径通过跟踪付款冻结键字段（BSEG-ZLSPR）的更改来捕获此事件。表CDHDR和CDPOS中的更改日志会记录该字段何时被填入。采集跟踪CDHDR/CDPOS中字段BSEG-ZLSPR的新增记录。事件类型 explicit
	收货单已匹配	表示已验证发票所列货物或服务确已收到，方法是将发票关联到收货单凭证。这是三方匹配的第三个组成部分，可根据发票行项目中的引用信息推断。
重要性与收货单匹配，表明公司已收到付款对应的货物或服务。跟踪此活动有助于分析采购订单、收货单与发票的匹配时间KPI，并简化验证流程。获取途径根据BSEG表中的供应商行项目推断：检查是否填写了收货单凭证编号（BSEG-LFBNR），或追溯关联采购订单的历史记录（表EKBE）。采集检查BSEG.LFBNR中的收货单引用，或通过EKBE中的采购订单历史记录进行追溯。事件类型 inferred
	采购订单已匹配	此活动表示发票行项目已成功关联到采购订单，是三方匹配流程中的关键验证步骤。可根据发票行项目明细中是否存在采购订单编号推断该活动。
重要性采购订单匹配延迟可能形成显著瓶颈。分析此活动有助于衡量匹配效率，并找出偏离标准采购订单工作流的发票。获取途径根据BSEG表中的供应商行项目推断。如果采购订单编号字段（BSEG-EBELN）有值，则视为匹配发生在凭证创建时。采集检查发票对应的BSEG.EBELN是否为非空值。事件类型 inferred

建议填写选填

数据提取指南

如何从SAP ECC获取数据

步骤

确定范围并设计方案：编写代码前，先确定与应付账款流程相关的SAP公司代码（BUKRS）和单据类型（BLART）。常见的FI发票单据类型包括“KR”（供应商发票）和“RE”（发票总额）。后续将使用这些条件筛选数据。请与业务相关方确认所需的13项活动是否都适用于该流程。
创建ABAP程序：使用事务代码SE38或SE80创建新的可执行ABAP程序，例如Z_PM_AP_EXTRACTION，并填写清晰的标题。
定义选择屏幕：在程序中设置选择屏幕，让用户指定提取参数。屏幕必须包含发票过账日期范围（P_BUDAT）、公司代码（P_BUKRS）和单据类型（P_BLART），以便灵活开展不同分析。
声明数据结构：定义与最终事件日志格式相匹配的内表结构，包含案例ID（发票编号）、活动、事件时间，以及供应商名称、公司代码等其他必要属性。
选择基础发票数据：编写核心数据选择逻辑。程序首先根据用户在选择屏幕中指定的参数，从BKPF中选择发票抬头，从BSEG中选择行项目。首次查询时将这些数据与供应商主数据表LFA1联接，即可高效获取供应商名称。
生成“现状”事件：遍历所选的基础发票数据，为每张发票生成可直接从BKPF和BSEG表确定的事件，包括发票凭证已创建、发票已暂存、发票已过账、采购订单已匹配、收货已匹配和发票已通过付款清账。将每个事件作为新行追加到最终事件日志内表中。
生成更改日志事件：要记录付款冻结等更改，请从更改凭证表CDHDR（抬头）和CDPOS（项目）中选择数据。查找BSEG表中ZLSPR（付款冻结码）字段的更改，并遍历这些更改凭证，生成付款冻结已设置和付款冻结已移除事件，时间戳使用CDHDR中的准确时间。
生成付款运行事件：查询付款建议表REGUH（抬头）和REGUP（项目），确定发票何时被纳入付款建议，并据此生成“已创建付款建议”活动。
生成计算和推断事件：为未直接记录在系统中的事件编写逻辑。对于“到期未付款”，比较发票到期日（BSEG-NETDT）与清账日期或当前日期。对于“发票已批准”，可能需要根据特定的“需要审批”付款冻结被移除这一情况进行推断。
整合并格式化数据：确保所有时间戳转换为统一格式（例如YYYY-MM-DD HH:MM:SS），并将上述步骤生成的所有事件合并到一个最终内表中。
创建输出文件：使用cl_gui_frontend_services=>gui_download方法，或将文件写入应用服务器。输出应为平面文件（例如CSV），并包含符合ProcessMind数据模型要求的标题行。文件生成后即可上传。

配置

选择参数：程序应提供选择屏幕，包含以下必填和选填字段：
- S_BUDAT：过账日期范围（必填），用于定义数据提取的时间范围。
- S_BUKRS：公司代码（必填），用于限定特定法人实体。
- S_BLART：单据类型（选填），可筛选“KR”或“RE”等特定发票类型。
日期范围建议：首次提取建议选择最近3至6个月的数据，以控制数据量并加快执行速度。完整历史数据应在后台加载。
性能注意事项：从更改日志表（CDHDR/CDPOS）中选择数据可能较慢。请尽可能使用主键和索引字段进行查询。对于大型数据集，可考虑将程序作为后台作业运行（事务SM36），避免对话进程超时。
前提条件和授权：
- 执行程序的用户需要有权访问BKPF、BSEG、LFA1、CDHDR、CDPOS、REGUH和REGUP表。
- 运行程序需要SE38事务的执行权限。
- 要记录付款冻结已设置/已移除活动，必须在系统中启用BSEG表ZLSPR字段的更改凭证日志。这属于系统配置。

查询示例 abap

*&---------------------------------------------------------------------*
*& Report Z_PM_AP_EXTRACTION
*&---------------------------------------------------------------------*
*& This program extracts Accounts Payable invoice data for process mining.
*& It creates an event log based on key business activities.
*&---------------------------------------------------------------------*
REPORT z_pm_ap_extraction.

*&---------------------------------------------------------------------*
*& Global Data Declarations
*&---------------------------------------------------------------------*
TABLES: bkpf, bseg, lfa1.

TYPES:
  BEGIN OF ty_event_log,
    invoicenumber       TYPE belnr_d,
    activity            TYPE string,
    eventtime           TYPE string,
    processoruser       TYPE uname,
    vendorname          TYPE name1_gp,
    companycode         TYPE bukrs,
    invoicegrossamount  TYPE wrbtr,
    invoiceduedate      TYPE c, "char20
    paymentterms        TYPE char256,
    purchaseordernumber TYPE ebeln,
    paymentblockreason  TYPE char256,
    approver            TYPE uname,
  END OF ty_event_log.

DATA: gt_event_log TYPE TABLE OF ty_event_log.

TYPES:
  BEGIN OF ty_invoice_data,
    bukrs TYPE bkpf-bukrs,
    belnr TYPE bkpf-belnr,
    gjahr TYPE bkpf-gjahr,
    blart TYPE bkpf-blart,
    budat TYPE bkpf-budat,
    cpudt TYPE bkpf-cpudt,
    cputm TYPE bkpf-cputm,
    usnam TYPE bkpf-usnam,
    bstat TYPE bkpf-bstat,
    stblg TYPE bkpf-stblg,
    xblnr TYPE bkpf-xblnr,
    lifnr TYPE bseg-lifnr,
    buzei TYPE bseg-buzei,
    wrbtr TYPE bseg-wrbtr,
    zterm TYPE bseg-zterm,
    zlspr TYPE bseg-zlspr,
    netdt TYPE bseg-netdt,
    ebeln TYPE bseg-ebeln,
    lfbnr TYPE bseg-lfbnr,
    augbl TYPE bseg-augbl,
    augdt TYPE bseg-augdt,
    name1 TYPE lfa1-name1,
  END OF ty_invoice_data.

DATA: gt_invoice_data TYPE TABLE OF ty_invoice_data.

*&---------------------------------------------------------------------*
*& Selection Screen
*&---------------------------------------------------------------------*
SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE TEXT-001.
  SELECT-OPTIONS: s_budat FOR bkpf-budat OBLIGATORY,  " Posting Date
                    s_bukrs FOR bkpf-bukrs OBLIGATORY,  " Company Code
                    s_blart FOR bkpf-blart.             " Document Type
SELECTION-SCREEN END OF BLOCK b1.

PARAMETERS: p_file TYPE rlgrap-filename OBLIGATORY DEFAULT 'C:\temp\ap_event_log.csv'.

*&---------------------------------------------------------------------*
*& Main Program Logic
*&---------------------------------------------------------------------*
START-OF-SELECTION.

  " 1. Select base invoice data
  SELECT
    h~bukrs, h~belnr, h~gjahr, h~blart, h~budat, h~cpudt, h~cputm, h~usnam,
    h~bstat, h~stblg, h~xblnr, i~lifnr, i~buzei, i~wrbtr, i~zterm, i~zlspr,
    i~netdt, i~ebeln, i~lfbnr, i~augbl, i~augdt, v~name1
    INTO TABLE @gt_invoice_data
    FROM bkpf AS h
    INNER JOIN bseg AS i ON  h~bukrs = i~bukrs
                         AND h~belnr = i~belnr
                         AND h~gjahr = i~gjahr
    INNER JOIN lfa1 AS v ON i~lifnr = v~lifnr
    WHERE h~budat IN @s_budat
      AND h~bukrs IN @s_bukrs
      AND h~blart IN @s_blart
      AND i~koart = 'K'. " Vendor line items only

  CHECK gt_invoice_data IS NOT INITIAL.

  " 2. Process each invoice to generate events
  LOOP AT gt_invoice_data ASSIGNING FIELD-SYMBOL(<fs_invoice>).
    " Generate events for each invoice document/line item
    PERFORM generate_events USING <fs_invoice>.
  ENDLOOP.

  " 3. Generate events from change documents (payment blocks)
  PERFORM generate_change_log_events.

  " 4. Generate events from payment proposal run
  PERFORM generate_payment_proposal_events.

  " 5. Download the final event log
  PERFORM download_event_log.


*&---------------------------------------------------------------------*
*&      Form  GENERATE_EVENTS
*&---------------------------------------------------------------------*
FORM generate_events USING is_invoice TYPE ty_invoice_data.
  DATA: ls_event_log TYPE ty_event_log,
        lv_timestamp TYPE string.

  " Common attributes for all events of this invoice
  ls_event_log-invoicenumber      = is_invoice-belnr.
  ls_event_log-companycode        = is_invoice-bukrs.
  ls_event_log-vendorname         = is_invoice-name1.
  ls_event_log-invoicegrossamount = is_invoice-wrbtr.
  ls_event_log-paymentterms       = is_invoice-zterm.
  ls_event_log-purchaseordernumber= is_invoice-ebeln.

  " Format Due Date
  WRITE is_invoice-netdt TO ls_event_log-invoiceduedate DD/MM/YYYY.

  " Activity: Invoice Document Created
  CONCATENATE is_invoice-cpudt is_invoice-cputm INTO lv_timestamp.
  ls_event_log-activity     = 'Invoice Document Created'.
  ls_event_log-eventtime    = lv_timestamp.
  ls_event_log-processoruser= is_invoice-usnam.
  APPEND ls_event_log TO gt_event_log.

  " Activity: Invoice Parked
  IF is_invoice-bstat = 'V'.
    ls_event_log-activity     = 'Invoice Parked'.
    ls_event_log-eventtime    = lv_timestamp. " Parked at time of creation
    ls_event_log-processoruser= is_invoice-usnam.
    APPEND ls_event_log TO gt_event_log.
  ENDIF.

  " Activity: Invoice Posted
  IF is_invoice-bstat = space.
    CONCATENATE is_invoice-budat '000000' INTO lv_timestamp.
    ls_event_log-activity     = 'Invoice Posted'.
    ls_event_log-eventtime    = lv_timestamp.
    ls_event_log-processoruser= is_invoice-usnam.
    APPEND ls_event_log TO gt_event_log.
  ENDIF.

  " Activity: Purchase Order Matched
  IF is_invoice-ebeln IS NOT INITIAL.
    CONCATENATE is_invoice-cpudt is_invoice-cputm INTO lv_timestamp.
    ls_event_log-activity     = 'Purchase Order Matched'.
    ls_event_log-eventtime    = lv_timestamp.
    ls_event_log-processoruser= is_invoice-usnam.
    APPEND ls_event_log TO gt_event_log.
  ENDIF.

  " Activity: Goods Receipt Matched
  IF is_invoice-lfbnr IS NOT INITIAL.
    CONCATENATE is_invoice-cpudt is_invoice-cputm INTO lv_timestamp.
    ls_event_log-activity     = 'Goods Receipt Matched'.
    ls_event_log-eventtime    = lv_timestamp.
    ls_event_log-processoruser= is_invoice-usnam.
    APPEND ls_event_log TO gt_event_log.
  ENDIF.

  " Activity: Invoice Cleared By Payment
  IF is_invoice-augbl IS NOT INITIAL.
    CONCATENATE is_invoice-augdt '000000' INTO lv_timestamp.
    ls_event_log-activity     = 'Invoice Cleared By Payment'.
    ls_event_log-eventtime    = lv_timestamp.
    " Processor user for clearing is not in this structure, would require another SELECT
    ls_event_log-processoruser = ''.
    APPEND ls_event_log TO gt_event_log.
  ENDIF.

  " Activity: Invoice Reversed
  IF is_invoice-stblg IS NOT INITIAL.
    SELECT SINGLE budat INTO @DATA(lv_rev_date) FROM bkpf
      WHERE belnr = @is_invoice-stblg AND gjahr = @is_invoice-gjahr.
    IF sy-subrc = 0.
      CONCATENATE lv_rev_date '000000' INTO lv_timestamp.
      ls_event_log-activity     = 'Invoice Reversed'.
      ls_event_log-eventtime    = lv_timestamp.
      ls_event_log-processoruser= sy-uname.
      APPEND ls_event_log TO gt_event_log.
    ENDIF.
  ENDIF.

  " Activity: Due Date Passed Without Payment
  IF is_invoice-netdt < sy-datum AND is_invoice-augbl IS INITIAL.
    CONCATENATE is_invoice-netdt '000000' INTO lv_timestamp.
    ls_event_log-activity      = 'Due Date Passed Without Payment'.
    ls_event_log-eventtime     = lv_timestamp.
    ls_event_log-processoruser = 'SYSTEM'.
    APPEND ls_event_log TO gt_event_log.
  ENDIF.

ENDFORM.

*&---------------------------------------------------------------------*
*&      Form  GENERATE_CHANGE_LOG_EVENTS
*&---------------------------------------------------------------------*
FORM generate_change_log_events.
  TYPES: BEGIN OF ty_cdpos,
           objectid TYPE cdpos-objectid,
           changenr TYPE cdpos-changenr,
           fname    TYPE cdpos-fname,
           value_new TYPE cdpos-value_new,
           value_old TYPE cdpos-value_old,
         END OF ty_cdpos.

  DATA: lt_cdpos TYPE TABLE OF ty_cdpos,
        lt_cdhdr TYPE TABLE OF cdhdr.

  DATA: ls_event_log TYPE ty_event_log.

  DATA(lt_invoice_range) = VALUE range_belnr_d( FOR wa IN gt_invoice_data ( sign = 'I' option = 'EQ' low = wa-belnr ) ).
  CHECK lt_invoice_range IS NOT INITIAL.

  SELECT objectclas, objectid, changenr, username, udate, utime
    FROM cdhdr
    INTO TABLE @lt_cdhdr
    FOR ALL ENTRIES IN @gt_invoice_data
    WHERE objectclas = 'BELEG'
      AND objectid   = @gt_invoice_data-objectid.
  CHECK sy-subrc = 0.

  SELECT objectid, changenr, fname, value_new, value_old
    FROM cdpos
    INTO TABLE @lt_cdpos
    FOR ALL ENTRIES IN @lt_cdhdr
    WHERE changenr = @lt_cdhdr-changenr
      AND objectid = @lt_cdhdr-objectid
      AND tabname  = 'BSEG'
      AND fname    = 'ZLSPR'.
  CHECK sy-subrc = 0.

  LOOP AT lt_cdpos ASSIGNING FIELD-SYMBOL(<fs_cdpos>).
    READ TABLE lt_cdhdr ASSIGNING FIELD-SYMBOL(<fs_cdhdr>) WITH KEY changenr = <fs_cdpos>-changenr.
    IF sy-subrc <> 0. CONTINUE. ENDIF.

    " Find corresponding invoice data
    DATA(lv_belnr) = <fs_cdhdr>-objectid+10(10).
    READ TABLE gt_invoice_data ASSIGNING FIELD-SYMBOL(<fs_invoice>) WITH KEY belnr = lv_belnr.
    IF sy-subrc <> 0. CONTINUE. ENDIF.

    " Populate common event data
    ls_event_log-invoicenumber       = <fs_invoice>-belnr.
    ls_event_log-companycode         = <fs_invoice>-bukrs.
    ls_event_log-vendorname          = <fs_invoice>-name1.
    ls_event_log-invoicegrossamount  = <fs_invoice>-wrbtr.
    ls_event_log-purchaseordernumber = <fs_invoice>-ebeln.
    ls_event_log-processoruser       = <fs_cdhdr>-username.

    CONCATENATE <fs_cdhdr>-udate <fs_cdhdr>-utime INTO ls_event_log-eventtime.

    " Activity: Payment Block Set
    IF <fs_cdpos>-value_new IS NOT INITIAL.
      ls_event_log-activity           = 'Payment Block Set'.
      ls_event_log-paymentblockreason = <fs_cdpos>-value_new.
      APPEND ls_event_log TO gt_event_log.
    ENDIF.

    " Activity: Payment Block Removed
    IF <fs_cdpos>-value_new IS INITIAL AND <fs_cdpos>-value_old IS NOT INITIAL.
      ls_event_log-activity           = 'Payment Block Removed'.
      ls_event_log-paymentblockreason = <fs_cdpos>-value_old.
      APPEND ls_event_log TO gt_event_log.

      " INFERRED Activity: Invoice Approved
      " Assumption: Removing a specific block (e.g., 'A' for Approval) means approval.
      IF <fs_cdpos>-value_old = '[Your Approval Block Reason]'. " E.g., 'A'
        ls_event_log-activity           = 'Invoice Approved'.
        ls_event_log-approver           = <fs_cdhdr>-username.
        APPEND ls_event_log TO gt_event_log.
      ENDIF.
    ENDIF.

    " INFERRED Activity: Invoice Routed For Approval
    " Assumption: Setting a specific block (e.g., 'A' for Approval) means routed for approval.
    IF <fs_cdpos>-value_new = '[Your Approval Block Reason]'. " E.g., 'A'
      ls_event_log-activity           = 'Invoice Routed For Approval'.
      ls_event_log-approver           = ''.
      APPEND ls_event_log TO gt_event_log.
    ENDIF.

  ENDLOOP.
ENDFORM.

*&---------------------------------------------------------------------*
*&      Form  GENERATE_PAYMENT_PROPOSAL_EVENTS
*&---------------------------------------------------------------------*
FORM generate_payment_proposal_events.
  DATA: lt_regup TYPE TABLE OF regup,
        ls_reguh TYPE reguh.
  DATA: ls_event_log TYPE ty_event_log.

  SELECT * FROM regup INTO TABLE @lt_regup
    FOR ALL ENTRIES IN @gt_invoice_data
    WHERE bukrs = @gt_invoice_data-bukrs
      AND belnr = @gt_invoice_data-belnr
      AND gjahr = @gt_invoice_data-gjahr.
  CHECK sy-subrc = 0.

  LOOP AT lt_regup ASSIGNING FIELD-SYMBOL(<fs_regup>).
    READ TABLE gt_invoice_data ASSIGNING FIELD-SYMBOL(<fs_invoice>) WITH KEY belnr = <fs_regup>-belnr.
    IF sy-subrc <> 0. CONTINUE. ENDIF.

    SELECT SINGLE * FROM reguh INTO @ls_reguh
      WHERE rundat = @<fs_regup>-rundat AND runid = @<fs_regup>-runid.
    IF sy-subrc <> 0. CONTINUE. ENDIF.

    ls_event_log-invoicenumber      = <fs_invoice>-belnr.
    ls_event_log-companycode        = <fs_invoice>-bukrs.
    ls_event_log-vendorname         = <fs_invoice>-name1.
    ls_event_log-invoicegrossamount = <fs_invoice>-wrbtr.
    ls_event_log-processoruser      = ls_reguh-usnam.
    ls_event_log-activity           = 'Payment Proposal Created'.

    CONCATENATE ls_reguh-rundat '000000' INTO ls_event_log-eventtime.
    APPEND ls_event_log TO gt_event_log.
  ENDLOOP.
ENDFORM.

*&---------------------------------------------------------------------*
*&      Form  DOWNLOAD_EVENT_LOG
*&---------------------------------------------------------------------*
FORM download_event_log.
  DATA: lt_final_output TYPE TABLE OF string,
        l_header        TYPE string.

  SORT gt_event_log BY invoicenumber eventtime.

  " Create Header
  l_header = `"InvoiceNumber","Activity","EventTime","ProcessorUser","VendorName","CompanyCode","InvoiceGrossAmount","InvoiceDueDate","PaymentTerms","PurchaseOrderNumber","PaymentBlockReason","Approver"`.
  APPEND l_header TO lt_final_output.

  " Create Data Rows
  LOOP AT gt_event_log ASSIGNING FIELD-SYMBOL(<fs_log>).
    DATA(l_line) = |"{ <fs_log>-invoicenumber }","{
                     <fs_log>-activity }","{
                     <fs_log>-eventtime }","{
                     <fs_log>-processoruser }","{
                     <fs_log>-vendorname }","{
                     <fs_log>-companycode }","{
                     <fs_log>-invoicegrossamount }","{
                     <fs_log>-invoiceduedate }","{
                     <fs_log>-paymentterms }","{
                     <fs_log>-purchaseordernumber }","{
                     <fs_log>-paymentblockreason }","{
                     <fs_log>-approver }"|.
    APPEND l_line TO lt_final_output.
  ENDLOOP.

  " Download file to presentation server
  cl_gui_frontend_services=>gui_download(
    EXPORTING
      filename = p_file
      filetype = 'ASC'
    CHANGING
      data_tab = lt_final_output
    EXCEPTIONS
      OTHERS   = 4 ).

  IF sy-subrc <> 0.
    MESSAGE 'File download failed.' TYPE 'E'.
  ELSE.
    MESSAGE |File '{ p_file }' downloaded successfully.| TYPE 'I'.
  ENDIF.
ENDFORM.

步骤

前提条件和访问权限：确保数据库用户拥有所需SAP表（如BKPF、BSEG、LFA1、CDHDR、CDPOS、REGUH、REGUP）的读取权限。此方法需要直接访问数据库，可能需要获得IT安全团队和SAP Basis团队的批准。
确认系统详情：确认SAP ECC系统使用的数据库类型（如SAP HANA、Oracle、MS SQL Server）。提供的SQL查询采用SAP HANA常见语法，其他数据库可能需要少量调整，尤其是创建时间戳的部分。
自定义查询：在数据库客户端（如DBeaver、SAP HANA Studio或SQL Server Management Studio）中打开提供的SQL查询。修改BaseInvoices CTE顶部的占位值：
- “{StartDate}”：设置提取周期的起始日期（例如“2023-01-01”）。
- “{EndDate}”：设置提取周期的结束日期（例如“2023-06-30”）。
- “{CompanyCodes}”：替换为要分析的公司代码列表，多个代码以逗号分隔（例如“1000”、“2000”）。
- “{DocTypes}”：确认系统中供应商发票的单据类型。“KR”和“RE”是常见的默认值。
执行查询：在SAP数据库中运行自定义SQL查询。执行时间取决于日期范围、公司代码数量和系统总体规模。
检查查询结果：查询完成后，检查输出的前几百行。确认所有列（InvoiceNumber、Activity、EventTime等）均已生成且数据符合预期。
处理潜在错误：如果遇到语法错误，请调整日期/时间函数以适配具体数据库。例如，TO_TIMESTAMP（HANA/Oracle）可能需要替换为CAST或CONVERT函数（SQL Server）。
导出数据：通过SQL客户端将完整结果集导出为CSV（逗号分隔值）文件。请将文件编码设为UTF-8，避免特殊字符显示异常。
准备上传：CSV文件中的列名必须与查询别名完全一致（InvoiceNumber、Activity、EventTime、ProcessorUser等），以确保上传时能够顺利映射。
上传到流程挖掘工具：将最终CSV文件上传到流程挖掘应用程序。将InvoiceNumber列映射到“案例ID”，Activity映射到“活动”，EventTime映射到“时间戳”，即可开始分析。

配置

数据库连接：需要直接只读连接SAP ECC底层数据库。您需要准备服务器地址、数据库名称、端口、用户名和密码。
日期范围：建议先选择较短的日期范围（例如3至6个月），以确保性能并在大规模提取前验证结果。日期筛选条件应用于凭证创建日期（BKPF.CPUDT）。
公司代码：查询必须按一个或多个CompanyCode（BUKRS）值筛选。不建议在大型系统中一次提取所有公司代码的数据。
单据类型：提取数据时会按发票单据类型（BLART）筛选。供应商发票常用类型为KR（供应商发票）和RE（发票收据）。请与财务团队确认贵组织适用的类型。
表授权：数据库用户需要拥有以下表的SELECT权限：BKPF、BSEG、LFA1、CDHDR、CDPOS、REGUH、REGUP。
时间戳转换：查询使用TO_TIMESTAMP(CONCAT(date, time), 'YYYYMMDDHH24MISS')。此语法兼容SAP HANA和Oracle。对于SQL Server，可使用CAST(CONCAT(date, ' ', time) AS DATETIME2)。请根据目标数据库进行调整。

查询示例 sql

WITH BaseInvoices AS (
  SELECT
    BKPF.MANDT,
    BKPF.BUKRS,
    BKPF.BELNR,
    BKPF.GJAHR,
    CONCAT(CONCAT(CONCAT(BKPF.BUKRS, '-'), BKPF.BELNR), BKPF.GJAHR) AS InvoiceNumber,
    BKPF.CPUDT AS CreationDate,
    BKPF.CPUTM AS CreationTime,
    BKPF.USNAM AS CreatorUser,
    BKPF.BSTAT AS DocStatus,
    BKPF.STBLG AS ReversalDoc,
    BKPF.STGRD AS ReversalDate
  FROM BKPF
  WHERE
    BKPF.BUKRS IN ('{CompanyCodes}') -- E.g., '1000', '2000'
    AND BKPF.BLART IN ('{DocTypes}') -- E.g., 'KR', 'RE'
    AND BKPF.CPUDT BETWEEN '{StartDate}' AND '{EndDate}' -- E.g., '20230101' AND '20231231'
),
InvoiceVendorLines AS (
  SELECT
    BSEG.MANDT, BSEG.BUKRS, BSEG.BELNR, BSEG.GJAHR,
    MAX(BSEG.LIFNR) AS VendorNumber,
    MAX(BSEG.ZFBDT) AS DueDate,
    MAX(BSEG.ZTERM) AS PaymentTerms,
    MAX(BSEG.ZLSPR) AS PaymentBlockReason,
    SUM(CASE WHEN BSEG.SHKZG = 'S' THEN BSEG.WRBTR ELSE -BSEG.WRBTR END) AS InvoiceGrossAmount,
    MAX(BSEG.EBELN) AS PurchaseOrderNumber,
    MAX(BSEG.AUGDT) AS ClearingDate,
    MAX(AUGBL) AS ClearingDoc
  FROM BSEG
  INNER JOIN BaseInvoices ON BSEG.MANDT = BaseInvoices.MANDT
    AND BSEG.BUKRS = BaseInvoices.BUKRS
    AND BSEG.BELNR = BaseInvoices.BELNR
    AND BSEG.GJAHR = BaseInvoices.GJAHR
  WHERE BSEG.KOART = 'K' -- Filter for Vendor line items
  GROUP BY BSEG.MANDT, BSEG.BUKRS, BSEG.BELNR, BSEG.GJAHR
)
-- 1. Invoice Document Created
SELECT
  bi.InvoiceNumber AS "InvoiceNumber",
  'Invoice Document Created' AS "Activity",
  TO_TIMESTAMP(CONCAT(bi.CreationDate, bi.CreationTime), 'YYYYMMDDHH24MISS') AS "EventTime",
  bi.CreatorUser AS "ProcessorUser",
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  ivl.PaymentBlockReason AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR

UNION ALL

-- 2. Invoice Parked
SELECT
  bi.InvoiceNumber,
  'Invoice Parked' AS "Activity",
  TO_TIMESTAMP(CONCAT(bi.CreationDate, bi.CreationTime), 'YYYYMMDDHH24MISS') AS "EventTime",
  bi.CreatorUser AS "ProcessorUser",
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  ivl.PaymentBlockReason AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
WHERE bi.DocStatus = 'V'

UNION ALL

-- 3. Purchase Order Matched & 4. Goods Receipt Matched (Inferred at creation)
SELECT
  bi.InvoiceNumber,
  CASE WHEN ivl.PurchaseOrderNumber IS NOT NULL THEN 'Purchase Order Matched' ELSE 'Goods Receipt Matched' END AS "Activity",
  TO_TIMESTAMP(CONCAT(bi.CreationDate, bi.CreationTime), 'YYYYMMDDHH24MISS') AS "EventTime",
  bi.CreatorUser AS "ProcessorUser",
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  ivl.PaymentBlockReason AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
WHERE ivl.PurchaseOrderNumber IS NOT NULL -- Simplified logic: If PO exists, we assume match for both.

UNION ALL

-- 5. Payment Block Set & 6. Invoice Routed For Approval (Proxy) & 8. Payment Block Removed
SELECT
  bi.InvoiceNumber,
  CASE 
    WHEN pos.VALUE_OLD = ' ' AND pos.VALUE_NEW != ' ' AND pos.VALUE_NEW = 'A' THEN 'Invoice Routed For Approval'
    WHEN pos.VALUE_OLD = ' ' AND pos.VALUE_NEW != ' ' THEN 'Payment Block Set'
    ELSE 'Payment Block Removed' 
  END AS "Activity",
  TO_TIMESTAMP(CONCAT(hdr.UDATE, hdr.UTIME), 'YYYYMMDDHH24MISS') AS "EventTime",
  hdr.USERNAME AS "ProcessorUser",
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  pos.VALUE_NEW AS "PaymentBlockReason",
  NULL AS "Approver"
FROM CDHDR hdr
JOIN CDPOS pos ON hdr.MANDANT = pos.MANDANT AND hdr.OBJECTCLAS = pos.OBJECTCLAS AND hdr.OBJECTID = pos.OBJECTID AND hdr.CHANGENR = pos.CHANGENR
JOIN BaseInvoices bi ON hdr.MANDANT = bi.MANDT AND hdr.OBJECTID = CONCAT(bi.BUKRS, bi.BELNR, bi.GJAHR)
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
WHERE hdr.OBJECTCLAS = 'BELEG' AND pos.TABNAME = 'BSEG' AND pos.FNAME = 'ZLSPR' AND pos.VALUE_NEW != pos.VALUE_OLD

UNION ALL

-- 7. Invoice Approved (Proxy by removal of 'A' block)
SELECT
  bi.InvoiceNumber,
  'Invoice Approved' AS "Activity",
  TO_TIMESTAMP(CONCAT(hdr.UDATE, hdr.UTIME), 'YYYYMMDDHH24MISS') AS "EventTime",
  hdr.USERNAME AS "ProcessorUser", -- This user is the approver
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  pos.VALUE_NEW AS "PaymentBlockReason",
  hdr.USERNAME AS "Approver"
FROM CDHDR hdr
JOIN CDPOS pos ON hdr.MANDANT = pos.MANDANT AND hdr.OBJECTCLAS = pos.OBJECTCLAS AND hdr.OBJECTID = pos.OBJECTID AND hdr.CHANGENR = pos.CHANGENR
JOIN BaseInvoices bi ON hdr.MANDANT = bi.MANDT AND hdr.OBJECTID = CONCAT(bi.BUKRS, bi.BELNR, bi.GJAHR)
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
WHERE hdr.OBJECTCLAS = 'BELEG' AND pos.TABNAME = 'BSEG' AND pos.FNAME = 'ZLSPR' AND pos.VALUE_OLD = 'A' AND pos.VALUE_NEW = ' '

UNION ALL

-- 9. Invoice Posted
SELECT
  bi.InvoiceNumber,
  'Invoice Posted' AS "Activity",
  CASE -- If posted from parked, use change date. If posted directly, use creation date.
    WHEN chg.EventTime IS NOT NULL THEN chg.EventTime
    ELSE TO_TIMESTAMP(CONCAT(bi.CreationDate, bi.CreationTime), 'YYYYMMDDHH24MISS')
  END AS "EventTime",
  CASE
    WHEN chg.USERNAME IS NOT NULL THEN chg.USERNAME
    ELSE bi.CreatorUser
  END AS "ProcessorUser",
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  ivl.PaymentBlockReason AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
LEFT JOIN (
    SELECT hdr.MANDANT, hdr.OBJECTID, hdr.USERNAME, TO_TIMESTAMP(CONCAT(hdr.UDATE, hdr.UTIME), 'YYYYMMDDHH24MISS') AS EventTime
    FROM CDHDR hdr JOIN CDPOS pos ON hdr.CHANGENR = pos.CHANGENR AND hdr.OBJECTID = pos.OBJECTID
    WHERE hdr.OBJECTCLAS = 'BELEG' AND pos.TABNAME = 'BKPF' AND pos.FNAME = 'BSTAT' AND pos.VALUE_OLD = 'V' AND pos.VALUE_NEW = ' '
) chg ON bi.MANDT = chg.MANDANT AND CONCAT(bi.BUKRS, bi.BELNR, bi.GJAHR) = chg.OBJECTID
WHERE bi.DocStatus != 'V' -- Only include documents that are currently posted

UNION ALL

-- 10. Due Date Passed Without Payment
SELECT
  bi.InvoiceNumber,
  'Due Date Passed Without Payment' AS "Activity",
  TO_TIMESTAMP(ivl.DueDate, 'YYYYMMDD') AS "EventTime",
  'System' AS "ProcessorUser",
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  ivl.PaymentBlockReason AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
WHERE ivl.ClearingDoc IS NULL AND ivl.DueDate < CURRENT_DATE

UNION ALL

-- 11. Payment Proposal Created
SELECT DISTINCT
  bi.InvoiceNumber,
  'Payment Proposal Created' AS "Activity",
  TO_TIMESTAMP(CONCAT(reguh.LAUFD, '000000'), 'YYYYMMDDHH24MISS') AS "EventTime", -- Time is not available in REGUH
  reguh.USNAM AS "ProcessorUser",
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  ivl.PaymentBlockReason AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
JOIN REGUP ON ivl.MANDT = REGUP.MANDT AND ivl.BUKRS = REGUP.BUKRS AND ivl.BELNR = REGUP.BELNR AND ivl.GJAHR = REGUP.GJAHR
JOIN REGUH ON REGUP.MANDT = REGUH.MANDT AND REGUP.LAUFD = REGUH.LAUFD AND REGUP.LAUFI = REGUH.LAUFI AND REGUP.XVORL = REGUH.XVORL AND REGUP.ZBUKR = REGUH.ZBUKR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR

UNION ALL

-- 12. Invoice Cleared By Payment
SELECT
  bi.InvoiceNumber,
  'Invoice Cleared By Payment' AS "Activity",
  TO_TIMESTAMP(ivl.ClearingDate, 'YYYYMMDD') AS "EventTime",
  NULL AS "ProcessorUser", -- Clearing user is not on the vendor line
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  ivl.PaymentBlockReason AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
WHERE ivl.ClearingDoc IS NOT NULL

UNION ALL

-- 13. Invoice Reversed
SELECT
  bi.InvoiceNumber,
  'Invoice Reversed' AS "Activity",
  TO_TIMESTAMP(bi.ReversalDate, 'YYYYMMDD') AS "EventTime",
  NULL AS "ProcessorUser", -- Reversal user not in BKPF, would require another join
  vend.Name1 AS "VendorName",
  bi.BUKRS AS "CompanyCode",
  ivl.InvoiceGrossAmount AS "InvoiceGrossAmount",
  ivl.DueDate AS "InvoiceDueDate",
  ivl.PaymentTerms AS "PaymentTerms",
  ivl.PurchaseOrderNumber AS "PurchaseOrderNumber",
  NULL AS "PaymentBlockReason",
  NULL AS "Approver"
FROM BaseInvoices bi
JOIN InvoiceVendorLines ivl ON bi.MANDT = ivl.MANDT AND bi.BUKRS = ivl.BUKRS AND bi.BELNR = ivl.BELNR AND bi.GJAHR = ivl.GJAHR
LEFT JOIN LFA1 vend ON ivl.MANDT = vend.MANDT AND ivl.VendorNumber = vend.LIFNR
WHERE bi.ReversalDoc IS NOT NULL;

步骤

安装前提条件：确保Python环境已安装所需库，包括用于数据处理的pandas和用于SAP RFC通信的pyrfc。此外，您需要从SAP支持门户下载SAP NetWeaver RFC SDK，并确保系统路径中可以访问其lib目录。
设置SAP连接：在Python脚本中配置SAP连接字典，填写系统的具体信息：应用服务器主机（ashost）、系统编号（sysnr）、客户端（client）、用户（user）和密码（passwd）。请确保指定的SAP用户拥有所需权限，主要包括访问所需表时使用RFC_READ_TABLE所需的S_RFC和S_TABU_DIS权限。
定义提取参数：在脚本顶部设置数据提取的关键参数，包括date_range（发票录入的起止日期）和company_codes列表，以限定相关业务单元。
从SAP表提取数据：运行Python脚本。脚本将通过RFC协议连接SAP系统，并多次调用RFC_READ_TABLE函数，从核心应付账款表中提取原始数据，包括BKPF（抬头）、BSEG（行项目）、RSEG（发票收据详情）、LFA1（供应商主数据）、CDHDR/CDPOS（冻结更改日志）和BSAK（已清账项目）。
在内存中联接数据：脚本使用pandas库联接提取的数据框，将发票抬头与行项目关联，补充供应商名称，并关联相应的更改凭证记录，从而为每张发票生成完整的扁平数据集。
转换为事件日志：这是脚本的核心逻辑。脚本遍历联接后的数据，为所需的13项业务活动分别创建记录。对于每项活动（例如“发票已暂存”“付款冻结已设置”），脚本会设置正确的活动名称，并根据SAP数据中的相关日期和时间字段确定准确的时间戳。
处理计算事件：脚本会计算SAP中未直接记录的事件。例如，对于所有尚未清账的发票，脚本会比较发票到期日（ZFBDT）与当前日期，生成“到期未付款”事件。
填充属性：为每条事件记录填充一组统一属性，包括InvoiceNumber、Activity和EventTime等必需字段，以及VendorName、InvoiceGrossAmount和CompanyCode等建议属性，为流程分析提供充分背景信息。
最终整合：脚本将各个事件数据框汇总为一个最终事件日志数据框，并确保所有记录的列名和数据类型一致。
导出为CSV：最后，将整合后的事件日志数据框保存为CSV文件。该文件可直接上传到ProcessMind等流程挖掘工具。脚本会在运行目录中生成名为sap_ap_event_log.csv的文件。

配置

SAP连接参数：脚本需要包含连接详情的字典：ashost（主机名或IP地址）、sysnr（系统编号）、client（例如“100”）、user（SAP用户名）和passwd（SAP密码）。
日期范围：使用“YYYYMMDD”格式定义start_date和end_date。此筛选条件应用于发票录入日期（BKPF-CPUDT），以限定提取范围。首次分析建议选择3至6个月的数据，在数据量和洞察价值之间取得平衡。
公司代码（BUKRS）：指定要纳入提取范围的SAP公司代码列表。此筛选条件至关重要，可确保分析正确的组织实体（例如['1000', '2000']）。
单据类型（BLART）：虽然脚本中未将其设为显式参数，但您可以轻松地在针对BKPF的RFC_READ_TABLE调用中添加单据类型筛选条件（例如“KR”表示供应商发票，“RE”表示发票收据），进一步限定数据集。
性能和分块处理：脚本会根据筛选条件读取完整表。对于包含数百万张发票的大型数据集，RFC_READ_TABLE可能超时或占用过多内存。如果遇到性能问题，可按月遍历日期范围，分块提取数据。
SAP授权：SAP用户必须拥有RFC执行权限，并获准查看以下表中的数据：BKPF、BSEG、RSEG、LFA1、CDHDR、CDPOS、BSAK、BSIK、REGUH、REGUP。通常通过授权对象S_TABU_DIS授予此权限。

查询示例 python

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

class=class="hl-string">"hl-comment"># --- 1. SETTINGS & PARAMETERS ---

class=class="hl-string">"hl-comment"># SAP Connection Details (replace with your system's details)
sap_conn_params = {
    class="hl-string">"user": class="hl-string">"[SAP_USER]",
    class="hl-string">"passwd": class="hl-string">"[SAP_PASSWORD]",
    class="hl-string">"ashost": class="hl-string">"[SAP_HOST]",
    class="hl-string">"sysnr": class="hl-string">"[SYSTEM_NUMBER]",
    class="hl-string">"client": class="hl-string">"[CLIENT]"
}

class=class="hl-string">"hl-comment"># Extraction Parameters
company_codes = [class="hl-string">'[YOUR_COMPANY_CODE_1]', class="hl-string">'[YOUR_COMPANY_CODE_2]']
date_range = {
    class="hl-string">"start_date": class="hl-string">"20230101", class=class="hl-string">"hl-comment"># YYYYMMDD
    class="hl-string">"end_date": class="hl-string">"20231231"    class=class="hl-string">"hl-comment"># YYYYMMDD
}

class=class="hl-string">"hl-comment"># --- 2. HELPER FUNCTION TO READ SAP TABLE ---
def read_sap_table(conn, table_name, fields=[], options=[], row_count=0):
    class="hl-string">"""Reads an SAP table using RFC_READ_TABLE and returns a pandas DataFrame."""
    try:
        result = conn.call(class="hl-string">'RFC_READ_TABLE',
                             QUERY_TABLE=table_name,
                             DELIMITER=class="hl-string">'|',
                             FIELDS=fields,
                             OPTIONS=options,
                             ROWCOUNT=row_count)
        
        data = result[class="hl-string">'DATA']
        if not data:
            return pd.DataFrame(columns=[f[class="hl-string">'FIELDNAME'] for f in result[class="hl-string">'FIELDS']])

        df = pd.DataFrame([row[class="hl-string">'WA'].split(class="hl-string">'|') for row in data])
        df.columns = [f[class="hl-string">'FIELDNAME'] for f in result[class="hl-string">'FIELDS']]
        return df
    except Exception as e:
        print(fclass="hl-string">"Error reading table {table_name}: {e}")
        return pd.DataFrame(columns=[f[class="hl-string">'FIELDNAME'] for f in fields])

class=class="hl-string">"hl-comment"># --- 3. DATA EXTRACTION ---
print(class="hl-string">"Starting SAP data extraction...")

with Connection(**sap_conn_params) as conn:
    class=class="hl-string">"hl-comment"># Define filters
    company_code_filter = class="hl-string">" OR ".join([fclass="hl-string">"BUKRS = '{cc}'" for cc in company_codes])
    date_filter = fclass="hl-string">"CPUDT >= '{date_range['start_date']}' AND CPUDT <= '{date_range['end_date']}'"
    bkpf_filter = [fclass="hl-string">"({company_code_filter}) AND ({date_filter})"]

    class=class="hl-string">"hl-comment"># Extract main tables
    df_bkpf = read_sap_table(conn, class="hl-string">'BKPF', fields=[class="hl-string">'MANDT', class="hl-string">'BUKRS', class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BLART', class="hl-string">'BUDAT', class="hl-string">'CPUDT', class="hl-string">'CPUTM', class="hl-string">'USNAM', class="hl-string">'TCODE', class="hl-string">'STBLG', class="hl-string">'BSTAT'], options=bkpf_filter)
    df_bkpf[class="hl-string">'AWKEY'] = df_bkpf[class="hl-string">'BELNR'] + df_bkpf[class="hl-string">'GJAHR']
    df_bkpf[class="hl-string">'OBJECTKEY'] = df_bkpf[class="hl-string">'MANDT'] + df_bkpf[class="hl-string">'BUKRS'] + df_bkpf[class="hl-string">'BELNR'] + df_bkpf[class="hl-string">'GJAHR']
    doc_keys = df_bkpf[[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS']].drop_duplicates().to_dict(class="hl-string">'records')
    bseg_filter = class="hl-string">" OR ".join([fclass="hl-string">"(BELNR = '{k['BELNR']}' AND GJAHR = '{k['GJAHR']}' AND BUKRS = '{k['BUKRS']}')" for k in doc_keys])
    df_bseg = read_sap_table(conn, class="hl-string">'BSEG', fields=[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS', class="hl-string">'BUZEI', class="hl-string">'LIFNR', class="hl-string">'ZFBDT', class="hl-string">'ZTERM', class="hl-string">'ZLSPR', class="hl-string">'WRBTR'])

    class=class="hl-string">"hl-comment"># Extract more tables based on findings
    rseg_filter = [fclass="hl-string">"BELNR IN ({','.join(df_bkpf['BELNR'].unique())}) AND GJAHR IN ({','.join(df_bkpf['GJAHR'].unique())})"]
    df_rseg = read_sap_table(conn, class="hl-string">'RSEG', fields=[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'EBELN', class="hl-string">'EBELP', class="hl-string">'LFBNR'])
    
    vendor_numbers = df_bseg[class="hl-string">'LIFNR'].dropna().unique()
    lfa1_filter = [fclass="hl-string">"LIFNR IN ({','.join(vendor_numbers)})"]
    df_lfa1 = read_sap_table(conn, class="hl-string">'LFA1', fields=[class="hl-string">'LIFNR', class="hl-string">'NAME1'])

    class=class="hl-string">"hl-comment"># Change Documents (CDHDR/CDPOS) for Payment Blocks
    cdhdr_filter = [fclass="hl-string">"OBJECTCLAS = 'BELEGV' AND OBJECTID IN ({','.join(df_bkpf['OBJECTKEY'].unique())}) AND TCODE = 'FB02'"]
    df_cdhdr = read_sap_table(conn, class="hl-string">'CDHDR', fields=[class="hl-string">'OBJECTCLAS', class="hl-string">'OBJECTID', class="hl-string">'CHANGENR', class="hl-string">'USERNAME', class="hl-string">'UDATE', class="hl-string">'UTIME'])
    cdpos_filter = [fclass="hl-string">"OBJECTCLAS = 'BELEGV' AND FNAME = 'ZLSPR' AND TABNAME = 'BSEG' AND CHANGENR IN ({','.join(df_cdhdr['CHANGENR'].unique())})"]
    df_cdpos = read_sap_table(conn, class="hl-string">'CDPOS', fields=[class="hl-string">'CHANGENR', class="hl-string">'TABKEY', class="hl-string">'FNAME', class="hl-string">'VALUE_NEW', class="hl-string">'VALUE_OLD'])
    
    class=class="hl-string">"hl-comment"># Cleared Items
    bsak_filter = class="hl-string">" OR ".join([fclass="hl-string">"(BELNR = '{k['BELNR']}' AND GJAHR = '{k['GJAHR']}' AND BUKRS = '{k['BUKRS']}')" for k in doc_keys])
    df_bsak = read_sap_table(conn, class="hl-string">'BSAK', fields=[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS', class="hl-string">'AUGDT', class="hl-string">'AUGBL'])

    class=class="hl-string">"hl-comment"># Payment Proposal
    regup_filter = class="hl-string">" OR ".join([fclass="hl-string">"(VBLNR = '{k['BELNR']}' AND GJAHR = '{k['GJAHR']}' AND BUKRS = '{k['BUKRS']}')" for k in doc_keys])
    df_regup = read_sap_table(conn, class="hl-string">'REGUP', fields=[class="hl-string">'LAUFD', class="hl-string">'LAUFI', class="hl-string">'VBLNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS'])
    reguh_filter = [fclass="hl-string">"LAUFD IN ({','.join(df_regup['LAUFD'].unique())}) AND LAUFI IN ({','.join(df_regup['LAUFI'].unique())})"]
    df_reguh = read_sap_table(conn, class="hl-string">'REGUH', fields=[class="hl-string">'LAUFD', class="hl-string">'LAUFI', class="hl-string">'VBLNR'])


print(class="hl-string">"Extraction complete. Starting data transformation...")

class=class="hl-string">"hl-comment"># --- 4. DATA TRANSFORMATION & JOINING ---
class=class="hl-string">"hl-comment"># Merge core invoice data
df_inv = pd.merge(df_bkpf, df_bseg.loc[df_bseg[class="hl-string">'LIFNR'].notna()], on=[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS'])
df_inv = pd.merge(df_inv, df_lfa1, on=class="hl-string">'LIFNR', how=class="hl-string">'left')
df_inv = pd.merge(df_inv, df_rseg, on=[class="hl-string">'BELNR', class="hl-string">'GJAHR'], how=class="hl-string">'left')

class=class="hl-string">"hl-comment"># --- 5. EVENT LOG CREATION ---
all_events = []

class=class="hl-string">"hl-comment"># Invoice Document Created
df_created = df_inv.copy()
df_created[class="hl-string">'Activity'] = class="hl-string">'Invoice Document Created'
df_created[class="hl-string">'EventTime'] = pd.to_datetime(df_created[class="hl-string">'CPUDT'] + df_created[class="hl-string">'CPUTM'], format=class="hl-string">'%Y%m%d%H%M%S')
all_events.append(df_created)

class=class="hl-string">"hl-comment"># Invoice Parked
df_parked = df_inv[df_inv[class="hl-string">'BSTAT'] == class="hl-string">'V'].copy()
df_parked[class="hl-string">'Activity'] = class="hl-string">'Invoice Parked'
df_parked[class="hl-string">'EventTime'] = pd.to_datetime(df_parked[class="hl-string">'CPUDT'] + df_parked[class="hl-string">'CPUTM'], format=class="hl-string">'%Y%m%d%H%M%S')
all_events.append(df_parked)

class=class="hl-string">"hl-comment"># Purchase Order Matched
df_po_match = df_inv[df_inv[class="hl-string">'EBELN'].notna()].copy()
df_po_match[class="hl-string">'Activity'] = class="hl-string">'Purchase Order Matched'
df_po_match[class="hl-string">'EventTime'] = pd.to_datetime(df_po_match[class="hl-string">'CPUDT'] + df_po_match[class="hl-string">'CPUTM'], format=class="hl-string">'%Y%m%d%H%M%S')
all_events.append(df_po_match)

class=class="hl-string">"hl-comment"># Goods Receipt Matched
df_gr_match = df_inv[df_inv[class="hl-string">'LFBNR'].notna()].copy()
df_gr_match[class="hl-string">'Activity'] = class="hl-string">'Goods Receipt Matched'
df_gr_match[class="hl-string">'EventTime'] = pd.to_datetime(df_gr_match[class="hl-string">'CPUDT'] + df_gr_match[class="hl-string">'CPUTM'], format=class="hl-string">'%Y%m%d%H%M%S')
all_events.append(df_gr_match)

class=class="hl-string">"hl-comment"># Payment Block Set & Removed (from change logs)
if not df_cdhdr.empty and not df_cdpos.empty:
    df_changes = pd.merge(df_cdhdr, df_cdpos, on=class="hl-string">'CHANGENR')
    df_changes[class="hl-string">'BELNR'] = df_changes[class="hl-string">'OBJECTID'].str[7:17]
    df_changes[class="hl-string">'GJAHR'] = df_changes[class="hl-string">'OBJECTID'].str[17:21]
    df_changes[class="hl-string">'BUKRS'] = df_changes[class="hl-string">'OBJECTID'].str[3:7]
    df_changes = pd.merge(df_changes, df_inv[[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS']].drop_duplicates(), on=[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS'])
    
    df_block_set = df_changes[df_changes[class="hl-string">'VALUE_NEW'].str.strip() != class="hl-string">''].copy()
    df_block_set[class="hl-string">'Activity'] = class="hl-string">'Payment Block Set'
    df_block_set[class="hl-string">'EventTime'] = pd.to_datetime(df_block_set[class="hl-string">'UDATE'] + df_block_set[class="hl-string">'UTIME'], format=class="hl-string">'%Y%m%d%H%M%S')
    df_block_set.rename(columns={class="hl-string">'VALUE_NEW': class="hl-string">'PaymentBlockReason', class="hl-string">'USERNAME': class="hl-string">'ProcessorUser'}, inplace=True)
    all_events.append(df_block_set)

    df_block_removed = df_changes[df_changes[class="hl-string">'VALUE_OLD'].str.strip() != class="hl-string">''].copy()
    df_block_removed[class="hl-string">'Activity'] = class="hl-string">'Payment Block Removed'
    df_block_removed[class="hl-string">'EventTime'] = pd.to_datetime(df_block_removed[class="hl-string">'UDATE'] + df_block_removed[class="hl-string">'UTIME'], format=class="hl-string">'%Y%m%d%H%M%S')
    df_block_removed.rename(columns={class="hl-string">'VALUE_OLD': class="hl-string">'PaymentBlockReason', class="hl-string">'USERNAME': class="hl-string">'ProcessorUser'}, inplace=True)
    all_events.append(df_block_removed)

    class=class="hl-string">"hl-comment"># Invoice Routed For Approval & Approved (inferred from blocks)
    class=class="hl-string">"hl-comment"># Assumption: A specific block reason, e.g., class="hl-string">'A', signifies approval workflow.
    df_routed = df_block_set[df_block_set[class="hl-string">'PaymentBlockReason'].str.strip() == class="hl-string">'[A]'].copy()
    df_routed[class="hl-string">'Activity'] = class="hl-string">'Invoice Routed For Approval'
    all_events.append(df_routed)

    df_approved = df_block_removed[df_block_removed[class="hl-string">'PaymentBlockReason'].str.strip() == class="hl-string">'[A]'].copy()
    df_approved[class="hl-string">'Activity'] = class="hl-string">'Invoice Approved'
    df_approved[class="hl-string">'Approver'] = df_approved[class="hl-string">'ProcessorUser']
    all_events.append(df_approved)

class=class="hl-string">"hl-comment"># Invoice Posted
df_posted = df_inv[df_inv[class="hl-string">'BSTAT'] != class="hl-string">'V'].copy()
df_posted[class="hl-string">'Activity'] = class="hl-string">'Invoice Posted'
df_posted[class="hl-string">'EventTime'] = pd.to_datetime(df_posted[class="hl-string">'BUDAT'], format=class="hl-string">'%Y%m%d')
all_events.append(df_posted)

class=class="hl-string">"hl-comment"># Invoice Cleared By Payment
if not df_bsak.empty:
    df_cleared = pd.merge(df_inv, df_bsak[df_bsak[class="hl-string">'AUGDT'] != class="hl-string">'00000000'], on=[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS'])
    df_cleared[class="hl-string">'Activity'] = class="hl-string">'Invoice Cleared By Payment'
    df_cleared[class="hl-string">'EventTime'] = pd.to_datetime(df_cleared[class="hl-string">'AUGDT'], format=class="hl-string">'%Y%m%d')
    all_events.append(df_cleared)

class=class="hl-string">"hl-comment"># Invoice Reversed
df_reversed = df_inv[df_inv[class="hl-string">'STBLG'].notna() & (df_inv[class="hl-string">'STBLG'] != class="hl-string">'')].copy()
if not df_reversed.empty:
    reversal_docs = pd.merge(df_reversed, df_bkpf[[class="hl-string">'BELNR', class="hl-string">'BUDAT']], left_on=class="hl-string">'STBLG', right_on=class="hl-string">'BELNR', suffixes=(class="hl-string">'', class="hl-string">'_rev'))
    reversal_docs[class="hl-string">'Activity'] = class="hl-string">'Invoice Reversed'
    reversal_docs[class="hl-string">'EventTime'] = pd.to_datetime(reversal_docs[class="hl-string">'BUDAT_rev'], format=class="hl-string">'%Y%m%d')
    all_events.append(reversal_docs)

class=class="hl-string">"hl-comment"># Payment Proposal Created
if not df_regup.empty and not df_reguh.empty:
    df_proposal = pd.merge(df_regup, df_reguh, on=[class="hl-string">'LAUFD', class="hl-string">'LAUFI'])
    df_proposal = pd.merge(df_proposal, df_inv, left_on=[class="hl-string">'VBLNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS'], right_on=[class="hl-string">'BELNR', class="hl-string">'GJAHR', class="hl-string">'BUKRS'])
    df_proposal[class="hl-string">'Activity'] = class="hl-string">'Payment Proposal Created'
    df_proposal[class="hl-string">'EventTime'] = pd.to_datetime(df_proposal[class="hl-string">'LAUFD'], format=class="hl-string">'%Y%m%d')
    all_events.append(df_proposal)

class=class="hl-string">"hl-comment"># Due Date Passed Without Payment (Calculated)
if not df_bsak.empty:
    cleared_keys = df_bsak[class="hl-string">'BELNR'] + df_bsak[class="hl-string">'GJAHR'] + df_bsak[class="hl-string">'BUKRS']
    df_open = df_inv[~(df_inv[class="hl-string">'BELNR'] + df_inv[class="hl-string">'GJAHR'] + df_inv[class="hl-string">'BUKRS']).isin(cleared_keys)].copy()
    df_open[class="hl-string">'DueDate'] = pd.to_datetime(df_open[class="hl-string">'ZFBDT'], format=class="hl-string">'%Y%m%d', errors=class="hl-string">'coerce')
    df_overdue = df_open[(df_open[class="hl-string">'DueDate'] < datetime.now()) & (df_open[class="hl-string">'DueDate'].notna())].copy()
    if not df_overdue.empty:
        df_overdue[class="hl-string">'Activity'] = class="hl-string">'Due Date Passed Without Payment'
        df_overdue[class="hl-string">'EventTime'] = df_overdue[class="hl-string">'DueDate']
        all_events.append(df_overdue)

class=class="hl-string">"hl-comment"># --- 6. FINAL ASSEMBLY & EXPORT ---
print(class="hl-string">"Assembling final event log...")

df_event_log = pd.concat(all_events, ignore_index=True, sort=False)

class=class="hl-string">"hl-comment"># Rename and select columns
column_mapping = {
    class="hl-string">'BELNR': class="hl-string">'InvoiceNumber',
    class="hl-string">'USNAM': class="hl-string">'ProcessorUser',
    class="hl-string">'NAME1': class="hl-string">'VendorName',
    class="hl-string">'BUKRS': class="hl-string">'CompanyCode',
    class="hl-string">'WRBTR': class="hl-string">'InvoiceGrossAmount',
    class="hl-string">'ZFBDT': class="hl-string">'InvoiceDueDate',
    class="hl-string">'ZTERM': class="hl-string">'PaymentTerms',
    class="hl-string">'EBELN': class="hl-string">'PurchaseOrderNumber',
    class="hl-string">'ZLSPR': class="hl-string">'PaymentBlockReason'
}
df_event_log.rename(columns=column_mapping, inplace=True)

class=class="hl-string">"hl-comment"># Ensure required columns exist
final_cols = [
    class="hl-string">'InvoiceNumber', class="hl-string">'Activity', class="hl-string">'EventTime', class="hl-string">'ProcessorUser', class="hl-string">'VendorName', 
    class="hl-string">'CompanyCode', class="hl-string">'InvoiceGrossAmount', class="hl-string">'InvoiceDueDate', class="hl-string">'PaymentTerms', 
    class="hl-string">'PurchaseOrderNumber', class="hl-string">'PaymentBlockReason', class="hl-string">'Approver'
]

for col in final_cols:
    if col not in df_event_log.columns:
        df_event_log[col] = None

df_final = df_event_log[final_cols].sort_values(by=[class="hl-string">'InvoiceNumber', class="hl-string">'EventTime']).reset_index(drop=True)

class=class="hl-string">"hl-comment"># Export to CSV
df_final.to_csv(class="hl-string">'sap_ap_event_log.csv', index=False)
print(fclass="hl-string">"Event log created successfully with {len(df_final)} events.")

步骤

前提条件和设置：安装经过认证的第三方ETL工具（例如Theobald Xtract Universal或带SAP连接器的Talend）。确保您拥有有效许可证，并可连接SAP ECC系统。配置SAP用户账号，并授予所需的RFC和表读取权限（例如访问所需表的S_RFC和S_TABU_DIS权限）。
创建SAP连接：在ETL工具中创建新的SAP连接，填写应用服务器详情、系统ID、客户端编号和专用SAP用户账号的凭据。测试连接，确认连接成功。
定义基础数据源：将核心SAP表添加为提取作业的数据源：BKPF（会计凭证抬头）、BSEG（会计凭证分段）、LFA1（供应商主数据）、RBKP（MM发票抬头）、RSEG（MM发票行项目）、CDHDR（更改凭证抬头）和CDPOS（更改凭证项目）。
建立表联接：通过联接各表创建基础视图或数据流。按BUKRS、BELNR和GJAHR联接BKPF与BSEG；按LIFNR联接BKPF与LFA1；使用MM凭证信息（BELNR、GJAHR映射到RSEG.BELNR、RSEG.GJAHR）联接BSEG与RSEG；按OBJECTCLAS='BELEG'且OBJECTID = CompanyCode + DocumentNumber + FiscalYear联接BKPF与CDHDR。
应用全局筛选条件：在数据源层应用筛选条件，限定数据范围。常见条件包括BKPF.BUKRS（公司代码）、BKPF.GJAHR（会计年度）和BKPF.BLART（单据类型，例如“KR”“RE”）。必须按BKPF.CPUDT（录入日期）筛选日期范围，以控制数据量。
构建“发票凭证已创建”活动：创建第一个数据流，将Activity设为“发票凭证已创建”。EventTime由BKPF.CPUDT（日期）和BKPF.CPUTM（时间）组合而成。从联接后的表中选择所有必需和建议属性。
构建后续活动数据流：为其余12项活动分别创建数据流或转换路径，并应用特定逻辑和筛选条件以提取对应记录。例如，对于“发票已暂存”，筛选BKPF.BSTAT = 'V'。对于基于更改记录的事件，则按特定表、字段和值的更改筛选CDHDR和CDPOS（例如，付款冻结对应FNAME = 'ZLSPL'）。
提取更改凭证事件：对于“付款冻结已设置”和“付款冻结已移除”等活动，使用CDHDR和CDPOS中的数据。EventTime取自CDHDR.UDATE和CDHDR.UTIME，ProcessorUser取自CDHDR.USERNAME。
计算“已过到期日”事件：创建专用转换步骤来计算此活动。逻辑为：IF BSEG.AUGBL IS NULL AND CURRENT_DATE > BSEG.ZFBDT THEN create event。此活动的EventTime应设为到期日（BSEG.ZFBDT）。
合并所有数据流：使用ETL工具中的“Union”或“Merge”转换，将13个活动数据流合并为一个数据集。合并前，请确保所有数据流的列名、顺序和数据类型一致。
最终格式化并导出：检查合并后的数据集，确保EventTime列采用标准时间戳格式（例如YYYY-MM-DD HH:MI:SS）。将最终事件日志以UTF-8编码导出为CSV文件，即可上传到流程挖掘工具。

配置

ETL工具和连接器：需要使用获得许可且配备认证SAP连接器的ETL工具。此方法通过工具的图形界面进行配置，无需直接编写ABAP或SQL代码。
SAP用户授权：SAP用户需要拥有RFC执行权限，以及查看以下表的权限：BKPF、BSEG、LFA1、T001、T003T、RBKP、RSEG、CDHDR、CDPOS、REGUH、REGUP和LFB1。
日期范围筛选：首次加载时，强烈建议按BKPF.CPUDT等录入日期字段筛选。首次分析通常选择6至12个月的数据。后续加载可根据更改日期使用增量机制。
关键数据源筛选条件：
- BKPF.BUKRS（公司代码）：选择特定公司代码，限定分析范围。
- BKPF.BLART（单据类型）：筛选相关发票类型，常见类型包括“KR”（供应商发票）和“RE”（MM发票收据）。
性能注意事项：从更改凭证表（CDHDR、CDPOS）提取数据可能占用大量资源。请按OBJECTCLAS = 'BELEG'和相关事务代码（TCODE）设置具体筛选条件，以降低性能影响。避免全表扫描。

查询示例 sql

-- This is a logical representation of the ETL configuration.
-- Each 'SELECT' block represents a separate data stream for an activity,
-- which are then combined using a UNION ALL transformation in the ETL tool.

-- Base Data Source: A join of BKPF, BSEG, LFA1, RBKP, RSEG
-- Let's call this joined view 'INVOICE_DETAILS'

-- 1. Invoice Document Created
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, -- Case ID
    'Invoice Document Created' AS Activity,
    TO_TIMESTAMP(B.CPUDT, B.CPUTM) AS EventTime,
    B.USNAM AS ProcessorUser,
    L.NAME1 AS VendorName,
    B.BUKRS AS CompanyCode,
    B.WAERS AS Currency,
    (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, 
    S1.ZFBDT AS InvoiceDueDate, -- Due date from first line item
    S1.ZTERM AS PaymentTerms,
    S1.EBELN AS PurchaseOrderNumber,
    S1.ZLSPR AS PaymentBlockReason,
    '[Workflow Approver]' AS Approver
FROM BKPF AS B
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K' -- First vendor line item
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE B.BLART IN ('KR', 'RE') AND B.BUKRS = '[YourCompanyCode]' AND B.CPUDT BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 2. Invoice Parked
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber,
    'Invoice Parked' AS Activity,
    TO_TIMESTAMP(B.CPUDT, B.CPUTM) AS EventTime,
    B.USNAM AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, S1.ZLSPR AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM BKPF AS B
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K'
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE B.BSTAT = 'V' AND B.BLART IN ('KR', 'RE') AND B.BUKRS = '[YourCompanyCode]' AND B.CPUDT BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 3. Purchase Order Matched
SELECT DISTINCT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber,
    'Purchase Order Matched' AS Activity, 
    TO_TIMESTAMP(B.CPUDT, B.CPUTM) AS EventTime, 
    B.USNAM AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, S1.ZLSPR AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM BKPF AS B
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K'
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE S1.EBELN IS NOT NULL AND B.BLART IN ('KR', 'RE') AND B.BUKRS = '[YourCompanyCode]' AND B.CPUDT BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 4. Goods Receipt Matched
SELECT DISTINCT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber,
    'Goods Receipt Matched' AS Activity, 
    TO_TIMESTAMP(B.CPUDT, B.CPUTM) AS EventTime, 
    B.USNAM AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, S1.ZLSPR AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM BKPF AS B
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K'
JOIN RSEG AS R ON S1.BELNR = R.BELNR AND S1.GJAHR = R.GJAHR
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE R.LFBNR IS NOT NULL AND B.BLART IN ('KR', 'RE') AND B.BUKRS = '[YourCompanyCode]' AND B.CPUDT BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 5. Payment Block Set
SELECT
    CONCAT(SUBSTRING(H.OBJECTID, 1, 4), SUBSTRING(H.OBJECTID, 5, 10), SUBSTRING(H.OBJECTID, 15, 4)) AS InvoiceNumber,
    'Payment Block Set' AS Activity,
    TO_TIMESTAMP(H.UDATE, H.UTIME) AS EventTime,
    H.USERNAME AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, P.VALUE_NEW AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM CDHDR H
JOIN CDPOS P ON H.CHANGENR = P.CHANGENR
JOIN BKPF B ON SUBSTRING(H.OBJECTID, 5, 10) = B.BELNR AND SUBSTRING(H.OBJECTID, 1, 4) = B.BUKRS AND SUBSTRING(H.OBJECTID, 15, 4) = B.GJAHR
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K'
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE H.OBJECTCLAS = 'BELEG' AND P.TABNAME = 'BSEG' AND P.FNAME = 'ZLSPR' AND P.VALUE_NEW <> ''
AND B.BUKRS = '[YourCompanyCode]' AND H.UDATE BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 6. Invoice Routed For Approval (Inferred from specific block)
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, 'Invoice Routed For Approval' AS Activity, TO_TIMESTAMP(H.UDATE, H.UTIME) AS EventTime, H.USERNAME AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, P.VALUE_NEW AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM CDHDR H JOIN CDPOS P ON H.CHANGENR = P.CHANGENR JOIN BKPF B ON SUBSTRING(H.OBJECTID, 5, 10) = B.BELNR AND SUBSTRING(H.OBJECTID, 1, 4) = B.BUKRS AND SUBSTRING(H.OBJECTID, 15, 4) = B.GJAHR JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K' JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE H.OBJECTCLAS = 'BELEG' AND P.TABNAME = 'BSEG' AND P.FNAME = 'ZLSPR' AND P.VALUE_NEW = '[ApprovalBlockReasonCode]'
AND B.BUKRS = '[YourCompanyCode]' AND H.UDATE BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 7. Invoice Approved (Inferred from removal of specific block)
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, 'Invoice Approved' AS Activity, TO_TIMESTAMP(H.UDATE, H.UTIME) AS EventTime, H.USERNAME AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, '' AS PaymentBlockReason, H.USERNAME AS Approver
FROM CDHDR H JOIN CDPOS P ON H.CHANGENR = P.CHANGENR JOIN BKPF B ON SUBSTRING(H.OBJECTID, 5, 10) = B.BELNR AND SUBSTRING(H.OBJECTID, 1, 4) = B.BUKRS AND SUBSTRING(H.OBJECTID, 15, 4) = B.GJAHR JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K' JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE H.OBJECTCLAS = 'BELEG' AND P.TABNAME = 'BSEG' AND P.FNAME = 'ZLSPR' AND P.VALUE_OLD = '[ApprovalBlockReasonCode]' AND P.VALUE_NEW = ''
AND B.BUKRS = '[YourCompanyCode]' AND H.UDATE BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 8. Payment Block Removed
SELECT
    CONCAT(SUBSTRING(H.OBJECTID, 1, 4), SUBSTRING(H.OBJECTID, 5, 10), SUBSTRING(H.OBJECTID, 15, 4)) AS InvoiceNumber, 'Payment Block Removed' AS Activity, TO_TIMESTAMP(H.UDATE, H.UTIME) AS EventTime, H.USERNAME AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, '' AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM CDHDR H JOIN CDPOS P ON H.CHANGENR = P.CHANGENR JOIN BKPF B ON SUBSTRING(H.OBJECTID, 5, 10) = B.BELNR AND SUBSTRING(H.OBJECTID, 1, 4) = B.BUKRS AND SUBSTRING(H.OBJECTID, 15, 4) = B.GJAHR JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K' JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE H.OBJECTCLAS = 'BELEG' AND P.TABNAME = 'BSEG' AND P.FNAME = 'ZLSPR' AND P.VALUE_NEW = '' AND P.VALUE_OLD <> ''
AND B.BUKRS = '[YourCompanyCode]' AND H.UDATE BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 9. Invoice Posted (Change from Parked to Posted)
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, 'Invoice Posted' AS Activity, TO_TIMESTAMP(H.UDATE, H.UTIME) AS EventTime, H.USERNAME AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, S1.ZLSPR AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM CDHDR H JOIN CDPOS P ON H.CHANGENR = P.CHANGENR JOIN BKPF B ON SUBSTRING(H.OBJECTID, 5, 10) = B.BELNR AND SUBSTRING(H.OBJECTID, 1, 4) = B.BUKRS AND SUBSTRING(H.OBJECTID, 15, 4) = B.GJAHR JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K' JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE H.OBJECTCLAS = 'BELEG' AND P.TABNAME = 'BKPF' AND P.FNAME = 'BSTAT' AND P.VALUE_OLD = 'V' AND P.VALUE_NEW = ''
AND B.BUKRS = '[YourCompanyCode]' AND H.UDATE BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 10. Due Date Passed Without Payment (Calculated)
SELECT 
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, 'Due Date Passed Without Payment' AS Activity, TO_TIMESTAMP(S1.ZFBDT) AS EventTime, 'SYSTEM' AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, S1.ZLSPR AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM BKPF AS B JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K' JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE S1.AUGBL IS NULL AND S1.ZFBDT < CURRENT_DATE
AND B.BLART IN ('KR', 'RE') AND B.BUKRS = '[YourCompanyCode]' AND B.CPUDT BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 11. Payment Proposal Created
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, 'Payment Proposal Created' AS Activity, TO_TIMESTAMP(H.LAUFD) AS EventTime, H.USNAM AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, S1.ZLSPR AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM REGUH H
JOIN REGUP P ON H.LAUFD = P.LAUFD AND H.LAUFI = P.LAUFI AND H.XVORL = P.XVORL
JOIN BKPF B ON P.BUKRS = B.BUKRS AND P.BELNR = B.BELNR AND P.GJAHR = B.GJAHR
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K'
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE B.BUKRS = '[YourCompanyCode]' AND H.LAUFD BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 12. Invoice Cleared By Payment
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, 'Invoice Cleared By Payment' AS Activity, TO_TIMESTAMP(S1.AUGDT) AS EventTime, B.USNAM AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, '' AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM BKPF AS B
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K'
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE S1.AUGBL IS NOT NULL
AND B.BLART IN ('KR', 'RE') AND B.BUKRS = '[YourCompanyCode]' AND S1.AUGDT BETWEEN '[StartDate]' AND '[EndDate]'

UNION ALL

-- 13. Invoice Reversed
SELECT
    CONCAT(B.BUKRS, B.BELNR, B.GJAHR) AS InvoiceNumber, 'Invoice Reversed' AS Activity, TO_TIMESTAMP(B.STODT) AS EventTime, B.USNAM_REV AS ProcessorUser, L.NAME1 AS VendorName, B.BUKRS AS CompanyCode, B.WAERS AS Currency, (SELECT SUM(WRBTR) FROM BSEG S WHERE S.BELNR = B.BELNR AND S.GJAHR = B.GJAHR AND S.BUKRS = B.BUKRS) AS InvoiceGrossAmount, S1.ZFBDT AS InvoiceDueDate, S1.ZTERM AS PaymentTerms, S1.EBELN AS PurchaseOrderNumber, S1.ZLSPR AS PaymentBlockReason, '[Workflow Approver]' AS Approver
FROM BKPF AS B
JOIN BSEG AS S1 ON B.BELNR = S1.BELNR AND B.GJAHR = S1.GJAHR AND B.BUKRS = S1.BUKRS AND S1.KOART = 'K'
JOIN LFA1 AS L ON B.LIFNR = L.LIFNR
WHERE B.STBLG IS NOT NULL
AND B.BLART IN ('KR', 'RE') AND B.BUKRS = '[YourCompanyCode]' AND B.STODT BETWEEN '[StartDate]' AND '[EndDate]'

准备好开始了吗？

使用此模板开启流程挖掘之旅。立即借助数据洞察，改进应付账款发票处理流程。

返回改进指南

下载模板

告别滞纳金：立即优化应付账款，节省60%

借助我们的平台，消除重复付款、实现处理自动化并降低60%的成本。

开始免费试用

无需信用卡，几分钟即可完成设置

应付账款发票处理数据模板

应付账款发票处理数据模板

应付账款发票处理属性

应付账款发票处理活动

数据提取指南

用于提取应付账款发票数据的自定义ABAP程序

步骤

配置

查询示例 abap

直接查询SAP ECC底层数据库

步骤

配置

查询示例 sql

通过SAP RFC协议使用Python脚本提取数据

步骤

配置

查询示例 python

使用带有认证SAP连接器的ETL工具（例如Theobald）

步骤

配置

查询示例 sql

准备好开始了吗？

告别滞纳金：立即优化应付账款，节省60%