A_CABusPartInvoice

DDL: A_CABUSPARTINVOICE Type: view_entity COMPOSITE Package: ODATA_API_FICA_BP_INVOICE
16 Fields 1 Data Sources 1 Associations 1 OData Services

Business Partner Invoice

A_CABusPartInvoice is a Composite CDS View that provides data about "Business Partner Invoice" in SAP S/4HANA. It reads from 1 data source (I_CABusPartInvcEnhcdForDspCrcy) and exposes 16 fields with key field CADocumentContainerUUID. It has 1 association to related views. It is exposed through 1 OData service (API_CABUSPARTINVOICE). Part of development package ODATA_API_FICA_BP_INVOICE.

Data Sources (1)

SourceAliasJoin Type
I_CABusPartInvcEnhcdForDspCrcy I_CABusPartInvcEnhcdForDspCrcy from

Parameters (1)

NameTypeDefault
P_DisplayCurrency waers_curc

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_CABusPartInvoiceCorrespnc _BusPartInvoiceCorrespnc $projection.CADocumentContainerUUID = _BusPartInvoiceCorrespnc.CADocumentContainerUUID

Annotations (11)

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
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Partner Invoice view

OData Services (1)

ServiceBindingVersionContractRelease
API_CABUSPARTINVOICE API_CABUSPARTINVOICE V4 C2 Deprecated

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CADocumentContainerUUID CABusPartnerInvoiceUUID
CADocContainerInvoiceStatus CABusPartnerInvoiceStatus
CADocContainerInvoiceStatusTxt
CADocumentContainerRefType CADocumentContainerRefType
CADocumentContainerRefTypeText
CADocumentContainerReference CADocumentContainerReference
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
DisplayCurrency DisplayCurrency Display Currency
CAInvoiceAmountInDisplayCrcy CAInvoiceAmountInDisplayCrcy
OpenAmountInDisplayCrcy OpenAmountInDisplayCrcy
CashDiscountAmountInDspCrcy CashDiscountAmountInDspCrcy
CAEligibleAmountForCshDiscInDC CAEligibleAmountForCshDiscInDC
CAReleasedAmtInDisplayCurrency CAReleasedAmtInDisplayCurrency
CAClearingAmountInDisplayCrcy CAClearingAmountInDisplayCrcy
_BusPartInvoiceCorrespnc _BusPartInvoiceCorrespnc

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_CABusPartInvoice.
-- 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_CABusPartInvoice AS
SELECT
  CABusPartnerInvoiceUUID AS CADocumentContainerUUID,
  CABusPartnerInvoiceStatus AS CADocContainerInvoiceStatus,
  _BusPartnerInvoiceStatus._Text[1:Language = $session.system_language].CABusPartnerInvoiceStatusText AS CADocContainerInvoiceStatusTxt,
  CADocumentContainerRefType,
  _DocCtnRefType._DocCtnRefTypeText[1:Language = $session.system_language].CADocumentContainerRefTypeText AS CADocumentContainerRefTypeText,
  CADocumentContainerReference,
  CreationDate,
  CreationTime,
  DisplayCurrency,
  CAInvoiceAmountInDisplayCrcy,
  OpenAmountInDisplayCrcy,
  CashDiscountAmountInDspCrcy,
  CAEligibleAmountForCshDiscInDC,
  CAReleasedAmtInDisplayCurrency,
  CAClearingAmountInDisplayCrcy
FROM I_CABusPartInvcEnhcdForDspCrcy
LEFT OUTER JOIN A_CABusPartInvoiceCorrespnc AS _BusPartInvoiceCorrespnc ON CADocumentContainerUUID = _BusPartInvoiceCorrespnc.CADocumentContainerUUID  -- association [0..*]
;

Learn More