I_BPCustomerGovTP

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_BPCustomerGovTP.
-- 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_BPCustomerGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS BusinessPartnerUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessStep,
  BPAssignmentID,
  Customer,
  OrderIsBlockedForCustomer,
  ExpressTrainStationName,
  TrainStationName,
  AuthorizationGroup,
  BillingIsBlockedForCustomer,
  FiscalAddress,
  AlternativePayerAccount,
  CustomerCorporateGroup,
  CustomerAccountGroup,
  CustomerClassification,
  Supplier,
  DeliveryIsBlocked,
  DeletionIndicator,
  NielsenRegion,
  County,
  CityCode,
  PostingIsBlocked,
  VATLiability,
  AlternativePayeeIsAllowed,
  IndustryCode1,
  IndustryCode2,
  IndustryCode3,
  IndustryCode4,
  IndustryCode5,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedAttribute05,
  FreeDefinedAttribute06,
  FreeDefinedAttribute07,
  FreeDefinedAttribute08,
  FreeDefinedAttribute09,
  FreeDefinedAttribute10,
  DataMediumExchangeIndicator,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  ResponsibleType,
  TaxInvoiceRepresentativeName,
  BusinessType,
  IndustryType,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  cast( 1000 as mdc_process_update_token ) AS ETag,
  cast( '' as mdc_source_modified preserving type ) AS MDChgProcessSourceModified,
  Origin
FROM I_BPCustomerGov AS CustomerGovernance
LEFT OUTER JOIN I_BusinessPartnerGovTP AS _BusinessPartnerGov ON BusinessPartnerUUID = _BusinessPartnerGov.BusinessPartnerUUID AND MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_BPChangeProcessGovTP AS _Process ON BusinessPartnerUUID = _Process.BusinessPartnerUUID AND MasterDataChangeProcess = _Process.MasterDataChangeProcess AND MDChgProcessSrceSystem = _Process.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Process.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_CustomerAccountGroup AS _CustomerAccountGroup ON CustomerAccountGroup = _CustomerAccountGroup.CustomerAccountGroup  -- association [0..1]
LEFT OUTER JOIN I_BPCustomerCompanyGovTP AS _CustomerCompany ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCustomerSalesAreaGovTP AS _CustomerSalesArea ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCustomerTaxIndicatorGovTP AS _CustomerTaxIndicator ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCustUnloadingPointGovTP AS _CustomerUnloadingPoint ON /* condition not available in parsed metadata */  -- association [0..*]
;