C_ExcessRqmtQtySlsContrItm

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_ExcessRqmtQtySlsContrItm.
-- 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 C_ExcessRqmtQtySlsContrItm AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  SalesDocumentItemUUID,
  FormattedSalesDocumentItem,
  CreatedByUser,
  _CreatedByUser.UserDescription AS UserDescription,
  CreationDate,
  SalesDocumentType,
  _SalesDocumentTypeText.SalesDocumentTypeName AS SalesDocumentTypeName,
  SalesOrganization,
  _SalesOrganizationText.SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannelText.DistributionChannelName AS DistributionChannelName,
  OrganizationDivision,
  _OrganizationDivisionText.DivisionName AS DivisionName,
  Division,
  SalesDistrict,
  _SalesDistrictText.SalesDistrictName AS SalesDistrictName,
  SDDocumentReason,
  _SDDocumentReasonText.SDDocumentReasonText AS SDDocumentReasonText,
  _SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  _SalesDocument.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  CrossPlantConfigurableProduct,
  _ConfigurableProductText.MaterialName AS CrsPlntConfigurableProductName,
  MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  AdditionalMaterialGroup1,
  _AdditionalMaterialGroup1Name.AdditionalMaterialGroup1Name AS AdditionalMaterialGroup1Name,
  AdditionalMaterialGroup2,
  _AdditionalMaterialGroup2Name.AdditionalMaterialGroup2Name AS AdditionalMaterialGroup2Name,
  AdditionalMaterialGroup3,
  _AdditionalMaterialGroup3Name.AdditionalMaterialGroup3Name AS AdditionalMaterialGroup3Name,
  AdditionalMaterialGroup4,
  _AdditionalMaterialGroup4Name.AdditionalMaterialGroup4Name AS AdditionalMaterialGroup4Name,
  AdditionalMaterialGroup5,
  _AdditionalMaterialGroup5Name.AdditionalMaterialGroup5Name AS AdditionalMaterialGroup5Name,
  SalesDocumentItemCategory,
  _ItemCategoryText.SalesDocumentItemCategoryName AS SalesDocumentItemCategoryName,
  Plant,
  _Plant.PlantName AS PlantName,
  RequestedDeliveryDate,
  CustomerGroup,
  _CustomerGroupText.CustomerGroupName AS CustomerGroupName,
  FashionCancelDate,
  SoldToParty,
  BillingCompanyCode,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  SalesDocumentRjcnReason,
  RequirementSegment,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  OpenForConfQtyInBaseUnit,
  AssignedQuantityInBaseUnit,
  OpenForAssignmentQtyInBsUnt,
  ContractItmCnsmdQtyInBsUnt,
  OpenContrRefQtyInBsUnt,
  OpenForConfReqdQtyRatioPct,
  OpenForAssgmtReqdQtyRatioPct,
  OpenContrRefReqdQtyRatioPct,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ProductCharacteristic1,
  _CharValTexts1.RetailCharacteristicValueDesc AS ProductCharacteristic1Desc,
  ProductCharacteristic2,
  _CharValTexts1.RetailCharacteristicValueDesc AS ProductCharacteristic2Desc,
  ProductCharacteristic3,
  _CharValTexts1.RetailCharacteristicValueDesc AS ProductCharacteristic3Desc,
  DeliveryPriority,
  _DeliveryPriorityText.DeliveryPriorityDesc AS DeliveryPriorityDesc,
  Batch,
  NetPriceAmount,
  TransactionCurrency,
  ShippingPoint,
  _ShippingPointText.ShippingPointName AS ShippingPointName,
  CustomerPaymentTerms,
  _CustomerPaymentTermsText.CustomerPaymentTermsName AS CustomerPaymentTermsName,
  IncotermsClassification,
  _IncotermsClassificationText.IncotermsClassificationName AS IncotermsClassificationName,
  cast ('' as rfm_document_type ) AS ExcessRqmtDocumentType,
  cast ('' as rfm_rejection_type ) AS ExcessRqmtQtyRejectionType,
  cast (0 as rfm_rejection_qty ) AS ExcessRqmtRejectionQuantity,
  cast ('' as apj_job_text ) AS ApplicationJobDescription,
  cast ('' as ebeln ) AS PurchaseOrder,
  cast ('' as ekorg ) AS PurchasingOrganization,
  cast ('' as ekgrp ) AS PurchasingGroup,
  cast ('' as bsart ) AS PurchaseOrderType,
  cast ('' as reswk ) AS SupplyingPlant,
  ItemGeneralIncompletionStatus,
  ItemBillingIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  RqmtIsSupAssgmtRelevant,
  ProdCharc1InternalNumber,
  ProdCharc2InternalNumber,
  ProdCharc3InternalNumber
FROM I_ExcessRqmtQtySlsContrItm
LEFT OUTER JOIN I_Material AS _ConfigurableProduct ON CrossPlantConfigurableProduct = _ConfigurableProduct.Material  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON DistributionChannel = _DistributionChannelText.DistributionChannel AND _DistributionChannelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _OrganizationDivisionText ON OrganizationDivision = _OrganizationDivisionText.Division AND _OrganizationDivisionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _ConfigurableProductText ON CrossPlantConfigurableProduct = _ConfigurableProductText.Material AND _ConfigurableProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup1Text AS _AdditionalMaterialGroup1Name ON AdditionalMaterialGroup1 = _AdditionalMaterialGroup1Name.AdditionalMaterialGroup1 AND _AdditionalMaterialGroup1Name.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup2Text AS _AdditionalMaterialGroup2Name ON AdditionalMaterialGroup2 = _AdditionalMaterialGroup2Name.AdditionalMaterialGroup2 AND _AdditionalMaterialGroup2Name.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup3Text AS _AdditionalMaterialGroup3Name ON AdditionalMaterialGroup3 = _AdditionalMaterialGroup3Name.AdditionalMaterialGroup3 AND _AdditionalMaterialGroup3Name.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup4Text AS _AdditionalMaterialGroup4Name ON AdditionalMaterialGroup4 = _AdditionalMaterialGroup4Name.AdditionalMaterialGroup4 AND _AdditionalMaterialGroup4Name.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup5Text AS _AdditionalMaterialGroup5Name ON AdditionalMaterialGroup5 = _AdditionalMaterialGroup5Name.AdditionalMaterialGroup5 AND _AdditionalMaterialGroup5Name.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint AND _ShippingPointText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentTypeText AS _SalesDocumentTypeText ON SalesDocumentType = _SalesDocumentTypeText.SalesDocumentType AND _SalesDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts1 ON ProductCharacteristic1 = _CharValTexts1.RetailCharacteristicValue AND ProdCharc1InternalNumber = _CharValTexts1.CharacteristicInternalID AND _CharValTexts1.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts2 ON ProductCharacteristic2 = _CharValTexts2.RetailCharacteristicValue AND ProdCharc2InternalNumber = _CharValTexts2.CharacteristicInternalID AND _CharValTexts2.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts3 ON ProductCharacteristic3 = _CharValTexts3.RetailCharacteristicValue AND ProdCharc3InternalNumber = _CharValTexts3.CharacteristicInternalID AND _CharValTexts3.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriorityText AS _DeliveryPriorityText ON DeliveryPriority = _DeliveryPriorityText.DeliveryPriority AND _DeliveryPriorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategoryT AS _ItemCategoryText ON SalesDocumentItemCategory = _ItemCategoryText.SalesDocumentItemCategory AND _ItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTermsText AS _CustomerPaymentTermsText ON CustomerPaymentTerms = _CustomerPaymentTermsText.CustomerPaymentTerms AND _CustomerPaymentTermsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification AND _IncotermsClassificationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroupText AS _CustomerGroupText ON CustomerGroup = _CustomerGroupText.CustomerGroup AND _CustomerGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrictText AS _SalesDistrictText ON SalesDistrict = _SalesDistrictText.SalesDistrict AND _SalesDistrictText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReasonText AS _SDDocumentReasonText ON SDDocumentReason = _SDDocumentReasonText.SDDocumentReason AND _SDDocumentReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _SalesDocHeaderExtension ON SalesDocument = _SalesDocHeaderExtension.SalesDocument  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _SalesDocItemExtension ON SalesDocument = _SalesDocItemExtension.SalesDocument AND SalesDocumentItem = _SalesDocItemExtension.SalesDocumentItem  -- association [0..1]
;