R_TrdgContrItem

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 R_TrdgContrItem.
-- 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.

CREATE VIEW R_TrdgContrItem AS
SELECT
  TradingDocument AS TradingContract,
  TradingDocumentItem AS TradingContractItem,
  PaymentGuaranteeProcedure,
  DepreciationPercentage,
  SupplierQuotationExternalID,
  PurchasingDocumentType,
  SupplierConfirmationControlKey,
  CustomerPurchaseOrderDate,
  CustPurOrdDateByShipToParty,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  _TrdgDoc.TrdgDocPurgDocCat AS TrdgContrPurgDocCat,
  DownPaymentDueDate,
  DownPaymentPercentageOfTotAmt,
  DownPaymentType,
  PurchasingDocumentOrderDate,
  TrdgDocSlsReqdDeliveryDate AS TrdgContrSlsReqdDeliveryDate,
  TrdgDocPurgReqdDeliveryDate AS TrdgContrPurgReqdDeliveryDate,
  PurchasingGroup,
  PurchasingOrganization,
  Supplier,
  TrdgDocPurgShipgInstrn AS TrdgContrPurgShipgInstrn,
  TrdgDocPurgDelivAddrCat AS TrdgContrPurgDelivAddrCat,
  QuotationSubmissionDate,
  TrdgDocPurgDocExtReference AS TrdgContrPurgDocExtReference,
  PurgIncotermsClassification,
  SlsIncotermsClassification,
  TrdgDocPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  TrdgDocSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  PurgIncotermsTransferLocation,
  SlsIncotermsTransferLocation,
  TrdgDocPurgIncotermsLoc2Text AS TrdgContrPurgIncotermsLoc2Text,
  TrdgDocSlsIncotermsLoc2Text AS TrdgContrSlsIncotermsLoc2Text,
  TrdgDocPurgIncotermsVersion AS TrdgContrPurgIncotermsVersion,
  TrdgDocSalesIncotermsVersion AS TrdgContrSalesIncotermsVersion,
  TrdgDocPurgPricingProcedure AS TrdgContrPurgPricingProcedure,
  TrdgDocPurgValidityStartDate AS TrdgContrPurgValidityStartDate,
  TrdgDocPurgValidityEndDate AS TrdgContrPurgValidityEndDate,
  FixedExchangeRateIsUsed,
  _TrdgDoc.TrdgDocPurgExchangeRateType AS TrdgContrPurgExchangeRateType,
  IsOrderAcknRqd,
  OrderCombinationIsAllowed,
  PurgDocOrderAcknNumber,
  InternalFinancialDocument,
  TrdgDocPurgDeliveryDateType AS TrdgContrPurgDeliveryDateType,
  SEPAMandate,
  UnderlyingPurchaseOrderItem,
  TrdgDocMnlPOSplit AS TrdgContrMnlPOSplit,
  TrdgDocSlsDeliveryDateType AS TrdgContrSlsDeliveryDateType,
  TrdgDocPurgPricingDate AS TrdgContrPurgPricingDate,
  TrdgDocSalesPricingDate AS TrdgContrSalesPricingDate,
  SupplyingPlant,
  RetentionPercentage,
  SupplierPhoneNumber,
  PaymentTermsName,
  TrdgDocPurgExchangeRate AS TrdgContrPurgExchangeRate,
  CorrespncInternalReference,
  TrdgDocPurgFixedValueDate AS TrdgContrPurgFixedValueDate,
  TrdgDocSalesFixedValueDate AS TrdgContrSalesFixedValueDate,
  SupplierRespSalesPersonName,
  ShippingType,
  IssuingPlant,
  TrdgDocSalesPaymentMethod AS TrdgContrSalesPaymentMethod,
  TrdgDocPurgPaymentTerms AS TrdgContrPurgPaymentTerms,
  TrdgDocSalesPaymentTerms AS TrdgContrSalesPaymentTerms,
  TrdgDocPurgDocCndn AS TrdgContrPurgDocCndn,
  TrdgDocItemCategory AS TradingContractItemCategory,
  Product,
  TrdgDocItemText AS TrdgContrItemText,
  ProductGroup,
  TrdgDocReltdDocItmValnType AS TrdgContrReltdDocItmValnType,
  Plant,
  StorageLocation,
  Batch,
  OrganizationDivision,
  BusinessArea,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TrdgDocPurgQuantity AS TrdgContrPurgQuantity,
  TrdgDocPurgQuantityUnit AS TrdgContrPurgQuantityUnit,
  TrdgDocSlsQuantityUnit AS TrdgContrSlsQuantityUnit,
  TrdgDocSalesQuantity AS TrdgContrSalesQuantity,
  TrdgDocSlsToBaseQtyNmrtr AS TrdgContrSlsToBaseQtyNmrtr,
  TrdgDocSlsToBaseQtyDnmntr AS TrdgContrSlsToBaseQtyDnmntr,
  BaseUnit,
  TrdgDocPurgToBaseQtyNmrtr AS TrdgContrPurgToBaseQtyNmrtr,
  TrdgDocPurgToBaseQtyDnmntr AS TrdgContrPurgToBaseQtyDnmntr,
  TrdgDocPurgToOrdQtyNmrtr AS TrdgContrPurgToOrdQtyNmrtr,
  TrdgDocPurgToOrdQtyDnmntr AS TrdgContrPurgToOrdQtyDnmntr,
  TrdgDocSlsToOrdQtyNmrtr AS TrdgContrSlsToOrdQtyNmrtr,
  TrdgDocSlsToOrdQtyDnmntr AS TrdgContrSlsToOrdQtyDnmntr,
  TrdgDocPurgCurrency AS TrdgContrPurgCurrency,
  TrdgDocSalesCurrency AS TradingContractSalesCurrency,
  TrdgDocSlsWeightUnit AS TrdgContrSlsWeightUnit,
  TrdgDocSlsGrossWeight AS TrdgContrSlsGrossWeight,
  TrdgDocSlsNetWeight AS TrdgContrSlsNetWeight,
  TrdgDocSlsVolumeUnit AS TrdgContrSlsVolumeUnit,
  TrdgDocSlsVolume AS TrdgContrSlsVolume,
  TrdgDocPurgGrossWeight AS TrdgContrPurgGrossWeight,
  TrdgDocPurgNetWeight AS TrdgContrPurgNetWeight,
  TrdgDocPurgVolume AS TrdgContrPurgVolume,
  TrdgDocSlsPriceUnit AS TrdgContrSlsPriceUnit,
  TrdgDocPurgPriceUnit AS TrdgContrPurgPriceUnit,
  TrdgDocPurgNetPriceQuantity AS TrdgContrPurgNetPriceQuantity,
  TrdgDocSlsNetPriceQuantity AS TrdgContrSlsNetPriceQuantity,
  TrdgDocSalesNetPriceAmount AS TrdgContrSalesNetPriceAmount,
  TrdgDocPurgNetPriceAmount AS TrdgContrPurgNetPriceAmount,
  TrdgDocSlsItemNetAmount AS TrdgContrSlsItemNetAmount,
  TrdgDocPurgItemNetAmount AS TrdgContrPurgItemNetAmount,
  TrdgDocSlsItmNetAmtInSlsCrcy AS TrdgContrSlsItmNetAmtInSlsCrcy,
  TrdgDocPurgItmNetAmtInPOCrcy AS TrdgContrPurgItmNetAmtInPOCrcy,
  TrdgDocPurgSubtotal1Amount AS TrdgContrPurgSubtotal1Amount,
  TrdgDocPurgSubtotal2Amount AS TrdgContrPurgSubtotal2Amount,
  TrdgDocPurgSubtotal3Amount AS TrdgContrPurgSubtotal3Amount,
  TrdgDocPurgSubtotal4Amount AS TrdgContrPurgSubtotal4Amount,
  TrdgDocPurgSubtotal5Amount AS TrdgContrPurgSubtotal5Amount,
  TrdgDocPurgSubtotal6Amount AS TrdgContrPurgSubtotal6Amount,
  TrdgDocSlsSubtotal1Amount AS TrdgContrSlsSubtotal1Amount,
  TrdgDocSlsSubtotal2Amount AS TrdgContrSlsSubtotal2Amount,
  TrdgDocSlsSubtotal3Amount AS TrdgContrSlsSubtotal3Amount,
  TrdgDocSlsSubtotal4Amount AS TrdgContrSlsSubtotal4Amount,
  TrdgDocSlsSubtotal5Amount AS TrdgContrSlsSubtotal5Amount,
  TrdgDocSlsSubtotal6Amount AS 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,
  TrdgDocSlsShippingPoint AS TrdgContrSlsShippingPoint,
  TradingDocumentPurchasingRoute,
  TradingDocumentSalesRoute,
  TrdgDocPurgShippingCondition AS TrdgContrPurgShippingCondition,
  TrdgDocPurgShippingPoint AS TrdgContrPurgShippingPoint,
  TrdgDocPurgTaxCode AS TrdgContrPurgTaxCode,
  ValuationCategory,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  GoodsReceiptLatestCreationDate,
  BatchClassification,
  TradingDocumentBusinessItem AS TrdgContrBusinessItem,
  TrdgDocItemIsExtended AS TrdgContrItemIsExtended,
  TrdgDocItemIsDeleted AS TrdgContrItemIsDeleted,
  TrdgPortfolioInternalID,
  TrdgDocItmPrtfloDetnDate AS TrdgContrItmPrtfloDetnDate,
  TrdgDocRefDocument AS TrdgContrRefDocument,
  TrdgDocRefDocItem AS TrdgContrRefDocItem,
  TrdgDocReferenceDocumentType AS TrdgContrReferenceDocumentType,
  TrdgDocAddlRefDocument AS TrdgContrAddlRefDocument,
  TrdgDocAddlRefDocItem AS TrdgContrAddlRefDocItem,
  TrdgDocAddlRefDocumentType AS TrdgContrAddlRefDocumentType,
  TrdgDocBusinessScenario AS TrdgContrBusinessScenario,
  TrdgDocAssociationGroup AS TrdgContrAssociationGroup,
  SupplierProductID,
  TrdgDocOriglReqdProd AS TrdgContrOriglReqdProd,
  TradingDocumentHigherLevelItem AS TrdgContrHigherLevelItem,
  TrdgDocPrcDetnIsIncomplete AS TrdgContrPrcDetnIsIncomplete,
  TrdgDocPurgBOMItmQty AS TrdgContrPurgBOMItmQty,
  TrdgDocSlsBOMItmQty AS TrdgContrSlsBOMItmQty,
  TrdgDocBOMKeyDate AS TrdgContrBOMKeyDate,
  QuantityIsFixed,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  TrdgDocPrcgRefProduct AS TrdgContrPrcgRefProduct,
  _TrdgDoc.TrdgDocProdUsgeCat AS TrdgContrProdUsgeCat,
  TrdgDocSlsItmEffctvAmount AS TrdgContrSlsItmEffctvAmount,
  TrdgDocPurgItmEffctvAmount AS TrdgContrPurgItmEffctvAmount,
  TrdgDocSlsIsCshDiscGrntd AS TrdgContrSlsIsCshDiscGrntd,
  TrdgDocPurgIsCshDiscGrntd AS TrdgContrPurgIsCshDiscGrntd,
  TrdgDocPredecessorDocument AS TrdgContrPredecessorDocument,
  TrdgDocPredecessorItem AS TrdgContrPredecessorItem,
  TrdgDocPrdcssrDocumentType AS TrdgContrPrdcssrDocumentType,
  TrdgDocPurgTaxAmount AS TrdgContrPurgTaxAmount,
  TrdgDocSlsTaxAmount AS TrdgContrSlsTaxAmount,
  TrdgDocHdggRlvt AS TrdgContrHdggRlvt,
  TrdgDocCndnCnsldtnCat AS TrdgContrCndnCnsldtnCat,
  TrdgDocCndnIsCnsldtd AS TrdgContrCndnIsCnsldtd,
  TrdgDocSTOPostingLogic AS TrdgContrSTOPostingLogic,
  TrdgDocSettlementMode AS TrdgContrSettlementMode,
  IssuingStorageLocation,
  TrdgDocPurgTaxJurisdiction AS TrdgContrPurgTaxJurisdiction,
  PaymentGuaranteeForm,
  DownPaymentAmount,
  SupplierTotalGrossAmount,
  TrdgDocBOMProfile AS TrdgContrBOMProfile,
  AlternativeBillOfMaterial,
  TrdgDocPurgRiskRelevancy AS TrdgContrPurgRiskRelevancy,
  TrdgDocSlsRiskRelevancy AS TrdgContrSlsRiskRelevancy,
  TrdgDocSlsClfnObjInternalID AS TrdgContrSlsClfnObjInternalID,
  TrdgDocPurgClfnObjInternalID AS TrdgContrPurgClfnObjInternalID,
  TrdgDocProdSizeOrDimnDesc AS TrdgContrProdSizeOrDimnDesc,
  TrdgDocItemIsComplete AS TrdgContrItemIsComplete,
  TradingDocumentInternalOrder AS TradingContractInternalOrder,
  TrdgDocItemBlockCode AS TrdgContrItemBlockCode,
  TrdgDocPurgTaxCountry AS TrdgContrPurgTaxCountry,
  TrdgDocPurgTaxDate AS TrdgContrPurgTaxDate,
  _TrdgDoc.TrdgDocCurrency AS TradingContractCurrency,
  ControllingArea,
  TrdgDocBillOfMaterial AS TrdgContrBillOfMaterial,
  TrdgDocPurchaseOrderItem AS TrdgContrPurchaseOrderItem,
  TrdgDocPrcDetnExchRate AS TrdgContrPrcDetnExchRate,
  TrdgDocIsRlvtPoDProcg AS TrdgContrIsRlvtPoDProcg,
  TrdgDocSlsQtyInBaseUnit AS TrdgContrSlsQtyInBaseUnit,
  TrdgDocPurgQtyInBaseUnit AS TrdgContrPurgQtyInBaseUnit
FROM R_TrdgDocItem AS TrdgContrItem
LEFT OUTER JOIN R_TrdgContrItemPartner AS _TrdgContrItemPartner ON TradingContract = _TrdgContrItemPartner.TradingContract AND TradingContractItem = _TrdgContrItemPartner.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgContrItmSlsPrcgElmnt AS _TrdgContrItmSlsPrcgElmnt ON TradingContract = _TrdgContrItmSlsPrcgElmnt.TradingContract AND TradingContract = _TrdgContrItmSlsPrcgElmnt.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgContrItmPurgPrcgElmnt AS _TrdgContrItmPurgPrcgElmnt ON TradingContract = _TrdgContrItmPurgPrcgElmnt.TradingContract AND TradingContractItem = _TrdgContrItmPurgPrcgElmnt.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgContrScheduleLine AS _TrdgContrScheduleLine ON TradingContract = _TrdgContrScheduleLine.TradingContract AND TradingContractItem = _TrdgContrScheduleLine.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgContr AS _TrdgContr ON TradingContract = _TrdgContr.TradingContract  -- association [1..1]
;