I_CreditBlockedSalesDocument

Credit Blocked Sales Document | view: ICRDTBLKDSLSDOC | TRAN | 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
LastChangeDate Last Changed On
CreditBlockReleaseDate Release date of the document determined by credit management
NextShippingDate Next date
NextCreditCheckDate Date of Next Credit Check of Document
Column Name Description
SDDocumentCategory SD Document Category Show values
FinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
CentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management 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
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
Master Data Relations Join Conditions
Currency key of credit control area
  • Currency key of credit control area
  • Client
  • I_CREDITBLOCKEDSALESDOCUMENT.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TCURC.MANDT
Customer's Account Number with Credit Limit Reference
  • Customer's Account Number with Credit Limit Reference
  • Client
  • I_CREDITBLOCKEDSALESDOCUMENT.CUSTOMERCREDITACCOUNT == KNA1.KUNNR
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == KNA1.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_CREDITBLOCKEDSALESDOCUMENT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TVKOV.MANDT
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Distribution Channel
  • Division
  • Client
  • Sales Organization
  • I_CREDITBLOCKEDSALESDOCUMENT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_CREDITBLOCKEDSALESDOCUMENT.ORGANIZATIONDIVISION == TVTA.SPART
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TVTA.MANDT
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Sales Document Type
  • Client
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESDOCUMENTTYPE == TVAK.AUART
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TVAK.MANDT
Sales group
  • Sales group
  • Sales office
  • Client
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESGROUP == TVBVK.VKGRP
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESOFFICE == TVBVK.VKBUR
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TVBVK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TVKO.MANDT
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • I_CREDITBLOCKEDSALESDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • I_CREDITBLOCKEDSALESDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Division
  • Sales office
  • Client
  • Sales Organization
  • I_CREDITBLOCKEDSALESDOCUMENT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_CREDITBLOCKEDSALESDOCUMENT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESOFFICE == TVKBZ.VKBUR
  • I_CREDITBLOCKEDSALESDOCUMENT.MANDT == TVKBZ.MANDT
  • I_CREDITBLOCKEDSALESDOCUMENT.SALESORGANIZATION == TVKBZ.VKORG