I_SalesDocumentBasic

Sales Document Basic | view: ISDSALESDOCBSC | ATTR | Extraction: Not supported | Component: Sales
Tables used: VBAK
Column Name Description
SalesDocument Sales Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
💲 Currency key of credit control area (ControllingAreaCurrency):
ReleasedCreditAmount Released credit value of the document
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
LastCustomerContactDate Last Customer Contact Date
SalesDocumentDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
NextCreditCheckDate Date of Next Credit Check of Document
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
AgrmtValdtyStartDate Valid-From Date (Outline Agreements, Product Proposals)
AgrmtValdtyEndDate Valid-To Date (Outline Agreements, Product Proposals)
RequestedDeliveryDate Requested Delivery Date
FashionCancelDate Cancellation Date
CreditBlockReleaseDate Release date of the document determined by credit management
NextShippingDate Next date
AlternativePricingDate Cross-Item Pricing Date
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentProcessingType SD document indicator Show values
HdrOrderProbabilityInPercent Sales probability Show values
SchedulingAgreementProfileCode MRP for delivery schedule types Show values
DelivSchedTypeMRPRlvnceCode MRP for delivery schedule types Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallPurchaseConfStatus Purchasing Confirmation Status Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
MaxDocValueCreditCheckStatus Status of Credit Check Against Maximum Document Value Show values
PaymentTermCreditCheckStatus Status of Credit Check Against Terms of Payment Show values
FinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
ExprtInsurCreditCheckStatus Status of Credit Check Against Export Credit Insurance Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
CentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
OverallChmlCmplncStatus Product Marketability Status (All Items) Show values
OverallDangerousGoodsStatus Dangerous Goods Status (All Items) Show values
OverallSafetyDataSheetStatus Safety Data Sheet Status (All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
ContractDownPaymentStatus Down Payment Status Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status Show values
DeliveryDateTypeRule Delivery Date Rule Show values
OmniChnlSalesPromotionStatus Omnichannel Sales Promotion Status (Header) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
SenderBusinessSystemName External Business System ID SLD_BSKEY
ExternalDocumentID External Document ID CHAR40
ExternalDocLastChangeDateTime Timestamp for Revision of External Calls TZNTSTMPL
SDDocumentCollectiveNumber Collective Number (SD) CHAR10
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
RetsMgmtProcess Process Identification Number MSR_PROCESS_ID
SalesDocumentCondition Number of the Document Condition KNUMV
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
CostCenter Cost Center KOSTL
AssignmentReference Assignment Number ZUONR
ReferenceSDDocument Document number of the reference document VBELN
AccountingDocExternalReference Reference Document Number XBLNR1
MasterSalesContract Master Contract Number VBELN
SalesItemProposalDescription Search term for product proposal TEXT40
CorrespncExternalReference Your Reference TEXT12
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
ContractManualCompletion Manual Completion of Contract MANEK
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_SALESDOCUMENTBASIC.MANDT == TVV1.MANDT
  • I_SALESDOCUMENTBASIC.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • I_SALESDOCUMENTBASIC.MANDT == TVV2.MANDT
  • I_SALESDOCUMENTBASIC.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • I_SALESDOCUMENTBASIC.MANDT == TVV3.MANDT
  • I_SALESDOCUMENTBASIC.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • I_SALESDOCUMENTBASIC.MANDT == TVV4.MANDT
  • I_SALESDOCUMENTBASIC.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • I_SALESDOCUMENTBASIC.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_SALESDOCUMENTBASIC.MANDT == TVV5.MANDT
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_SALESDOCUMENTBASIC.MANDT == T001.MANDT
  • I_SALESDOCUMENTBASIC.BILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Client
  • Business Area
  • I_SALESDOCUMENTBASIC.MANDT == TGSB.MANDT
  • I_SALESDOCUMENTBASIC.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Controlling Area
  • Client
  • I_SALESDOCUMENTBASIC.CONTROLLINGAREA == TKA01.KOKRS
  • I_SALESDOCUMENTBASIC.MANDT == TKA01.MANDT
Currency key of credit control area
  • Client
  • Currency key of credit control area
  • I_SALESDOCUMENTBASIC.MANDT == TCURC.MANDT
  • I_SALESDOCUMENTBASIC.CONTROLLINGAREACURRENCY == TCURC.WAERS
Business Area from Cost Center
  • Client
  • Business Area from Cost Center
  • I_SALESDOCUMENTBASIC.MANDT == TGSB.MANDT
  • I_SALESDOCUMENTBASIC.COSTCENTERBUSINESSAREA == TGSB.GSBER
Credit control area
  • Client
  • Credit control area
  • I_SALESDOCUMENTBASIC.MANDT == T014.MANDT
  • I_SALESDOCUMENTBASIC.CREDITCONTROLAREA == T014.KKBER
Customer's Account Number with Credit Limit Reference
  • Client
  • Customer's Account Number with Credit Limit Reference
  • I_SALESDOCUMENTBASIC.MANDT == KNA1.MANDT
  • I_SALESDOCUMENTBASIC.CUSTOMERCREDITACCOUNT == KNA1.KUNNR
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • I_SALESDOCUMENTBASIC.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • I_SALESDOCUMENTBASIC.MANDT == T176.MANDT
Agreement (various conditions grouped together)
  • Client
  • Agreement (various conditions grouped together)
  • I_SALESDOCUMENTBASIC.MANDT == KONA.MANDT
  • I_SALESDOCUMENTBASIC.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • I_SALESDOCUMENTBASIC.MANDT == TVLS.MANDT
  • I_SALESDOCUMENTBASIC.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_SALESDOCUMENTBASIC.MANDT == TVKOV.MANDT
  • I_SALESDOCUMENTBASIC.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESDOCUMENTBASIC.SALESORGANIZATION == TVKOV.VKORG
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_SALESDOCUMENTBASIC.EXCHANGERATETYPE == TCURV.KURST
  • I_SALESDOCUMENTBASIC.MANDT == TCURV.MANDT
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • I_SALESDOCUMENTBASIC.MANDT == TVFS.MANDT
  • I_SALESDOCUMENTBASIC.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Usage Indicator
  • Client
  • Usage Indicator
  • I_SALESDOCUMENTBASIC.MANDT == TVLV.MANDT
  • I_SALESDOCUMENTBASIC.MATLUSAGEINDICATOR == TVLV.ABRVW
Order Number
  • Client
  • Order Number
  • I_SALESDOCUMENTBASIC.MANDT == AUFK.MANDT
  • I_SALESDOCUMENTBASIC.ORDERID == AUFK.AUFNR
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • I_SALESDOCUMENTBASIC.MANDT == TVTA.MANDT
  • I_SALESDOCUMENTBASIC.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESDOCUMENTBASIC.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESDOCUMENTBASIC.SALESORGANIZATION == TVTA.VKORG
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • I_SALESDOCUMENTBASIC.MANDT == SDAPMAPRR.CLIENT
  • I_SALESDOCUMENTBASIC.SALESDOCAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Order type in order header
  • Client
  • Sales Document Type
  • I_SALESDOCUMENTBASIC.MANDT == TVAK.MANDT
  • I_SALESDOCUMENTBASIC.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • I_SALESDOCUMENTBASIC.MANDT == TVBVK.MANDT
  • I_SALESDOCUMENTBASIC.SALESOFFICE == TVBVK.VKBUR
  • I_SALESDOCUMENTBASIC.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESDOCUMENTBASIC.MANDT == TVKO.MANDT
  • I_SALESDOCUMENTBASIC.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • I_SALESDOCUMENTBASIC.MANDT == TVAU.MANDT
  • I_SALESDOCUMENTBASIC.SDDOCUMENTREASON == TVAU.AUGRU
Pricing Procedure in Pricing
  • ?
  • Client
  • ?
  • Pricing Procedure in Pricing
  • I_SALESDOCUMENTBASIC.[column in domain "KAPPL"] == T683.KAPPL
  • I_SALESDOCUMENTBASIC.MANDT == T683.MANDT
  • I_SALESDOCUMENTBASIC.[column in domain "KVEWE"] == T683.KVEWE
  • I_SALESDOCUMENTBASIC.SDPRICINGPROCEDURE == T683.KALSM
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_SALESDOCUMENTBASIC.MANDT == TVSB.MANDT
  • I_SALESDOCUMENTBASIC.SHIPPINGCONDITION == TVSB.VSBED
Sold-to Party
  • Client
  • Sold-to Party
  • I_SALESDOCUMENTBASIC.MANDT == KNA1.MANDT
  • I_SALESDOCUMENTBASIC.SOLDTOPARTY == KNA1.KUNNR
Statistics Currency
  • Client
  • Statistics Currency
  • I_SALESDOCUMENTBASIC.MANDT == TCURC.MANDT
  • I_SALESDOCUMENTBASIC.STATISTICSCURRENCY == TCURC.WAERS
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • I_SALESDOCUMENTBASIC.TAXDEPARTURECOUNTRY == T005.LAND1
  • I_SALESDOCUMENTBASIC.MANDT == T005.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • I_SALESDOCUMENTBASIC.MANDT == TCURC.MANDT
  • I_SALESDOCUMENTBASIC.TRANSACTIONCURRENCY == TCURC.WAERS
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • I_SALESDOCUMENTBASIC.MANDT == T005.MANDT
  • I_SALESDOCUMENTBASIC.VATREGISTRATIONCOUNTRY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Distribution Channel
  • Sales Organization
  • I_SALESDOCUMENTBASIC.MANDT == TVKBZ.MANDT
  • I_SALESDOCUMENTBASIC.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SALESDOCUMENTBASIC.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESDOCUMENTBASIC.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESDOCUMENTBASIC.SALESORGANIZATION == TVKBZ.VKORG