I_CABPINVCITEMENHCDFORDSPCRCY

CDS View

Enhanced BP Invc Item for Dsp Crcy

I_CABPINVCITEMENHCDFORDSPCRCY is a CDS View in S/4HANA. Enhanced BP Invc Item for Dsp Crcy. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_CABPInvcItemEnhcdForDspCrcy view_entity from COMPOSITE Enhanced BP Invc Item for Dsp Crcy
A_CABusPartInvoiceItem view_entity from COMPOSITE Business Partner Invoice Item
P_CABusPartInvcItemSumForDC view_entity from COMPOSITE 
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking : #REQUIRED

@EndUserText.label: 'Enhanced BP Invc Item for Dsp Crcy'

define view entity I_CABPInvcItemEnhcdForDspCrcy
  with parameters
    P_DisplayCurrency : waers_curc

  as select from I_CABusPartInvoiceItem                                                          as BusPartInvoiceItem
    join         P_CADocCtnDocBPItemSumForDC (P_DisplayCurrency : $parameters.P_DisplayCurrency) as DocCtnDocBPItemSumForDC on  BusPartInvoiceItem.CADocument             = DocCtnDocBPItemSumForDC.CADocument
                                                                                                                            and BusPartInvoiceItem.CARepetitionItemNumber = DocCtnDocBPItemSumForDC.CARepetitionItemNumber
                                                                                                                            and BusPartInvoiceItem.CABPItemNumber         = DocCtnDocBPItemSumForDC.CABPItemNumber

  association [0..1] to I_CAClearingReason           as _ClearingReason              on  $projection.CAClearingReason = _ClearingReason.CAClearingReason
  association [0..1] to I_CABusPartInvoiceItemStatus as _BusPartnerInvoiceItemStatus on  $projection.CABusPartnerInvoiceItemStatus = _BusPartnerInvoiceItemStatus.CABusPartnerInvoiceItemStatus

{
      //I_CABusPartInvoiceItem

  key BusPartInvoiceItem.CABusPartnerInvoiceUUID,
  key BusPartInvoiceItem.CABusPartnerInvoiceItem,

      //status

      @ObjectModel.foreignKey.association: '_BusPartnerInvoiceItemStatus'
      cast( case
        when DocCtnDocBPItemSumForDC.CAClearingAmountInDisplayCrcy = 0
          then '01'  //open

        when DocCtnDocBPItemSumForDC.CAOpenAmountInTransactionCrcy = 0
          then '02'  //paid

        when DocCtnDocBPItemSumForDC.CAReleasedAmtInTransCurrency = DocCtnDocBPItemSumForDC.CAOpenAmountInTransactionCrcy
         and DocCtnDocBPItemSumForDC.CAClearingAmountInDisplayCrcy = 0
          then '04'  //released

        else   '03'  //partly paid/released

      end as inv_item_status_dc_kk) as CABusPartnerInvoiceItemStatus,

      //header data

      BusPartInvoiceItem.CADocumentContainerRefType,
      BusPartInvoiceItem.CADocumentContainerReference,
      BusPartInvoiceItem.CreationDate,
      BusPartInvoiceItem.CreationTime,

      //document key

      BusPartInvoiceItem.CADocument,
      BusPartInvoiceItem.CARepetitionItemNumber,
      BusPartInvoiceItem.CABPItemNumber,

      //container item data

      BusPartInvoiceItem.BusinessPartner,
      BusPartInvoiceItem.ContractAccount,
      BusPartInvoiceItem.CAContract,
      BusPartInvoiceItem.CASubApplication,
      BusPartInvoiceItem.CompanyCode,

      //P_CADocCtnDocBPItemSumForDC

      DocCtnDocBPItemSumForDC.CADocumentOriginCode,
      DocCtnDocBPItemSumForDC.CABPItemText,
      DocCtnDocBPItemSumForDC.BusinessArea,
      DocCtnDocBPItemSumForDC.Segment,
      DocCtnDocBPItemSumForDC.CACashDiscountRate,
      DocCtnDocBPItemSumForDC.CAGroupingForPayment,
      DocCtnDocBPItemSumForDC.CAApplicationArea,
      DocCtnDocBPItemSumForDC.CAMainTransaction,
      DocCtnDocBPItemSumForDC.CASubTransaction,
      @ObjectModel.foreignKey.association: '_ClearingReason'
      DocCtnDocBPItemSumForDC.CAClearingReason,

      //dates

      DocCtnDocBPItemSumForDC.DocumentDate,
      DocCtnDocBPItemSumForDC.CAPostingDate,
      DocCtnDocBPItemSumForDC.CANetDueDate,
      DocCtnDocBPItemSumForDC.CADeferralDate,
      DocCtnDocBPItemSumForDC.CACashDiscountDueDate,
      DocCtnDocBPItemSumForDC.CAValueDateForClearing,
      DocCtnDocBPItemSumForDC.CAClearingDate,
      DocCtnDocBPItemSumForDC.ExchangeRateDate,

      //amounts in transaction currency

      @ObjectModel.foreignKey.association: '_Currency'
      DocCtnDocBPItemSumForDC.TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      DocCtnDocBPItemSumForDC.CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      DocCtnDocBPItemSumForDC.CAOpenAmountInTransactionCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      DocCtnDocBPItemSumForDC.CACashDiscountAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      DocCtnDocBPItemSumForDC.CAEligibleAmountForCshDiscInTC,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      DocCtnDocBPItemSumForDC.CAReleasedAmtInTransCurrency,

      //amounts in display currency

      @ObjectModel.foreignKey.association: '_DisplayCurrency'
      DocCtnDocBPItemSumForDC.DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      DocCtnDocBPItemSumForDC.AmountInDisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      DocCtnDocBPItemSumForDC.OpenAmountInDisplayCrcy,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      DocCtnDocBPItemSumForDC.CashDiscountAmountInDspCrcy,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      DocCtnDocBPItemSumForDC.CAEligibleAmountForCshDiscInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      DocCtnDocBPItemSumForDC.CAReleasedAmtInDisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      DocCtnDocBPItemSumForDC.CAClearingAmountInDisplayCrcy,

      /* Associations */
      _ClearingReason,
      _BusPartnerInvoiceItemStatus,
      //I_CABusPartInvoiceItem

      BusPartInvoiceItem._BusPartnerInvoice,
      BusPartInvoiceItem._DocCtnRefType,
      BusPartInvoiceItem._DocHeader,
      BusPartInvoiceItem._BusinessPartner,
      BusPartInvoiceItem._ContractAccount,
      BusPartInvoiceItem._ContractAccountPartner,
      BusPartInvoiceItem._SubApplication,
      BusPartInvoiceItem._CompCode,
      //P_CADocCtnDocBPItemSum

      DocCtnDocBPItemSumForDC._BusinessArea,
      DocCtnDocBPItemSumForDC._Segment,
      DocCtnDocBPItemSumForDC._ApplArea,
      DocCtnDocBPItemSumForDC._MainTransaction,
      DocCtnDocBPItemSumForDC._SubTransaction,
      DocCtnDocBPItemSumForDC._Currency,
      DocCtnDocBPItemSumForDC._DisplayCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CABUSPARTINVOICEITEM",
"P_CADOCCTNDOCBPITEMSUMFORDC"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_BUSINESSPARTNER",
"I_CAAPPLICATIONAREA",
"I_CABUSPARTINVOICE",
"I_CABUSPARTINVOICEITEMSTATUS",
"I_CACLEARINGREASON",
"I_CADOCCTNREFTYPE",
"I_CADOCUMENTHEADER",
"I_CAMAINTRANSACTION",
"I_CASUBAPPLICATION",
"I_CASUBTRANSACTION",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTHEADER",
"I_CONTRACTACCOUNTPARTNER",
"I_CURRENCY",
"I_SEGMENT"
],
"BASE":
[
"I_CABUSPARTINVOICEITEM",
"P_CADOCCTNDOCBPITEMSUMFORDC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More