I_BPCustomerSalesAddressInfo

DDL: I_BPCUSTOMERSALESADDRESSINFO SQL: IBPCUSTSLSADDR Type: view COMPOSITE
49 Fields 2 Data Sources 2 Associations

BP and Cust sls Addr Depdnt Info

I_BPCustomerSalesAddressInfo is a Composite CDS View that provides data about "BP and Cust sls Addr Depdnt Info" in SAP S/4HANA. It reads from 2 data sources (I_BusPartAddress, I_Businesspartnersalesarea) and exposes 49 fields with key fields BusinessPartner, AddressID, Customer, SalesOrganization, DistributionChannel. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BusPartAddress BusinessPartnerAddress from
I_Businesspartnersalesarea Businesspartnersalesarea inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.BusinessPartner
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBPCUSTSLSADDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label BP and Cust sls Addr Depdnt Info view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusPartAddress BusinessPartner Issuing Authority
KEY AddressID I_BusPartAddress AddressID Ship-to address
KEY Customer I_Businesspartnersalesarea Customer Sold-to Party
KEY SalesOrganization I_Businesspartnersalesarea SalesOrganization Sales Organization
KEY DistributionChannel I_Businesspartnersalesarea DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_Businesspartnersalesarea Division Internal Division ID
IncotermsVersionendasIncotermsVersion
SalesOfficeendasSalesOffice
SalesGroupendasSalesGroup
SupplyingPlantendasSupplyingPlant
CustomerGroup CustomerGroup Customer Group
AccountByCustomer AccountByCustomer Acct at cust.
CustomerABCClassification CustomerABCClassification ABC class
Currency Currency Valuation Crcy
CustomerPriceGroup CustomerPriceGroup CustPrice Group
DeliveryPriority DeliveryPriority Delivery Prior.
OrderCombinationIsAllowed OrderCombinationIsAllowed Order Combinat.
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup AccAssmtGrpCust
SalesDistrict SalesDistrict Sales District
OrderIsBlockedForCustomer OrderIsBlockedForCustomer Order block
PriceListType PriceListType Price List Tp.
AuthorizationGroup _Customer AuthorizationGroup AuthorizGroup
InvoiceListSchedule InvoiceListSchedule Inv.List Sched.
ExchangeRateType ExchangeRateType Exch. Rate Type
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent Order Probab.
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery Max.Part.Deliv.
SuplrIsRlvtForSettlmtMgmt SuplrIsRlvtForSettlmtMgmt Settlem. Mgmt.
ProductUnitGroup ProductUnitGroup UoM Group
SlsDocIsRlvtForProofOfDeliv SlsDocIsRlvtForProofOfDeliv POD-relevant
SlsUnlmtdOvrdelivIsAllwd SlsUnlmtdOvrdelivIsAllwd Unlimited Tol.
CreditControlArea CreditControlArea Credit Control Area
CustomerIsRebateRelevant CustomerIsRebateRelevant Rebate
InspSbstHasNoTimeOrQuantity InspSbstHasNoTimeOrQuantity Price determin.
ManualInvoiceMaintIsRelevant ManualInvoiceMaintIsRelevant Man.Inv.Maint.
SalesItemProposal SalesItemProposal Item proposal
CustProdProposalProcedure CustProdProposalProcedure PP cust. proc.
_BusinessPartner _BusinessPartner
_BPProtectedAddress _BPProtectedAddress
_Customer _Customer

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_BPCustomerSalesAddressInfo.
-- 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: IBPCUSTSLSADDR

CREATE VIEW I_BPCustomerSalesAddressInfo AS
SELECT
  BusinessPartnerAddress.BusinessPartner AS BusinessPartner,
  BusinessPartnerAddress.AddressID AS AddressID,
  Businesspartnersalesarea.Customer AS Customer,
  Businesspartnersalesarea.SalesOrganization AS SalesOrganization,
  Businesspartnersalesarea.DistributionChannel AS DistributionChannel,
  Businesspartnersalesarea.Division AS Division,
  case when CustSlsAreaAddrDepdntInfo.AddressID is not initial then CustSlsAreaAddrDepdntInfo.IncotermsVersion else Businesspartnersalesarea.IncotermsVersion end as IncotermsVersion AS IncotermsVersionendasIncotermsVersion,
  case when CustSlsAreaAddrDepdntInfo.AddressID is not initial then CustSlsAreaAddrDepdntInfo.SalesOffice else Businesspartnersalesarea.SalesOffice end as SalesOffice AS SalesOfficeendasSalesOffice,
  case when CustSlsAreaAddrDepdntInfo.AddressID is not initial then CustSlsAreaAddrDepdntInfo.SalesGroup else Businesspartnersalesarea.SalesGroup end as SalesGroup AS SalesGroupendasSalesGroup,
  case when CustSlsAreaAddrDepdntInfo.AddressID is not initial then CustSlsAreaAddrDepdntInfo.SupplyingPlant else Businesspartnersalesarea.SupplyingPlant end as SupplyingPlant AS SupplyingPlantendasSupplyingPlant,
  CustomerGroup,
  AccountByCustomer,
  CustomerABCClassification,
  Currency,
  CustomerPriceGroup,
  DeliveryPriority,
  OrderCombinationIsAllowed,
  CompleteDeliveryIsDefined,
  PartialDeliveryIsAllowed,
  CustomerPaymentTerms,
  CustomerAccountAssignmentGroup,
  SalesDistrict,
  OrderIsBlockedForCustomer,
  PriceListType,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  InvoiceListSchedule,
  ExchangeRateType,
  ItemOrderProbabilityInPercent,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  MaxNmbrOfPartialDelivery,
  SuplrIsRlvtForSettlmtMgmt,
  ProductUnitGroup,
  SlsDocIsRlvtForProofOfDeliv,
  SlsUnlmtdOvrdelivIsAllwd,
  CreditControlArea,
  CustomerIsRebateRelevant,
  InspSbstHasNoTimeOrQuantity,
  ManualInvoiceMaintIsRelevant,
  SalesItemProposal,
  CustProdProposalProcedure
FROM I_BusPartAddress AS BusinessPartnerAddress
INNER JOIN I_Businesspartnersalesarea AS Businesspartnersalesarea 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_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
;

Learn More