Export Pound Sugar

Export Pound Sugar

Business Schema:

Schema: SAP_Custom

Table: exportInvoiceSQL

Go Live: April 8, 2024

Users: Mary Schoenberger

Purpose: Generates a report that displays a total pounds of sugar we sell to be reported to the government.

Fields/Definitions:

Field Name

Definition

Formula

Invoice Date

Billing date for billing index

SAPECC_BL.VBRK.FKDAT

Invoice Number

Billing document number

SAPECC_BL.VBRK.VBELN

Delivery Note

Shipping document number

SAPECC_DL.LIPS.VBELN

Sales Order

Sales document number

SAPECC_SO.VBAK.VBELN

Customer Number

Customer account number

SAPECC_SO.VBAK.KUNNR

Customer Name

Customer name

SAPECC_CM_MD.KNA1.NAME1

Sugar Pounds

Total pounds of sugar being sold

SAPECC_Custom.ExportPoundConversion

Formula: sugarconversionfactor * invoice net weight. External table that is manually maintained.

Candy Pounds

Total pounds of candy being sold

SAPECC_Custom.exportInvoiceSQL

Individual Filters

Filter Fields

Table

Criteria

Division

SAPECC_Custom.exportInvoiceSQL

In (20)

Document Type

SAPECC_Custom.exportInvoiceSQL

No in (U)

Change Control

Date

Modification Made

Version

Updated by