A_CABPInvcItemEnhcdForDspCrcy

DDL: A_CABPINVCITEMENHCDFORDSPCRCY Type: view_entity COMPOSITE
48 Fields 1 Data Sources 2 Associations

Enhanced BP Invc Item for Dsp Crcy

A_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_CABPInvcItemEnhcdForDspCrcy) and exposes 48 fields with key fields CABusPartnerInvoiceUUID, CABusPartnerInvoiceItem. It has 2 associations to related views.

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 (13)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Enhanced BP Invc Item for Dsp Crcy view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.createEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name CABPInvcItemEnhcdForDspCrcy_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY CABusPartnerInvoiceUUID CABusPartnerInvoiceUUID
KEY CABusPartnerInvoiceItem CABusPartnerInvoiceItem
CABusPartnerInvoiceItemStatus CABusPartnerInvoiceItemStatus
CADocumentContainerRefType CADocumentContainerRefType
CADocumentContainerReference CADocumentContainerReference
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CADocument CADocument CA Document No.
CARepetitionItemNumber CARepetitionItemNumber Repetition Item
CABPItemNumber CABPItemNumber Item
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CompanyCode CompanyCode Receiver Company Code
CADocumentOriginCode CADocumentOriginCode Document Origin
CABPItemText CABPItemText Text
BusinessArea BusinessArea Business Area
Segment Segment Segment number
CACashDiscountRate CACashDiscountRate Discount rate
CAGroupingForPayment CAGroupingForPayment Pymt Grouping
CAApplicationArea CAApplicationArea ApplicationArea
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAClearingReason CAClearingReason Clearing Reason
DocumentDate DocumentDate Journal Entry Date
CAPostingDate CAPostingDate Posting Date
CANetDueDate CANetDueDate Net Due Date
CADeferralDate CADeferralDate Deferral To
CACashDiscountDueDate CACashDiscountDueDate Disct Due Date
CAValueDateForClearing CAValueDateForClearing Clear.Val.Date
CAClearingDate CAClearingDate Clearing
ExchangeRateDate ExchangeRateDate Translatn Date
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
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

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 A_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 A_CABPInvcItemEnhcdForDspCrcy AS
SELECT
  CABusPartnerInvoiceUUID,
  CABusPartnerInvoiceItem,
  CABusPartnerInvoiceItemStatus,
  CADocumentContainerRefType,
  CADocumentContainerReference,
  CreationDate,
  CreationTime,
  CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  BusinessPartner,
  ContractAccount,
  CAContract,
  CASubApplication,
  CompanyCode,
  CADocumentOriginCode,
  CABPItemText,
  BusinessArea,
  Segment,
  CACashDiscountRate,
  CAGroupingForPayment,
  CAApplicationArea,
  CAMainTransaction,
  CASubTransaction,
  CAClearingReason,
  DocumentDate,
  CAPostingDate,
  CANetDueDate,
  CADeferralDate,
  CACashDiscountDueDate,
  CAValueDateForClearing,
  CAClearingDate,
  ExchangeRateDate,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CAOpenAmountInTransactionCrcy,
  CACashDiscountAmtInTransCrcy,
  CAEligibleAmountForCshDiscInTC,
  CAReleasedAmtInTransCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  AmountInDisplayCurrency,
  OpenAmountInDisplayCrcy,
  CashDiscountAmountInDspCrcy,
  CAEligibleAmountForCshDiscInDC,
  CAReleasedAmtInDisplayCurrency,
  CAClearingAmountInDisplayCrcy
FROM I_CABPInvcItemEnhcdForDspCrcy
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN A_ContractAccountPartner_2 AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [1..1]
;

Learn More