R_CreditMemoRequestTP

DDL: R_CREDITMEMOREQUESTTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_CMR
101 Fields 1 Data Sources 10 Associations

Credit Memo Request - TP

R_CreditMemoRequestTP is a Transactional CDS View that provides data about "Credit Memo Request - TP" in SAP S/4HANA. It reads from 1 data source (I_CreditMemoRequest) and exposes 101 fields with key field CreditMemoRequest. It has 10 associations to related views. Part of development package RAP_SD_SLS_CMR.

Data Sources (1)

SourceAliasJoin Type
I_CreditMemoRequest CreditMemoRequest from

Associations (10)

CardinalityTargetAliasCondition
[0..1] R_OutputRequestTP _OutputRequest $projection.OutputRequestUUID = _OutputRequest.OutputRequestUUID
[0..1] I_SlsOrganizationDistrChnl _SlsOrganizationDistrChnl $projection.SalesOrganization = _SlsOrganizationDistrChnl.SalesOrganization and $projection.DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel
[0..1] I_CreditMemoReqPartner _SoldToParty $projection.CreditMemoRequest = _SoldToParty.CreditMemoRequest and _SoldToParty.PartnerFunction = 'AG'
[0..1] I_CreditMemoReqPartner _Payer $projection.CreditMemoRequest = _Payer.CreditMemoRequest and _Payer.PartnerFunction = 'RG'
[1] E_SalesDocumentBasic _Extension $projection.CreditMemoRequest = _Extension.SalesDocument
[0..*] R_CreditMemoRequestItemTP _Item
[0..*] R_CreditMemoRequestPartnerTP _Partner
[0..*] R_CreditMemoReqPricingElmntTP _PricingElement
[0..*] R_CreditMemoRequestTextTP _Text
[0..1] R_CreditMemoReqShipToPartyTP _ShipToParty

Annotations (13)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name CreditMemoRequest view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SDH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 6800 view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Credit Memo Request - TP view

Fields (101)

KeyFieldSource TableSource FieldDescription
KEY CreditMemoRequest I_CreditMemoRequest CreditMemoRequest
CreditMemoRequestType I_CreditMemoRequest CreditMemoRequestType Sales Doc. Type
CreditMemoRequestDate I_CreditMemoRequest CreditMemoRequestDate Document Date
ControllingArea I_CreditMemoRequest ControllingArea Controlling Area
SoldToParty I_CreditMemoRequest SoldToParty Sold-to Party
CustomerName
PayerParty _Payer Customer Sold-to Party
SalesOrganization I_CreditMemoRequest SalesOrganization Sales Organization
DistributionChannel I_CreditMemoRequest DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_CreditMemoRequest OrganizationDivision Org. Division
ReferenceDistributionChannel _SlsOrganizationDistrChnl ReferenceDistributionChannel
SalesOffice I_CreditMemoRequest SalesOffice Sales Office
SalesGroup I_CreditMemoRequest SalesGroup Sales Group
SalesDistrict I_CreditMemoRequest SalesDistrict Sales District
PurchaseOrderByCustomer I_CreditMemoRequest PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderType I_CreditMemoRequest CustomerPurchaseOrderType
CustPurOrdTypeByShipToParty I_CreditMemoRequest CustPurOrdTypeByShipToParty
CustomerPurchaseOrderDate I_CreditMemoRequest CustomerPurchaseOrderDate Purchase Order Date
PurchaseOrderByShipToParty I_CreditMemoRequest PurchaseOrderByShipToParty
CorrespncExternalReference I_CreditMemoRequest CorrespncExternalReference Your Reference
CorrespncExtRefByShipToParty I_CreditMemoRequest CorrespncExtRefByShipToParty
CustomerGroup I_CreditMemoRequest CustomerGroup Customer Group
SDDocumentReason I_CreditMemoRequest SDDocumentReason Order Reason
PricingDate I_CreditMemoRequest PricingDate Pricing Date
TotalNetAmount I_CreditMemoRequest TotalNetAmount Total Net Amount
TransactionCurrency I_CreditMemoRequest TransactionCurrency Transaction Currency
HeaderBillingBlockReason I_CreditMemoRequest HeaderBillingBlockReason Billing Block
SDPricingProcedure I_CreditMemoRequest SDPricingProcedure Pric. Procedure
CustomerPriceGroup I_CreditMemoRequest CustomerPriceGroup CustPrice Group
PriceListType I_CreditMemoRequest PriceListType Price List Tp.
IncotermsClassification I_CreditMemoRequest IncotermsClassification Incoterms
IncotermsVersion I_CreditMemoRequest IncotermsVersion Inco. Version
IncotermsLocation1 I_CreditMemoRequest IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_CreditMemoRequest IncotermsLocation2 Inco. Location2
CustomerPaymentTerms I_CreditMemoRequest CustomerPaymentTerms Pyt Terms
BillingCompanyCode I_CreditMemoRequest BillingCompanyCode CCodeToBeBilled
PaymentMethod I_CreditMemoRequest PaymentMethod Pymt Meth.
CustomerAccountAssignmentGroup I_CreditMemoRequest CustomerAccountAssignmentGroup AccAssmtGrpCust
AssignmentReference I_CreditMemoRequest AssignmentReference Assignment Reference
AccountingDocExternalReference I_CreditMemoRequest AccountingDocExternalReference
BillingDocumentDate I_CreditMemoRequest BillingDocumentDate Billing Date
ServicesRenderedDate I_CreditMemoRequest ServicesRenderedDate Services Rendered Date
ReferenceSDDocument I_CreditMemoRequest ReferenceSDDocument Reference Doc.
ReferenceSDDocumentCategory I_CreditMemoRequest ReferenceSDDocumentCategory Prec.Doc.Categ.
CreatedByUser I_CreditMemoRequest CreatedByUser User Name
CreationDate I_CreditMemoRequest CreationDate Time Stamp
CreationTime I_CreditMemoRequest CreationTime Time of Change
LastChangedByUser I_CreditMemoRequest LastChangedByUser User Name
LastChangeDate I_CreditMemoRequest LastChangeDate Time Stamp
CreditMemoReqApprovalReason I_CreditMemoRequest CreditMemoReqApprovalReason
SalesDocApprovalStatus I_CreditMemoRequest SalesDocApprovalStatus
OverallBillingBlockStatus I_CreditMemoRequest OverallBillingBlockStatus
OverallSDProcessStatus I_CreditMemoRequest OverallSDProcessStatus
OverallSDDocumentRejectionSts I_CreditMemoRequest OverallSDDocumentRejectionSts
OverallOrdReltdBillgStatus I_CreditMemoRequest OverallOrdReltdBillgStatus
TotalBlockStatus I_CreditMemoRequest TotalBlockStatus
HdrGeneralIncompletionStatus I_CreditMemoRequest HdrGeneralIncompletionStatus
OvrlItmGeneralIncompletionSts I_CreditMemoRequest OvrlItmGeneralIncompletionSts
OverallSDDocReferenceStatus I_CreditMemoRequest OverallSDDocReferenceStatus
OutputRequestUUID OutputRequest OutputRequestUUID
_Item _Item
_Partner _Partner
_PricingElement _PricingElement
_Text _Text
_ShipToParty _ShipToParty
_OutputRequest _OutputRequest
_CreditMemoRequestType I_CreditMemoRequest _CreditMemoRequestType
_SalesOrganization I_CreditMemoRequest _SalesOrganization
_DistributionChannel I_CreditMemoRequest _DistributionChannel
_OrganizationDivision I_CreditMemoRequest _OrganizationDivision
_SalesOffice I_CreditMemoRequest _SalesOffice
_SalesGroup I_CreditMemoRequest _SalesGroup
_SalesDistrict I_CreditMemoRequest _SalesDistrict
_CustomerPurchaseOrderType I_CreditMemoRequest _CustomerPurchaseOrderType
_CustPurOrdTypeByShipToParty I_CreditMemoRequest _CustPurOrdTypeByShipToParty
_CustomerGroup I_CreditMemoRequest _CustomerGroup
_SDDocumentReason I_CreditMemoRequest _SDDocumentReason
_TransactionCurrency I_CreditMemoRequest _TransactionCurrency
_IncotermsClassification I_CreditMemoRequest _IncotermsClassification
_IncotermsVersion I_CreditMemoRequest _IncotermsVersion
_CustomerPaymentTerms I_CreditMemoRequest _CustomerPaymentTerms
_BillingCompanyCode I_CreditMemoRequest _BillingCompanyCode
_HeaderBillingBlockReason I_CreditMemoRequest _HeaderBillingBlockReason
_ReferenceSDDocumentCategory I_CreditMemoRequest _ReferenceSDDocumentCategory
_CreditMemoReqApprovalReason I_CreditMemoRequest _CreditMemoReqApprovalReason
_OverallSDProcessStatus I_CreditMemoRequest _OverallSDProcessStatus
_OverallBillingBlockStatus I_CreditMemoRequest _OverallBillingBlockStatus
_SalesDocApprovalStatus I_CreditMemoRequest _SalesDocApprovalStatus
_OverallSDDocumentRejectionSts I_CreditMemoRequest _OverallSDDocumentRejectionSts
_OverallOrdReltdBillgStatus I_CreditMemoRequest _OverallOrdReltdBillgStatus
_TotalBlockStatus I_CreditMemoRequest _TotalBlockStatus
_OverallSDDocReferenceStatus I_CreditMemoRequest _OverallSDDocReferenceStatus
_HdrGeneralIncompletionStatus I_CreditMemoRequest _HdrGeneralIncompletionStatus
_OvrlItmGeneralIncompletionSts I_CreditMemoRequest _OvrlItmGeneralIncompletionSts
_ControllingArea I_CreditMemoRequest _ControllingArea
_LastChangedByUser I_CreditMemoRequest _LastChangedByUser
_CreatedByUser I_CreditMemoRequest _CreatedByUser
_SDPricingProcedure I_CreditMemoRequest _SDPricingProcedure
_CustomerPriceGroup I_CreditMemoRequest _CustomerPriceGroup
_PriceListType I_CreditMemoRequest _PriceListType
_CustomerAccountAssgmtGroup I_CreditMemoRequest _CustomerAccountAssgmtGroup

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_CreditMemoRequestTP.
-- 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_CreditMemoRequestTP AS
SELECT
  CreditMemoRequest.CreditMemoRequest AS CreditMemoRequest,
  CreditMemoRequest.CreditMemoRequestType AS CreditMemoRequestType,
  CreditMemoRequest.CreditMemoRequestDate AS CreditMemoRequestDate,
  CreditMemoRequest.ControllingArea AS ControllingArea,
  CreditMemoRequest.SoldToParty AS SoldToParty,
  _SoldToParty._DfltAddrRprstn.AddresseeFullName AS CustomerName,
  _Payer.Customer AS PayerParty,
  CreditMemoRequest.SalesOrganization AS SalesOrganization,
  CreditMemoRequest.DistributionChannel AS DistributionChannel,
  CreditMemoRequest.OrganizationDivision AS OrganizationDivision,
  _SlsOrganizationDistrChnl.ReferenceDistributionChannel AS ReferenceDistributionChannel,
  CreditMemoRequest.SalesOffice AS SalesOffice,
  CreditMemoRequest.SalesGroup AS SalesGroup,
  CreditMemoRequest.SalesDistrict AS SalesDistrict,
  CreditMemoRequest.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CreditMemoRequest.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  CreditMemoRequest.CustPurOrdTypeByShipToParty AS CustPurOrdTypeByShipToParty,
  CreditMemoRequest.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  CreditMemoRequest.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  CreditMemoRequest.CorrespncExternalReference AS CorrespncExternalReference,
  CreditMemoRequest.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  CreditMemoRequest.CustomerGroup AS CustomerGroup,
  CreditMemoRequest.SDDocumentReason AS SDDocumentReason,
  CreditMemoRequest.PricingDate AS PricingDate,
  CreditMemoRequest.TotalNetAmount AS TotalNetAmount,
  CreditMemoRequest.TransactionCurrency AS TransactionCurrency,
  CreditMemoRequest.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  CreditMemoRequest.SDPricingProcedure AS SDPricingProcedure,
  CreditMemoRequest.CustomerPriceGroup AS CustomerPriceGroup,
  CreditMemoRequest.PriceListType AS PriceListType,
  CreditMemoRequest.IncotermsClassification AS IncotermsClassification,
  CreditMemoRequest.IncotermsVersion AS IncotermsVersion,
  CreditMemoRequest.IncotermsLocation1 AS IncotermsLocation1,
  CreditMemoRequest.IncotermsLocation2 AS IncotermsLocation2,
  CreditMemoRequest.CustomerPaymentTerms AS CustomerPaymentTerms,
  CreditMemoRequest.BillingCompanyCode AS BillingCompanyCode,
  CreditMemoRequest.PaymentMethod AS PaymentMethod,
  CreditMemoRequest.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  CreditMemoRequest.AssignmentReference AS AssignmentReference,
  CreditMemoRequest.AccountingDocExternalReference AS AccountingDocExternalReference,
  CreditMemoRequest.BillingDocumentDate AS BillingDocumentDate,
  CreditMemoRequest.ServicesRenderedDate AS ServicesRenderedDate,
  CreditMemoRequest.ReferenceSDDocument AS ReferenceSDDocument,
  CreditMemoRequest.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CreditMemoRequest.CreatedByUser AS CreatedByUser,
  CreditMemoRequest.CreationDate AS CreationDate,
  CreditMemoRequest.CreationTime AS CreationTime,
  CreditMemoRequest.LastChangedByUser AS LastChangedByUser,
  CreditMemoRequest.LastChangeDate AS LastChangeDate,
  CreditMemoRequest.CreditMemoReqApprovalReason AS CreditMemoReqApprovalReason,
  CreditMemoRequest.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  CreditMemoRequest.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  CreditMemoRequest.OverallSDProcessStatus AS OverallSDProcessStatus,
  CreditMemoRequest.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  CreditMemoRequest.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  CreditMemoRequest.TotalBlockStatus AS TotalBlockStatus,
  CreditMemoRequest.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  CreditMemoRequest.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts,
  CreditMemoRequest.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  OutputRequest.OutputRequestUUID AS OutputRequestUUID,
  CreditMemoRequest._CreditMemoRequestType AS _CreditMemoRequestType,
  CreditMemoRequest._SalesOrganization AS _SalesOrganization,
  CreditMemoRequest._DistributionChannel AS _DistributionChannel,
  CreditMemoRequest._OrganizationDivision AS _OrganizationDivision,
  CreditMemoRequest._SalesOffice AS _SalesOffice,
  CreditMemoRequest._SalesGroup AS _SalesGroup,
  CreditMemoRequest._SalesDistrict AS _SalesDistrict,
  CreditMemoRequest._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  CreditMemoRequest._CustPurOrdTypeByShipToParty AS _CustPurOrdTypeByShipToParty,
  CreditMemoRequest._CustomerGroup AS _CustomerGroup,
  CreditMemoRequest._SDDocumentReason AS _SDDocumentReason,
  CreditMemoRequest._TransactionCurrency AS _TransactionCurrency,
  CreditMemoRequest._IncotermsClassification AS _IncotermsClassification,
  CreditMemoRequest._IncotermsVersion AS _IncotermsVersion,
  CreditMemoRequest._CustomerPaymentTerms AS _CustomerPaymentTerms,
  CreditMemoRequest._BillingCompanyCode AS _BillingCompanyCode,
  CreditMemoRequest._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  CreditMemoRequest._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  CreditMemoRequest._CreditMemoReqApprovalReason AS _CreditMemoReqApprovalReason,
  CreditMemoRequest._OverallSDProcessStatus AS _OverallSDProcessStatus,
  CreditMemoRequest._OverallBillingBlockStatus AS _OverallBillingBlockStatus,
  CreditMemoRequest._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  CreditMemoRequest._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  CreditMemoRequest._OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus,
  CreditMemoRequest._TotalBlockStatus AS _TotalBlockStatus,
  CreditMemoRequest._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  CreditMemoRequest._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  CreditMemoRequest._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  CreditMemoRequest._ControllingArea AS _ControllingArea,
  CreditMemoRequest._LastChangedByUser AS _LastChangedByUser,
  CreditMemoRequest._CreatedByUser AS _CreatedByUser,
  CreditMemoRequest._SDPricingProcedure AS _SDPricingProcedure,
  CreditMemoRequest._CustomerPriceGroup AS _CustomerPriceGroup,
  CreditMemoRequest._PriceListType AS _PriceListType,
  CreditMemoRequest._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup
FROM I_CreditMemoRequest AS CreditMemoRequest
LEFT OUTER JOIN R_OutputRequestTP AS _OutputRequest ON OutputRequestUUID = _OutputRequest.OutputRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_SlsOrganizationDistrChnl AS _SlsOrganizationDistrChnl ON SalesOrganization = _SlsOrganizationDistrChnl.SalesOrganization AND DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CreditMemoReqPartner AS _SoldToParty ON CreditMemoRequest = _SoldToParty.CreditMemoRequest AND _SoldToParty.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN I_CreditMemoReqPartner AS _Payer ON CreditMemoRequest = _Payer.CreditMemoRequest AND _Payer.PartnerFunction = 'RG'  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CreditMemoRequest = _Extension.SalesDocument  -- association [1]
LEFT OUTER JOIN R_CreditMemoRequestItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CreditMemoRequestPartnerTP AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CreditMemoReqPricingElmntTP AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CreditMemoRequestTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CreditMemoReqShipToPartyTP AS _ShipToParty ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More