R_StockTransportOrderPartner

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 R_StockTransportOrderPartner.
-- 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.

CREATE VIEW R_StockTransportOrderPartner AS
SELECT
  cast(Partner.PurchasingDocument as vdm_stocktransportorder preserving type) AS StockTransportOrder,
  cast(Partner.PartnerFunction as parvw_unv preserving type) AS PartnerFunction,
  Partner.SupplierSubrange AS SupplierSubrange,
  Partner.Plant AS Plant,
  Partner.PurchasingOrganization AS PurchasingOrganization,
  Partner.PartnerCounter AS PartnerCounter,
  Partner.CreatedByUser AS CreatedByUser,
  Partner.CreationDate AS CreationDate,
  Partner.PurchasingDocumentPartnerType AS PurchasingDocumentPartnerType,
  Partner.Supplier AS Supplier,
  Partner.SupplierHierarchyCategory AS SupplierHierarchyCategory,
  Partner.SupplierContact AS SupplierContact,
  Partner.PersonWorkAgreement AS PersonWorkAgreement,
  Partner.DefaultPartner AS DefaultPartner,
  Partner._PurchasingOrganization AS _PurchasingOrganization,
  Partner._Plant AS _Plant,
  Partner._PartnerFunction AS _PartnerFunction,
  Partner._PartnerFunctionText AS _PartnerFunctionText,
  Partner._Supplier AS _Supplier,
  Partner._SupplierContact AS _SupplierContact,
  Partner._PersonWorkAgreement AS _PersonWorkAgreement
FROM I_PurchasingDocumentPartner AS Partner
INNER JOIN R_StockTransportOrder AS StockTransportOrder ON /* join condition not captured in parsed metadata */
;