P_CADocCtnDocBPItemForDC

DDL: P_CADOCCTNDOCBPITEMFORDC Type: view_entity COMPOSITE
44 Fields 1 Data Sources 1 Associations

P_CADocCtnDocBPItemForDC is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_CADocCtnDocBPItemCalc) and exposes 44 fields with key fields CADocument, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CADocCtnDocBPItemCalc P_CADocCtnDocBPItemCalc from

Parameters (1)

NameTypeDefault
P_DisplayCurrency waers_curc

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Currency _DisplayCurrency $projection.DisplayCurrency = _DisplayCurrency.Currency

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CADocument CADocument CA Document No.
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
BusinessArea BusinessArea Business Area
Segment Segment Segment number
BusinessPartner BusinessPartner Issuing Authority
CADocumentOriginCode CADocumentOriginCode Document Origin
CABPItemText CABPItemText Text
CAClearingStatus CAClearingStatus Clearing Status
CACashDiscountRate CACashDiscountRate Discount rate
CAGroupingForPayment CAGroupingForPayment Pymt Grouping
CAApplicationArea CAApplicationArea ApplicationArea
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAClearingReason CAClearingReason Clearing Reason
CAClearingDocumentNumber CAClearingDocumentNumber Clearing Doc.
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
_DocHeader _DocHeader
_BusinessArea _BusinessArea
_Segment _Segment
_BusinessPartner _BusinessPartner
_ClearingStatus _ClearingStatus
_ApplArea _ApplArea
_MainTransaction _MainTransaction
_SubTransaction _SubTransaction
_ClearingReason _ClearingReason
_ClearingDocHeader _ClearingDocHeader
_Currency _Currency
_DisplayCurrency _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 P_CADocCtnDocBPItemForDC.
-- 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 P_CADocCtnDocBPItemForDC AS
SELECT
  CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  BusinessArea,
  Segment,
  BusinessPartner,
  CADocumentOriginCode,
  CABPItemText,
  CAClearingStatus,
  CACashDiscountRate,
  CAGroupingForPayment,
  CAApplicationArea,
  CAMainTransaction,
  CASubTransaction,
  CAClearingReason,
  CAClearingDocumentNumber,
  DocumentDate,
  CAPostingDate,
  CANetDueDate,
  CADeferralDate,
  CACashDiscountDueDate,
  CAValueDateForClearing,
  CAClearingDate,
  ExchangeRateDate,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CAOpenAmountInTransactionCrcy,
  CACashDiscountAmtInTransCrcy,
  CAEligibleAmountForCshDiscInTC,
  CAReleasedAmtInTransCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency
FROM P_CADocCtnDocBPItemCalc
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
;

Learn More