I_RFM_PrvsnlSlsContrDocHdr

Provisional Sales Contract Document Header | view: IRFMPRVSNLDOC | TRAN | Extraction: Not supported | Component: Retail & Fashion Sales and Distribution
Tables used: VBAK, VBKD, VBPA, KNA1, TVAK
Column Name Description
SalesContract 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
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
SalesDocumentDate Document Date (Date Received/Sent)
SalesContractValidityStartDate Valid-From Date (Outline Agreements, Product Proposals)
SalesContractValidityEndDate 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
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) 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
Column Name Description Domain name
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
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVV5.MANDT
Credit control area
  • Credit control area
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CREDITCONTROLAREA == T014.KKBER
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == T014.MANDT
Customer condition group 1
  • Customer condition group 1
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKGG.MANDT
Customer condition group 2
  • Client
  • Customer condition group 2
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKGG.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
Customer condition group 3
  • Client
  • Customer condition group 3
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKGG.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer condition group 4
  • Customer condition group 4
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKGG.MANDT
Customer condition group 5
  • Customer condition group 5
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKGG.MANDT
Customer Group
  • Customer Group
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERGROUP == T151.KDGRP
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == T151.MANDT
Customer Price Group
  • Client
  • Customer Price Group
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == T188.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERPRICEGROUP == T188.KONDA
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == T176.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVLS.MANDT
Department number
  • Client
  • Department number
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TSAB.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.DEPARTMENTCLASSIFICATIONBYCUST == TSAB.ABTNR
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKOV.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVFS.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TINC.MANDT
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVTA.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.ORGANIZATIONDIVISION == TVTA.SPART
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == TVTA.VKORG
Customer Group 10
  • Client
  • Customer Group 10
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == FSH_TVV10.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.RETAILADDITIONALCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == FSH_TVV10.VKORG
Customer Group 6
  • Client
  • Customer Group 6
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == FSH_TVV6.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.RETAILADDITIONALCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == FSH_TVV6.VKORG
Customer Group 7
  • Customer Group 7
  • Client
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.RETAILADDITIONALCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == FSH_TVV7.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == FSH_TVV7.VKORG
Customer Group 8
  • Customer Group 8
  • Client
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.RETAILADDITIONALCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == FSH_TVV8.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == FSH_TVV8.VKORG
Customer Group 9
  • Customer Group 9
  • Client
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.RETAILADDITIONALCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == FSH_TVV9.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == FSH_TVV9.VKORG
Sales District
  • Sales District
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESDISTRICT == T171.BZIRK
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == T171.MANDT
Order type in order header
  • Client
  • Sales Document Type
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVAK.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Sales office
  • Sales group
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESOFFICE == TVBVK.VKBUR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESGROUP == TVBVK.VKGRP
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVBVK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKO.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SDDOCUMENTREASON == TVAU.AUGRU
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVAU.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVSB.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Client
  • Shipping Type
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == T173.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Customer Number
  • Sold-to Party
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SHIPTOPARTY == KNA1.KUNNR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SOLDTOPARTY == KNA1.KUNNR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == KNA1.MANDT
Sold-to Party
  • Customer Number
  • Sold-to Party
  • Client
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SHIPTOPARTY == KNA1.KUNNR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SOLDTOPARTY == KNA1.KUNNR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TCURC.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Sales office
  • Client
  • Division
  • Sales Organization
  • I_RFM_PRVSNLSLSCONTRDOCHDR.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESOFFICE == TVKBZ.VKBUR
  • I_RFM_PRVSNLSLSCONTRDOCHDR.MANDT == TVKBZ.MANDT
  • I_RFM_PRVSNLSLSCONTRDOCHDR.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_RFM_PRVSNLSLSCONTRDOCHDR.SALESORGANIZATION == TVKBZ.VKORG