I_BPSuplrPurchasingOrgProcTP

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_BPSuplrPurchasingOrgProcTP.
-- 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_BPSuplrPurchasingOrgProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPAssignmentID,
  PurchasingOrganization,
  Supplier,
  PurchasingGroup,
  PurchasingIsBlockedForSupplier,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  PurchaseOrderCurrency,
  MinimumOrderAmount,
  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,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcSrceLastChgdDateTime
FROM I_BPSuplrPurchasingOrgProc
LEFT OUTER JOIN I_BusinessPartnerProcessTP AS _BusinessPartner ON MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartner.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_BPProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _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 PurchasingOrganization = _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_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_BPSuplrPurchasingDataProcTP AS _SupplierPurchasingData ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPSuplrPartnerFunctionProcTP AS _SupplierPartnerFunction ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPSuplrPurgTextGeneralProcTP AS _SupplierPurchasingTextGeneral ON /* condition not available in parsed metadata */  -- association [0..*]
;