This Data Flow Specification (DFS) defines the end-to-end data flow required to meet the following requirements:
| Customs | Customs Analysis including Import and Export | This will be built using enhanced SAP Standard Business Content | ||
| Compliance | Compliance Analysis | This is entirely Custom as no Business Content nor standard CDS views Exist | ||
| Preferences | 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
The export declaration item Analytic Model contains item data enhanced with master data associations to importer, exporter, Customs product and text associations.
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_COMPLETENESS | 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) | |||
| Classification | /SYQ/C_PRODUCTCREATION_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 objects only need documentation if some field adjustment is made (over and above the standard load date / time and source system stamp).
Field XYZ converted to date.
Field ABC converted from BIGINT to...
Every table will have it's own harmonization view. This only needs to be documented if field adjustments are required. E.g. Conversion of data field / type.
Where actions are performed to improve reusability, e.g. joining header and item tables, details of the join (left outer, which is left, which is right, fields to join with, cardinality etc) should listed.
Each node inside the view will appear as a heading 3 in this document detailing what it does and, if not obvious, why.
Calculated dimension CD_PLANT to change length of field 'Plant' from 4 to 5 to align with WHM plant. (Ubiquitously true, reusable change made at lowest level possible).
Calculated measure: CM_PRICE = Value / Quantity. (Ubiquitously true, reusable change made at lowest level possible).
Purpose: Join PO header and item to create reusable view at item level that contains all fields from PO header
LHS: 2VR_S4H_C_PurchaseOrderDex
RHS: 2VR_S4H_C_PurchaseOrderItemDex
Join Field: POHeader to POHeader
Join type: Left outer join
Cardinality: 1: Many
Remove fields that occur in both PO Header and Item views leaving fields from PO Header side.
A line item level calculation which applies specific business rules that are owned by the POD would be added here.
Purpose: etc
Purpose: etc
Purpose: etc
Calculated measure: CM_DocItemValue = DocQuantity * CM_PRICE
Purpose: To bring in values from PO level alongside lower level granularity documents
| Target Field | Source1-Field | Source2-Field |
|---|---|---|
| PO | PO | PO |
| POItem | POItem | POItem |
| MaterialDocument | - | MaterialDocument |
List objects where material master associations are to be made.
Facts
Tier 1 — simple event-based facts (no snapshots):
Tier 2 — periodic snapshots for state representation:
Tier 3 — audit-grade snapshots:
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).
Include technical details for:
Detail restrictions
Detail rate type, from currency