P_JP_ForeignBPClearedItem

DDL: P_JP_FOREIGNBPCLEAREDITEM Type: view_entity CONSUMPTION
14 Fields 1 Data Sources 2 Associations

P_JP_ForeignBPClearedItem is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItem) and exposes 14 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItem BPClearedItem from

Parameters (2)

NameTypeDefault
p_period_from date_from
p_company_code bukrs

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Industries _IndustryCustomer BPIndustry.IndustrySector = _IndustryCustomer.IndustrySector and BPIndustry.IndustrySystemType = _IndustryCustomer.IndustrySystemType
[1..1] I_CalendarDate _PostingCalendar BPClearedItem.CAPostingDateOfClearingDoc = _PostingCalendar.CalendarDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItem CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItem CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItem CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItem CASubItemNumber Subitem
CompanyCode I_CADocumentBPItem CompanyCode Receiver Company Code
CountryCode
CAAccountDeterminationCode I_CADocumentBPItem CAAccountDeterminationCode Acct Determ. ID
CAMainTransaction I_CADocumentBPItem CAMainTransaction Main Trans.
CASubTransaction I_CADocumentBPItem CASubTransaction Subtransaction
TransactionCurrency I_CADocumentBPItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_CADocumentBPItem CAAmountInTransactionCurrency Amount
LocalCurrency I_CADocumentBPItem CompanyCodeCurrency Local Currency
TransactionAmountInLocalCrcy I_CADocumentBPItem CAAmountInLocalCurrency Local Crcy Amt
JP_CentralBkPaymentReportStyle

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_JP_ForeignBPClearedItem.
-- 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_period_from : date_from, p_company_code : bukrs

CREATE VIEW P_JP_ForeignBPClearedItem AS
SELECT
  BPClearedItem.CADocumentNumber AS CADocumentNumber,
  BPClearedItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  BPClearedItem.CABPItemNumber AS CABPItemNumber,
  BPClearedItem.CASubItemNumber AS CASubItemNumber,
  BPClearedItem.CompanyCode AS CompanyCode,
  BPClearedItem._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS CountryCode,
  BPClearedItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  BPClearedItem.CAMainTransaction AS CAMainTransaction,
  BPClearedItem.CASubTransaction AS CASubTransaction,
  BPClearedItem.TransactionCurrency AS TransactionCurrency,
  BPClearedItem.CAAmountInTransactionCurrency AS AmountInTransactionCurrency,
  BPClearedItem.CompanyCodeCurrency AS LocalCurrency,
  BPClearedItem.CAAmountInLocalCurrency AS TransactionAmountInLocalCrcy,
  cast( 'S4' as scbr_style ) AS JP_CentralBkPaymentReportStyle
FROM I_CADocumentBPItem AS BPClearedItem
LEFT OUTER JOIN I_Industries AS _IndustryCustomer ON BPIndustry.IndustrySector = _IndustryCustomer.IndustrySector AND BPIndustry.IndustrySystemType = _IndustryCustomer.IndustrySystemType  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PostingCalendar ON BPClearedItem.CAPostingDateOfClearingDoc = _PostingCalendar.CalendarDate  -- association [1..1]
;

Learn More