P_ACMContractHdrDets

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_ACMContractHdrDets.
-- 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: PACMCTRHDRDET

CREATE VIEW P_ACMContractHdrDets AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  Header.TradingContractType AS TradingContractType,
  Header.ContractStatus AS ContractStatus,
  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,
  case Business.DocumentSide when 'M' then Purchase_Counterparty.CustomerName else Sales_Counterparty.CustomerName end as CustomerName AS CustomerNameendasCustomerName,
  case Business.DocumentSide when 'M' then Purchase_Counterparty.Counterparty else Sales_Counterparty.Counterparty end as Counterparty AS CounterpartyendasCounterparty
FROM I_ACMTrdgContrHdrApproval AS Header
INNER JOIN I_ACMTrdgContrBizDet AS Business ON /* join condition not captured in parsed metadata */
INNER JOIN I_TrdgContrTypeDetails AS TrdgContrTypeDet ON /* join condition not captured in parsed metadata */
INNER JOIN P_ACMContractStatusMappg AS TrdgContTypeMapDet ON /* join condition not captured in parsed metadata */
;