I_LstMiSDInvoice

DDL: I_LSTMISDINVOICE SQL: ILSTMISDINV Type: view COMPOSITE

Last Mile Distribution SD Invoice

I_LstMiSDInvoice is a Composite CDS View that provides data about "Last Mile Distribution SD Invoice" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocument, P_LstMiRteVstToBillingDocument) and exposes 17 fields with key field Invoice. It has 2 associations to related views.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_BillingDocument billingDocument from
P_LstMiRteVstToBillingDocument toVisit inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LstMiRoute _Route $projection.LastMileRouteUUID = _Route.LastMileRouteUUID
[1..*] I_LstMiSDOutbDelivToSDInvoice _OutboundDelivery $projection.Invoice = _OutboundDelivery.Invoice

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ILSTMISDINV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Last Mile Distribution SD Invoice view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Invoice P_LstMiRteVstToBillingDocument BillingDocument
LastMileRouteVisitUUID P_LstMiRteVstToBillingDocument LastMileRouteVisitUUID
LastMileRouteUUID P_LstMiRteVstToBillingDocument LastMileRouteUUID
TotalGrossAmount
TransactionCurrency TransactionCurrency
CustomerPaymentTerms CustomerPaymentTerms
AccountingDocument AccountingDocument
FiscalYear FiscalYear
CompanyCode CompanyCode
OverallSDProcessStatus OverallSDProcessStatus
OverallBillingStatus OverallBillingStatus
SDDocumentCategory I_BillingDocument SDDocumentCategory
AccountingDocumentCategory _AccountingDocument AccountingDocumentCategory
_Route _Route
_TransactionCurrency _TransactionCurrency
_CustomerPaymentTerms _CustomerPaymentTerms
_OutboundDelivery _OutboundDelivery 
@AbapCatalog.sqlViewName: 'ILSTMISDINV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel:   {   usageType:          { serviceQuality: #C,
                                          sizeCategory:   #XL,
                                          dataClass:      #TRANSACTIONAL}
                }
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Last Mile Distribution SD Invoice'
define view I_LstMiSDInvoice
  as select from I_BillingDocument              as billingDocument
    inner join   P_LstMiRteVstToBillingDocument as toVisit on billingDocument.BillingDocument = toVisit.BillingDocument

  association [1..1] to I_LstMiRoute                  as _Route            on $projection.LastMileRouteUUID = _Route.LastMileRouteUUID
  association [1..*] to I_LstMiSDOutbDelivToSDInvoice as _OutboundDelivery on $projection.Invoice = _OutboundDelivery.Invoice

{
  key    toVisit.BillingDocument                                                       as Invoice,
         toVisit.LastMileRouteVisitUUID                                                as LastMileRouteVisitUUID,
         toVisit.LastMileRouteUUID                                                     as LastMileRouteUUID,
         @Semantics.amount.currencyCode: 'TransactionCurrency'
         cast( ( TotalNetAmount + TotalTaxAmount ) as lmd_sd_invoice_total_gross_amt ) as TotalGrossAmount,
         @Semantics.currencyCode: true
         TransactionCurrency                                                           as TransactionCurrency,
         CustomerPaymentTerms                                                          as CustomerPaymentTerms,
         AccountingDocument                                                            as AccountingDocument,
         FiscalYear                                                                    as FiscalYear,
         CompanyCode                                                                   as CompanyCode,
         OverallSDProcessStatus                                                        as OverallSDProcessStatus,
         OverallBillingStatus                                                          as OverallBillingStatus,
         billingDocument.SDDocumentCategory                                            as SDDocumentCategory,
         _AccountingDocument.AccountingDocumentCategory                                as AccountingDocumentCategory,
         

         _Route,
         _TransactionCurrency,
         _CustomerPaymentTerms,
         _OutboundDelivery
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"I_BILLINGDOCUMENT",
"P_LSTMIRTEVSTTOBILLINGDOCUMENT"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_CUSTOMERPAYMENTTERMS",
"I_LSTMIROUTE",
"I_LSTMISDOUTBDELIVTOSDINVOICE"
],
"BASE":
[
"I_BILLINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More