I_Supplier

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_Supplier.
-- 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: I_SUPPLIER_CDS

CREATE VIEW I_Supplier AS
SELECT *  -- field list not available in parsed metadata
FROM lfa1
LEFT OUTER JOIN I_SupplierToBusinessPartner AS _SupplierToBusinessPartner ON Supplier = _SupplierToBusinessPartner.Supplier  -- association [1..1]
LEFT OUTER JOIN bp1020 AS _FiscalData ON lfa1.lifnr = _FiscalData.partnr  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier  -- association [0..*]
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON Supplier = _SupplierPurchasingOrg.Supplier  -- association [0..*]
LEFT OUTER JOIN I_SupplierBankDetails AS _SupplierBankDetails ON Supplier = _SupplierBankDetails.Supplier  -- association [0..*]
LEFT OUTER JOIN I_SupplierAccountGroup AS _SupplierAccountGroup ON SupplierAccountGroup = _SupplierAccountGroup.SupplierAccountGroup  -- association [0..1]
LEFT OUTER JOIN I_Industries AS _Industry ON Industry = _Industry.IndustrySector  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _CorrespondingCustomer ON Customer = _CorrespondingCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SupplierAccountGroupText AS _SupplierAccountGroupText ON SupplierAccountGroup = _SupplierAccountGroupText.SupplierAccountGroup  -- association [0..*]
LEFT OUTER JOIN I_SupplierIndustryText AS _SupplierIndustryText ON Industry = _SupplierIndustryText.SupplierIndustry  -- association [0..*]
LEFT OUTER JOIN I_ProcurementBlock AS _ProcurementBlock ON SupplierProcurementBlock = _ProcurementBlock.ProcurementBlock  -- association [0..1]
LEFT OUTER JOIN I_QualityManagementSystem AS _QualityManagementSystem ON SuplrQualityManagementSystem = _QualityManagementSystem.QualityManagementSystem  -- association [0..1]
LEFT OUTER JOIN I_Address AS _StandardAddress ON AddressID = _StandardAddress.AddressID  -- association [1..1]
LEFT OUTER JOIN E_Supplier AS _SupplierExt ON Supplier = _SupplierExt.Supplier  -- association [0..1]
LEFT OUTER JOIN I_OrganizationAddress AS _AddressDefaultRepresentation ON AddressID = _AddressDefaultRepresentation.AddressID AND _AddressDefaultRepresentation.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _AddressRepresentation ON AddressID = _AddressRepresentation.AddressID AND _AddressRepresentation.AddressRepresentationCode is initial AND _AddressRepresentation.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_AddressEmailAddress_2 AS _EmailAddress ON _EmailAddress.AddressID = AddressID AND _EmailAddress.AddressPersonID is initial  -- association [0..*]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _CurrentDfltEmailAddress ON _CurrentDfltEmailAddress.AddressID = AddressID AND _CurrentDfltEmailAddress.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _PhoneNumber ON _PhoneNumber.AddressID = AddressID AND _PhoneNumber.AddressPersonID is initial  -- association [0..*]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr ON _CurrentDfltLandlinePhoneNmbr.AddressID = AddressID AND _CurrentDfltLandlinePhoneNmbr.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber ON _CurrentDfltMobilePhoneNumber.AddressID = AddressID AND _CurrentDfltMobilePhoneNumber.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _FaxNumber ON _FaxNumber.AddressID = AddressID AND _FaxNumber.AddressPersonID is initial  -- association [0..*]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _CurrentDfltFaxNumber ON _CurrentDfltFaxNumber.AddressID = AddressID AND _CurrentDfltFaxNumber.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_AddressURI AS _UniformResourceIdentifier ON _UniformResourceIdentifier.AddressID = AddressID AND _UniformResourceIdentifier.AddressPersonID is initial  -- association [0..*]
LEFT OUTER JOIN I_AddressMainWebsiteURL AS _MainWebsiteURL ON _MainWebsiteURL.AddressID = AddressID AND _MainWebsiteURL.AddressPersonID is initial  -- association [0..1]
;