C_RFM_MaSaDoEditSlsOrdGnrcItm

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_RFM_MaSaDoEditSlsOrdGnrcItm.
-- 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: CRFMMASADOESDGI

CREATE VIEW C_RFM_MaSaDoEditSlsOrdGnrcItm AS
SELECT
  SalesOrder,
  SalesOrderItem,
  SalesOrder AS SalesDocument,
  cast(concat(concat(SalesDocument, '/'), SalesDocumentItem) as rfm_formattedsalesdocitm preserving type) AS FormattedSalesDocumentItem,
  CustomerPurchaseOrderType,
  RequestedDeliveryDate,
  cast ('00000000' as eindt ) AS FirstDeliveryDate,
  RequirementSegment,
  Plant,
  StorageLocation,
  ShippingPoint,
  DeliveryPriority,
  IncotermsClassification,
  IncotermsLocation1,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  FashionCancelDate,
  SalesDocumentRjcnReason,
  ProductGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  HigherLevelItem,
  PricingDate,
  CustomerPriceGroup,
  ShippingType,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  BillingDocumentDate,
  MaterialPricingGroup,
  Route,
  MaterialByCustomer,
  OrganizationDivision,
  SalesDocumentType,
  SalesOrganization,
  DistributionChannel,
  SDDocumentCategory,
  SalesDocumentDate,
  SoldToParty,
  CreatedByUser,
  CreationDate,
  SalesDistrict,
  SalesOffice,
  SalesGroup,
  ShippingCondition,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  RetailAdditionalCustomerGrp6,
  RetailAdditionalCustomerGrp7,
  RetailAdditionalCustomerGrp8,
  RetailAdditionalCustomerGrp9,
  RetailAdditionalCustomerGrp10,
  CustomerPurchaseOrderDate,
  DeliveryBlockReason,
  HeaderBillingBlockReason,
  CustomerPaymentTerms,
  SDDocumentReason,
  HdrGeneralIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  TotalCreditCheckStatus,
  HeaderBillgIncompletionStatus,
  OvrlItmBillingIncompletionSts,
  OverallPricingIncompletionSts,
  HeaderDelivIncompletionStatus,
  OvrlItmDelivIncompletionSts,
  DepartmentClassificationByCust,
  Material,
  RqmtIsSupAssgmtRelevant,
  AgrmtValdtyStartDate,
  AgrmtValdtyEndDate,
  SalesDocumentHasRejection,
  cast( '' as sit2_de_st_id ) AS SitnDefinitionID,
  cast('' as abap.char( 1 )) AS PricingType,
  cast ('' as abap.char( 120 )) AS InternalComment,
  cast ('' as abap.sstring( 1332 )) AS SalesDocsInclusionListValue,
  cast ('' as abap.sstring( 1332 )) AS SalesDocsExclusionListValue,
  cast ('' as abap.char( 1 )) AS SalesOrdItemsAreSelected,
  cast ('' as abap.char( 1 )) AS SalesOrdItemIsSelected,
  cast ('' as abap.char( 1 )) AS SalesOrdGnrcArticleIsSelected,
  cast ('' as abap.char( 1 )) AS MngSlsOrdsMassUpdateExecMode,
  cast('' as rfm_sd_log_action ) AS RFM_SD_ApplJobAction
FROM I_RFM_MaSaDoSlsDocumentItm
LEFT OUTER JOIN C_RFM_MaSaDoSlsOrdHdr AS _SlsOrdHdr ON SalesOrder = _SlsOrdHdr.SalesOrder  -- association [1..1]
LEFT OUTER JOIN C_RFM_MaSaDoSlsOrdGnrcItm AS _SlsOrdGnrcItm ON SalesOrder = _SlsOrdGnrcItm.SalesOrder AND HigherLevelItem = _SlsOrdGnrcItm.SalesOrderItem  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesOrder = _SalesDocumentItem.SalesDocument AND SalesOrderItem = _SalesDocumentItem.SalesDocumentItem  -- association [1..1]
;