P_ACMTrdgContrHdr

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_ACMTrdgContrHdr.
-- 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: PACMTRDGCONTRHDR

CREATE VIEW P_ACMTrdgContrHdr AS
SELECT
  Header.tkonn AS TradingContractNumber,
  Header.tctyp AS TradingContractType,
  Header.btbsta AS ContractStatus,
  Status.ACMTrdgContrStatusCategory AS ACMTrdgContrStatusCategory,
  ContractType.ACMContractCategory AS ACMContractCategory,
  ContractType.ACMTradingContractCategory AS TrdgContractCategory,
  Business.TradingContractCurrency AS TradingContractCurrency,
  Business.TrdgContrPurgPaymentTerms AS PaymentTerms,
  Header.vkorg AS SalesOrganization,
  Header.vtweg AS DistributionChannel,
  Header.spart AS Division,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.PurchasingGroup AS PurchasingGroup,
  Header.tkonn_ex AS TradingContractExternalID,
  Header.erdat AS DocumentDate,
  Header.tksachb AS PersonResponsible,
  Header.ernam AS TradingContractCreatedBy,
  Header.aenam AS TradingContractChangedBy,
  Header.aedat AS TradingContractChangedOnDate,
  Counterparty.Counterparty AS Counterparty,
  Business.ACMPurgIncotermsPart1 AS Incoterms,
  Business.TrdgContrPurgIncotermsLoc1Text AS IncotermsLocation1,
  Header.company_code AS CompanyCode,
  TrdgContrHdrOthDet.ACMTradingContractCurrency AS ACMTradingContractCurrency,
  TrdgContrHdrOthDet.ACMBidValidTillDate AS ACMBidValidTillDate,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference,
  TrdgContrHdrAddDets.ACMTrdgContrIsStatusClosed AS ACMTrdgContrIsStatusClosed,
  TrdgContrHdrAddDets.TradingContractTradeOffice AS TradingContractTradeOffice,
  TrdgContrHdrAddDets.TradingContractCreditSales AS TradingContractCreditSales,
  TrdgContrHdrAddDets.ACMSignedStatus AS ACMSignedStatus,
  cast(Shadow.DocumentSide as wlf_pr_side) as Side AS tkonnasTradingContractNumber,
  cast(Shadow.DocumentSide as wlf_pr_side) AS Side
INNER JOIN I_ContSubItem AS Business ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContrShadowItemDets AS Shadow ON /* join condition not captured in parsed metadata */
;