I_BPAddlSuplrPurgOrgTP

DDL: I_BPADDLSUPLRPURGORGTP SQL: IBPADDSPOTP Type: view TRANSACTIONAL
30 Fields 2 Data Sources 3 Associations

BO view for purg org for addl suppliers

I_BPAddlSuplrPurgOrgTP is a Transactional CDS View that provides data about "BO view for purg org for addl suppliers" in SAP S/4HANA. It reads from 2 data sources (I_BPMultipleAssignment, I_SupplierPurchasingOrg) and exposes 30 fields with key fields BusinessPartner, Supplier, PurchasingOrganization. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BPMultipleAssignment BPMultipleAssignment inner
I_SupplierPurchasingOrg BusinessPartnerSupplierPO from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BPAdditionalSupplierTP _BPAdditionalSupplier $projection.BusinessPartner = _BPAdditionalSupplier.BusinessPartner and $projection.Supplier = _BPAdditionalSupplier.Supplier
[0..*] I_BPAddlSuplrPartFuncTP _BPAddlSuplrPartFunc $projection.BusinessPartner = _BPAddlSuplrPartFunc.BusinessPartner and $projection.Supplier = _BPAddlSuplrPartFunc.Supplier and $projection.PurchasingOrganization = _BPAddlSuplrPartFunc.PurchasingOrganization

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDSPOTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO view for purg org for addl suppliers view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BPADDSPO_D view
ObjectModel.draftEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMultipleAssignment BusinessPartner Issuing Authority
KEY Supplier I_SupplierPurchasingOrg Supplier Supplier
KEY PurchasingOrganization I_SupplierPurchasingOrg PurchasingOrganization Purchasing Organization
PurchasingOrganizationForEdit I_SupplierPurchasingOrg PurchasingOrganization Purchasing Organization
SupplierForEdit I_SupplierPurchasingOrg Supplier Supplier
BusinessPartnerForEdit I_BPMultipleAssignment BusinessPartner Issuing Authority
PurchasingGroup I_SupplierPurchasingOrg PurchasingGroup Purchasing Group
PlannedDeliveryDurationInDays I_SupplierPurchasingOrg PlannedDeliveryDurationInDays Plnd dely time
PurchasingIsBlockedForSupplier I_SupplierPurchasingOrg PurchasingIsBlockedForSupplier Pur. block POrg
SupplierRespSalesPersonName I_SupplierPurchasingOrg SupplierRespSalesPersonName Salesperson
ContactPersonPhoneNumber I_SupplierPurchasingOrg ContactPersonPhoneNumber Telephone No.
PurchaseOrderCurrency I_SupplierPurchasingOrg PurchaseOrderCurrency Order currency
MinimumOrderAmount I_SupplierPurchasingOrg MinimumOrderAmount Minimum value
CalculationSchemaGroupCode I_SupplierPurchasingOrg CalculationSchemaGroupCode Schema Grp Supp
PaymentTerms I_SupplierPurchasingOrg PaymentTerms Pyt Terms
PricingDateControl I_SupplierPurchasingOrg PricingDateControl Pr. Date Cat.
SupplierABCClassificationCode I_SupplierPurchasingOrg SupplierABCClassificationCode ABC indicator
ShippingCondition I_SupplierPurchasingOrg ShippingCondition Shipping Conditions
PurOrdAutoGenerationIsAllowed I_SupplierPurchasingOrg PurOrdAutoGenerationIsAllowed Automatic PO
InvoiceIsGoodsReceiptBased I_SupplierPurchasingOrg InvoiceIsGoodsReceiptBased GR-Based IV
IncotermsClassification I_SupplierPurchasingOrg IncotermsClassification Incoterms
IncotermsTransferLocation I_SupplierPurchasingOrg IncotermsTransferLocation Incoterms 2
IncotermsVersion I_SupplierPurchasingOrg IncotermsVersion Inco. Version
IncotermsLocation1 I_SupplierPurchasingOrg IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_SupplierPurchasingOrg IncotermsLocation2 Inco. Location2
SupplierConfirmationControlKey I_SupplierPurchasingOrg SupplierConfirmationControlKey Conf. Control
IsOrderAcknRqd I_SupplierPurchasingOrg IsOrderAcknRqd Acknowl. Reqd.
_BusinessPartner _BusinessPartner
_BPAdditionalSupplier _BPAdditionalSupplier
_BPAddlSuplrPartFunc _BPAddlSuplrPartFunc

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_BPAddlSuplrPurgOrgTP.
-- 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: IBPADDSPOTP

CREATE VIEW I_BPAddlSuplrPurgOrgTP AS
SELECT
  BPMultipleAssignment.BusinessPartner AS BusinessPartner,
  BusinessPartnerSupplierPO.Supplier AS Supplier,
  BusinessPartnerSupplierPO.PurchasingOrganization AS PurchasingOrganization,
  BusinessPartnerSupplierPO.PurchasingOrganization AS PurchasingOrganizationForEdit,
  BusinessPartnerSupplierPO.Supplier AS SupplierForEdit,
  BPMultipleAssignment.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerSupplierPO.PurchasingGroup AS PurchasingGroup,
  BusinessPartnerSupplierPO.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  BusinessPartnerSupplierPO.PurchasingIsBlockedForSupplier AS PurchasingIsBlockedForSupplier,
  BusinessPartnerSupplierPO.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  BusinessPartnerSupplierPO.ContactPersonPhoneNumber AS ContactPersonPhoneNumber,
  BusinessPartnerSupplierPO.PurchaseOrderCurrency AS PurchaseOrderCurrency,
  BusinessPartnerSupplierPO.MinimumOrderAmount AS MinimumOrderAmount,
  BusinessPartnerSupplierPO.CalculationSchemaGroupCode AS CalculationSchemaGroupCode,
  BusinessPartnerSupplierPO.PaymentTerms AS PaymentTerms,
  BusinessPartnerSupplierPO.PricingDateControl AS PricingDateControl,
  BusinessPartnerSupplierPO.SupplierABCClassificationCode AS SupplierABCClassificationCode,
  BusinessPartnerSupplierPO.ShippingCondition AS ShippingCondition,
  BusinessPartnerSupplierPO.PurOrdAutoGenerationIsAllowed AS PurOrdAutoGenerationIsAllowed,
  BusinessPartnerSupplierPO.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  BusinessPartnerSupplierPO.IncotermsClassification AS IncotermsClassification,
  BusinessPartnerSupplierPO.IncotermsTransferLocation AS IncotermsTransferLocation,
  BusinessPartnerSupplierPO.IncotermsVersion AS IncotermsVersion,
  BusinessPartnerSupplierPO.IncotermsLocation1 AS IncotermsLocation1,
  BusinessPartnerSupplierPO.IncotermsLocation2 AS IncotermsLocation2,
  BusinessPartnerSupplierPO.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  BusinessPartnerSupplierPO.IsOrderAcknRqd AS IsOrderAcknRqd
FROM I_SupplierPurchasingOrg AS BusinessPartnerSupplierPO
INNER JOIN I_BPMultipleAssignment AS BPMultipleAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPAdditionalSupplierTP AS _BPAdditionalSupplier ON BusinessPartner = _BPAdditionalSupplier.BusinessPartner AND Supplier = _BPAdditionalSupplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_BPAddlSuplrPartFuncTP AS _BPAddlSuplrPartFunc ON BusinessPartner = _BPAddlSuplrPartFunc.BusinessPartner AND Supplier = _BPAddlSuplrPartFunc.Supplier AND PurchasingOrganization = _BPAddlSuplrPartFunc.PurchasingOrganization  -- association [0..*]
;

Learn More