C_MngCustCndnContr

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_MngCustCndnContr.
-- 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: CWCBMNGCUSTCONTR

CREATE VIEW C_MngCustCndnContr AS
SELECT
  Contract.ConditionContract AS ConditionContract,
  Contract.CndnContrType AS CndnContrType,
  Contract._CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc AS CndnContrTypeDesc,
  Contract.Customer AS Customer,
  Contract._Customer.CustomerName AS CustomerName,
  Contract.DocumentReferenceID AS DocumentReferenceID,
  , successor: 'CndnContrAssgmtRef' AS CndnContrAssgmtRefasAssignmentReference,
  Contract.CndnContrAssgmtRef AS CndnContrAssgmtRef,
  Contract.CndnContrExternalPartner AS CndnContrExternalPartner,
  Contract.CreatedByUser AS CreatedByUser,
  cast( Contract._CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  Contract.LastChangedByUser AS LastChangedByUser,
  Contract._LastChangedByUser.UserDescription AS LastChangedByUserFullName,
  Contract.PurchasingOrganization AS PurchasingOrganization,
  Contract.PurchasingGroup AS PurchasingGroup,
  Contract.SalesOrganization AS SalesOrganization,
  Contract._SalesOrganization._Text[1: Language = $session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  Contract.DistributionChannel AS DistributionChannel,
  Contract._DistributionChannel._Text[1: Language = $session.system_language ].DistributionChannelName AS DistributionChannelName,
  Contract.Division AS Division,
  Contract._Division._Text[1: Language = $session.system_language ].DivisionName AS DivisionName,
  Contract.SalesGroup AS SalesGroup,
  Contract.SalesOffice AS SalesOffice,
  Contract.PaymentTerms AS PaymentTerms,
  Contract.CashDiscount1Days AS CashDiscount1Days,
  Contract.CashDiscount1Percent AS CashDiscount1Percent,
  Contract.CashDiscount2Days AS CashDiscount2Days,
  Contract.CashDiscount2Percent AS CashDiscount2Percent,
  Contract.NetPaymentDays AS NetPaymentDays,
  Contract.PaymentMethod AS PaymentMethod,
  Contract.CndnContrIsInactive AS CndnContrIsInactive,
  Contract._CndnContrIsInactive._Text[1: Language = $session.system_language ].CndnContrIsInactiveName AS CndnContrIsInactiveName,
  Contract.CndnContrValidFrom AS CndnContrValidFrom,
  Contract.CndnContrValidTo AS CndnContrValidTo,
  Contract.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
  Contract.CndnContrCurrency AS CndnContrCurrency,
  Contract.SettlmtProduct AS SettlmtProduct,
  Contract._SettlmtProduct._Text[1: Language = $session.system_language ].ProductName AS ProductName,
  Contract.CompanyCode AS CompanyCode,
  Contract._CompanyCode.CompanyCodeName AS CompanyCodeName,
  Contract.CndnContrClassfctnType AS CndnContrClassfctnType,
  Contract._CndnContrClassfctnType._Text[1: Language = $session.system_language ].CndnContrClassfctnTypeDesc AS CndnContrClassfctnTypeDesc,
  Contract.CndnContrPurposeCat AS CndnContrPurposeCat,
  Contract.CndnContrSourceDocCat AS CndnContrSourceDocCat,
  Contract.CndnContrSourceDoc AS CndnContrSourceDoc,
  Contract.CndnContrUnit AS CndnContrUnit,
  Contract.CndnContrWeightUnit AS CndnContrWeightUnit,
  Contract.CndnContrVolumeUnit AS CndnContrVolumeUnit,
  Contract.CndnContrPointsQtyUnit AS CndnContrPointsQtyUnit,
  Contract.AccrualUpdateIsRequired AS AccrualUpdateIsRequired,
  cast( Contract.CreationUTCDateTime as wcb_created_on_tstmp preserving type ) AS CreationUTCDateTime,
  cast( Contract.LastChangeUTCDateTime as wcb_changed_on_tstmp preserving type ) AS LastChangeUTCDateTime,
  Contract.Supplier AS Supplier,
  Contract.PriorSupplier AS PriorSupplier,
  Contract.CndnContrUUID AS CndnContrUUID,
  Contract.CndnContrSourceUUID AS CndnContrSourceUUID,
  Contract.CndnContrProcVar AS CndnContrProcVar,
  Contract._CndnContrProcVar._Text[1: Language = $session.system_language ].CndnContrProcVarDesc AS CndnContrProcVarDesc,
  cast( 1 as wcb_cc_chart_counter ) AS CndnContrChartCounter,
  cast( _MainSystemStatus.CndnContrMainSystemStatus as wcb_main_system_status preserving type ) AS CndnContrMainSystemStatus,
  _MainSystemStatus._SystemStatus._SystemStatusText[1: Language = $session.system_language ].SystemStatusName AS CndnContrMainSystemStatusText,
  Contract.PersonWorkAgreement AS PersonWorkAgreement,
  Contract.CndnContrWorkerCostCenter AS CndnContrWorkerCostCenter,
  Contract._CndnContrType AS _CndnContrType,
  Contract._CndnContrIsInactive AS _CndnContrIsInactive,
  Contract._CndnContrClassfctnType AS _CndnContrClassfctnType,
  Contract._Customer AS _Customer,
  Contract._Supplier AS _Supplier,
  Contract._PriorSupplier AS _PriorSupplier,
  Contract._PersonWorkAgreement AS _PersonWorkAgreement,
  Contract._SalesOrganization AS _SalesOrganization,
  Contract._DistributionChannel AS _DistributionChannel,
  Contract._Division AS _Division,
  Contract._CndnContrCurrency AS _CndnContrCurrency,
  Contract._SalesGroup AS _SalesGroup,
  Contract._SalesOffice AS _SalesOffice,
  Contract._CompanyCode AS _CompanyCode,
  Contract._PurchasingOrganization AS _PurchasingOrganization,
  Contract._PurchasingGroup AS _PurchasingGroup,
  Contract._SettlmtProduct AS _SettlmtProduct,
  Contract._CndnContrUnit AS _CndnContrUnit,
  Contract._CndnContrWeightUnit AS _CndnContrWeightUnit,
  Contract._CndnContrVolumeUnit AS _CndnContrVolumeUnit,
  Contract._CndnContrPointsQtyUnit AS _CndnContrPointsQtyUnit,
  Contract._CndnContrProcVar AS _CndnContrProcVar,
  Contract._CndnContrPurposeCat AS _CndnContrPurposeCat,
  Contract._CndnContrSourceDocCat AS _CndnContrSourceDocCat
FROM I_ConditionContract AS Contract
INNER JOIN I_CndnContrType AS ContractType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_CndnContrMainSystStatus AS _MainSystemStatus ON CndnContrUUID = _MainSystemStatus.CndnContrUUID  -- association [0..1]
LEFT OUTER JOIN I_CndnContrActSystemStatus AS _SettlmtLockStatus ON CndnContrUUID = _SettlmtLockStatus.StatusObjectUUID AND _SettlmtLockStatus.SystemStatus = 'ICC08'  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSettlmtLockText AS _SettlmtLockText ON _SettlmtLockText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN E_ConditionContract AS _Extension ON ConditionContract = _Extension.ConditionContract  -- association [1..1]
;