I_SuplrBillgDocItemPartner

DDL: I_SUPLRBILLGDOCITEMPARTNER Type: view BASIC
28 Fields 1 Data Sources 3 Associations

Supplier Billing Document Item Partner

I_SuplrBillgDocItemPartner (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_SuplrBillgDocItemPartner is a Basic CDS View (Dimension) that provides data about "Supplier Billing Document Item Partner" in SAP S/4HANA. It reads from 1 data source (R_SuplrBillgDocItemPartner) and exposes 28 fields with key fields SuplrBillgDoc, SuplrBillgDocItem, PartnerFunction, PartnerCounter. It has 3 associations to related views.

SAP Help Documentation

CategorySupplier Billing Document
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering questions about supplier-partners at a billing document item level. This CDS view provides the prerequisites for answering the following business questions: What is the function of the partner (e.g. 3rd Party Supplier, Additional Contact)? What is the address of the partner?

Prerequisites
This view is based on the view I_SettlmtMgmtDocItemPartner . Users who want to run reports using this CDS view must have the authorization to display the following data: Authorization Object: W_WBRK_FKA Authorization required for Settlement Document Type ( LFART ) Authorization Object: W_WBRK_ORG Authorization required for the following: Company Code ( BUKRS ) Purchasing Organization ( EKGRP ) Purchasing Group ( EKGRP ) Authorization Object: F_LFA1_BEK Authorization group needs to be maintained for the following: Invoicing Party Invoicing Party Company Payee Party Payee Party Company Alternative Invoicing Party Alternative Invoicing Party Company Prior Supplier Supplier Authorization Object: F_KNA1_BED Authorization group needs to be maintained for the following: Customer Customer Settlement Recipient Note In SAP S/4HANA 2021 FPS01, the access control for this CDS view was enhanced with a new authorization object. It now also checks the authorization for the authorization group with regard to customer settlement recipient ( CustomerSettlmtRecipient ). If you built custom CDS views based on this view prior to SAP S/4HANA 2021 FPS01, you must adjust the access controls accordingly.

Structure
Object types This view relates to the following SAP object types: Supplier Billing Document Measures and attributes Some important measures and attributes are: Supplier Billing Document Supplier Billing Document Item Partner Function Partner Counter Supplier Customer Contact Partner Personnel Address ID VAT Registration

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AB
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Analytical Dimension
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering questions about supplier-partners at a billing document item level. </p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the function of the partner (e.g. 3rd Party Supplier, Additional Contact)?</p></li> <li><p>What is the address of the partner?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_SuplrBillgDocItemPartner R_SuplrBillgDocItemPartner from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SuplrBillgDoc _SuplrBillgDoc _SuplrBillgDoc.SuplrBillgDoc = $projection.SuplrBillgDoc
[1..1] I_SuplrBillgDocItem _SuplrBillgDocItem _SuplrBillgDocItem.SuplrBillgDoc = $projection.SuplrBillgDoc and _SuplrBillgDocItem.SuplrBillgDocItem = $projection.SuplrBillgDocItem
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IWLFSUPBDCITMPRT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey PartnerCounter view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
EndUserText.label Supplier Billing Document Item Partner view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SuplrBillgDoc SuplrBillgDoc Supplier Billing Document Number
KEY SuplrBillgDocItem SuplrBillgDocItem Document Item
KEY PartnerFunction PartnerFunction Partner Function
KEY PartnerCounter PartnerCounter Partner counter
representativekeyCreatedByUser
CreationDate CreationDate Date of Document Creation
Supplier Supplier Account Number of Supplier
Customer Customer Customer Number
ContactPerson ContactPerson Number of Contact Person
Personnel Personnel Personnel Number
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
ReferenceBusinessPartner ReferenceBusinessPartner Business Partner Number
SuplrBillgDocPartAddrRefType SuplrBillgDocPartAddrRefType Address indicator
AddressObjectType AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person)
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Determination in Document
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
VATRegistration VATRegistration VAT Registration Number
_SuplrBillgDoc _SuplrBillgDoc
_SuplrBillgDocItem _SuplrBillgDocItem
_PartnerFunction _PartnerFunction
_Supplier _Supplier
_Customer _Customer
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_PersonWorkplaceAddrDfltRprstn _PersonWorkplaceAddrDfltRprstn
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr

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_SuplrBillgDocItemPartner.
-- 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_SuplrBillgDocItemPartner AS
SELECT
  SuplrBillgDoc,
  SuplrBillgDocItem,
  PartnerFunction,
  PartnerCounter,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SuplrBillgDocPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration
FROM R_SuplrBillgDocItemPartner
LEFT OUTER JOIN I_SuplrBillgDoc AS _SuplrBillgDoc ON _SuplrBillgDoc.SuplrBillgDoc = SuplrBillgDoc  -- association [1..1]
LEFT OUTER JOIN I_SuplrBillgDocItem AS _SuplrBillgDocItem ON _SuplrBillgDocItem.SuplrBillgDoc = SuplrBillgDoc AND _SuplrBillgDocItem.SuplrBillgDocItem = SuplrBillgDocItem  -- association [1..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
;

Learn More