C_RFM_MaSaDoSlsOrdHdr

Sales Order Header Details | view: CRFMMASADOSDH | TRAN | Extraction: Not supported | Component: Retail & Fashion Sales and Distribution
Tables used: VBAK, VBKD, VBPA, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, KNA1, TVAK, SIT_DEF, SIT_T_DEF
Column Name Description
SalesOrder Sales Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
SalesDocumentDate Document Date (Date Received/Sent)
RequestedDeliveryDate Requested Delivery Date
CreationDate Date on which the record was created
FashionCancelDate Cancellation Date
CustomerPurchaseOrderDate Customer Reference Date
PricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
FirstDeliveryDate Item delivery date
AgrmtValdtyStartDate Valid-From Date (Outline Agreements, Product Proposals)
AgrmtValdtyEndDate Valid-To Date (Outline Agreements, Product Proposals)
Column Name Description
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
TotalBlockStatus Overall Block Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
ARunDocumentStatus ARun Document Status Show values
HasIncompleteItems Checkbox Show values
Column Name Description Domain name
SalesDocument Sales Document VBELN
RequirementType null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPaymentTerms Terms of payment key ZTERM
IncotermsLocation1 Incoterms Location 1 INCO_L
OvrlItmGeneralIncompletionSts Incompletion Status (All Items)
ConfdReqdRqmtQtyRatioPct null
AssgdReqdRqmtQtyRatioPct null
DlvrdReqdRqmtQtyRatioPct null
ARunDocumentStatusText Explanatory Short Text DDTEXT
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
SalesDocumentHasRejection Checkbox
FormattedSalesDocumentItem Sales Document Item CHAR17
Material Material Number
Plant Plant
ShippingPoint Shipping Point / Receiving Point VSTEL
DeliveryPriority Delivery Priority LPRIO
ProductSeasonYear Season Year FSH_CJAHR
ProductSeason Season RFM_SAISO
ProductCollection Fashion Collection FSH_COLLECTION
ProductTheme Fashion Theme FSH_THEME
RqmtIsSupAssgmtRelevant Indicates if Supply Assignment is Relevant for Item
ProductGroup Product Group
AdditionalMaterialGroup1 Material Group 1 MVGR1
AdditionalMaterialGroup2 Material Group 2 MVGR2
AdditionalMaterialGroup3 Material Group 3 MVGR3
AdditionalMaterialGroup4 Material Group 4 MVGR4
AdditionalMaterialGroup5 Material Group 5 MVGR5
SitnNumberOfInstances Number of Situations
SitnRowCriticalityCode null
RequirementDocumentNumber ARun Order Number ARUN_AUFN
SalesOrdGnrcArticleIsSelected null
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_RFM_MASADOSLSORDHDR.MANDT == TVV1.MANDT
  • C_RFM_MASADOSLSORDHDR.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_RFM_MASADOSLSORDHDR.MANDT == TVV2.MANDT
  • C_RFM_MASADOSLSORDHDR.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • C_RFM_MASADOSLSORDHDR.MANDT == TVV3.MANDT
  • C_RFM_MASADOSLSORDHDR.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_RFM_MASADOSLSORDHDR.MANDT == TVV4.MANDT
  • C_RFM_MASADOSLSORDHDR.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • C_RFM_MASADOSLSORDHDR.MANDT == TVV5.MANDT
  • C_RFM_MASADOSLSORDHDR.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Credit control area
  • Client
  • Credit control area
  • C_RFM_MASADOSLSORDHDR.MANDT == T014.MANDT
  • C_RFM_MASADOSLSORDHDR.CREDITCONTROLAREA == T014.KKBER
Customer condition group 1
  • Client
  • Customer condition group 1
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKGG.MANDT
  • C_RFM_MASADOSLSORDHDR.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
Customer condition group 2
  • Customer condition group 2
  • Client
  • C_RFM_MASADOSLSORDHDR.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKGG.MANDT
Customer condition group 3
  • Client
  • Customer condition group 3
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKGG.MANDT
  • C_RFM_MASADOSLSORDHDR.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer condition group 4
  • Client
  • Customer condition group 4
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKGG.MANDT
  • C_RFM_MASADOSLSORDHDR.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
Customer condition group 5
  • Client
  • Customer condition group 5
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKGG.MANDT
  • C_RFM_MASADOSLSORDHDR.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Customer Group
  • Client
  • Customer Group
  • C_RFM_MASADOSLSORDHDR.MANDT == T151.MANDT
  • C_RFM_MASADOSLSORDHDR.CUSTOMERGROUP == T151.KDGRP
Customer Price Group
  • Customer Price Group
  • Client
  • C_RFM_MASADOSLSORDHDR.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOSLSORDHDR.MANDT == T188.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • C_RFM_MASADOSLSORDHDR.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • C_RFM_MASADOSLSORDHDR.MANDT == T176.MANDT
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_RFM_MASADOSLSORDHDR.MANDT == TVLS.MANDT
  • C_RFM_MASADOSLSORDHDR.DELIVERYBLOCKREASON == TVLS.LIFSP
Department number
  • Department number
  • Client
  • C_RFM_MASADOSLSORDHDR.DEPARTMENTCLASSIFICATIONBYCUST == TSAB.ABTNR
  • C_RFM_MASADOSLSORDHDR.MANDT == TSAB.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKOV.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == TVKOV.VKORG
  • C_RFM_MASADOSLSORDHDR.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • C_RFM_MASADOSLSORDHDR.MANDT == TVFS.MANDT
  • C_RFM_MASADOSLSORDHDR.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_RFM_MASADOSLSORDHDR.MANDT == TINC.MANDT
  • C_RFM_MASADOSLSORDHDR.INCOTERMSCLASSIFICATION == TINC.INCO1
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_RFM_MASADOSLSORDHDR.MANDT == TVTA.MANDT
  • C_RFM_MASADOSLSORDHDR.ORGANIZATIONDIVISION == TVTA.SPART
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == TVTA.VKORG
  • C_RFM_MASADOSLSORDHDR.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Customer Group 10
  • Client
  • Customer Group 10
  • Sales Organization
  • C_RFM_MASADOSLSORDHDR.MANDT == FSH_TVV10.MANDT
  • C_RFM_MASADOSLSORDHDR.RETAILADDITIONALCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == FSH_TVV10.VKORG
Customer Group 6
  • Customer Group 6
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSORDHDR.RETAILADDITIONALCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • C_RFM_MASADOSLSORDHDR.MANDT == FSH_TVV6.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == FSH_TVV6.VKORG
Customer Group 7
  • Client
  • Customer Group 7
  • Sales Organization
  • C_RFM_MASADOSLSORDHDR.MANDT == FSH_TVV7.MANDT
  • C_RFM_MASADOSLSORDHDR.RETAILADDITIONALCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == FSH_TVV7.VKORG
Customer Group 8
  • Customer Group 8
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSORDHDR.RETAILADDITIONALCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • C_RFM_MASADOSLSORDHDR.MANDT == FSH_TVV8.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == FSH_TVV8.VKORG
Customer Group 9
  • Client
  • Sales Organization
  • Customer Group 9
  • C_RFM_MASADOSLSORDHDR.MANDT == FSH_TVV9.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == FSH_TVV9.VKORG
  • C_RFM_MASADOSLSORDHDR.RETAILADDITIONALCUSTOMERGRP9 == FSH_TVV9.KVGR9
Sales District
  • Client
  • Sales District
  • C_RFM_MASADOSLSORDHDR.MANDT == T171.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESDISTRICT == T171.BZIRK
Order type in order header
  • Client
  • Sales Document Type
  • C_RFM_MASADOSLSORDHDR.MANDT == TVAK.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales group
  • Sales office
  • C_RFM_MASADOSLSORDHDR.MANDT == TVBVK.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESGROUP == TVBVK.VKGRP
  • C_RFM_MASADOSLSORDHDR.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKO.MANDT
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_RFM_MASADOSLSORDHDR.MANDT == TVAU.MANDT
  • C_RFM_MASADOSLSORDHDR.SDDOCUMENTREASON == TVAU.AUGRU
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_RFM_MASADOSLSORDHDR.MANDT == TVSB.MANDT
  • C_RFM_MASADOSLSORDHDR.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Client
  • Shipping Type
  • C_RFM_MASADOSLSORDHDR.MANDT == T173.MANDT
  • C_RFM_MASADOSLSORDHDR.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Client
  • Customer Number
  • Sold-to Party
  • C_RFM_MASADOSLSORDHDR.MANDT == KNA1.MANDT
  • C_RFM_MASADOSLSORDHDR.SHIPTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSORDHDR.SOLDTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Customer Number
  • Sold-to Party
  • C_RFM_MASADOSLSORDHDR.MANDT == KNA1.MANDT
  • C_RFM_MASADOSLSORDHDR.SHIPTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOSLSORDHDR.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_RFM_MASADOSLSORDHDR.MANDT == TCURC.MANDT
  • C_RFM_MASADOSLSORDHDR.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • Sales office
  • C_RFM_MASADOSLSORDHDR.MANDT == TVKBZ.MANDT
  • C_RFM_MASADOSLSORDHDR.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_RFM_MASADOSLSORDHDR.SALESORGANIZATION == TVKBZ.VKORG
  • C_RFM_MASADOSLSORDHDR.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_RFM_MASADOSLSORDHDR.SALESOFFICE == TVKBZ.VKBUR