P_IL_CATransferredDocBPItem

DDL: P_IL_CATRANSFERREDDOCBPITEM Type: view_entity COMPOSITE Package: FKK_ID_IL_REP
37 Fields 2 Data Sources

Transferred Business Partner items

P_IL_CATransferredDocBPItem is a Composite CDS View that provides data about "Transferred Business Partner items" in SAP S/4HANA. It reads from 2 data sources (P_CATransferredDocumentHeader, P_CATransferredDocumentHeader) and exposes 37 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber, CARepetitionItemNumber. Part of development package FKK_ID_IL_REP.

Data Sources (2)

SourceAliasJoin Type
P_CATransferredDocumentHeader TransferredDocumentHeader from
P_CATransferredDocumentHeader TransferredDocumentHeader union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber P_CATransferredDocumentHeader CADocumentNumber Document Number
KEY CARepetitionItemNumber BPItem CARepetitionItemNumber Repetition Item
KEY CABPItemNumber BPItem CABPItemNumber Item
KEY CASubItemNumber BPItem CASubItemNumber Subitem
CompanyCode BPItem CompanyCode Receiver Company Code
CAReceivingCountry BPItem CAReceivingCountry Destination C/R
CADocumentType P_CATransferredDocumentHeader CADocumentType Document Type
TaxCode BPItem TaxCode Tax Code
CAAccountDeterminationCode BPItem CAAccountDeterminationCode Acct Determ. ID
BusinessPartner BPItem BusinessPartner Issuing Authority
DocumentDate P_CATransferredDocumentHeader DocumentDate Journal Entry Date
PostingDate P_CATransferredDocumentHeader PostingDate Posting Date for GR
TaxReportingDate P_CATransferredDocumentHeader TaxReportingDate Tax Reporting Date
CAReferenceDocument P_CATransferredDocumentHeader CAReferenceDocument Reference
IL_ElectronicDocOutgDocUnqID P_CATransferredDocumentHeader IL_ElectronicDocOutgDocUnqID Reference
_CompanyCode BPItem _CompanyCode
_BusinessPartner BPItem _BusinessPartner
_ReceivingCountry BPItem _ReceivingCountry
CADocumentNumber Document Number
KEY CARepetitionItemNumber Repetition Item
KEY CABPItemNumber Item
KEY CASubItemNumber Subitem
CompanyCode ReversedDocumentBPItem CompanyCode Receiver Company Code
CAReceivingCountry ReversedDocumentBPItem CAReceivingCountry Destination C/R
CADocumentType P_CATransferredDocumentHeader CADocumentType Document Type
TaxCode ReversedDocumentBPItem TaxCode Tax Code
CAAccountDeterminationCode ReversedDocumentBPItem CAAccountDeterminationCode Acct Determ. ID
BusinessPartner ReversedDocumentBPItem BusinessPartner Issuing Authority
DocumentDate P_CATransferredDocumentHeader DocumentDate Journal Entry Date
PostingDate P_CATransferredDocumentHeader PostingDate Posting Date for GR
TaxReportingDate P_CATransferredDocumentHeader TaxReportingDate Tax Reporting Date
CAReferenceDocument ReversedDocumentBPItem CAReferenceDocument Reference
IL_ElectronicDocOutgDocUnqID P_CATransferredDocumentHeader IL_ElectronicDocOutgDocUnqID Reference
_CompanyCode ReversedDocumentBPItem _CompanyCode
_BusinessPartner ReversedDocumentBPItem _BusinessPartner
_ReceivingCountry ReversedDocumentBPItem _ReceivingCountry
_CAAccountDeterminationCode ReversedDocumentBPItem _CAAccountDeterminationCode

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_IL_CATransferredDocBPItem.
-- 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_IL_CATransferredDocBPItem AS
SELECT
  TransferredDocumentHeader.CADocumentNumber AS CADocumentNumber,
  BPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  BPItem.CABPItemNumber AS CABPItemNumber,
  BPItem.CASubItemNumber AS CASubItemNumber,
  BPItem.CompanyCode AS CompanyCode,
  BPItem.CAReceivingCountry AS CAReceivingCountry,
  TransferredDocumentHeader.CADocumentType AS CADocumentType,
  BPItem.TaxCode AS TaxCode,
  BPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  BPItem.BusinessPartner AS BusinessPartner,
  TransferredDocumentHeader.DocumentDate AS DocumentDate,
  TransferredDocumentHeader.PostingDate AS PostingDate,
  TransferredDocumentHeader.TaxReportingDate AS TaxReportingDate,
  TransferredDocumentHeader.CAReferenceDocument AS CAReferenceDocument,
  TransferredDocumentHeader.IL_ElectronicDocOutgDocUnqID AS IL_ElectronicDocOutgDocUnqID,
  BPItem._CompanyCode AS _CompanyCode,
  BPItem._BusinessPartner AS _BusinessPartner,
  BPItem._ReceivingCountry AS _ReceivingCountry,
  ReversedDocumentBPItem._CAAccountDeterminationCode AS _CAAccountDeterminationCode
FROM P_CATransferredDocumentHeader AS TransferredDocumentHeader
-- UNION ALL with additional select branch(es): P_CATransferredDocumentHeader
;

Learn More