I_BillingDocumentRequestItem

Billing Document Request Item | view: ISDBILDOCREQIT | ATTR | Extraction: Not supported | Component: Billing
Tables used: VBRK, VBRP
Column Name Description
BillingDocumentRequest FK Billing Document Request
BillingDocumentRequestItem Billing Document Request Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of Billing item in Document Currency
GrossAmount Gross Value of the Billing Item in Document Currency
TaxAmount Tax Amount in Document Currency
CostAmount Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
CreditRelatedPrice Item credit price
Column Name Description
📏 Billing Quantity Unit (BillingQuantityUnit):
BillingQuantity Billing Quantity
📏 Base Unit of Measure (BaseUnit):
BillingQuantityInBaseUnit Billing quantity in stock keeping unit
MRPRequiredQuantityInBaseUnit Required quantity for mat.management in stockkeeping units
PricingScaleQuantityInBaseUnit Scale Quantity in base unit of measure
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross weight
ItemNetWeight Net weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
PriceDetnExchangeRateDate Translation date
Column Name Description
SalesDocumentItemType Item Type Show values
ReturnItemProcessingType Returns item Show values
StatisticalValueControl Statistical Values Show values
CashDiscountIsDeductible Cash Discount Indicator Show values
BillgDocReqBillgSts Billing Document Request Status Show values
ReferenceDocSDDocCategory Source Document Category Show values
SalesSDDocumentCategory Sales Document Category Show values
ItemIsRelevantForCredit ID: Item with active credit function / relevant for credit Show values
Column Name Description Domain name
SalesDocumentItemCategory Sales Document Item Category PSTYV
CreatedByUser Name of Person Responsible for Creating the Object USNAM
ReferenceLogicalSystem Logical system LOGSYS
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
BillingDocumentRequestItemText Text of Billing Document Request Item TEXT40
BillingToBaseQuantityDnmntr Denominator (divisor) for conversion of billing Qty into SKU UMBSN
BillingToBaseQuantityNmrtr Numerator (factor) for conversion of bill. quantity into SKU UMBSZ
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
TaxJurisdiction Tax Jurisdiction TXJCD
ProductTaxClassification1 Tax classification material TAXKM
ProductTaxClassification2 Tax Classification 2 for Material TAXKM
ProductTaxClassification3 Tax Classification 3 for Material TAXKM
ProductTaxClassification4 Tax Classification 4 for Material TAXKM
ProductTaxClassification5 Tax Classification 5 for Material TAXKM
ProductTaxClassification6 Tax Classification 6 for Material TAXKM
ProductTaxClassification7 Tax Classification 7 for Material TAXKM
ProductTaxClassification8 Tax Classification 8 for Material TAXKM
ProductTaxClassification9 Tax Classification 9 for Material TAXKM
ProfitCenter Profit Center PRCTR
WBSElementInternalID WBS Element PS_S4_PSPNR
ProviderContract Identification of a Provider Contract VTKEY_KK
ProviderContractItem Provider Contract Item VTPOS_KK
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
CostCenter Cost Center KOSTL
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
ReferenceDocument Source document of data contained in billing doc. request VBELN
ReferenceDocumentItem Source Document Item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVM1.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVM2.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVM3.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVM4.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVM5.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T006.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Batch Number
  • Client
  • Plant
  • Material Number
  • Product Number
  • I_BILLINGDOCUMENTREQUESTITEM.BATCH == MCHA.CHARG
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == MCHA.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.PLANT == MCHA.WERKS
  • I_BILLINGDOCUMENTREQUESTITEM.MATERIAL == MCHA.MATNR
  • I_BILLINGDOCUMENTREQUESTITEM.PRODUCT == MCHA.MATNR
Billing Quantity Unit
  • Client
  • Billing Quantity Unit
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T006.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.BILLINGQUANTITYUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • I_BILLINGDOCUMENTREQUESTITEM.BUSINESSAREA == TGSB.GSBER
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_BILLINGDOCUMENTREQUESTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TKA01.MANDT
Departure Country/Region (from which the goods are sent)
  • Client
  • Departure Country/Region (from which the goods are sent)
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T005.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.DEPARTURECOUNTRY == T005.LAND1
Division
  • Client
  • Division
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TSPA.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.DIVISION == TSPA.SPART
Volume unit
  • Client
  • Volume unit
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T006.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T006.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ITEMWEIGHTUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • Product Number
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.MATERIAL == MARA.MATNR
  • I_BILLINGDOCUMENTREQUESTITEM.PRODUCT == MARA.MATNR
Commission Group
  • Client
  • Commission Group
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVPR.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.MATERIALCOMMISSIONGROUP == TVPR.PROVG
Material Group
  • Client
  • Material Group
  • Product Group
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T023.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.MATERIALGROUP == T023.MATKL
  • I_BILLINGDOCUMENTREQUESTITEM.PRODUCTGROUP == T023.MATKL
Account Assignment Group for Material
  • Client
  • Account Assignment Group for Material
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVKM.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM
Order Number
  • Client
  • Order Number
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == AUFK.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ORDERID == AUFK.AUFNR
Division in Sales Order Header
  • Client
  • Division in Sales Order Header
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TSPA.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ORGANIZATIONDIVISION == TSPA.SPART
Material Entered
  • Client
  • Material Entered
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T001W.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.PLANT == T001W.WERKS
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR
Product Number
  • Client
  • Material Number
  • Product Number
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.MATERIAL == MARA.MATNR
  • I_BILLINGDOCUMENTREQUESTITEM.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Material Group
  • Product Group
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T023.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.MATERIALGROUP == T023.MATKL
  • I_BILLINGDOCUMENTREQUESTITEM.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T179.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.PRODUCTHIERARCHYNODE == T179.PRODH
Sales group
  • Client
  • Sales group
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVKGR.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.SALESGROUP == TVKGR.VKGRP
Sales office
  • Client
  • Sales office
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == TVBUR.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.SALESOFFICE == TVBUR.VKBUR
Service Document Type
  • Client
  • Service Document Type
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == CRMC_PROC_TYPE.CLIENT
  • I_BILLINGDOCUMENTREQUESTITEM.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Storage location
  • Client
  • Plant
  • Storage location
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == T001L.MANDT
  • I_BILLINGDOCUMENTREQUESTITEM.PLANT == T001L.WERKS
  • I_BILLINGDOCUMENTREQUESTITEM.STORAGELOCATION == T001L.LGORT
Foreign key for J_1ARFZ
  • Reason for Zero VAT
  • Client
  • I_BILLINGDOCUMENTREQUESTITEM.ZEROVATRSN == J_1ARFZ.J_1ARFZ
  • I_BILLINGDOCUMENTREQUESTITEM.MANDT == J_1ARFZ.MANDT