I_BillingDocItemPartnerBasic

DDL: I_BILLINGDOCITEMPARTNERBASIC Type: view BASIC
22 Fields 2 Data Sources 2 Associations

Billing Document Item Partner Basic

I_BillingDocItemPartnerBasic is a Basic CDS View that provides data about "Billing Document Item Partner Basic" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentItemBasic, I_SDDocumentItemPartner) and exposes 22 fields with key fields BillingDocument, BillingDocumentItem, PartnerFunction. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentItemBasic BillingDocumentItem inner
I_SDDocumentItemPartner Partner from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillingDocumentBasic _BillingDocumentBasic $projection.BillingDocument = _BillingDocumentBasic.BillingDocument
[1..1] I_BillingDocumentItemBasic _ItemBasic $projection.BillingDocument = _ItemBasic.BillingDocument and $projection.BillingDocumentItem = _ItemBasic.BillingDocumentItem

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Item Partner Basic view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISDBILDOCITPTBC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument
KEY BillingDocumentItem I_BillingDocumentItemBasic BillingDocumentItem Item
KEY PartnerFunction I_SDDocumentItemPartner PartnerFunction Partner Functn
Customer I_SDDocumentItemPartner Customer Sold-to Party
Supplier I_SDDocumentItemPartner Supplier Supplier
Personnel I_SDDocumentItemPartner Personnel Personnel No.
AddressID I_SDDocumentItemPartner AddressID Ship-to address
ContactPerson I_SDDocumentItemPartner ContactPerson Contact Person Key
AddressPersonID I_SDDocumentItemPartner AddressPersonID Person Number
ReferenceBusinessPartner I_SDDocumentItemPartner ReferenceBusinessPartner Busn. Partner
BPRefAddressIDForDocSpcfcAddr I_SDDocumentItemPartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
SDDocPartnerAddressRefType I_SDDocumentItemPartner SDDocPartnerAddressRefType Adress ind.
AddressObjectType I_SDDocumentItemPartner AddressObjectType Address Type
VATRegistration I_SDDocumentItemPartner VATRegistration VAT Registration No.
UnloadingPointName I_SDDocumentItemPartner UnloadingPointName Unloading Point Name
_BillingDocumentBasic _BillingDocumentBasic
_ItemBasic _ItemBasic
_PartnerFunction I_SDDocumentItemPartner _PartnerFunction
_Address I_SDDocumentItemPartner _Address
_BusinessPartnerAddress I_SDDocumentItemPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SDDocumentItemPartner _BPRefAddressForDocSpcfcAddr
_DfltAddrRprstn I_SDDocumentItemPartner _DfltAddrRprstn

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 I_BillingDocItemPartnerBasic.
-- 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 I_BillingDocItemPartnerBasic AS
SELECT
  cast(Partner.SDDocument as vbeln_vf preserving type ) AS BillingDocument,
  BillingDocumentItem.BillingDocumentItem AS BillingDocumentItem,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.Customer AS Customer,
  Partner.Supplier AS Supplier,
  Partner.Personnel AS Personnel,
  Partner.AddressID AS AddressID,
  Partner.ContactPerson AS ContactPerson,
  Partner.AddressPersonID AS AddressPersonID,
  Partner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  Partner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  Partner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  Partner.AddressObjectType AS AddressObjectType,
  Partner.VATRegistration AS VATRegistration,
  Partner.UnloadingPointName AS UnloadingPointName,
  Partner._PartnerFunction AS _PartnerFunction,
  Partner._Address AS _Address,
  Partner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  Partner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  Partner._DfltAddrRprstn AS _DfltAddrRprstn
FROM I_SDDocumentItemPartner AS Partner
INNER JOIN I_BillingDocumentItemBasic AS BillingDocumentItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingDocumentBasic AS _BillingDocumentBasic ON BillingDocument = _BillingDocumentBasic.BillingDocument  -- association [1..1]
LEFT OUTER JOIN I_BillingDocumentItemBasic AS _ItemBasic ON BillingDocument = _ItemBasic.BillingDocument AND BillingDocumentItem = _ItemBasic.BillingDocumentItem  -- association [1..1]
;

Learn More