I_BPSuplrPurchasingOrgGovTP

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_BPSuplrPurchasingOrgGovTP.
-- 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 I_BPSuplrPurchasingOrgGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS SuplrPurchasingOrgUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  PurchasingOrganization,
  MDChgProcessStep,
  PurchasingOrganization AS PurchasingOrganizationForEdit,
  BPAssignmentID,
  Supplier,
  PurchasingGroup,
  PurchasingIsBlockedForSupplier,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  PurchaseOrderCurrency,
  MinimumOrderAmount,
  cast ( PurchaseOrderCurrency as bstwa ) AS MinimumOrderAmountCurrency,
  CalculationSchemaGroupCode,
  PaymentTerms,
  PricingDateControl,
  SupplierABCClassificationCode,
  ShippingCondition,
  PurOrdAutoGenerationIsAllowed,
  InvoiceIsGoodsReceiptBased,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  DeletionIndicator,
  PlannedDeliveryDurationInDays,
  SupplierConfirmationControlKey,
  IsOrderAcknRqd,
  EvaldReceiptSettlementIsActive,
  AutomaticEvaluatedRcptSettlmt,
  SupplierAccountNumber,
  SuplrIsSubjToSubsqntSettlement,
  SuplrPurgOrgAgrmtOfBusVolIsRqd,
  SuplrInvcRevalIsAllowed,
  SuplrPurgOrgIsRlvtForPriceDetn,
  IntrastatCrsBorderTrMode,
  ProductUnitGroup,
  RoundingProfile,
  SuplrDiscountInKindIsGranted,
  SuplrIsRlvtForSettlmtMgmt,
  InvoiceIsMMServiceEntryBased,
  ProdStockAndSlsDataTransfPrfl,
  MasterDataIsCurrent,
  Origin
FROM I_BPSuplrPurchasingOrgGov AS BPSuplrPurchasingOrgGovernance
LEFT OUTER JOIN I_BusinessPartnerGovTP AS _BusinessPartnerGov ON MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess AND BusinessPartnerUUID = _BusinessPartnerGov.BusinessPartnerUUID AND MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganizationForEdit = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON PurchaseOrderCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SchemaGroupHelp AS _SchemaGroupText ON CalculationSchemaGroupCode = _SchemaGroupText.SchemaGroup AND _SchemaGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PricingDateControl AS _PriceDateControl ON PricingDateControl = _PriceDateControl.PricingDateControl  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_PurgIntrastatCrsBrdrTrMode AS _TransportationMode ON IntrastatCrsBorderTrMode = _TransportationMode.IntrastatCrsBorderTrMode AND PurchasingOrganizationForEdit = _TransportationMode.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_SuplrLoglRoundingProfile AS _LogisticalRoundingProfile ON RoundingProfile = _LogisticalRoundingProfile.LogisticalRoundingProfile AND Supplier = _LogisticalRoundingProfile.Supplier  -- association [0..1]
LEFT OUTER JOIN E_BPPURORG_D AS _ExtBPSuplrPurchasingOrgActive ON PurchasingOrganization = _ExtBPSuplrPurchasingOrgActive.PurchasingOrganization AND Supplier = _ExtBPSuplrPurchasingOrgActive.Supplier  -- association [0..1]
LEFT OUTER JOIN E_BPSuplrPurchasingOrgProc AS _ExtBPSuplrPurchasingOrgProc ON MasterDataChangeProcess = _ExtBPSuplrPurchasingOrgProc.MasterDataChangeProcess AND MDChgProcessStep = _ExtBPSuplrPurchasingOrgProc.MDChgProcessStep AND MDChgProcessSrceSystem = _ExtBPSuplrPurchasingOrgProc.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtBPSuplrPurchasingOrgProc.MDChgProcessSrceObject AND BPAssignmentID = _ExtBPSuplrPurchasingOrgProc.BPAssignmentID AND PurchasingOrganization = _ExtBPSuplrPurchasingOrgProc.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_BPSuplrPurchasingDataGovTP AS _SupplierPurchasingData ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPSuplrPartnerFunctionGovTP AS _SupplierPartnerFunction ON /* condition not available in parsed metadata */  -- association [0..*]
;