...
This Data Flow Specification (DFS) defines the end-to-end data flow required to meet the following requirements:
| Customs (Import/Export) | Customs Analysis including Import and Export | This will be use some built using enhanced SAP Standard Business Content | ||
| Customs Classification | ||||
| Trade Compliance | Compliance Analysis | This is entirely Custom as no Business Content nor standard CDS views Exist | ||
| PreferencesPreference Management | Preference Analysis | This is entirely Custom as no Business Content nor standard CDS views Exist | ||
| Intrastat | Intrastat Analysis | This is entirely Custom as no Business Content nor standard CDS views Exist |
...
The import declaration item Analytic Model contains item data enhanced with master data associations to importer, exporter, Customs product and text associations.
m
Export Declaration Items Model
The export declaration item Analytic Model contains item data enhanced with master data associations to importer, exporter, Customs product and text associations.
Please see the example DFD done for a fictional requirement that wishes to show original purchase order item and value alongside the PO history according to Purchase Order Creation date.
| draw.io Diagram | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
How to use this document
Please see the SyWay Analytics Approach document, section 'Documentation' for more information about the context of this document.
This document is designed to:
- Be an aid in to the initial design of a data flow for the reporting functional consultant
- Be the means of communication between the reporting functional consultant and the developer as to what is to be built
- Be the long term repository for the documentation of the actual technical build.
Fill in the document following the steps below and keeping close alignment with the SAP Analytics and Reporting Standards.
First, copy this template, copy the template data flow diagram inside it, replace the template DFD with the new DFD in the new document.
In DFD:
- Lay out the spaces.
- Populate the spaces with the tentative objects depicting object type with the appropriate box. (Build the entity relationship model). Use a short, meaningful, code for the object name to keep the boxes small and the design flexible till complete.
- Be aware of and respect the colour coding for boxes as seen in the key at the top of the DFD.
- N.B. do not include master data objects in transaction data DFD unless they are actively joined to (i.e. not just used as attributes). MD objects have their own DFD.
- Where an object's data flow belongs in a different DFD (e.g. S2P consumes an object from O2C), just reference the object, don't include its full flow.
- Once the data flow makes sense (i.e. will deliver the desired solution), populate the technical names for relevant objects in the boxes into the tables beneath the data flow diagram. This allows you to add / change the names without having to reconfigure the diagram.
In the confluence document:
- Update the details of any business logic below the data flow diagram. Updates to be made according to the layer and type.
|
Source System Extractors
Standard extractors do not need to be documented unless extended.
Where custom extractors / extensions are required, reference the FSD for that enhancement.
| Area | Extractor Code | Extractor Name | Check if Transactional | Notes | Purpose | Build Jira Ref For Extension Information |
|---|---|---|---|---|---|---|
| Customs | XE_Exp_DecItem | C_EXPORTDECLARATIONITEMDEX | Yes | Delta | The export declaration item Analytic Model contains item data enhanced with master data associations to importer, exporter, Customs product and text associations. | |
| Customs | XE_Imp_DecItem | C_IMPORTDECLARATIONITEMDEX | Yes | Delta | The import declaration item Analytic Model contains item data enhanced with master data associations to importer, exporter, Customs product and text associations. | |
| Customs | XE_CusDoc_Com | /SYQ/C_CUSTOMSDOC_LTSD_InbndXE_LTSD_OutbdCOMPLETENESS | Derived Master | Declaration data quality assessment | ||
| Customs | XE_CusDoc_Cor | /SYQ/C_CUSTOMSDOC_CORRECTIONS | Yes | Declaration correction events | ||
| Customs | XE_TariffRate | /SYQ/C_TARIFF_RATE | Master - Transactionally sourced | MFN and preferential rates from GTS-loaded tariff data | ||
| Intrastat | XE_Intra_Mat | /SYQ/C_INTRASTAT_MATERIALREQUEST | Transactional | Material request events | ||
| Intrastat | XE_Intra_Mov | /SYQ/C_INTRASTAT_MOVEMENT | Transactional | Check if required | Movement details if needed | |
| Preference | XE_LTSD_Comb | /SYQ/C_LTSD_COMBINED | Master - Transactionally sourced | Needs direction Indicator | Inbound and outbound LTSDs unified with direction attribute | |
| Preference | XE_LTSD_Req | /SYQ/C_LTSD_REQUEST_ACTIVITY | Transactional | Request lifecycle events with campaign attribute | ||
| Preference | XE_PrefResult | /SYQ/C_PREFERENCE_RESULT | Master - Transactionally sourced | Determination results including all status codes (positive, negative, affected by-price) | ||
| Preference | XE_VendDec_Cv | /SYQ/C_VENDORDECLARATION_COVERAGE | Derived Master | Coverage at product level across BOM | ||
| Compliance | XE_SPL_Aud | /SYQ/C_SPLHIT_AUDIT | Yes | SPL screening events and decisions | ||
| Compliance | XE_BlkDoc_Aud | /SYQ/C_BLOCKEDDOCUMENTAUDIT | Yes | Document block/release events with block reason granularity | ||
| Compliance | XE_PartStatHist | /SYQ/C_PARTNERCOMPSTATUS_HISTORY | Yes | Partner status change events for SCD-2 build | ||
| Compliance | /SYQ/C_BusinessPartner_SPLRelevant | Master | Active SPL-screenable partner master | |||
| License | XE_LicenseMas | /SYQ/C_LICENSE_MASTER | Master | License headers with validity, capacity, regulation | ||
| License | XE_LicenseDep | /SYQ/C_LICENSE_DEPLETION | Yes | License depletion events | ||
| License | XE_License_Val | /SYQ/C_LICENSEUSAGE_WITHVALUE | Yes | Depletion joined to commercial value (single-domain composite) | ||
| Classification | /SYQ/C_CLASSIFICATION_CURRENT | Master - Transactionally sourced | Current classification state with expiry flags, filtered from event history | |||
| Classification | /SYQ/C_CLASSIFICATIONCHANGE_HISTORY | Transactional | Change events from change documents (covers user activity through grouping) | |||
| ClassificationXE_TariffRate | /SYQ/C_TARIFF_RATEPRODUCTCREATION_EVENTS | Transactional | Product creation and country extension events | |||
| Classification | /SYQ/C_CLASSIFICATIONLEADTIME | Derived Transactional | Check what this means | Joins creation to first classification with working-day duration |
Inbound Layer
Inbound layer objects only need documentation if some field adjustment is made (over and above the standard load date / time and source system stamp).
...
Calculated Measures (Pre-Aggregation Calculations)
Facts
Tier 1 — simple event-based facts (no snapshots):
- FACT_SPL_SCREENING
- FACT_BLOCKED_DOCUMENT
- FACT_LICENSE_USAGE
- FACT_CLASSIFICATION_ACTIVITY
- FACT_PRODUCT_CREATION
- FACT_LTSD_REQUEST
- FACT_PREFERENCE_RESULT
- FACT_CUSTOMS_DOC (built directly on DEX views with simple enrichment)
- FACT_CUSTOMS_CORRECTIONS
- FACT_CUSTOMS_DATA_QUALITY
- FACT_INTRASTAT_MATERIAL_REQUEST (if in scope)
Tier 2 — periodic snapshots for state representation:
- FACT_LICENSE_PORTFOLIO — weekly snapshot
- FACT_LTSD_COVERAGE — weekly snapshot
- FACT_CLASSIFICATION_CURRENT — daily snapshot
- FACT_CLASSIFICATION_LEAD_TIME — periodic snapshot
- FACT_PARTNER_AVAILABILITY — periodic snapshot of master state
- FACT_CAMPAIGN_RELEVANT_MATERIALS — periodic snapshot
- FACT_CUSTOMS_CYCLE_TIME — depends on TM/broker timestamp availability
Tier 3 — audit-grade snapshots:
- FACT_PREFERENCE_SAVINGS — monthly snapshot with locked tariff rates
- FACT_TRADE_COMPLIANCE_OVERVIEW — daily snapshot with as-of-date dimensional state
Reporting Layer
4VA_S2PP2R_POHisAcc
| Type | Code | Technical Name | Logic | Functional Spec |
|---|---|---|---|---|
| 4MA_CustomsDeclarations | ||||
| 4MA_CustomsCycleTime | ||||
| 4MA_ComplianceActivity | ||||
| 4MA_BlockedDocuments | ||||
| 4MA_LicensePortfolio | ||||
| 4MA_ClassificationAnalytics | ||||
| 4MA_PreferenceResults | ||||
4MA_CustomsDeclarations — duty spend, declaration volumes, data quality, corrections
4MA_CustomsCycleTime — cycle times and SLA adherence (subject to data availability)
4MA_ComplianceActivity — SPL screening and partner activity
4MA_BlockedDocuments — document blocks and releases by regulation
4MA_LicensePortfolio — license analytics and usage
4MA_ClassificationAnalytics — classification activity, coverage, lead times
4MA_PreferenceResults — eligibility analytics with all status codes
4MA_LTSDManagement — LTSD operations and campaign management
4MA_PreferenceSavings — realized savings, potential, leakage
4MA_TradeComplianceOverview — cross-module risk view
4MA_Intrastat — Intrastat material request analytics
Link to FSD (Each Analytic model should have its own FSD).
...