I_CABPInvcItemEnhcdForDspCrcy

DDL: I_CABPINVCITEMENHCDFORDSPCRCY Type: view_entity COMPOSITE
62 Fields 1 Data Sources 2 Associations

Enhanced BP Invc Item for Dsp Crcy

I_CABPInvcItemEnhcdForDspCrcy is a Composite CDS View that provides data about "Enhanced BP Invc Item for Dsp Crcy" in SAP S/4HANA. It reads from 1 data source (I_CABusPartInvoiceItem) and exposes 62 fields with key fields CABusPartnerInvoiceUUID, CABusPartnerInvoiceItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CABusPartInvoiceItem BusPartInvoiceItem from

Parameters (1)

NameTypeDefault
P_DisplayCurrency waers_curc

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CAClearingReason _ClearingReason $projection.CAClearingReason = _ClearingReason.CAClearingReason
[0..1] I_CABusPartInvoiceItemStatus _BusPartnerInvoiceItemStatus $projection.CABusPartnerInvoiceItemStatus = _BusPartnerInvoiceItemStatus.CABusPartnerInvoiceItemStatus

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Enhanced BP Invc Item for Dsp Crcy view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY CABusPartnerInvoiceUUID I_CABusPartInvoiceItem CABusPartnerInvoiceUUID
KEY CABusPartnerInvoiceItem I_CABusPartInvoiceItem CABusPartnerInvoiceItem
CADocumentContainerRefType I_CABusPartInvoiceItem CADocumentContainerRefType
CADocumentContainerReference I_CABusPartInvoiceItem CADocumentContainerReference
CreationDate I_CABusPartInvoiceItem CreationDate Time Stamp
CreationTime I_CABusPartInvoiceItem CreationTime Time of Change
CADocument I_CABusPartInvoiceItem CADocument CA Document No.
CARepetitionItemNumber I_CABusPartInvoiceItem CARepetitionItemNumber Repetition Item
CABPItemNumber I_CABusPartInvoiceItem CABPItemNumber Item
BusinessPartner I_CABusPartInvoiceItem BusinessPartner Issuing Authority
ContractAccount I_CABusPartInvoiceItem ContractAccount Contract Acct
CAContract I_CABusPartInvoiceItem CAContract Contract
CASubApplication I_CABusPartInvoiceItem CASubApplication Subapplication
CompanyCode I_CABusPartInvoiceItem CompanyCode Receiver Company Code
CADocumentOriginCode DocCtnDocBPItemSumForDC CADocumentOriginCode Document Origin
CABPItemText DocCtnDocBPItemSumForDC CABPItemText Text
BusinessArea DocCtnDocBPItemSumForDC BusinessArea Business Area
Segment DocCtnDocBPItemSumForDC Segment Segment number
CACashDiscountRate DocCtnDocBPItemSumForDC CACashDiscountRate Discount rate
CAGroupingForPayment DocCtnDocBPItemSumForDC CAGroupingForPayment Pymt Grouping
CAApplicationArea DocCtnDocBPItemSumForDC CAApplicationArea ApplicationArea
CAMainTransaction DocCtnDocBPItemSumForDC CAMainTransaction Main Trans.
CASubTransaction DocCtnDocBPItemSumForDC CASubTransaction Subtransaction
CAClearingReason DocCtnDocBPItemSumForDC CAClearingReason Clearing Reason
DocumentDate DocCtnDocBPItemSumForDC DocumentDate Journal Entry Date
CAPostingDate DocCtnDocBPItemSumForDC CAPostingDate Posting Date
CANetDueDate DocCtnDocBPItemSumForDC CANetDueDate Net Due Date
CADeferralDate DocCtnDocBPItemSumForDC CADeferralDate Deferral To
CACashDiscountDueDate DocCtnDocBPItemSumForDC CACashDiscountDueDate Disct Due Date
CAValueDateForClearing DocCtnDocBPItemSumForDC CAValueDateForClearing Clear.Val.Date
CAClearingDate DocCtnDocBPItemSumForDC CAClearingDate Clearing
ExchangeRateDate DocCtnDocBPItemSumForDC ExchangeRateDate Translatn Date
TransactionCurrency DocCtnDocBPItemSumForDC TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency DocCtnDocBPItemSumForDC CAAmountInTransactionCurrency Amount
CAOpenAmountInTransactionCrcy DocCtnDocBPItemSumForDC CAOpenAmountInTransactionCrcy
CACashDiscountAmtInTransCrcy DocCtnDocBPItemSumForDC CACashDiscountAmtInTransCrcy
CAEligibleAmountForCshDiscInTC DocCtnDocBPItemSumForDC CAEligibleAmountForCshDiscInTC
CAReleasedAmtInTransCurrency DocCtnDocBPItemSumForDC CAReleasedAmtInTransCurrency
DisplayCurrency DocCtnDocBPItemSumForDC DisplayCurrency Display Currency
AmountInDisplayCurrency DocCtnDocBPItemSumForDC AmountInDisplayCurrency
OpenAmountInDisplayCrcy DocCtnDocBPItemSumForDC OpenAmountInDisplayCrcy
CashDiscountAmountInDspCrcy DocCtnDocBPItemSumForDC CashDiscountAmountInDspCrcy
CAEligibleAmountForCshDiscInDC DocCtnDocBPItemSumForDC CAEligibleAmountForCshDiscInDC
CAReleasedAmtInDisplayCurrency DocCtnDocBPItemSumForDC CAReleasedAmtInDisplayCurrency
CAClearingAmountInDisplayCrcy DocCtnDocBPItemSumForDC CAClearingAmountInDisplayCrcy
_ClearingReason _ClearingReason
_BusPartnerInvoiceItemStatus _BusPartnerInvoiceItemStatus
_BusPartnerInvoice I_CABusPartInvoiceItem _BusPartnerInvoice
_DocCtnRefType I_CABusPartInvoiceItem _DocCtnRefType
_DocHeader I_CABusPartInvoiceItem _DocHeader
_BusinessPartner I_CABusPartInvoiceItem _BusinessPartner
_ContractAccount I_CABusPartInvoiceItem _ContractAccount
_ContractAccountPartner I_CABusPartInvoiceItem _ContractAccountPartner
_SubApplication I_CABusPartInvoiceItem _SubApplication
_CompCode I_CABusPartInvoiceItem _CompCode
_BusinessArea DocCtnDocBPItemSumForDC _BusinessArea
_Segment DocCtnDocBPItemSumForDC _Segment
_ApplArea DocCtnDocBPItemSumForDC _ApplArea
_MainTransaction DocCtnDocBPItemSumForDC _MainTransaction
_SubTransaction DocCtnDocBPItemSumForDC _SubTransaction
_Currency DocCtnDocBPItemSumForDC _Currency
_DisplayCurrency DocCtnDocBPItemSumForDC _DisplayCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CABPInvcItemEnhcdForDspCrcy.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_DisplayCurrency : waers_curc

CREATE VIEW I_CABPInvcItemEnhcdForDspCrcy AS
SELECT
  BusPartInvoiceItem.CABusPartnerInvoiceUUID AS CABusPartnerInvoiceUUID,
  BusPartInvoiceItem.CABusPartnerInvoiceItem AS CABusPartnerInvoiceItem,
  BusPartInvoiceItem.CADocumentContainerRefType AS CADocumentContainerRefType,
  BusPartInvoiceItem.CADocumentContainerReference AS CADocumentContainerReference,
  BusPartInvoiceItem.CreationDate AS CreationDate,
  BusPartInvoiceItem.CreationTime AS CreationTime,
  BusPartInvoiceItem.CADocument AS CADocument,
  BusPartInvoiceItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  BusPartInvoiceItem.CABPItemNumber AS CABPItemNumber,
  BusPartInvoiceItem.BusinessPartner AS BusinessPartner,
  BusPartInvoiceItem.ContractAccount AS ContractAccount,
  BusPartInvoiceItem.CAContract AS CAContract,
  BusPartInvoiceItem.CASubApplication AS CASubApplication,
  BusPartInvoiceItem.CompanyCode AS CompanyCode,
  DocCtnDocBPItemSumForDC.CADocumentOriginCode AS CADocumentOriginCode,
  DocCtnDocBPItemSumForDC.CABPItemText AS CABPItemText,
  DocCtnDocBPItemSumForDC.BusinessArea AS BusinessArea,
  DocCtnDocBPItemSumForDC.Segment AS Segment,
  DocCtnDocBPItemSumForDC.CACashDiscountRate AS CACashDiscountRate,
  DocCtnDocBPItemSumForDC.CAGroupingForPayment AS CAGroupingForPayment,
  DocCtnDocBPItemSumForDC.CAApplicationArea AS CAApplicationArea,
  DocCtnDocBPItemSumForDC.CAMainTransaction AS CAMainTransaction,
  DocCtnDocBPItemSumForDC.CASubTransaction AS CASubTransaction,
  DocCtnDocBPItemSumForDC.CAClearingReason AS CAClearingReason,
  DocCtnDocBPItemSumForDC.DocumentDate AS DocumentDate,
  DocCtnDocBPItemSumForDC.CAPostingDate AS CAPostingDate,
  DocCtnDocBPItemSumForDC.CANetDueDate AS CANetDueDate,
  DocCtnDocBPItemSumForDC.CADeferralDate AS CADeferralDate,
  DocCtnDocBPItemSumForDC.CACashDiscountDueDate AS CACashDiscountDueDate,
  DocCtnDocBPItemSumForDC.CAValueDateForClearing AS CAValueDateForClearing,
  DocCtnDocBPItemSumForDC.CAClearingDate AS CAClearingDate,
  DocCtnDocBPItemSumForDC.ExchangeRateDate AS ExchangeRateDate,
  DocCtnDocBPItemSumForDC.TransactionCurrency AS TransactionCurrency,
  DocCtnDocBPItemSumForDC.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  DocCtnDocBPItemSumForDC.CAOpenAmountInTransactionCrcy AS CAOpenAmountInTransactionCrcy,
  DocCtnDocBPItemSumForDC.CACashDiscountAmtInTransCrcy AS CACashDiscountAmtInTransCrcy,
  DocCtnDocBPItemSumForDC.CAEligibleAmountForCshDiscInTC AS CAEligibleAmountForCshDiscInTC,
  DocCtnDocBPItemSumForDC.CAReleasedAmtInTransCurrency AS CAReleasedAmtInTransCurrency,
  DocCtnDocBPItemSumForDC.DisplayCurrency AS DisplayCurrency,
  DocCtnDocBPItemSumForDC.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  DocCtnDocBPItemSumForDC.OpenAmountInDisplayCrcy AS OpenAmountInDisplayCrcy,
  DocCtnDocBPItemSumForDC.CashDiscountAmountInDspCrcy AS CashDiscountAmountInDspCrcy,
  DocCtnDocBPItemSumForDC.CAEligibleAmountForCshDiscInDC AS CAEligibleAmountForCshDiscInDC,
  DocCtnDocBPItemSumForDC.CAReleasedAmtInDisplayCurrency AS CAReleasedAmtInDisplayCurrency,
  DocCtnDocBPItemSumForDC.CAClearingAmountInDisplayCrcy AS CAClearingAmountInDisplayCrcy,
  BusPartInvoiceItem._BusPartnerInvoice AS _BusPartnerInvoice,
  BusPartInvoiceItem._DocCtnRefType AS _DocCtnRefType,
  BusPartInvoiceItem._DocHeader AS _DocHeader,
  BusPartInvoiceItem._BusinessPartner AS _BusinessPartner,
  BusPartInvoiceItem._ContractAccount AS _ContractAccount,
  BusPartInvoiceItem._ContractAccountPartner AS _ContractAccountPartner,
  BusPartInvoiceItem._SubApplication AS _SubApplication,
  BusPartInvoiceItem._CompCode AS _CompCode,
  DocCtnDocBPItemSumForDC._BusinessArea AS _BusinessArea,
  DocCtnDocBPItemSumForDC._Segment AS _Segment,
  DocCtnDocBPItemSumForDC._ApplArea AS _ApplArea,
  DocCtnDocBPItemSumForDC._MainTransaction AS _MainTransaction,
  DocCtnDocBPItemSumForDC._SubTransaction AS _SubTransaction,
  DocCtnDocBPItemSumForDC._Currency AS _Currency,
  DocCtnDocBPItemSumForDC._DisplayCurrency AS _DisplayCurrency
FROM I_CABusPartInvoiceItem AS BusPartInvoiceItem
LEFT OUTER JOIN I_CAClearingReason AS _ClearingReason ON CAClearingReason = _ClearingReason.CAClearingReason  -- association [0..1]
LEFT OUTER JOIN I_CABusPartInvoiceItemStatus AS _BusPartnerInvoiceItemStatus ON CABusPartnerInvoiceItemStatus = _BusPartnerInvoiceItemStatus.CABusPartnerInvoiceItemStatus  -- association [0..1]
;

Learn More