C_Customer360CancelledInvoice

DDL: C_CUSTOMER360CANCELLEDINVOICE Type: view_entity CONSUMPTION Package: ODATA_SD_ADVNCD_CUSTOMER360

Customer 360 Invoice Cancelled

C_Customer360CancelledInvoice is a Consumption CDS View that provides data about "Customer 360 Invoice Cancelled" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocument, I_Customer360BusDocSetting) and exposes 15 fields with key field BillingDocument. It is exposed through 1 OData service (SD_ADVNCD_CUSTOMER360). Part of development package ODATA_SD_ADVNCD_CUSTOMER360.

2 data source(s) Exposed by 1 service(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_BillingDocument CancelledInvoice from
I_Customer360BusDocSetting Customer360BusDocSetting inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer 360 Invoice Cancelled view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
SD_ADVNCD_CUSTOMER360 SD_ADVNCD_CUSTOMER360 V4 C1 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument
SoldToParty I_BillingDocument SoldToParty
CustomerName
BillingDocumentType I_BillingDocument BillingDocumentType
BillingDocumentTypeName
OverallBillingStatus I_BillingDocument OverallBillingStatus
OverallBillingStatusDesc
BillingDocumentDate I_BillingDocument BillingDocumentDate
CreationDate I_BillingDocument CreationDate
SalesOrganization I_BillingDocument SalesOrganization
SalesOrganizationName
TotalNetAmount I_BillingDocument TotalNetAmount
TransactionCurrency I_BillingDocument TransactionCurrency
CurrencyName
_SoldToParty I_BillingDocument _SoldToParty 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Customer 360 Invoice Cancelled'
@Metadata.allowExtensions: true
@Search.searchable: true
@ObjectModel: {
//   compositionRoot: true,

//   representativeKey: 'SalesDocument',

   usageType: {
 dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #XXL
   }
}
@VDM.viewType: #CONSUMPTION
define view entity C_Customer360CancelledInvoice
  as select from I_BillingDocument          as CancelledInvoice
    inner join   I_Customer360BusDocSetting as Customer360BusDocSetting on Customer360BusDocSetting.Cust360BusDocCategory     = 'N'
                                                                        and Customer360BusDocSetting.BusinessDocumentIsEnabled = 'X'
                                                                        and CancelledInvoice.SDDocumentCategory = 'N'
                                                                       
//     association [0..1] to C_SoldToValueHelp         as _SoldToPartyVH           on  $projection.SoldToParty = _SoldToPartyVH.Customer

{
@Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key CancelledInvoice.BillingDocument as BillingDocument,      
      
      @ObjectModel.text.element: ['CustomerName'] 
      @ObjectModel.foreignKey.association: '_SoldToParty'
      CancelledInvoice.SoldToParty,
      
        @UI.hidden: true
      CancelledInvoice._SoldToParty.CustomerName as CustomerName,
      
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
       @ObjectModel.text.element: ['BillingDocumentTypeName']
      CancelledInvoice.BillingDocumentType,
      @UI.hidden: true
      CancelledInvoice._BillingDocumentType._Text[1:Language = $session.system_language].BillingDocumentTypeName as BillingDocumentTypeName,
      
      @UI.textArrangement: #TEXT_ONLY
       @ObjectModel.text.element: ['OverallBillingStatusDesc']
      CancelledInvoice.OverallBillingStatus,
      @UI.hidden: true
      CancelledInvoice._OverallBillingStatus._Text[1:Language = $session.system_language].OverallBillingStatusDesc as OverallBillingStatusDesc,
      
      CancelledInvoice.BillingDocumentDate,
      CancelledInvoice.CreationDate,
   

//    For DCL

       @ObjectModel.text.element: ['SalesOrganizationName']
      CancelledInvoice.SalesOrganization,
      @UI.hidden: true
      CancelledInvoice._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName as SalesOrganizationName,
      
      CancelledInvoice.TotalNetAmount,

      //  Associations

       @ObjectModel.text.element: ['CurrencyName']
      CancelledInvoice.TransactionCurrency,
      @UI.hidden: true
      CancelledInvoice._TransactionCurrency._Text[1:Language = $session.system_language].CurrencyName as CurrencyName,
      
//      CancelledInvoice.TransactionCurrency,

     
      CancelledInvoice._SoldToParty

}
where CancelledInvoice.CreationDate > dats_add_days( tstmp_to_dats(tstmp_current_utctimestamp(), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), -Customer360BusDocSetting.BusDocumentDurationInDays, 'INITIAL')
  and CancelledInvoice.CreationDate <= $session.system_date

Learn More