C_CustomerCompanyCodeOP

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 C_CustomerCompanyCodeOP.
-- 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: CCUSTCCODEOP

CREATE VIEW C_CustomerCompanyCodeOP AS
SELECT
  CustomerCompany.Customer AS Customer,
  CustomerCompany.CompanyCode AS CompanyCode,
  CustomerCompany.AuthorizationGroup AS AuthorizationGroup,
  CustomerCompany.AccountingClerk AS AccountingClerk,
  CustomerCompany.ReconciliationAccount AS ReconciliationAccount,
  CustomerCompany.PaymentBlockingReason AS PaymentBlockingReason,
  _CustomerDunning.LastDunnedOn AS LastDunnedOn,
  _CustomerDunning.DunningProcedure AS DunningProcedure,
  _CustomerDunning.DunningLevel AS DunningLevel,
  _CustomerDunning.DunningBlock AS DunningBlock,
  _CustomerDunning.DunningRecipient AS DunningRecipient,
  _CustomerDunning.LegDunningProcedureOn AS LegDunningProcedureOn,
  IsBusinessPurposeCompleted,
  _Customer.CustomerName AS CustomerName,
  _Customer.BPCustomerName AS BPCustomerName
FROM I_CustomerCompany AS CustomerCompany
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeValueHelp ON CompanyCode = _CompanyCodeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerkValueHelp ON AccountingClerk = _AccountingClerkValueHelp.AccountingClerk AND CompanyCode = _AccountingClerkValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_Custrecnclnacctvhtemp AS _RecnclnAcctValueHelp ON ReconciliationAccount = _RecnclnAcctValueHelp.ReconciliationAccount AND CompanyCode = _RecnclnAcctValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockValueHelp ON PaymentBlockingReason = _PaymentBlockValueHelp.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_CustomerDunning AS _CustomerDunning ON Customer = _CustomerDunning.Customer AND CompanyCode = _CustomerDunning.CompanyCode AND _CustomerDunning.DunningArea = ''  -- association [0..1]
;