/SCMTMS/CV_BPSlsOrg

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 /SCMTMS/CV_BPSlsOrg.
-- 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: /SCMTMS/CV_BPORS

CREATE VIEW /SCMTMS/CV_BPSlsOrg AS
SELECT
  BusinessPartnerSalesArea.SalesOrganization AS SalesOrganization,
  BusinessPartnerSalesArea.DistributionChannel AS DistributionChannel,
  BusinessPartnerSalesArea.Division AS Division,
  BusinessPartnerSalesArea.BusinessPartner AS BusinessPartner,
  _BusinessPartnerTranspOrg.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartnerTranspOrg.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BusinessPartnerSalesArea.SalesOffice AS SalesOffice,
  BusinessPartnerSalesArea.SalesGroup AS SalesGroup,
  BusinessPartnerSalesArea.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  BusinessPartnerSalesArea.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  BusinessPartnerSalesArea.InvoiceDate AS InvoiceDate,
  BusinessPartnerSalesArea.AccountByCustomer AS AccountByCustomer,
  BusinessPartnerSalesArea.CustomerPaymentTerms AS CustomerPaymentTerms,
  BusinessPartnerSalesArea.Currency AS Currency,
  BusinessPartnerSalesArea.DeliveryPriority AS DeliveryPriority,
  BusinessPartnerSalesArea.IncotermsClassification AS IncotermsClassification,
  BusinessPartnerSalesArea.IncotermsTransferLocation AS IncotermsTransferLocation,
  BusinessPartnerSalesArea.ShippingCondition AS ShippingCondition,
  BusinessPartnerSalesArea.BusinessPartnerUUID AS BusinessPartnerUUID,
  _TranspOrganizationalUnit.OrganizationalUnitSpcfcExtID AS OrganizationalUnitSpcfcExtID,
  _TranspOrganizationalUnit.OrganizationalUnit AS OrganizationalUnit,
  cast ('4' as /scmb/org_func_code) AS OrganizationalUnitFunction,
  TMCommonCustomizing.tm_vtweg AS tm_vtweg,
  TMCommonCustomizing.tm_spart AS tm_spart,
  _BusinessPartnerTranspOrg.FreightSettlementProfile AS FreightSettlementProfile,
  _BusinessPartnerTranspOrg.CalculationProfile AS CalculationProfile,
  _BusinessPartnerTranspOrg.IsRespForExportDeclaration AS IsRespForExportDeclaration,
  _BusinessPartnerTranspOrg.IsRespForImportDeclaration AS IsRespForImportDeclaration
FROM I_Businesspartnersalesarea AS BusinessPartnerSalesArea
INNER JOIN I_TranspOrganizationalUnit AS _TranspOrganizationalUnit ON /* join condition not captured in parsed metadata */
INNER JOIN /scmtms/c_common AS TMCommonCustomizing ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTranspOrg AS _BusinessPartnerTranspOrg ON BusinessPartner = _BusinessPartnerTranspOrg.BusinessPartner AND OrganizationalUnitSpcfcExtID = _BusinessPartnerTranspOrg.OrganizationalUnitSpcfcExtID AND tm_vtweg = _BusinessPartnerTranspOrg.DistributionChannel AND tm_spart = _BusinessPartnerTranspOrg.Division AND _BusinessPartnerTranspOrg.OrganizationalUnitFunction = '4'  -- association [0..1]
;