P_CADocCtnDocBPItemCalc

DDL: P_CADOCCTNDOCBPITEMCALC Type: view_entity COMPOSITE
47 Fields 1 Data Sources

P_CADocCtnDocBPItemCalc is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_CADocCtnDocBPItem) and exposes 47 fields with key fields CADocument, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

Data Sources (1)

SourceAliasJoin Type
P_CADocCtnDocBPItem P_CADocCtnDocBPItem from

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

KeyFieldSource TableSource FieldDescription
KEY CADocument CADocument CA Document No.
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
CompanyCode CompanyCode Receiver Company Code
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
CAGroupingForPaymentCategory CAGroupingForPaymentCategory
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
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAOpenAmountInTransactionCrcy
CACashDiscountAmtInTransCrcy CACashDiscountAmtInTransCrcy
CAEligibleAmountForCshDiscInTC CAEligibleAmountForCshDiscInTC Disc. base
CAClearingCurrency CAClearingCurrency Clearing Curr.
CAClearingAmountInClearingCrcy CAClearingAmountInClearingCrcy Clearing Amount
CACashDiscAmountInClearingCrcy CACashDiscAmountInClearingCrcy Discnt/Surchrge
_DocHeader _DocHeader
_CompCode _CompCode
_BusinessArea _BusinessArea
_Segment _Segment
_BusinessPartner _BusinessPartner
_ClearingStatus _ClearingStatus
_ApplArea _ApplArea
_MainTransaction _MainTransaction
_SubTransaction _SubTransaction
_ClearingReason _ClearingReason
_ClearingDocHeader _ClearingDocHeader
_Currency _Currency
_ClearingCurrency _ClearingCurrency

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_CADocCtnDocBPItemCalc.
-- 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.

CREATE VIEW P_CADocCtnDocBPItemCalc AS
SELECT
  CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CompanyCode,
  BusinessArea,
  Segment,
  BusinessPartner,
  CADocumentOriginCode,
  CABPItemText,
  CAClearingStatus,
  CACashDiscountRate,
  CAGroupingForPayment,
  CAGroupingForPaymentCategory,
  CAApplicationArea,
  CAMainTransaction,
  CASubTransaction,
  CAClearingReason,
  CAClearingDocumentNumber,
  DocumentDate,
  CAPostingDate,
  CANetDueDate,
  CADeferralDate,
  CACashDiscountDueDate,
  CAValueDateForClearing,
  CAClearingDate,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CAOpenAmountInTransactionCrcy - CACashDiscountAmtInTransCrcy AS CAOpenAmountInTransactionCrcy,
  CACashDiscountAmtInTransCrcy,
  CAEligibleAmountForCshDiscInTC,
  CAClearingCurrency,
  CAClearingAmountInClearingCrcy,
  CACashDiscAmountInClearingCrcy
FROM P_CADocCtnDocBPItem
;

Learn More