A_CustomerReturn

Customer Return Header | view: ACUSTOMERRETURN | TRAN | Extraction: Not supported | Component: Customer Returns
Tables used: MSR_D_HEAD, MSR_D_ITEM, VBKD, VEDA, VBAK, MSR_D_FIN_STATUS, MSR_D_FIN_DETAIL, MSR_D_LOG_STATUS, MSR_D_PLANNED
Column Name Description
CustomerReturn Customer Return
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CustomerPurchaseOrderDate Customer Reference Date
CustomerReturnDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
Column Name Description
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SalesDocApprovalStatus Document Approval Status Show values
RetsMgmtLogProcgStatus Logistical Processing Status of a Return Show values
RetsMgmtCompnProcgStatus Status of Returns Refund Determination Show values
RetsMgmtProcessingStatus Processing Status Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SenderBusinessSystemName External Business System ID SLD_BSKEY
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
PurchaseOrderByCustomer Customer Reference BSTKD
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
CustomerTaxClassification1 Alternative Tax Classification TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
RetsMgmtProcess Process Identification Number MSR_PROCESS_ID
ReferenceSDDocument Document number of the reference document VBELN
Master Data Relations Join Conditions
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • A_CUSTOMERRETURN.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • A_CUSTOMERRETURN.MANDT == T176.MANDT
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • A_CUSTOMERRETURN.CUSTOMERRETURNAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • A_CUSTOMERRETURN.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Customer Return Type
  • Client
  • A_CUSTOMERRETURN.CUSTOMERRETURNTYPE == TVAK.AUART
  • A_CUSTOMERRETURN.MANDT == TVAK.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • A_CUSTOMERRETURN.DELIVERYBLOCKREASON == TVLS.LIFSP
  • A_CUSTOMERRETURN.MANDT == TVLS.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • A_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_CUSTOMERRETURN.MANDT == TVKOV.MANDT
  • A_CUSTOMERRETURN.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • A_CUSTOMERRETURN.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • A_CUSTOMERRETURN.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • A_CUSTOMERRETURN.INCOTERMSCLASSIFICATION == TINC.INCO1
  • A_CUSTOMERRETURN.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • A_CUSTOMERRETURN.INCOTERMSVERSION == TINCV.INCOV
  • A_CUSTOMERRETURN.MANDT == TINCV.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • A_CUSTOMERRETURN.ORGANIZATIONDIVISION == TVTA.SPART
  • A_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_CUSTOMERRETURN.MANDT == TVTA.MANDT
  • A_CUSTOMERRETURN.SALESORGANIZATION == TVTA.VKORG
Payment Method
  • ?
  • Client
  • Payment Method
  • A_CUSTOMERRETURN.[column in domain "LAND1"] == T042Z.LAND1
  • A_CUSTOMERRETURN.MANDT == T042Z.MANDT
  • A_CUSTOMERRETURN.PAYMENTMETHOD == T042Z.ZLSCH
Sales District
  • Sales District
  • Client
  • A_CUSTOMERRETURN.SALESDISTRICT == T171.BZIRK
  • A_CUSTOMERRETURN.MANDT == T171.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • A_CUSTOMERRETURN.SALESOFFICE == TVBVK.VKBUR
  • A_CUSTOMERRETURN.SALESGROUP == TVBVK.VKGRP
  • A_CUSTOMERRETURN.MANDT == TVBVK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • A_CUSTOMERRETURN.MANDT == TVKO.MANDT
  • A_CUSTOMERRETURN.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • A_CUSTOMERRETURN.SDDOCUMENTREASON == TVAU.AUGRU
  • A_CUSTOMERRETURN.MANDT == TVAU.MANDT
Shipping Type
  • Shipping Type
  • Client
  • A_CUSTOMERRETURN.SHIPPINGTYPE == T173.VSART
  • A_CUSTOMERRETURN.MANDT == T173.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • A_CUSTOMERRETURN.MANDT == KNA1.MANDT
  • A_CUSTOMERRETURN.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • A_CUSTOMERRETURN.MANDT == TCURC.MANDT
  • A_CUSTOMERRETURN.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • A_CUSTOMERRETURN.SALESOFFICE == TVKBZ.VKBUR
  • A_CUSTOMERRETURN.ORGANIZATIONDIVISION == TVKBZ.SPART
  • A_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • A_CUSTOMERRETURN.MANDT == TVKBZ.MANDT
  • A_CUSTOMERRETURN.SALESORGANIZATION == TVKBZ.VKORG