A_DebitMemoRequestSimulation

DDL: A_DEBITMEMOREQUESTSIMULATION Type: view_entity COMPOSITE
42 Fields 1 Data Sources 5 Associations

Debit Memo Request Simulation

A_DebitMemoRequestSimulation is a Composite CDS View that provides data about "Debit Memo Request Simulation" in SAP S/4HANA. It reads from 1 data source (I_DebitMemoRequest) and exposes 42 fields with key field DebitMemoRequest. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DebitMemoRequest DebitMemoRequest from

Associations (5)

CardinalityTargetAliasCondition
[1..1] A_DebitMemoReqCreditSimulation _Credit _Credit.DebitMemoRequest = $projection.DebitMemoRequest
[0..1] E_SalesDocumentBasic _Extension $projection.DebitMemoRequest = _Extension.SalesDocument
[0..*] A_DebitMemoReqItemSimulation _Item
[0..*] A_DebitMemoReqPartnerSimln _Partner
[0..*] A_DebitMemoReqPrcgElmntSimln _PricingElement

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.createEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Debit Memo Request Simulation view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY DebitMemoRequest I_DebitMemoRequest DebitMemoRequest
DebitMemoRequestType I_DebitMemoRequest DebitMemoRequestType
SalesOrganization I_DebitMemoRequest SalesOrganization Sales Organization
DistributionChannel I_DebitMemoRequest DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_DebitMemoRequest OrganizationDivision Org. Division
SalesGroup I_DebitMemoRequest SalesGroup Sales Group
SalesOffice I_DebitMemoRequest SalesOffice Sales Office
SalesDistrict I_DebitMemoRequest SalesDistrict Sales District
SoldToParty I_DebitMemoRequest SoldToParty Sold-to Party
PurchaseOrderByCustomer I_DebitMemoRequest PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderType I_DebitMemoRequest CustomerPurchaseOrderType
CustomerPurchaseOrderDate I_DebitMemoRequest CustomerPurchaseOrderDate Purchase Order Date
DebitMemoRequestDate I_DebitMemoRequest DebitMemoRequestDate Document Date
TotalNetAmount I_DebitMemoRequest TotalNetAmount Total Net Amount
TransactionCurrency I_DebitMemoRequest TransactionCurrency Transaction Currency
SDPricingProcedure I_DebitMemoRequest SDPricingProcedure Pric. Procedure
SDDocumentReason I_DebitMemoRequest SDDocumentReason Order Reason
PricingDate I_DebitMemoRequest PricingDate Pricing Date
CustomerTaxClassification1 I_DebitMemoRequest CustomerTaxClassification1
CustomerTaxClassification2 I_DebitMemoRequest CustomerTaxClassification2
CustomerTaxClassification3 I_DebitMemoRequest CustomerTaxClassification3
CustomerTaxClassification4 I_DebitMemoRequest CustomerTaxClassification4
CustomerTaxClassification5 I_DebitMemoRequest CustomerTaxClassification5
CustomerTaxClassification6 I_DebitMemoRequest CustomerTaxClassification6
CustomerTaxClassification7 I_DebitMemoRequest CustomerTaxClassification7
CustomerTaxClassification8 I_DebitMemoRequest CustomerTaxClassification8
CustomerTaxClassification9 I_DebitMemoRequest CustomerTaxClassification9
HeaderBillingBlockReason I_DebitMemoRequest HeaderBillingBlockReason Billing Block
IncotermsClassification I_DebitMemoRequest IncotermsClassification Incoterms
IncotermsTransferLocation I_DebitMemoRequest IncotermsTransferLocation Incoterms 2
IncotermsLocation1 I_DebitMemoRequest IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_DebitMemoRequest IncotermsLocation2 Inco. Location2
IncotermsVersion I_DebitMemoRequest IncotermsVersion Inco. Version
CustomerPaymentTerms I_DebitMemoRequest CustomerPaymentTerms Pyt Terms
PaymentMethod I_DebitMemoRequest PaymentMethod Pymt Meth.
BillingDocumentDate I_DebitMemoRequest BillingDocumentDate Billing Date
ServicesRenderedDate I_DebitMemoRequest ServicesRenderedDate Services Rendered Date
ReferenceSDDocument I_DebitMemoRequest ReferenceSDDocument Reference Doc.
_Item _Item
_Partner _Partner
_PricingElement _PricingElement
_Credit _Credit

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_DebitMemoRequestSimulation.
-- 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_DebitMemoRequestSimulation AS
SELECT
  DebitMemoRequest.DebitMemoRequest AS DebitMemoRequest,
  DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  DebitMemoRequest.SalesOrganization AS SalesOrganization,
  DebitMemoRequest.DistributionChannel AS DistributionChannel,
  DebitMemoRequest.OrganizationDivision AS OrganizationDivision,
  DebitMemoRequest.SalesGroup AS SalesGroup,
  DebitMemoRequest.SalesOffice AS SalesOffice,
  DebitMemoRequest.SalesDistrict AS SalesDistrict,
  DebitMemoRequest.SoldToParty AS SoldToParty,
  DebitMemoRequest.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  DebitMemoRequest.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  DebitMemoRequest.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  DebitMemoRequest.DebitMemoRequestDate AS DebitMemoRequestDate,
  DebitMemoRequest.TotalNetAmount AS TotalNetAmount,
  DebitMemoRequest.TransactionCurrency AS TransactionCurrency,
  DebitMemoRequest.SDPricingProcedure AS SDPricingProcedure,
  DebitMemoRequest.SDDocumentReason AS SDDocumentReason,
  DebitMemoRequest.PricingDate AS PricingDate,
  DebitMemoRequest.CustomerTaxClassification1 AS CustomerTaxClassification1,
  DebitMemoRequest.CustomerTaxClassification2 AS CustomerTaxClassification2,
  DebitMemoRequest.CustomerTaxClassification3 AS CustomerTaxClassification3,
  DebitMemoRequest.CustomerTaxClassification4 AS CustomerTaxClassification4,
  DebitMemoRequest.CustomerTaxClassification5 AS CustomerTaxClassification5,
  DebitMemoRequest.CustomerTaxClassification6 AS CustomerTaxClassification6,
  DebitMemoRequest.CustomerTaxClassification7 AS CustomerTaxClassification7,
  DebitMemoRequest.CustomerTaxClassification8 AS CustomerTaxClassification8,
  DebitMemoRequest.CustomerTaxClassification9 AS CustomerTaxClassification9,
  DebitMemoRequest.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  DebitMemoRequest.IncotermsClassification AS IncotermsClassification,
  DebitMemoRequest.IncotermsTransferLocation AS IncotermsTransferLocation,
  DebitMemoRequest.IncotermsLocation1 AS IncotermsLocation1,
  DebitMemoRequest.IncotermsLocation2 AS IncotermsLocation2,
  DebitMemoRequest.IncotermsVersion AS IncotermsVersion,
  DebitMemoRequest.CustomerPaymentTerms AS CustomerPaymentTerms,
  DebitMemoRequest.PaymentMethod AS PaymentMethod,
  DebitMemoRequest.BillingDocumentDate AS BillingDocumentDate,
  DebitMemoRequest.ServicesRenderedDate AS ServicesRenderedDate,
  DebitMemoRequest.ReferenceSDDocument AS ReferenceSDDocument
FROM I_DebitMemoRequest AS DebitMemoRequest
LEFT OUTER JOIN A_DebitMemoReqCreditSimulation AS _Credit ON _Credit.DebitMemoRequest = DebitMemoRequest  -- association [1..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON DebitMemoRequest = _Extension.SalesDocument  -- association [0..1]
LEFT OUTER JOIN A_DebitMemoReqItemSimulation AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_DebitMemoReqPartnerSimln AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_DebitMemoReqPrcgElmntSimln AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More