Transportation Order - Freight Dispute Cases
The freight dispute case analytic model contains dimensions and measures about the freight dispute cases within a time period.
Information like the number of dispute cases and dispute case items are included as well as the amounts like order amount, dispute amount and proposed amount. Also, the order quantity, the dispute quantity and the proposed quantity are available.
The following lineage diagram shows the entities described here:
Data Replication for Freight Dispute Cases
The local table Freight Dispute Case Analytics (LT) (technical name: SAP_TMS_IL_C_FRTDSPUTCASEANLYTSDEX) is based on the CDS-View DEX for Freight Dispute Case Analytics (technical name: C_FrtDsputCaseAnlytsDEX) from S/4HANA. As a best practice you should replicate the data via replication flow to the local table.
Freight Dispute Case (IL)
The inbound layer view Freight Dispute Case (IL) (technical name: SAP_TMS_IL_FreightDisputeCase) is based on the local table Freight Dispute Case Analytics (LT). Within this view columns are converted from data type string to time and all UUIDs from binary to string.
Freight Dispute Case (HL)
The harmonization view Freight Dispute Case (HL) (technical name: SAP_TMS_HL_FreightDisputeCase) uses the inbound layer view Freight Dispute Case (IL). Additionally, master data associations are added to the view to add attributes, texts and time dimensions. Also, the transportation order and the transportation order UUID are read in via an inner join via the Transport Order Analytics Root and Item (IL).
The harmonization layer also contains the Display Currency (P_DISPLAYCURRENCY) as an input parameter to convert the currency fields:
Order Amount (FrtDsputCaseValOrderAmount), the Dispute Amount (FrtDsputCaseValDisputeAmount) and the Proposed Amount (FrtDsputCaseValProposedAmount) to the given currency.
|
Input Parameter |
Name |
|---|---|
|
P_DISPLAYCURRENCY |
Display Currency |
The following measures are converted into the display currency using the input parameter:
|
Measure |
Name |
Input Parameter for Conversion |
|---|---|---|
|
FrtDsputCaseValOrderAmount |
Order Amount |
P_DISPLAYCURRENCY |
|
FrtDsputCaseValDisputeAmount |
Dispute Amount |
P_DISPLAYCURRENCY |
|
FrtDsputCaseValProposedAmount |
Proposed Amount |
P_DISPLAYCURRENCY |
Furthermore, in the Harmonization View, the date fields are converted from string to date format.
Freight Dispute Case (RL)
The reporting layer analytic model Freight Dispute Case (RL) (technical name: SAP_TMS_RL_FreightDisputeCase) consumes the graphical view SAP_TMS_RL_FreightDisputeCase (technical name: SAP_TMS_IL_FreightDisputeCase).
It exposes the freight dispute cases per transport order to SAP Analytics Cloud and other business intelligence solutions.
The analytical model provides many dimensions and key figures based on the transport order for the freight dispute cases. Information about the order amount, dispute amount and the proposed amount is available, and information about the dispute quantity.
|
Measures Transport Order Item |
Name |
|---|---|
|
FrtDsputCaseValOrderQuantity |
Order Quantity |
|
FrtDsputCaseValDisputeQuantity |
Dispute Quantity |
|
FrtDsputCaseValProposedQty |
Proposed Quantity |
|
FrtDsputCaseValOrderAmount |
Order Amount |
|
FrtDsputCaseValDisputeAmount |
Dispute Amount |
|
FrtDsputCaseValProposedAmount |
Proposed Amount |
Additionally, restricted and count distinct key figures are available:
|
Restricted Measures |
Name |
Restriction |
|---|---|---|
|
FrtDsputCaseValAutomOrderAmt |
Auto. Approved Order Amount |
FrtDsputCaseValueIsInitial = 'X' and FrtDsputCaseItemChangedAttrib = '01' and FrtDsputCaseItemIsMnllyUpdated = ' ' |
|
FrtDsputCaseValAutomPrpsdAmt |
Auto. Approved Proposed Amount |
FrtDsputCaseValueIsInitial = 'X' and FrtDsputCaseItemChangedAttrib = '01' and FrtDsputCaseItemIsMnllyUpdated = ' ' |
|
FrtDsputCaseValMnlOrderAmt |
Manual Approved Order Amount |
FrtDsputCaseValueIsInitial = 'X' and FrtDsputCaseItemChangedAttrib = '01' and FrtDsputCaseItemIsMnllyUpdated = 'X' |
|
FrtDsputCaseValMnlPrpsdAmt |
Manual Approved Proposed Amount |
FrtDsputCaseValueIsInitial = 'X' and FrtDsputCaseItemChangedAttrib = '01' and FrtDsputCaseItemIsMnllyUpdated = 'X' |
|
NrOfFrtDsputCaseItmAutomUpdt |
No. Of Items with auto. Update |
FrtDsputCaseItemIsMnllyUpdated = '' |
|
NrOfFrtDsputCaseItmMnlUpdt |
No. of Itms with man. update |
FrtDsputCaseItemIsMnllyUpdated = 'X' |
|
Count Distinct Measures |
Name |
Dimension |
|---|---|---|
|
NrOfFrtDsputCase |
No. of Dispute Cases |
Freight Dispute Case UUID |
|
NrOfFrtDsputCaseItm |
No. of Dispute Case Items |
Freight Dispute Case Item UUID |