P_ACMContractHeaderDets

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 P_ACMContractHeaderDets.
-- 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: PACMCTRHDRDETS

CREATE VIEW P_ACMContractHeaderDets AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  Header.TradingContractType AS TradingContractType,
  Header.ContractStatus AS ContractStatus,
  Counterparty.Counterparty AS Counterparty,
  Header.TradingContractCreatedBy AS TradingContractCreatedBy,
  Header.TradingContrCreatedOnDate AS TradingContrCreatedOnDate,
  Header.TradingContractChangedBy AS TradingContractChangedBy,
  Header.TradingContractChangedOnDate AS TradingContractChangedOnDate,
  Header.SalesOrganization AS SalesOrganization,
  Header.DistributionChannel AS DistributionChannel,
  Header.Division AS Division,
  Header.PersonResponsible AS PersonResponsible,
  Header.ACMTransactingCustomerRef AS ACMTransactingCustomerRef,
  Header.DocumentDate AS DocumentDate,
  Header.TradingContractExternalID AS TradingContractExternalID,
  Header.CompanyCode AS CompanyCode,
  Business.DocumentSide AS Side,
  Status.TrdgContrApplStsName AS TrdgContrApplStsName,
  ContractTypeDesc.ACMTrdgContrTypeDesc AS TradingContractTypeName,
  SalesOrganizationText.SalesOrganizationText AS SalesOrgDescr,
  DistributionChannelText.DistributionChannelText AS DistributionChannelDescr,
  OrganizationDivisionText.DivisionName AS SalesDivisionDescr,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.PurchasingOrganizationName AS PurchasingOrganizationName,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.PurchasingGroupName AS PurchasingGroupName,
  case Business.DocumentSide when 'M' then Business.ACMPurgIncotermsPart1 else Business.ACMSlsIncotermsPart1 end as Incoterms AS ACMSlsIncotermsPart1endasIncoterms,
  Business.IncotermsClassificationName AS IncotermsClassificationName,
  Business.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Business.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  Business.ACMSupplyingPlant AS ACMSupplyingPlant,
  Business.ACMReferencePO AS ACMReferencePO,
  Business.ACMCustomerReference AS ACMCustomerReference,
  Business.ACMYourReference AS ACMYourReference,
  Side.DocumentSide AS DocumentSide,
  CreatedbyDetails.UserDescription AS CreatedBy,
  PersonResponsibleDetails.UserDescription AS PersonResponsibleName,
  ChangedbyDetails.UserDescription AS ChangedBy,
  Counterparty.CounterpartyFullName AS CounterpartyFullName,
  Counterparty.CustomerName AS CustomerName,
  Counterparty.ACMCounterpartyFirstName AS ACMCounterpartyFirstName,
  Counterparty.ACMCounterpartyLastName AS ACMCounterpartyLastName,
  Counterparty.AuthorizationGroup AS AuthorizationGroup,
  Counterparty.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_ACMTrdgContrHdrApproval AS Header
INNER JOIN I_ACMTrdgContrBizDet AS Business ON /* join condition not captured in parsed metadata */
;