I_BPCustomerWhldgTaxGovTP

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_BPCustomerWhldgTaxGovTP.
-- 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_BPCustomerWhldgTaxGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS BusinessPartnerUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS CustomerCompanyUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS CustomerWithholdingTaxUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  CompanyCode,
  WithholdingTaxType,
  MDChgProcessStep,
  CompanyCode AS CompanyCodeForEdit,
  WithholdingTaxType AS WithholdingTaxTypeForEdit,
  BPAssignmentID,
  Customer,
  WithholdingTaxCode,
  WithholdingTaxAgent,
  ObligationDateBegin,
  ObligationDateEnd,
  WithholdingTaxNumber,
  WithholdingTaxCertificate2,
  WithholdingTaxExmptPercent,
  ExemptionDateBegin,
  ExemptionDateEnd,
  ExemptionReason,
  MasterDataIsCurrent
FROM I_BPCustomerWhldgTaxGov
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_BPCustomerGovTP AS _Customer ON MasterDataChangeProcess = _Customer.MasterDataChangeProcess AND BusinessPartnerUUID = _Customer.BusinessPartnerUUID AND MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_CoCodeWithholdingTaxType AS _WithholdingTaxType ON CompanyCodeForEdit = _WithholdingTaxType.CompanyCode AND WithholdingTaxTypeForEdit = _WithholdingTaxType.WithholdingTaxType  -- association [0..1]
LEFT OUTER JOIN I_CoCodeWithholdingTaxCode AS _WithholdingTaxCode ON CompanyCodeForEdit = _WithholdingTaxCode.CompanyCode AND WithholdingTaxTypeForEdit = _WithholdingTaxCode.WithholdingTaxType AND WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode  -- association [0..1]
LEFT OUTER JOIN I_CoCodeWhgdTaxExemptionReason AS _ExemptionReason ON CompanyCodeForEdit = _ExemptionReason.CompanyCode AND ExemptionReason = _ExemptionReason.ExemptionReason  -- association [0..1]
;