I_BillingDocumentPartnerBasic

DDL: I_BILLINGDOCUMENTPARTNERBASIC Type: view BASIC
20 Fields 2 Data Sources 1 Associations

Billing Document Partner Basic

I_BillingDocumentPartnerBasic is a Basic CDS View that provides data about "Billing Document Partner Basic" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentBasic, I_SDDocumentPartner) and exposes 20 fields with key fields BillingDocument, PartnerFunction. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentBasic BillingDocument inner
I_SDDocumentPartner Partner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BillingDocumentBasic _BillingDocumentBasic $projection.BillingDocument = _BillingDocumentBasic.BillingDocument

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Partner Basic view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISDBILDOCPTBC 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 (20)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument
KEY PartnerFunction I_SDDocumentPartner PartnerFunction Partner Functn
Customer I_SDDocumentPartner Customer Sold-to Party
Supplier I_SDDocumentPartner Supplier Supplier
Personnel I_SDDocumentPartner Personnel Personnel No.
AddressID I_SDDocumentPartner AddressID Ship-to address
ContactPerson I_SDDocumentPartner ContactPerson Contact Person Key
AddressPersonID I_SDDocumentPartner AddressPersonID Person Number
ReferenceBusinessPartner I_SDDocumentPartner ReferenceBusinessPartner Busn. Partner
SDDocPartnerAddressRefType I_SDDocumentPartner SDDocPartnerAddressRefType Adress ind.
BPRefAddressIDForDocSpcfcAddr I_SDDocumentPartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
AddressObjectType I_SDDocumentPartner AddressObjectType Address Type
VATRegistration I_SDDocumentPartner VATRegistration VAT Registration No.
UnloadingPointName I_SDDocumentPartner UnloadingPointName Unloading Point Name
_BillingDocumentBasic _BillingDocumentBasic
_PartnerFunction I_SDDocumentPartner _PartnerFunction
_Address I_SDDocumentPartner _Address
_BusinessPartnerAddress I_SDDocumentPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SDDocumentPartner _BPRefAddressForDocSpcfcAddr
_DfltAddrRprstn I_SDDocumentPartner _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_BillingDocumentPartnerBasic.
-- 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_BillingDocumentPartnerBasic AS
SELECT
  cast(Partner.SDDocument as vbeln_vf preserving type ) AS BillingDocument,
  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.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  Partner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  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_SDDocumentPartner AS Partner
INNER JOIN I_BillingDocumentBasic AS BillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingDocumentBasic AS _BillingDocumentBasic ON BillingDocument = _BillingDocumentBasic.BillingDocument  -- association [1..1]
;

Learn More