A_CreditMemoRequest_2

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 A_CreditMemoRequest_2.
-- 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 A_CreditMemoRequest_2 AS
SELECT
  CreditMemoRequest.CreditMemoRequest AS CreditMemoRequest,
  cast(CreditMemoRequest.CreditMemoRequestType as auart_spr preserving type ) AS CreditMemoRequestType,
  CreditMemoRequest.SoldToParty AS SoldToParty,
  CreditMemoRequest.SalesOrganization AS SalesOrganization,
  CreditMemoRequest.OrganizationDivision AS OrganizationDivision,
  CreditMemoRequest.DistributionChannel AS DistributionChannel,
  CreditMemoRequest.SalesGroup AS SalesGroup,
  CreditMemoRequest.SalesOffice AS SalesOffice,
  CreditMemoRequest.SalesDistrict AS SalesDistrict,
  CreditMemoRequest.CreationDate AS CreationDate,
  CreditMemoRequest.CreatedByUser AS CreatedByUser,
  CreditMemoRequest.CreationTime AS CreationTime,
  CreditMemoRequest.LastChangedByUser AS LastChangedByUser,
  CreditMemoRequest.LastChangeDateTime AS LastChangeDateTime,
  CreditMemoRequest.CreditMemoRequestDate AS CreditMemoRequestDate,
  CreditMemoRequest.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CreditMemoRequest.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  CreditMemoRequest.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  CreditMemoRequest.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  CreditMemoRequest.CustPurOrdTypeByShipToParty AS CustPurOrdTypeByShipToParty,
  CreditMemoRequest.CorrespncExternalReference AS CorrespncExternalReference,
  CreditMemoRequest.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  CreditMemoRequest.PricingDate AS PricingDate,
  CreditMemoRequest.BillingDocumentDate AS BillingDocumentDate,
  CreditMemoRequest.ServicesRenderedDate AS ServicesRenderedDate,
  CreditMemoRequest.TotalNetAmount AS TotalNetAmount,
  CreditMemoRequest.TransactionCurrency AS TransactionCurrency,
  CreditMemoRequest.TotalBlockStatus AS TotalBlockStatus,
  CreditMemoRequest.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  CreditMemoRequest.SDDocumentReason AS SDDocumentReason,
  CreditMemoRequest.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  CreditMemoRequest.IncotermsClassification AS IncotermsClassification,
  CreditMemoRequest.IncotermsLocation1 AS IncotermsLocation1,
  CreditMemoRequest.IncotermsLocation2 AS IncotermsLocation2,
  CreditMemoRequest.IncotermsVersion AS IncotermsVersion,
  CreditMemoRequest.SDPricingProcedure AS SDPricingProcedure,
  CreditMemoRequest.CustomerPriceGroup AS CustomerPriceGroup,
  CreditMemoRequest.PriceListType AS PriceListType,
  CreditMemoRequest.CustomerPaymentTerms AS CustomerPaymentTerms,
  CreditMemoRequest.PaymentMethod AS PaymentMethod,
  CreditMemoRequest.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  CreditMemoRequest.AssignmentReference AS AssignmentReference,
  CreditMemoRequest.AccountingDocExternalReference AS AccountingDocExternalReference,
  CreditMemoRequest.ReferenceSDDocument AS ReferenceSDDocument,
  CreditMemoRequest.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CreditMemoRequest.CreditMemoReqApprovalReason AS CreditMemoReqApprovalReason,
  CreditMemoRequest.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  CreditMemoRequest.OverallSDProcessStatus AS OverallSDProcessStatus,
  CreditMemoRequest.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  CreditMemoRequest.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  CreditMemoRequest.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  CreditMemoRequest.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts
FROM R_CreditMemoRequestTP
;