I_BPSupplierAddrDepdntGenInfo

DDL: I_BPSUPPLIERADDRDEPDNTGENINFO SQL: IBPSUPLADDRINFO Type: view COMPOSITE
45 Fields 2 Data Sources 3 Associations

BP Supp Add Dep Gen Info

I_BPSupplierAddrDepdntGenInfo is a Composite CDS View that provides data about "BP Supp Add Dep Gen Info" in SAP S/4HANA. It reads from 2 data sources (I_BusPartAddress, I_BusinessPartnerSupplier) and exposes 45 fields with key fields BusinessPartner, AddressID. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BusPartAddress BusinessPartnerAddress from
I_BusinessPartnerSupplier BusinessPartnerSupplier inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.BusinessPartner
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] I_BPCurrentDefaultAddress _DefaultAddress _DefaultAddress.BusinessPartner = $projection.BusinessPartner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPSUPLADDRINFO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Supp Add Dep Gen Info view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusPartAddress BusinessPartner Issuing Authority
KEY AddressID I_BusPartAddress AddressID Ship-to address
Supplier I_BusinessPartnerSupplier Supplier Supplier
TrainStationNameendasTrainStationName
FactoryCalendarendasFactoryCalendar
SupplierAccountGroup I_BusinessPartnerSupplier SupplierAccountGroup Account group
TitleSupplier I_BusinessPartnerSupplier FormOfAddress Title Key
InternationalLocationNumber1 I_BusinessPartnerSupplier InternationalLocationNumber1 Location no. 1
InternationalLocationNumber2 I_BusinessPartnerSupplier InternationalLocationNumber2 Location no. 2
InternationalLocationNumber3 I_BusinessPartnerSupplier InternationalLocationNumber3 Check digit
ReferenceAccountGroup I_BusinessPartnerSupplier ReferenceAccountGroup Ref.Acct Group
SupplierAlternativePayee I_BusinessPartnerSupplier SupplierAlternativePayee Alternat. Payee
Customer I_BusinessPartnerSupplier Customer Sold-to Party
PostingIsBlocked I_BusinessPartnerSupplier PostingIsBlocked Posting Block
PurchasingIsBlocked I_BusinessPartnerSupplier PurchasingIsBlocked Purch. block
VATLiability I_BusinessPartnerSupplier VATLiability Liable for VAT
PaymentIsBlockedForSupplier I_BusinessPartnerSupplier PaymentIsBlockedForSupplier Payment block
SuplrProofOfDelivRlvtCode I_BusinessPartnerSupplier SuplrProofOfDelivRlvtCode POD-Relevant
BR_TaxIsSplit I_BusinessPartnerSupplier BR_TaxIsSplit Tax split
IsActiveEntity
AuthorizationGroup I_BusinessPartnerSupplier AuthorizationGroup AuthorizGroup
SupplierCorporateGroup I_BusinessPartnerSupplier SupplierCorporateGroup Group
ResponsibleType I_BusinessPartnerSupplier ResponsibleType Tax Type
FiscalAddress I_BusinessPartnerSupplier FiscalAddress Fiscal address
SupplierProcurementBlock I_BusinessPartnerSupplier SupplierProcurementBlock Block Function
DataExchangeInstructionKey I_BusinessPartnerSupplier DataExchangeInstructionKey Instruction Key
BPIsEqualizationTaxSubject I_BusinessPartnerSupplier BPIsEqualizationTaxSubject Equalizatn tax
BRSpcfcTaxBasePercentageCode I_BusinessPartnerSupplier BRSpcfcTaxBasePercentageCode Tax Base
DataMediumExchangeIndicator I_BusinessPartnerSupplier DataMediumExchangeIndicator DME Rec. Code
TaxNumberResponsible I_BusinessPartnerSupplier TaxNumberResponsible
TaxNumberType I_BusinessPartnerSupplier TaxNumberType Tax number type
SuplrQualityManagementSystem I_BusinessPartnerSupplier SuplrQualityManagementSystem Target QM Sys.
SuplrQltyInProcmtCertfnValidTo I_BusinessPartnerSupplier SuplrQltyInProcmtCertfnValidTo QM System To
SupplierIsSubRangeRelevant I_BusinessPartnerSupplier SupplierIsSubRangeRelevant VSR relevant
AlternativePayeeIsAllowed I_BusinessPartnerSupplier AlternativePayeeIsAllowed Payee in doc.
PaytSlipWthRefSubscriber I_BusinessPartnerSupplier PaytSlipWthRefSubscriber PBC/POR Number
SupplierIsPlantRelevant I_BusinessPartnerSupplier SupplierIsPlantRelevant Plant relevant
SupplierPlant I_BusinessPartnerSupplier SupplierPlant Plant
DeletionIndicator I_BusinessPartnerSupplier DeletionIndicator Deletion Ind.
IsBusinessPurposeCompleted I_BusinessPartnerSupplier IsBusinessPurposeCompleted Purpose Completed
PaymentReason I_BusinessPartnerSupplier PaymentReason Payment Reason
SupplierCentralDeletionIsBlock I_BusinessPartnerSupplier SupplierCentralDeletionIsBlock Deletion block
_BusinessPartner _BusinessPartner
_Supplier _Supplier
_DefaultAddress _DefaultAddress

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_BPSupplierAddrDepdntGenInfo.
-- 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.
-- SQL view name: IBPSUPLADDRINFO

CREATE VIEW I_BPSupplierAddrDepdntGenInfo AS
SELECT
  BusinessPartnerAddress.BusinessPartner AS BusinessPartner,
  BusinessPartnerAddress.AddressID AS AddressID,
  BusinessPartnerSupplier.Supplier AS Supplier,
  case when SuplAddrDepdntInformation.AddressID is not initial then SuplAddrDepdntInformation.TrainStationName else BusinessPartnerSupplier.TrainStationName end as TrainStationName AS TrainStationNameendasTrainStationName,
  case when SuplAddrDepdntInformation.AddressID is not initial then SuplAddrDepdntInformation.FactoryCalendar else BusinessPartnerSupplier.FactoryCalendar end as FactoryCalendar AS FactoryCalendarendasFactoryCalendar,
  BusinessPartnerSupplier.SupplierAccountGroup AS SupplierAccountGroup,
  BusinessPartnerSupplier.FormOfAddress AS TitleSupplier,
  BusinessPartnerSupplier.InternationalLocationNumber1 AS InternationalLocationNumber1,
  BusinessPartnerSupplier.InternationalLocationNumber2 AS InternationalLocationNumber2,
  BusinessPartnerSupplier.InternationalLocationNumber3 AS InternationalLocationNumber3,
  BusinessPartnerSupplier.ReferenceAccountGroup AS ReferenceAccountGroup,
  BusinessPartnerSupplier.SupplierAlternativePayee AS SupplierAlternativePayee,
  BusinessPartnerSupplier.Customer AS Customer,
  BusinessPartnerSupplier.PostingIsBlocked AS PostingIsBlocked,
  BusinessPartnerSupplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  BusinessPartnerSupplier.VATLiability AS VATLiability,
  BusinessPartnerSupplier.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  BusinessPartnerSupplier.SuplrProofOfDelivRlvtCode AS SuplrProofOfDelivRlvtCode,
  BusinessPartnerSupplier.BR_TaxIsSplit AS BR_TaxIsSplit,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  BusinessPartnerSupplier.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerSupplier.SupplierCorporateGroup AS SupplierCorporateGroup,
  BusinessPartnerSupplier.ResponsibleType AS ResponsibleType,
  BusinessPartnerSupplier.FiscalAddress AS FiscalAddress,
  BusinessPartnerSupplier.SupplierProcurementBlock AS SupplierProcurementBlock,
  BusinessPartnerSupplier.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  BusinessPartnerSupplier.BPIsEqualizationTaxSubject AS BPIsEqualizationTaxSubject,
  BusinessPartnerSupplier.BRSpcfcTaxBasePercentageCode AS BRSpcfcTaxBasePercentageCode,
  BusinessPartnerSupplier.DataMediumExchangeIndicator AS DataMediumExchangeIndicator,
  BusinessPartnerSupplier.TaxNumberResponsible AS TaxNumberResponsible,
  BusinessPartnerSupplier.TaxNumberType AS TaxNumberType,
  BusinessPartnerSupplier.SuplrQualityManagementSystem AS SuplrQualityManagementSystem,
  BusinessPartnerSupplier.SuplrQltyInProcmtCertfnValidTo AS SuplrQltyInProcmtCertfnValidTo,
  BusinessPartnerSupplier.SupplierIsSubRangeRelevant AS SupplierIsSubRangeRelevant,
  BusinessPartnerSupplier.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  BusinessPartnerSupplier.PaytSlipWthRefSubscriber AS PaytSlipWthRefSubscriber,
  BusinessPartnerSupplier.SupplierIsPlantRelevant AS SupplierIsPlantRelevant,
  BusinessPartnerSupplier.SupplierPlant AS SupplierPlant,
  BusinessPartnerSupplier.DeletionIndicator AS DeletionIndicator,
  BusinessPartnerSupplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BusinessPartnerSupplier.PaymentReason AS PaymentReason,
  BusinessPartnerSupplier.SupplierCentralDeletionIsBlock AS SupplierCentralDeletionIsBlock
FROM I_BusPartAddress AS BusinessPartnerAddress
INNER JOIN I_BusinessPartnerSupplier AS BusinessPartnerSupplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _DefaultAddress ON _DefaultAddress.BusinessPartner = BusinessPartner  -- association [1..1]
;

Learn More