P_ACMTradingContractHeader

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_ACMTradingContractHeader.
-- 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: PCONTRHEADER

CREATE VIEW P_ACMTradingContractHeader AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  Header.TrdgContrGoodsSupplier AS kunnr,
  Header.Division AS Division,
  Header.TradingContractType AS TradingContractType,
  Header.ContractStatus AS ContractStatus,
  Header.SalesOrganization AS SalesOrganization,
  Header.DistributionChannel AS DistributionChannel,
  Header.TradingContractExternalID AS TradingContractExternalID,
  Header.TradingContrCreatedOnDate AS TradingContrCreatedOnDate,
  Header.DocumentDate AS DocumentDate,
  Header.PersonResponsible AS PersonResponsible,
  Header.TradingContractCreatedBy AS TradingContractCreatedBy,
  Header.TradingContractChangedBy AS TradingContractChangedBy,
  Header.TradingContractChangedOnDate AS TradingContractChangedOnDate,
  Header.TradingContractSalesCurrency AS TradingContractSalesCurrency,
  Header.CompanyCode AS CompanyCode,
  Header.PricingDocument AS PricingDocument,
  TrdgContrHdrAddDets.TradingContractTradeOffice AS TradingContractTradeOffice,
  TrdgContrHdrAddDets.TradingContractCreditSales AS TradingContractCreditSales,
  TrdgContrHdrAddDets.ACMSignedStatus AS ACMSignedStatus,
  TrdgContrHdrAddDets.ACMTargetTrdgContrType AS ACMTargetTrdgContrType,
  TrdgContrHdrAddDets.ACMTargetTrdgContrTypeName AS ACMTargetTrdgContrTypeName,
  TrdgContrHdrAddDets.ACMTrdgContrQuotesValidDate AS ACMTrdgContrQuotesValidDate,
  Status.TrdgContrApplStsName AS bezei,
  ContractType.TradingContractTypeName AS tctyp_descr,
  CreatedbyDetails.UserDescription AS CreatedBy,
  DistributionChannelText.DistributionChannelText AS DistributionChannelDescr,
  OrganizationDivisionName.DivisionName AS SalesDivisionDescr,
  SalesOrganizationText.SalesOrganizationText AS SalesOrgDescr,
  personresponsibledetails.UserDescription AS PersonResponsibleName,
  Shadow.DocumentSide AS Side
FROM I_ACMContractHeader AS Header
INNER JOIN I_ACMTrdgContrShadowItemDets AS Shadow ON /* join condition not captured in parsed metadata */
;