A_CABusPartInvoiceItem

DDL: A_CABUSPARTINVOICEITEM Type: view_entity COMPOSITE

Business Partner Invoice Item

A_CABusPartInvoiceItem is a Composite CDS View that provides data about "Business Partner Invoice Item" in SAP S/4HANA. It reads from 1 data source (I_CABPInvcItemEnhcdForDspCrcy) and exposes 66 fields with key fields CADocumentContainerUUID, CADocumentContainerSqncNumber. It has 2 associations to related views.

1 data source(s) 66 fields

Data Sources (1)

SourceAliasJoin Type
I_CABPInvcItemEnhcdForDspCrcy I_CABPInvcItemEnhcdForDspCrcy from

Parameters (1)

NameTypeDefault
P_DisplayCurrency waers_curc

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] A_ContractAccountPartner_2 _ContractAccountPartner $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner and $projection.ContractAccount = _ContractAccountPartner.ContractAccount

Annotations (12)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Partner Invoice Item view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY CADocumentContainerUUID CABusPartnerInvoiceUUID
KEY CADocumentContainerSqncNumber CABusPartnerInvoiceItem
CADocContainerInvoiceItmStatus CABusPartnerInvoiceItemStatus
CADocContainerInvoiceItmStsTxt
CADocumentContainerRefType CADocumentContainerRefType
CADocumentContainerRefTypeText
CADocumentContainerReference CADocumentContainerReference
CreationDate CreationDate
CreationTime CreationTime
CADocument CADocument
CARepetitionItemNumber CARepetitionItemNumber
CABPItemNumber CABPItemNumber
BusinessPartner BusinessPartner
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName
ContractAccount ContractAccount
ContractAccountName _ContractAccount ContractAccountName
CAContract CAContract
CASubApplication CASubApplication
CASubApplicationText
CompanyCode CompanyCode
CompanyCodeName _CompCode CompanyCodeName
CAReferenceDocument _DocHeader CAReferenceDocument
CADocumentOriginCode _DocHeader CADocumentOriginCode
CADocumentOriginCodeName
CADocumentType _DocHeader CADocumentType
CADocumentTypeName
ReferenceDocumentType _DocHeader ReferenceDocumentType
OriginalReferenceDocument _DocHeader OriginalReferenceDocument
LogicalSystem _DocHeader LogicalSystem
CABPItemText CABPItemText
BusinessArea BusinessArea
BusinessAreaName
Segment Segment
SegmentName
CACashDiscountRate CACashDiscountRate
CAGroupingForPayment CAGroupingForPayment
CAMainTransaction CAMainTransaction
CAMainTransactionName
CASubTransaction CASubTransaction
CASubTransactionName
CashDiscountBaseAmtIsNetAmt _CompCode CashDiscountBaseAmtIsNetAmt
CAClearingReason CAClearingReason
CAClearingReasonName
DocumentDate DocumentDate
CAPostingDate CAPostingDate
CANetDueDate CANetDueDate
CADeferralDate CADeferralDate
CACashDiscountDueDate CACashDiscountDueDate
CAValueDateForClearing CAValueDateForClearing
CAClearingDate CAClearingDate
ExchangeRateDate ExchangeRateDate
TransactionCurrency TransactionCurrency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
CAOpenAmountInTransactionCrcy CAOpenAmountInTransactionCrcy
CACashDiscountAmtInTransCrcy CACashDiscountAmtInTransCrcy
CAEligibleAmountForCshDiscInTC CAEligibleAmountForCshDiscInTC
CAReleasedAmtInTransCurrency CAReleasedAmtInTransCurrency
DisplayCurrency
AmountInDisplayCurrency AmountInDisplayCurrency
OpenAmountInDisplayCrcy OpenAmountInDisplayCrcy
CashDiscountAmountInDspCrcy CashDiscountAmountInDspCrcy
CAEligibleAmountForCshDiscInDC CAEligibleAmountForCshDiscInDC
CAReleasedAmtInDisplayCurrency CAReleasedAmtInDisplayCurrency
CAClearingAmountInDisplayCrcy CAClearingAmountInDisplayCrcy
_BusinessPartner _BusinessPartner
_ContractAccountPartner _ContractAccountPartner 
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

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

@ObjectModel.createEnabled: false
@ObjectModel.updateEnabled: false
@ObjectModel.deleteEnabled: false

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

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Business Partner Invoice Item'

define view entity A_CABusPartInvoiceItem
  with parameters
    P_DisplayCurrency : waers_curc

  as select from I_CABPInvcItemEnhcdForDspCrcy
                 (P_DisplayCurrency : $parameters.P_DisplayCurrency)

  association [1..1] to A_BusinessPartner          as _BusinessPartner        on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [1..1] to A_ContractAccountPartner_2 as _ContractAccountPartner on  $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner
                                                                              and $projection.ContractAccount = _ContractAccountPartner.ContractAccount

{

  key CABusPartnerInvoiceUUID as CADocumentContainerUUID,
  key CABusPartnerInvoiceItem as CADocumentContainerSqncNumber,

      CABusPartnerInvoiceItemStatus as CADocContainerInvoiceItmStatus,
      _BusPartnerInvoiceItemStatus._Text[1:Language = $session.system_language].CABusPartnerInvoiceItemStsText as CADocContainerInvoiceItmStsTxt,

      //header data

      CADocumentContainerRefType,
      _DocCtnRefType._DocCtnRefTypeText[1:Language = $session.system_language].CADocumentContainerRefTypeText,
      CADocumentContainerReference,
      CreationDate,
      CreationTime,

      //document key

      CADocument,
      CARepetitionItemNumber,
      CABPItemNumber,

      //container item data

      BusinessPartner,
      _BusinessPartner.BusinessPartnerFullName,
      ContractAccount,
      _ContractAccount.ContractAccountName,
      CAContract,
      CASubApplication,
      cast( _SubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText as description_kk ) as CASubApplicationText,
      CompanyCode,
      _CompCode.CompanyCodeName,

      //document header data

      _DocHeader.CAReferenceDocument,
      _DocHeader.CADocumentOriginCode,
      _DocHeader._DocOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName,
      _DocHeader.CADocumentType,
      _DocHeader._DocType._Text[1:Language = $session.system_language].CADocumentTypeName,
      _DocHeader.ReferenceDocumentType,
      _DocHeader.OriginalReferenceDocument,
      _DocHeader.LogicalSystem,

      //document item data

      CABPItemText,
      BusinessArea,
      _BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName,
      Segment,
      _Segment._Text[1:Language = $session.system_language].SegmentName,
      CACashDiscountRate,
      CAGroupingForPayment,
      CAMainTransaction,
      _MainTransaction._Text[1:Language = $session.system_language].CAMainTransactionName,
      CASubTransaction,
      _SubTransaction._Text[1:Language = $session.system_language].CASubTransactionName,
      _CompCode.CashDiscountBaseAmtIsNetAmt,
      CAClearingReason,
      _ClearingReason._Text[1:Language = $session.system_language].CAClearingReasonName,

      //document item dates

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

      //document item amounts in transaction currency

      TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAOpenAmountInTransactionCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CACashDiscountAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAEligibleAmountForCshDiscInTC,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAReleasedAmtInTransCurrency,

      //amounts in display currency

      $parameters.P_DisplayCurrency as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      AmountInDisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      OpenAmountInDisplayCrcy,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CashDiscountAmountInDspCrcy,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CAEligibleAmountForCshDiscInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CAReleasedAmtInDisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CAClearingAmountInDisplayCrcy,

      /* Associations */
      // associations for access control

      _BusinessPartner,
      _ContractAccountPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_BUSINESSPARTNER",
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_CABPINVCITEMENHCDFORDSPCRCY",
"I_CABUSPARTINVOICEITEMSTATUS",
"I_CABUSPARTINVOICEITEMSTATUST",
"I_CACLEARINGREASON",
"I_CACLEARINGREASONTEXT",
"I_CADOCCTNREFTYPE",
"I_CADOCCTNREFTYPETEXT",
"I_CADOCUMENTHEADER",
"I_CADOCUMENTORIGINCODE",
"I_CADOCUMENTORIGINCODETEXT",
"I_CADOCUMENTTYPE",
"I_CADOCUMENTTYPETEXT",
"I_CAMAINTRANSACTION",
"I_CAMAINTRANSACTIONTEXT",
"I_CASUBAPPLICATION",
"I_CASUBAPPLICATIONTEXT",
"I_CASUBTRANSACTION",
"I_CASUBTRANSACTIONTEXT",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTHEADER",
"I_SEGMENT",
"I_SEGMENTTEXT"
],
"ASSOCIATED":
[
"A_BUSINESSPARTNER",
"A_CONTRACTACCOUNTPARTNER_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More