I_BR_NFSItemDetail_C

Brazil Service Nota Fiscal Item Details | view: IBRNFSITEMDET | Extraction: Not supported | Component: Logistics Brazil
Column Name Description
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem Document Item Number
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
NetValueAmount Net Amount
BR_NFNetOtherExpensesAmount Net expenses in document currency
BR_NFTotalAmount Net value/Freight/Insurance/Expenses/Discount
BR_NFValueAmountWithTaxes Net Value including taxes
BR_NFDiscountAmountWithTaxes Discount value including taxes
BR_NFExpensesAmountWithTaxes Expenses including taxes
BR_NFTotalAmountWithTaxes Net value/Freight/Insurance/Expenses/Discount
Column Name Description
📏 Base unit of measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
BR_CPRBIsRelevant CPRB Relevance Show values
Column Name Description Domain name
BR_NFApproximateTotalTaxAmount Approximate Tax DECV15_2
BR_NBSCode NBS Code J_1BNBS
BR_CSTISSCode CST for ISS Defined by Municipality LOGBR_MUNICIPAL_ISS_TAXSIT
MaterialName Material Description TEXT40
NetPriceAmount Net Price Including Tax J_1BNFPRI
BR_NFNetDiscountAmount Net Discount Amount DECV15_2
BR_NFPriceAmountWithTaxes Net Price Including Tax J_1BNFPRI
BR_ISSTaxSituationDesc ISS Tax Situation: Description TEXT60
BR_COFINSTaxSituationDesc COFINS Tax Situation: Description TEXT60
BR_PISTaxSituationDesc PIS Tax Situation: Description TEXT60
BR_COFINSTaxLawDesc Tax Law - Description TEXT60
BR_PISTaxLawDesc Tax Law - Description TEXT60
BR_ISSTaxLawDesc Tax Law - Description TEXT60
Master Data Relations Join Conditions
Base unit of measure
  • Base unit of measure
  • Client
  • I_BR_NFSITEMDETAIL_C.BASEUNIT == T006.MSEHI
  • I_BR_NFSITEMDETAIL_C.MANDT == T006.MANDT
CNAE Business Place Code
  • Client
  • CNAE Business Place Code
  • I_BR_NFSITEMDETAIL_C.MANDT == J_1BTCNAE.MANDT
  • I_BR_NFSITEMDETAIL_C.BR_BUSINESSPLACECNAE == J_1BTCNAE.J_1BCNAE
COFINS Tax Law
  • COFINS Tax Law
  • ISS Tax Law
  • PIS Tax Law
  • Client
  • I_BR_NFSITEMDETAIL_C.BR_COFINSTAXLAW == J_1BATL4A.TAXLAW
  • I_BR_NFSITEMDETAIL_C.BR_ISSTAXLAW == J_1BATL4A.TAXLAW
  • I_BR_NFSITEMDETAIL_C.BR_PISTAXLAW == J_1BATL4A.TAXLAW
  • I_BR_NFSITEMDETAIL_C.MANDT == J_1BATL4A.MANDT
Tax Situation COFINS
  • Tax Situation ISS
  • Tax Situation PIS
  • Tax Situation COFINS
  • Client
EFD-REINF Service Type Code
  • Client
  • EFD-REINF Service Type Code
  • I_BR_NFSITEMDETAIL_C.MANDT == LOGBR_REINF.CLIENT
  • I_BR_NFSITEMDETAIL_C.BR_EFDREINFSERVICECODE == LOGBR_REINF.REINF
Benefit Code for ISS Tax
  • ?
  • Benefit Code for ISS Tax
  • Client
ISS Tax Law
  • COFINS Tax Law
  • ISS Tax Law
  • PIS Tax Law
  • Client
  • I_BR_NFSITEMDETAIL_C.BR_COFINSTAXLAW == J_1BATL3.TAXLAW
  • I_BR_NFSITEMDETAIL_C.BR_ISSTAXLAW == J_1BATL3.TAXLAW
  • I_BR_NFSITEMDETAIL_C.BR_PISTAXLAW == J_1BATL3.TAXLAW
  • I_BR_NFSITEMDETAIL_C.MANDT == J_1BATL3.MANDT
Tax Situation ISS
  • Tax Situation ISS
  • Tax Situation PIS
  • Tax Situation COFINS
  • Client
LC 116 Service Type Code
  • Client
  • LC 116 Service Type Code
CNAE Code for Partner
  • Client
  • CNAE Code for Partner
  • I_BR_NFSITEMDETAIL_C.MANDT == J_1BTCNAE.MANDT
  • I_BR_NFSITEMDETAIL_C.BR_NFPARTNERCNAE == J_1BTCNAE.J_1BCNAE
PIS Tax Law
  • COFINS Tax Law
  • ISS Tax Law
  • PIS Tax Law
  • Client
  • I_BR_NFSITEMDETAIL_C.BR_COFINSTAXLAW == J_1BATL5.TAXLAW
  • I_BR_NFSITEMDETAIL_C.BR_ISSTAXLAW == J_1BATL5.TAXLAW
  • I_BR_NFSITEMDETAIL_C.BR_PISTAXLAW == J_1BATL5.TAXLAW
  • I_BR_NFSITEMDETAIL_C.MANDT == J_1BATL5.MANDT
Tax Situation PIS
  • Tax Situation ISS
  • Tax Situation PIS
  • Tax Situation COFINS
  • Client
Material Number
  • Client
  • Material Number
  • I_BR_NFSITEMDETAIL_C.MANDT == MARA.MANDT
  • I_BR_NFSITEMDETAIL_C.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_BR_NFSITEMDETAIL_C.MANDT == T023.MANDT
  • I_BR_NFSITEMDETAIL_C.MATERIALGROUP == T023.MATKL
Control Code
  • ?
  • Control Code
  • Client
  • I_BR_NFSITEMDETAIL_C.[column in domain "LAND1"] == T604F.LAND1
  • I_BR_NFSITEMDETAIL_C.NCMCODE == T604F.STEUC
  • I_BR_NFSITEMDETAIL_C.MANDT == T604F.MANDT
Plants
  • Plant
  • Client
  • I_BR_NFSITEMDETAIL_C.PLANT == T001W.WERKS
  • I_BR_NFSITEMDETAIL_C.MANDT == T001W.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_BR_NFSITEMDETAIL_C.MANDT == TCURC.MANDT
  • I_BR_NFSITEMDETAIL_C.SALESDOCUMENTCURRENCY == TCURC.WAERS