C_TrdgContrItemOutputForm

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_TrdgContrItemOutputForm.
-- 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: CTCITMOUTPUTFORM

CREATE VIEW C_TrdgContrItemOutputForm AS
SELECT
  R_TrdgContrItem.TradingContract AS TradingContract,
  R_TrdgContrItem.TradingContractItem AS TradingContractItem,
  PaymentGuaranteeProcedure,
  DepreciationPercentage,
  SupplierQuotationExternalID,
  PurchasingDocumentType,
  SupplierConfirmationControlKey,
  CustomerPurchaseOrderDate,
  CustPurOrdDateByShipToParty,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  TrdgContrPurgDocCat,
  DownPaymentDueDate,
  DownPaymentPercentageOfTotAmt,
  DownPaymentType,
  PurchasingDocumentOrderDate,
  TrdgContrSlsReqdDeliveryDate,
  TrdgContrPurgReqdDeliveryDate,
  PurchasingGroup,
  PurchasingOrganization,
  Supplier,
  TrdgContrPurgShipgInstrn,
  TrdgContrPurgDelivAddrCat,
  QuotationSubmissionDate,
  TrdgContrPurgDocExtReference,
  PurgIncotermsClassification,
  SlsIncotermsClassification,
  TrdgContrPurgIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc1Text,
  PurgIncotermsTransferLocation,
  SlsIncotermsTransferLocation,
  TrdgContrPurgIncotermsLoc2Text,
  TrdgContrSlsIncotermsLoc2Text,
  TrdgContrPurgIncotermsVersion,
  TrdgContrSalesIncotermsVersion,
  TrdgContrPurgPricingProcedure,
  TrdgContrPurgValidityStartDate,
  TrdgContrPurgValidityEndDate,
  FixedExchangeRateIsUsed,
  TrdgContrPurgExchangeRateType,
  IsOrderAcknRqd,
  OrderCombinationIsAllowed,
  PurgDocOrderAcknNumber,
  InternalFinancialDocument,
  TrdgContrPurgDeliveryDateType,
  SEPAMandate,
  UnderlyingPurchaseOrderItem,
  TrdgContrMnlPOSplit,
  TrdgContrSlsDeliveryDateType,
  TrdgContrPurgPricingDate,
  TrdgContrSalesPricingDate,
  SupplyingPlant,
  RetentionPercentage,
  SupplierPhoneNumber,
  PaymentTermsName,
  TrdgContrPurgExchangeRate,
  CorrespncInternalReference,
  TrdgContrPurgFixedValueDate,
  TrdgContrSalesFixedValueDate,
  SupplierRespSalesPersonName,
  ShippingType,
  IssuingPlant,
  TrdgContrSalesPaymentMethod,
  TrdgContrPurgPaymentTerms,
  TrdgContrSalesPaymentTerms,
  TrdgContrPurgDocCndn,
  TradingContractItemCategory,
  Product,
  TrdgContrItemText,
  ProductGroup,
  TrdgContrReltdDocItmValnType,
  Plant,
  StorageLocation,
  Batch,
  OrganizationDivision,
  BusinessArea,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TrdgContrPurgQuantity,
  TrdgContrPurgQuantityUnit,
  TrdgContrSlsQuantityUnit,
  TrdgContrSalesQuantity,
  TrdgContrSlsToBaseQtyNmrtr,
  TrdgContrSlsToBaseQtyDnmntr,
  BaseUnit,
  TrdgContrPurgToBaseQtyNmrtr,
  TrdgContrPurgToBaseQtyDnmntr,
  TrdgContrPurgToOrdQtyNmrtr,
  TrdgContrPurgToOrdQtyDnmntr,
  TrdgContrSlsToOrdQtyNmrtr,
  TrdgContrSlsToOrdQtyDnmntr,
  TrdgContrPurgCurrency,
  TradingContractSalesCurrency,
  TrdgContrSlsWeightUnit,
  TrdgContrSlsGrossWeight,
  TrdgContrSlsNetWeight,
  TrdgContrSlsVolumeUnit,
  TrdgContrSlsVolume,
  TrdgContrPurgGrossWeight,
  TrdgContrPurgNetWeight,
  TrdgContrPurgVolume,
  TrdgContrSlsPriceUnit,
  TrdgContrPurgPriceUnit,
  TrdgContrPurgNetPriceQuantity,
  TrdgContrSlsNetPriceQuantity,
  TrdgContrSalesNetPriceAmount,
  TrdgContrPurgNetPriceAmount,
  TrdgContrSlsItemNetAmount,
  TrdgContrPurgItemNetAmount,
  TrdgContrSlsItmNetAmtInSlsCrcy,
  TrdgContrPurgItmNetAmtInPOCrcy,
  TrdgContrPurgSubtotal1Amount,
  TrdgContrPurgSubtotal2Amount,
  TrdgContrPurgSubtotal3Amount,
  TrdgContrPurgSubtotal4Amount,
  TrdgContrPurgSubtotal5Amount,
  TrdgContrPurgSubtotal6Amount,
  TrdgContrSlsSubtotal1Amount,
  TrdgContrSlsSubtotal2Amount,
  TrdgContrSlsSubtotal3Amount,
  TrdgContrSlsSubtotal4Amount,
  TrdgContrSlsSubtotal5Amount,
  TrdgContrSlsSubtotal6Amount,
  SlsUnlmtdOvrdelivIsAllwd,
  SlsOvrdelivTolLmtRatioInPct,
  SlsUndrdelivTolLmtRatioInPct,
  PurgUnlmtdOvrdelivIsAllwd,
  PurgOvrdelivTolLmtRatioInPct,
  PurgUndrdelivTolLmtRatioInPct,
  SalesDocumentRjcnReason,
  ProductHierarchyNode,
  ProductUsedByCustomer,
  ProductTaxClassification1,
  ProductTaxClassification2,
  ProductTaxClassification3,
  ProductTaxClassification4,
  ProductTaxClassification5,
  ProductTaxClassification6,
  ProductTaxClassification7,
  ProductTaxClassification8,
  ProductTaxClassification9,
  InternationalArticleNumber,
  ProfitCenter,
  CostCenter,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  ItemBillingBlockReason,
  MaxNmbrOfPartialDelivery,
  PartialDeliveryIsAllowed,
  TrdgContrSlsShippingPoint,
  TradingDocumentPurchasingRoute,
  TradingDocumentSalesRoute,
  TrdgContrPurgShippingCondition,
  TrdgContrPurgShippingPoint,
  TrdgContrPurgTaxCode,
  ValuationCategory,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  GoodsReceiptLatestCreationDate,
  BatchClassification,
  TrdgContrBusinessItem,
  TrdgContrItemIsExtended,
  TrdgContrItemIsDeleted,
  TrdgPortfolioInternalID,
  TrdgContrItmPrtfloDetnDate,
  TrdgContrRefDocument,
  TrdgContrRefDocItem,
  TrdgContrReferenceDocumentType,
  TrdgContrAddlRefDocument,
  TrdgContrAddlRefDocItem,
  TrdgContrAddlRefDocumentType,
  TrdgContrBusinessScenario,
  TrdgContrAssociationGroup,
  SupplierProductID,
  TrdgContrOriglReqdProd,
  TrdgContrHigherLevelItem,
  TrdgContrPrcDetnIsIncomplete,
  TrdgContrPurgBOMItmQty,
  TrdgContrSlsBOMItmQty,
  TrdgContrBOMKeyDate,
  QuantityIsFixed,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  TrdgContrPrcgRefProduct,
  TrdgContrProdUsgeCat,
  TrdgContrSlsItmEffctvAmount,
  TrdgContrPurgItmEffctvAmount,
  TrdgContrSlsIsCshDiscGrntd,
  TrdgContrPurgIsCshDiscGrntd,
  TrdgContrPredecessorDocument,
  TrdgContrPredecessorItem,
  TrdgContrPrdcssrDocumentType,
  TrdgContrPurgTaxAmount,
  TrdgContrSlsTaxAmount,
  TrdgContrHdggRlvt,
  TrdgContrCndnCnsldtnCat,
  TrdgContrCndnIsCnsldtd,
  TrdgContrSTOPostingLogic,
  TrdgContrSettlementMode,
  IssuingStorageLocation,
  TrdgContrPurgTaxJurisdiction,
  PaymentGuaranteeForm,
  DownPaymentAmount,
  SupplierTotalGrossAmount,
  TrdgContrBOMProfile,
  AlternativeBillOfMaterial,
  TrdgContrPurgRiskRelevancy,
  TrdgContrSlsRiskRelevancy,
  TrdgContrSlsClfnObjInternalID,
  TrdgContrPurgClfnObjInternalID,
  TrdgContrProdSizeOrDimnDesc,
  TrdgContrItemIsComplete,
  TradingContractInternalOrder,
  TrdgContrItemBlockCode,
  TrdgContrPurgTaxCountry,
  TrdgContrPurgTaxDate,
  TradingContractCurrency,
  ControllingArea,
  TrdgContrBillOfMaterial,
  TrdgContrPurchaseOrderItem,
  TrdgContrPrcDetnExchRate,
  TrdgContrIsRlvtPoDProcg
FROM R_TrdgContrItem
LEFT OUTER JOIN C_TrdgContrOutputForm AS _TrdgContrOutputForm ON TradingContract = _TrdgContrOutputForm.TradingContract  -- association [1..1]
LEFT OUTER JOIN I_TrdgContrItemPartner AS _TrdgContrItemPartner ON TradingContract = _TrdgContrItemPartner.TradingContract AND TradingContractItem = _TrdgContrItemPartner.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN I_TrdgContrItmSlsPrcgElmnt AS _TrdgContrItmSlsPrcgElmnt ON TradingContract = _TrdgContrItmSlsPrcgElmnt.TradingContract AND TradingContractItem = _TrdgContrItmSlsPrcgElmnt.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN I_TrdgContr AS _TrdgContr ON TradingContract = _TrdgContr.TradingContract  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TrdgDocSlsQuantityUnit ON TrdgContrSlsQuantityUnit = _TrdgDocSlsQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _TrdgDocControllingArea ON ControllingArea = _TrdgDocControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _TrdgDocProfitCenter ON ProfitCenter = _TrdgDocProfitCenter.ProfitCenter AND _TrdgDocProfitCenter.ValidityEndDate >= CreationDate AND _TrdgDocProfitCenter.ValidityStartDate <= CreationDate AND ControllingArea = _TrdgDocProfitCenter.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _TrdgDocCostCenter ON CostCenter = _TrdgDocCostCenter.CostCenter AND ControllingArea = _TrdgDocCostCenter.ControllingArea AND _TrdgDocCostCenter.ValidityEndDate >= CreationDate AND _TrdgDocCostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _TrdgContrInternalOrder ON TradingContractInternalOrder = _TrdgContrInternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN C_TrdgContrItemOutputForm AS _HigherLevelItem ON TradingContract = _HigherLevelItem.TradingContract AND TrdgContrHigherLevelItem = _HigherLevelItem.TradingContractItem  -- association [0..1]
;