...
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 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
...
| draw.io Diagram | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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_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_InbndXEComb | /SYQ/C_LTSD_OutbdCOMBINED | 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) | ||
| ClassificationXE_TariffRate | /SYQ/C_TARIFF_RATE/SYQ/C_CLASSIFICATION_CURRENT | Master - Transactionally sourced | Current classification state with expiry flags, filtered from event history | |||
| ClassificationClassification_Current | /SYQ/C_ClassificationChange_HistoryCLASSIFICATIONCHANGE_HISTORY | Transactional | Change events from change documents (covers user activity through grouping) | |||
| Classification | /SYQ/C_ProductCreation_EventsPRODUCTCREATION_EVENTS | Transactional | Product creation and country extension events | |||
| Classification | /SYQ/C_ClassificationActivity_ByUser/SYQ/C_ClassificationLeadTimeCLASSIFICATIONLEADTIME | 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).
...
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).
...