I_SuplrAddrDepdntPurchasingOrg

DDL: I_SUPLRADDRDEPDNTPURCHASINGORG SQL: ISUADDEPTPURCH Type: view BASIC Package: VDM_MD_COMMON
31 Fields 1 Data Sources 3 Associations

Supplier Purch org data For Address

I_SuplrAddrDepdntPurchasingOrg is a Basic CDS View that provides data about "Supplier Purch org data For Address" in SAP S/4HANA. It reads from 1 data source (lfm1_addr) and exposes 31 fields with key fields Supplier, AddressID, PurchasingOrganization. It has 3 associations to related views. Part of development package VDM_MD_COMMON.

Data Sources (1)

SourceAliasJoin Type
lfm1_addr lfm1_addr from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] I_Address_2 _AddressDefaultRepresentation $projection.AddressID = _AddressDefaultRepresentation.AddressID and _AddressDefaultRepresentation.AddressRepresentationCode = ' '
[0..1] I_IncotermsClassification _IncotermsClassification $projection.IncotermsClassification = _IncotermsClassification.IncotermsClassification

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISUADDEPTPURCH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
EndUserText.label Supplier Purch org data For Address view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Supplier lfm1_addr lifnr Vendor no.
KEY AddressID lfm1_addr adrnr Sold-To Address
KEY PurchasingOrganization lfm1_addr ekorg Purchasing Org.
PurchasingIsBlockedForSupplier lfm1_addr sperm Purch. block
PurchaseOrderCurrency lfm1_addr waers Transaction Currency
SupplierRespSalesPersonName lfm1_addr verkf Salesperson
ContactPersonPhoneNumber lfm1_addr telf1 Telephone no.
MinimumOrderAmount lfm1_addr minbw Minimum value
PaymentTerms lfm1_addr zterm Terms of Payment
IncotermsClassification lfm1_addr inco1 Incoterms
IncotermsTransferLocation lfm1_addr inco2 Incoterms 2
IntrastatCrsBorderTrMode lfm1_addr expvz Mode of Trans.
PurgOutlineAgrmtCustomsOffice lfm1_addr zolla Customs office
PurchasingGroup lfm1_addr ekgrp Sub. purchasing grp
MaterialPlannedDeliveryDurn lfm1_addr plifz Plnd Deliv.Time
PlanningCalendarCode lfm1_addr mrppp Planning cal.
PlanningCycle lfm1_addr lfrhy Planning Cycle
IncotermsVersion lfm1_addr incov Inco. Version
IncotermsLocation1 lfm1_addr inco2_l Inco. Location1
IncotermsLocation2 lfm1_addr inco3_l Inco. Location2
IsToBeAcceptedAtOrigin lfm1_addr weora Origin Accept.
SchedgAgrmtRelCreationProfile lfm1_addr abueb RC Profile
PurgDocTransportationChain lfm1_addr transport_chain Transportation Chain
IncotermsSupChnLoc1AddlUUID
IncotermsSupChnLoc2AddlUUID
IncotermsSupChnDvtgLocAddlUUID
SupplierAccountNumber lfm1_addr eikto Acct w/ vendor
ShippingCondition lfm1_addr vsbed Shipping Conditions
_Supplier _Supplier
_AddressDefaultRepresentation _AddressDefaultRepresentation
_IncotermsClassification _IncotermsClassification

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_SuplrAddrDepdntPurchasingOrg.
-- 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: ISUADDEPTPURCH

CREATE VIEW I_SuplrAddrDepdntPurchasingOrg AS
SELECT
  lfm1_addr.lifnr AS Supplier,
  lfm1_addr.adrnr AS AddressID,
  lfm1_addr.ekorg AS PurchasingOrganization,
  lfm1_addr.sperm AS PurchasingIsBlockedForSupplier,
  lfm1_addr.waers AS PurchaseOrderCurrency,
  lfm1_addr.verkf AS SupplierRespSalesPersonName,
  lfm1_addr.telf1 AS ContactPersonPhoneNumber,
  lfm1_addr.minbw AS MinimumOrderAmount,
  lfm1_addr.zterm AS PaymentTerms,
  lfm1_addr.inco1 AS IncotermsClassification,
  lfm1_addr.inco2 AS IncotermsTransferLocation,
  lfm1_addr.expvz AS IntrastatCrsBorderTrMode,
  lfm1_addr.zolla AS PurgOutlineAgrmtCustomsOffice,
  lfm1_addr.ekgrp AS PurchasingGroup,
  lfm1_addr.plifz AS MaterialPlannedDeliveryDurn,
  lfm1_addr.mrppp AS PlanningCalendarCode,
  lfm1_addr.lfrhy AS PlanningCycle,
  lfm1_addr.incov AS IncotermsVersion,
  lfm1_addr.inco2_l AS IncotermsLocation1,
  lfm1_addr.inco3_l AS IncotermsLocation2,
  lfm1_addr.weora AS IsToBeAcceptedAtOrigin,
  lfm1_addr.abueb AS SchedgAgrmtRelCreationProfile,
  lfm1_addr.transport_chain AS PurgDocTransportationChain,
  cast( lfm1_addr.inco2_key as /sapapo/location_uuid) AS IncotermsSupChnLoc1AddlUUID,
  cast( lfm1_addr.inco3_key as /sapapo/location_uuid) AS IncotermsSupChnLoc2AddlUUID,
  cast( lfm1_addr.inco4_key as /sapapo/location_uuid) AS IncotermsSupChnDvtgLocAddlUUID,
  lfm1_addr.eikto AS SupplierAccountNumber,
  lfm1_addr.vsbed AS ShippingCondition
FROM lfm1_addr
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _AddressDefaultRepresentation ON AddressID = _AddressDefaultRepresentation.AddressID AND _AddressDefaultRepresentation.AddressRepresentationCode = ' '  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
;

Learn More