R_SalesContractItemTP

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_SalesContractItemTP.
-- 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_SalesContractItemTP AS
SELECT
  SalesContract,
  SalesContractItem,
  SalesContractItemCategory,
  SalesDocumentItemType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  Division,
  Product,
  ProductGroup,
  MaterialByCustomer,
  Batch,
  cast (MaterialPricingGroup as productpricinggroup preserving type ) AS MaterialPricingGroup,
  Plant,
  StorageLocation,
  SalesContractItemText,
  PurchaseOrderByCustomer,
  OrderQuantity,
  OrderQuantityUnit,
  TargetQuantity,
  TargetQuantityUnit,
  RequestedQuantity,
  ReferenceSDDocument,
  RequestedQuantityUnit,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  OutlineAgreementTargetAmount,
  SalesContractReleasedAmount,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  CustomerGroup,
  SalesDocumentRjcnReason,
  ServicesRenderedDate,
  NetAmount,
  TransactionCurrency,
  PricingDate,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  TaxAmount,
  CostAmount,
  ShippingType,
  ShippingPoint,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  Route,
  CustomerPriceGroup,
  ItemBillingBlockReason,
  BillingDocumentDate,
  BillingPlan,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  BusinessArea,
  ControllingArea,
  ProfitCenter,
  MatlAccountAssignmentGroup,
  WBSElementInternalID,
  _WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  _SalesContract.SDPricingProcedure AS SDPricingProcedure,
  _ItemEnhancedFields.ItemCategoryGroup AS ItemCategoryGroup,
  _ItemEnhancedFields.SDDocumentItemUsage AS SDDocumentItemUsage,
  SalesContractItem._HigherLevelItem.SalesContractItemCategory AS HigherLevelItemCategory,
  BillingBlockStatus,
  SDProcessStatus,
  ItemGeneralIncompletionStatus,
  ItemBillingIncompletionStatus,
  PricingIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  SDDocumentRejectionStatus,
  TotalSDDocReferenceStatus,
  SDDocReferenceStatus,
  ContractItemDownPaymentStatus,
  ChmlCmplncStatus,
  DangerousGoodsStatus,
  SafetyDataSheetStatus,
  TrdCmplncEmbargoSts,
  TrdCmplncSnctndListChkSts,
  OvrlTrdCmplncLegalCtrlChkSts,
  _SalesContract.SalesContractType AS SalesContractType,
  _SalesContract.OrganizationDivision AS OrganizationDivision,
  _SalesContract.SalesOrganization AS SalesOrganization,
  _SalesContract.DistributionChannel AS DistributionChannel,
  _ItemEnhancedFields._ItemCategoryGroup AS _ItemCategoryGroup,
  _ItemEnhancedFields._SDDocumentItemUsage AS _SDDocumentItemUsage,
  _SalesContract._SDPricingProcedure AS _SDPricingProcedure
FROM I_SalesContractItem AS SalesContractItem
LEFT OUTER JOIN I_SlsDocItemEnhancedFields AS _ItemEnhancedFields ON SalesContract = _ItemEnhancedFields.SalesDocument AND SalesContractItem = _ItemEnhancedFields.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _HigherLevelItemCategory ON HigherLevelItemCategory = _HigherLevelItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ProductPricingGroup AS _ProductPricingGroup ON MaterialPricingGroup = _ProductPricingGroup.ProductPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesContract = _Extension.SalesDocument AND SalesContractItem = _Extension.SalesDocumentItem  -- association [1]
LEFT OUTER JOIN R_SalesContractItemPartnerTP AS _ItemPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesContractItemTextTP AS _ItemText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsContrItemPricingElementTP AS _ItemPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsContractItemBillingPlanTP AS _ItemBillingPlan ON /* condition not available in parsed metadata */  -- association [0..1]
;