I_RO_SAFTOwner

DDL: I_RO_SAFTOWNER SQL: IROSAFTOWNER Type: view BASIC
7 Fields 1 Data Sources 1 Associations

RO SAFT Owner IDs

I_RO_SAFTOwner is a Basic CDS View that provides data about "RO SAFT Owner IDs" in SAP S/4HANA. It reads from 1 data source (/ceecv/rocownid) and exposes 7 fields with key fields Material, StorageLocation, Plant, RO_SAFTSupplierID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/ceecv/rocownid _Owners from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RO_BusinessPartnerTaxType _RO_BusinessPartnerTaxType _Owners.lifnr = _RO_BusinessPartnerTaxType.BusinessPartner and _RO_BusinessPartnerTaxType.BusinessPartnerIsSAFTRelevant = 'X' and _RO_BusinessPartnerTaxType.TaxType = '6' and _RO_BusinessPartnerTaxType.ValidFrom <= $session.system_date and _RO_BusinessPartnerTaxType.ValidTo >= $session.system_date

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTOWNER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label RO SAFT Owner IDs view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material /ceecv/rocownid matnr Vehicle Model
KEY StorageLocation /ceecv/rocownid lgort Sublocation
KEY Plant /ceecv/rocownid werks Receiving Plant
KEY RO_SAFTSupplierID /ceecv/rocownid lifnr Vendor no.
VATRegistration _RO_BusinessPartnerTaxType VATRegistration VAT Registration No.
owneridendasRO_SAFTOwnerID
_RO_BusinessPartnerTaxType _RO_BusinessPartnerTaxType

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_RO_SAFTOwner.
-- 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: IROSAFTOWNER

CREATE VIEW I_RO_SAFTOwner AS
SELECT
  _Owners.matnr AS Material,
  _Owners.lgort AS StorageLocation,
  _Owners.werks AS Plant,
  _Owners.lifnr AS RO_SAFTSupplierID,
  _RO_BusinessPartnerTaxType.VATRegistration AS VATRegistration,
  case when _Owners.ownerid is initial then '0' else _Owners.ownerid end as RO_SAFTOwnerID AS owneridendasRO_SAFTOwnerID
FROM /ceecv/rocownid AS _Owners
LEFT OUTER JOIN I_RO_BusinessPartnerTaxType AS _RO_BusinessPartnerTaxType ON _Owners.lifnr = _RO_BusinessPartnerTaxType.BusinessPartner AND _RO_BusinessPartnerTaxType.BusinessPartnerIsSAFTRelevant = 'X' AND _RO_BusinessPartnerTaxType.TaxType = '6' AND _RO_BusinessPartnerTaxType.ValidFrom <= $session.system_date AND _RO_BusinessPartnerTaxType.ValidTo >= $session.system_date  -- association [1..1]
;

Learn More