P_BR_ReportigNFDocumentItemTax
EFD - NF Document Item Tax Cube
P_BR_ReportigNFDocumentItemTax is a Consumption CDS View that provides data about "EFD - NF Document Item Tax Cube" in SAP S/4HANA. It reads from 3 data sources (P_BR_ReportingNFeActive, P_BR_ReportingNFTaxCalculation, I_UnitOfMeasureText) and exposes 177 fields with key fields CompanyCode, TaxGroup.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| P_BR_ReportingNFeActive | act | left_outer |
| P_BR_ReportingNFTaxCalculation | doc | from |
| I_UnitOfMeasureText | unit | left_outer |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PBRNFDOCITEMTAX | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| EndUserText.label | EFD - NF Document Item Tax Cube | view | |
| VDM.private | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | view |
Fields (177)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | P_BR_ReportingNFTaxCalculation | CompanyCode | |
| BusinessPlace | ||||
| BR_NotaFiscal | ||||
| BR_NotaFiscalItem | ||||
| BR_TaxType | ||||
| KEY | TaxGroup | P_BR_ReportingNFTaxCalculation | TaxGroup | |
| BR_PaymentForm | P_BR_ReportingNFTaxCalculation | BR_PaymentForm | ||
| BR_NFIssueDate | ||||
| BR_NFPostingDate | ||||
| BR_NFSeries | ||||
| BR_NFPartnerType | P_BR_ReportingNFTaxCalculation | BR_NFPartnerType | ||
| BR_NFPartnerendasBR_NFPartner | ||||
| LicensePlate | ||||
| BR_NFeNumber | ||||
| BR_NFeAccessKeyCNPJOrCPF | ||||
| BR_NFIssuedBy | ||||
| BR_NFSituationCode | ||||
| BR_NFDirectionasBR_NFOriginalDirection | ||||
| SupplierInvoice | ||||
| char2asBR_NFModel | ||||
| BR_NFeAccessKey | ||||
| CHV_NFE | ||||
| BR_NFPartnerRegionCode | P_BR_ReportingNFTaxCalculation | BR_NFPartnerRegionCode | ||
| BR_NFIsCanceled | ||||
| BR_NFeAccessKeyelseendasBR_CTeAccessKey | ||||
| BR_CTeJurisdictionCodeOrigin | ||||
| BR_CTeJurisdictionCodeDest | ||||
| FreightPayer | ||||
| BR_NFPartnerTaxJurisdiction | ||||
| MaterialOldID | ||||
| Material | P_BR_ReportingNFTaxCalculation | Material | ||
| MaterialName | ||||
| UnitOfMeasure_EendasBaseUnit | ||||
| BR_NFIsPhysicalMvtOfMaterial | ||||
| BR_CFOPCode14asBR_CFOPCode | ||||
| BR_CFOPCodeasNFOperationNature | ||||
| BR_IPITaxSituation | ||||
| BR_PISTaxSituation | ||||
| BR_COFINSTaxSituation | ||||
| GLAccount | ||||
| BR_MaterialUsage | ||||
| MATUSEJ_1BNFLINBWKEYasValuationArea | ||||
| ValuationType | ||||
| BR_NFExternalItemNumber | ||||
| BR_NFIsServiceItem | ||||
| BR_ICMSTaxLaw | ||||
| BR_IPITaxLaw | ||||
| BR_MaterialOrigin | ||||
| BR_COFINSTaxLaw | ||||
| BR_PISTaxLaw | ||||
| BR_NFCancellationDate | ||||
| BR_NFShippingUnitBrand | ||||
| BR_NFSVerificationCode | ||||
| BR_NFType | ||||
| BR_NFSubSeries | ||||
| BR_NFSNumber | ||||
| BR_NFPartnerStateTaxNumber | ||||
| QuantityInBaseUnit | ||||
| BR_ICMSIsIncludedInAmount | ||||
| BR_PISSTTaxBaseAmount | ||||
| BR_PISSTTaxRate | ||||
| BR_PISSTTaxAmount | ||||
| BR_PISSTTaxExcludedBaseAmount | ||||
| BR_IPITaxBaseAmount | ||||
| BR_IPITaxRate | ||||
| BR_IPITaxAmount | ||||
| BR_IPITaxExcludedBaseAmount | ||||
| BR_IPITaxOtherBaseAmount | ||||
| BR_ISSQNTaxBaseAmount | ||||
| BR_ISSQNTaxRate | ||||
| BR_ISSQNTaxAmount | ||||
| BR_ISSQNTaxExcludedBaseAmount | ||||
| BR_ISSQNTaxOtherBaseAmount | ||||
| BR_PISTaxBaseAmount | ||||
| BR_AppliedPISTaxAmount | ||||
| BR_PISTaxAmount | ||||
| BR_PISTaxExcludedBaseAmount | ||||
| BR_PISTaxOtherBaseAmount | ||||
| BR_PISTaxIsFiscalTariff | ||||
| BR_PISTxFiscalTariffBaseAmount | ||||
| BR_ICMSTaxBaseAmount | ||||
| BR_ICMSTaxRate | ||||
| BR_ICMSTaxAmount | ||||
| BR_ICMSTaxExcludedBaseAmount | ||||
| BR_ICMSTaxOtherBaseAmount | ||||
| BR_ICMSSTTaxBaseAmount | ||||
| BR_ICMSSTTaxRate | ||||
| BR_ICMSSTTaxAmount | ||||
| BR_ICMSSTTaxExcludedBaseAmount | ||||
| BR_ICMSSTTaxOtherBaseAmount | ||||
| BR_COFINSTaxBaseAmount | ||||
| BR_AppliedCOFINSTaxAmount | ||||
| BR_COFINSTaxAmount | ||||
| BR_COFINSTaxExcludedBaseAmount | ||||
| BR_COFINSTaxOtherBaseAmount | ||||
| BR_COFINSTaxIsFiscalTariff | ||||
| BR_COFINSTxFsclTrifBaseAmount | ||||
| BR_COFINSSTTaxBaseAmount | ||||
| BR_COFINSSTTaxRate | ||||
| BR_COFINSSTTaxAmount | ||||
| BR_COFINSSTTaxExcldBaseAmount | ||||
| BR_COFINSSTTaxOtherBaseAmount | ||||
| NFHeaderTotalAmount | ||||
| BR_ICMSReductionTaxAmount | ||||
| BR_IPIReductionTaxAmount | ||||
| BR_DIFALTaxBaseAmount | ||||
| BR_DIFALTaxRate | ||||
| BR_DIFALTaxAmount | ||||
| BR_DIFALTaxExcludedBaseAmount | ||||
| BR_DIFALTaxOtherBaseAmount | ||||
| BR_NFItemType | ||||
| BR_IPIControlSealCode | ||||
| BR_IPIControlSealQuantityValue | ||||
| PurchaseOrder | ||||
| PurchaseOrderItem | ||||
| NetPriceAmount | ||||
| NCMCode | ||||
| BR_NFIsMunicipal | ||||
| BR_OriginalICMSSTTaxAmount | ||||
| BR_OriginalIPITaxAmount | ||||
| BR_OriginalICMSTaxAmount | ||||
| BR_OriginalFCPOnICMSTaxAmount | ||||
| BR_OriglFCPOnICMSSTTaxAmount | ||||
| BR_NFCreditCalculationBasis | ||||
| BR_CFOPCategory | ||||
| BR_NFHasServiceItem | ||||
| SalesDocumentCurrency | ||||
| HeaderWeightUnit | ||||
| IncotermsClassification | P_BR_ReportingNFTaxCalculation | IncotermsClassification | ||
| BR_NFPartnerMunicipalTaxNumber | ||||
| BR_NFSourceDocumentNumber | ||||
| BR_NFSourceDocumentType | ||||
| BR_NFSourceDocumentItem | ||||
| Plant | ||||
| Batch | ||||
| BR_ISSTaxSituation | ||||
| BR_ISSTaxLaw | ||||
| BR_NFItemIsStatistical | ||||
| BR_ReferenceNFNumber | ||||
| BR_ReferenceNFItem | ||||
| BR_NFPriceAmountWithTaxes | ||||
| BR_NFReferenceDocument | ||||
| BR_NFPartnerFunction | ||||
| AccountingDocument | ||||
| BR_NFIsContingency | ||||
| BR_CTeServiceType | ||||
| PaymentTerms | ||||
| BR_NFIsCreatedManually | ||||
| BR_ICMSOriginTaxRate | ||||
| BR_ICMSOriginTaxAmount | ||||
| BR_ICMSOriginTaxBaseAmount | ||||
| BR_ICMSDestinationTaxRate | ||||
| BR_ICMSDestinationTaxAmount | ||||
| BR_FCPOnICMSTaxRate | ||||
| BR_FCPOnICMSTaxAmount | ||||
| BR_FCPOnICMSTaxBaseAmount | ||||
| BR_FCPOnICMSSTTaxRate | ||||
| BR_FCPOnICMSSTTaxAmount | ||||
| BR_FCPOnICMSSTTaxBaseAmount | ||||
| BR_NFArrivalOrDepartureDate | ||||
| BR_NFPartnerName1 | ||||
| BR_NFPartnerStreetName | ||||
| BR_NFPartnerDistrictName | ||||
| BR_NFPartnerCityName | ||||
| BR_NFPartnerPostalCode | ||||
| CostCenter | ||||
| asBR_NBSCode | ||||
| asBR_NCMCode | ||||
| PhoneNumber | ||||
| BR_NFValueAmountWithTaxes | ||||
| NetValueAmount | ||||
| BR_NFFreightAmountWithTaxes | P_BR_ReportingNFTaxCalculation | BR_NFFreightAmountWithTaxes | ||
| BR_NFInsuranceAmountWithTaxes | ||||
| BR_NFNetOtherExpensesAmount | ||||
| BR_ICMSPartilhaSubdivisionCode | ||||
| NFItemTaxAmount | ||||
| NFItemBaseAmount |
@AbapCatalog.sqlViewName: 'PBRNFDOCITEMTAX'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'EFD - NF Document Item Tax Cube'
@VDM: { private: true, viewType: #CONSUMPTION }
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: ''
define view P_BR_ReportigNFDocumentItemTax
as select from P_BR_ReportingNFTaxCalculation as doc
left outer join P_BR_ReportingNFeActive as act on doc.BR_NotaFiscal = act.BR_NotaFiscal --on doc.NFReferenceDocument = act.NotaFiscal
left outer join I_UnitOfMeasureText as unit on doc.BaseUnit = unit.UnitOfMeasure
and unit.Language = $session.system_language
{
key doc.CompanyCode, -- EMPRESA
key doc.BusinessPlace, -- FILIAL
key doc.BR_NotaFiscal, -- NF_ID
key doc.BR_NotaFiscalItem, -- NUM_ITEM
key doc.BR_TaxType,
key doc.TaxGroup,
doc.BR_PaymentForm, -- IND_PGTO
doc.BR_NFIssueDate, -- DTdoc
doc.BR_NFPostingDate, -- DT_E_S
doc.BR_NFSeries,
doc.BR_NFPartnerType, -- TIPO_PART
case when doc.BR_NFPartnerType = 'B' then
case when doc.PartnerFieldLength = 10 then
concat(doc.BR_NFPartnerType, right(doc.BR_NFPartner, 8))
else
concat(doc.BR_NFPartnerType, doc.BR_NFPartner)
end
else concat(doc.BR_NFPartnerType, doc.BR_NFPartner) end as BR_NFPartner, -- COD_PART
doc.LicensePlate, -- VEIC_ID
doc.BR_NFeNumber, -- NUMdoc
act.BR_NFeAccessKeyCNPJOrCPF, -- CNPJ_CPF
doc.BR_NFIssuedBy, -- IND_EMIT
doc.BR_NFSituationCode, -- COD_SIT
doc.BR_NFDirection as BR_NFOriginalDirection,
case when doc.BR_NFDirection = '2' then '1'
when doc.BR_NFDirection = '3' then '1'
else '0' end as BR_NFDirection, -- IND_OPER
doc.SupplierInvoice, -- FATURA_ID
cast(doc.BR_NFModel as abap.char( 2 )) as BR_NFModel, -- COD_MOD
act.BR_NFeAccessKey, -- CHV_NFE,
doc.BR_NFPartnerRegionCode, -- UF
doc.BR_NFIsCanceled, -- CANCELADO
case when doc.BR_CTeDocumentType <> ''
then act.BR_NFeAccessKey
else ''
end as BR_CTeAccessKey, -- CHV_CTE
doc.BR_CTeDocumentType as BR_CTeOriginalDocumentType,
case when doc.BR_CTeDocumentType = 'A' then '2'
when doc.BR_CTeDocumentType = 'S' then '3'
else case when doc.BR_NFDocumentType = '2' then '1'
when doc.BR_NFDocumentType = '4' then '0'
when doc.BR_NFDocumentType = '7' then '0'
else '' end
end as BR_CTeDocumentType, -- TP_CT-e
doc.BR_CTeJurisdictionCodeOrigin, -- COD_MUN_ORIG
doc.BR_CTeJurisdictionCodeDest, -- COD_MUN_DEST
doc.FreightPayer, -- IND_FRT
doc.BR_NFPartnerTaxJurisdiction, -- COD_MUN
doc.MaterialOldID,
doc.Material, -- COD_ITEM
doc.MaterialName, -- DESCR_COMPL
case when unit.UnitOfMeasure_E = '' then doc.BaseUnit else unit.UnitOfMeasure_E end as BaseUnit, -- UNID
doc.BR_NFIsPhysicalMvtOfMaterial, -- IND_MOV
doc.BR_ICMSTaxSituation as BR_ICMSIsOriginalTaxSituation,
case when doc.BR_ICMSTaxSituation = 'A' then concat(doc.BR_MaterialOrigin,'41')
when doc.BR_ICMSTaxSituation = 'B' then concat(doc.BR_MaterialOrigin,'51')
when doc.BR_ICMSTaxSituation <> 'A' and doc.BR_ICMSTaxSituation <> 'B' then concat(doc.BR_MaterialOrigin,concat(right(doc.BR_ICMSTaxSituation, 1),'0'))
else '' end as BR_ICMSTaxSituation, -- CST_ICMS
substring(doc.BR_CFOPCode,1,4) as BR_CFOPCode, -- CFOP
doc.BR_CFOPCode as NFOperationNature, -- COD_NAT
doc.BR_IPITaxSituation, -- CST_IPI
doc.BR_PISTaxSituation, -- CST_PIS
doc.BR_COFINSTaxSituation, -- CST_COFINS
doc.GLAccount, -- COD_CTA
doc.BR_MaterialUsage, -- MATUSE
'J_1BNFLIN-BWKEY' as ValuationArea, -- AVALIACAO_AREA (NEEDS TO BE CREATED)
doc.ValuationType, -- AVALIACAO_TIPO
doc.BR_NFExternalItemNumber, -- NUM_ITEM_EXT
'J_1BNFDOC-ISUF' as BR_SUFRAMACode, -- SUFRAMA_PARTNER (NEEDS TO BE CREATED)
doc.BR_NFIsServiceItem, -- IND_SERVICO
doc.BR_ICMSTaxLaw, -- SYS_DIR_ICMS
doc.BR_IPITaxLaw, -- SYS_DIR_IPI
doc.BR_MaterialOrigin, -- SYS_ORG_ITEM
doc.BR_COFINSTaxLaw, -- SYS_DIR_COFINS
doc.BR_PISTaxLaw, -- SYS_DIR_PIS
doc.BR_NFCancellationDate, -- DT_CANC
doc.BR_NFShippingUnitBrand, -- MARCA_VOL_TRANS
doc.BR_NFSVerificationCode, -- RPS
doc.BR_NFType, -- SYS_TIPO_NF
doc.BR_NFSubSeries, -- SUB
doc.BR_NFSNumber, -- NFE_SERV_NUM
doc.BR_NFPartnerStateTaxNumber, -- IE
@Semantics.amount.currencyCode: 'HeaderWeightUnit'
doc.QuantityInBaseUnit, -- QTD
-- 'J_1BNFLIN-INCLTX' as BR_ICMSIsIncludedInAmount, -- INC_IMPOSTO
doc.BR_ICMSIsIncludedInAmount, -- INC_IMPOSTO
doc.BR_PISSTTaxBaseAmount, -- VL_BC_PISST
doc.BR_PISSTTaxRate, -- ALIQ_PISST
doc.BR_PISSTTaxAmount, -- VL_PISST
doc.BR_PISSTTaxExcludedBaseAmount, -- VL_BC_EXC_PISST
doc.BR_IPITaxBaseAmount, -- VL_BC_IPI
doc.BR_IPITaxRate, -- ALIQ_IPI
doc.BR_IPITaxAmount, -- VL_IPI
doc.BR_IPITaxExcludedBaseAmount, -- VL_BC_EXC_IPI
doc.BR_IPITaxOtherBaseAmount, -- VL_BC_OUTRAS_IPI
doc.BR_ISSQNTaxBaseAmount, -- VL_BC_ISSQN
doc.BR_ISSQNTaxRate, -- ALIQ_ISSQN
doc.BR_ISSQNTaxAmount, -- VL_ISSQN
doc.BR_ISSQNTaxExcludedBaseAmount, -- VL_BC_EXC_ISSQN
doc.BR_ISSQNTaxOtherBaseAmount, -- VL_BC_OUTRAS_ISSQN
doc.BR_PISTaxBaseAmount, -- VL_BC_PIS
doc.BR_AppliedPISTaxAmount, -- ALIQ_PIS
doc.BR_PISTaxAmount, -- VL_PIS
doc.BR_PISTaxExcludedBaseAmount, -- VL_BC_EXC_PIS
doc.BR_PISTaxOtherBaseAmount, -- VL_BC_OUTRAS_PIS
doc.BR_PISTaxIsFiscalTariff, -- PAUTA_PIS
doc.BR_PISTxFiscalTariffBaseAmount, -- VL_BC_PAUTA_PIS
doc.BR_ICMSTaxBaseAmount, -- VL_BC_ICMS
doc.BR_ICMSTaxRate, -- ALIQ_ICMS
doc.BR_ICMSTaxAmount, -- VL_ICMS
doc.BR_ICMSTaxExcludedBaseAmount, -- VL_BC_EXC_ICMS
doc.BR_ICMSTaxOtherBaseAmount, -- VL_BC_OUTRAS_ICMS
doc.BR_ICMSSTTaxBaseAmount, -- VL_BC_ICMSST
doc.BR_ICMSSTTaxRate, -- ALIQ_ICMSST
doc.BR_ICMSSTTaxAmount, -- VL_ICMSST
doc.BR_ICMSSTTaxExcludedBaseAmount, -- VL_BC_EXC_ICMSST
doc.BR_ICMSSTTaxOtherBaseAmount, -- VL_BC_OUTRAS_ICMSST
doc.BR_COFINSTaxBaseAmount, -- VL_BC_COFINS
doc.BR_AppliedCOFINSTaxAmount, -- ALIQ_COFINS
doc.BR_COFINSTaxAmount, -- VL_COFINS
doc.BR_COFINSTaxExcludedBaseAmount, -- VL_BC_EXC_COFINS
doc.BR_COFINSTaxOtherBaseAmount, -- VL_BC_OUTRAS_COFINS
doc.BR_COFINSTaxIsFiscalTariff, -- PAUTA_COFINS
doc.BR_COFINSTxFsclTrifBaseAmount, -- VL_BC_PAUTA_COFINS
doc.BR_COFINSSTTaxBaseAmount, -- VL_BC_COFINSST
doc.BR_COFINSSTTaxRate, -- ALIQ_COFINSST
doc.BR_COFINSSTTaxAmount, -- VL_COFINSST
doc.BR_COFINSSTTaxExcldBaseAmount, -- VL_BC_EXC_COFINSST
doc.BR_COFINSSTTaxOtherBaseAmount, -- VL_BC_OUTRAS_COFINSST
doc.NFHeaderTotalAmount, -- VL_TOTALdocUMENTO
doc.BR_ICMSReductionTaxAmount, -- VL_ABAT_NT_ICMS
doc.BR_IPIReductionTaxAmount, -- VL_ABAT_NT_IPI
doc.BR_DIFALTaxBaseAmount, -- VL_BC_ICMS_DIFAL
doc.BR_DIFALTaxRate, -- ALIQ_ICMS_DIFAL
doc.BR_DIFALTaxAmount, -- VL_ICMS_DIFAL
doc.BR_DIFALTaxExcludedBaseAmount, -- VL_BC_EXC_ICMS_DIFAL
doc.BR_DIFALTaxOtherBaseAmount, -- VL_BC_OUTRAS_ICMS_DIFAL
doc.BR_NFItemType, -- TIPO_ITEM
doc.BR_IPIControlSealCode, -- COD_SELO_IPI
doc.BR_IPIControlSealQuantityValue, -- QT_SELO_IPI
doc.PurchaseOrder, -- PED_COMPRA
doc.PurchaseOrderItem, -- PED_COMPRA_ITEM
doc.NetPriceAmount, -- VL_UNID
doc.BR_NFTotalAmount as BR_OutgoingNFOperationAmount, -- VL_OPR_SAIDA
doc.BR_NFTotalAmountWithTaxes as BR_IncomingNFOperationAmount, -- VL_OPR_ENTRADA
doc.NCMCode, -- NCM
doc.BR_NFIsMunicipal, -- MUNICIPAL
@Semantics.amount.currencyCode: 'SalesDocumentCurrency'
case
when doc.BR_NFValueAmountWithTaxes = 0
then doc.NetValueAmount
else doc.BR_NFValueAmountWithTaxes
end as NFTotalAmount, -- VL_ITEM
case
when doc.BR_NFValueAmountWithTaxes = 0
then doc.NetValueAmount
else doc.BR_NFValueAmountWithTaxes
end as BR_NFTotalAmount, -- VL_ITEM
doc.BR_OriginalICMSSTTaxAmount, -- VL_CONT_ICMSST
doc.BR_OriginalIPITaxAmount, -- VL_CONT_IPI
doc.BR_OriginalICMSTaxAmount, -- VL_CONT_ICMS
doc.BR_OriginalFCPOnICMSTaxAmount, -- VL_CONT_ICMS_FUN
doc.BR_OriglFCPOnICMSSTTaxAmount, -- VL_CONT_ICMSST_FUN
case
when doc.MaterialOldID = '' and doc.BR_NFSNumber = ''
then case when doc.BR_NFIsServiceItem = 'X' or doc.BR_NFModel = '57'
then '09'
else case when doc.BR_MaterialUsage = '0' then '00'
when doc.BR_MaterialUsage = '1' then '10'
when doc.BR_MaterialUsage = '2' then '07'
when doc.BR_MaterialUsage = '3' then '08'
else '99'
end
end
else ''
end as MaterialType, -- TIPO_ITEM_NM
-- doc.BR_NFCreditCalculationBasis, -- NAT_BC_CRED
-- doc.BR_CFOPCategory, -- CATEGORIA_CFOP
doc.BR_NFHasServiceItem, -- NF_SRV
@Semantics.currencyCode: true
doc.SalesDocumentCurrency, -- MOEDA
@Semantics.unitOfMeasure: true
doc.HeaderWeightUnit,
doc.IncotermsClassification, -- INCOTERMS1
doc.BR_NFPartnerMunicipalTaxNumber, -- IM
doc.BR_NFSourceDocumentNumber, -- NUM_REF_LANCTO
doc.BR_NFSourceDocumentType, -- TP_REF_LANCTO
doc.BR_NFSourceDocumentItem, -- ITM_REF_LANCTO
doc.Plant, -- CENTRO
doc.Batch, -- LOTE
doc.BR_ISSTaxSituation, -- CST_ISS
doc.BR_ISSTaxLaw, -- SYS_DIR_ISS
doc.BR_NFItemIsStatistical, -- IND_STAT_ITEM
doc.BR_ReferenceNFNumber, -- NUM_REFdoc
doc.BR_ReferenceNFItem, -- NUM_REF_ITEM
doc.BR_NFPriceAmountWithTaxes, -- VL_LIQ_IMP
doc.BR_NFReferenceDocument, -- DOCREF
doc.BR_NFPartnerFunction, -- FUN_PARC
doc.AccountingDocument, -- NUMdoc_CONTABIL
doc.BR_NFIsContingency, -- CONTINGENCIA
doc.BR_CTeServiceType, -- TP_SERVICO
doc.PaymentTerms, -- CHV_CONDICAO
doc.BR_NFIsCreatedManually, -- MANUAL
doc.BR_ICMSOriginTaxRate, -- ALIQ_ICMS_ORI
doc.BR_ICMSOriginTaxAmount, -- VL_ICMS_ORI
doc.BR_ICMSOriginTaxBaseAmount, -- VL_BC_ICMS_ORI
doc.BR_ICMSDestinationTaxRate, -- ALIQ_ICMS_DES
doc.BR_ICMSDestinationTaxAmount, -- VL_ICMS_DES
doc.BR_FCPOnICMSTaxRate, -- ALIQ_ICMS_FUN
doc.BR_FCPOnICMSTaxAmount, -- VL_ICMS_FUN
doc.BR_FCPOnICMSTaxBaseAmount, -- VL_BC_ICMS_FUN
doc.BR_FCPOnICMSSTTaxRate, -- ALIQ_ICMSST_FUN
doc.BR_FCPOnICMSSTTaxAmount, -- VL_ICMSST_FUN
doc.BR_FCPOnICMSSTTaxBaseAmount, -- VL_BC_ICMSST_FUN
doc.BR_NFArrivalOrDepartureDate, -- DT_EXTEMPORANEA
doc.BR_NFPartnerName1, -- NOME
doc.BR_NFPartnerStreetName, -- ENDE
'J_1BNFDOC-HOUSE_NUM1' as BusinessPartnerHouseNumber, -- NUMERO
'J_1BNFDOC-HOUSE_NUM2' as BPHsNmbrSuplmntTxt, -- COMPL
doc.BR_NFPartnerDistrictName, -- BAIRRO
doc.BR_NFPartnerCityName, -- DESC_MUN
doc.BR_NFPartnerPostalCode, -- CEP
doc.CostCenter, -- COD_CCUS
replace(substring(doc.BR_NBSCode,1,9),'.',',') as BR_NBSCode, -- NBS -- leftstr(replace("NBS",'.',''),9)
replace(substring(doc.BR_NBSCode,9,3),'.',',') as BR_NCMCode, -- EX_IPI -- midstr(replace("NCM",'.',''),9,3)
doc.PhoneNumber, -- FONE
@Semantics.amount.currencyCode: 'SalesDocumentCurrency'
case when doc.BR_ICMSReductionTaxAmount = 0
then doc.BR_NFDiscountAmountWithTaxes*(-1)
else case when BR_ExemptedICMSAmount = 0
then (doc.BR_NFDiscountAmountWithTaxes*(-1) - doc.BR_ICMSReductionTaxAmount) else doc.BR_NFDiscountAmountWithTaxes*(-1)
end
end as BR_NFDiscountAmountWithTaxes, -- VL_DESC
doc.BR_NFValueAmountWithTaxes, -- VL_MERC
doc.NetValueAmount,
doc.BR_NFFreightAmountWithTaxes, -- VL_FRT
doc.BR_NFInsuranceAmountWithTaxes, -- VL_SEG
doc.BR_NFNetOtherExpensesAmount, -- VL_OUT
doc.BR_ICMSPartilhaSubdivisionCode, -- SUBDIVISION
doc.NFItemTaxAmount, -- TAXVAL
doc.NFItemBaseAmount, -- BASE
@Semantics.amount.currencyCode: 'SalesDocumentCurrency'
case when doc.BR_NFDirection <> '2' and doc.BR_NFDirection <> '3' and doc.BR_ICMSIsIncludedInAmount = ''
then case when doc.BR_NFValueAmountWithTaxes = 0
then doc.NetValueAmount
else doc.BR_NFValueAmountWithTaxes
end
else case when doc.BR_ICMSIsIncludedInAmount = 'X'
then doc.BR_NFTotalAmountWithTaxes
else doc.BR_NFTotalAmount
end
end as BR_NFOperationAmount, -- VL_OPR (without taxes)
@Semantics.amount.currencyCode: 'SalesDocumentCurrency'
case when doc.BR_NFDirection <> '2' and doc.BR_NFDirection <> '3' and doc.BR_ICMSIsIncludedInAmount = ''
then doc.BR_OriginalICMSSTTaxAmount + doc.BR_FCPOnICMSSTTaxAmount + doc.BR_OriginalIPITaxAmount + doc.ImportTaxAmount + doc.BR_ICZGTaxAmount
else case when doc.BR_ICMSIsIncludedInAmount = 'X'
then doc.BR_OriginalICMSSTTaxAmount+ doc.BR_FCPOnICMSSTTaxAmount + doc.BR_OriginalIPITaxAmount + doc.ImportTaxAmount
else case when doc.BR_PISIsIncludedInAmount = 'X' and doc.BR_COFINSIsIncludedInAmount = 'X'
then doc.BR_ICMSTaxAmount + doc.BR_FCPOnICMSTaxAmount
+ doc.BR_OriginalICMSSTTaxAmount + doc.BR_FCPOnICMSSTTaxAmount + doc.BR_ICMSSTStatisticalTaxAmount
+ doc.BR_OriginalIPITaxAmount + doc.BR_IPIStatisticalTaxAmount
+ doc.ImportTaxAmount
when doc.BR_PISIsIncludedInAmount = 'X' and doc.BR_COFINSIsIncludedInAmount = ''
then doc.BR_ICMSTaxAmount + doc.BR_FCPOnICMSTaxAmount
+ doc.BR_OriginalICMSSTTaxAmount + doc.BR_FCPOnICMSSTTaxAmount + doc.BR_ICMSSTStatisticalTaxAmount
+ doc.BR_OriginalIPITaxAmount + doc.BR_IPIStatisticalTaxAmount
+ doc.BR_COFINSTaxAmount
+ doc.ImportTaxAmount
when doc.BR_PISIsIncludedInAmount = '' and doc.BR_COFINSIsIncludedInAmount = 'X'
then doc.BR_ICMSTaxAmount + doc.BR_FCPOnICMSTaxAmount
+ doc.BR_OriginalICMSSTTaxAmount + doc.BR_FCPOnICMSSTTaxAmount + doc.BR_ICMSSTStatisticalTaxAmount
+ doc.BR_OriginalIPITaxAmount + doc.BR_IPIStatisticalTaxAmount
+ doc.BR_PISTaxAmount
+ doc.ImportTaxAmount
else doc.BR_ICMSTaxAmount + doc.BR_FCPOnICMSTaxAmount
+ doc.BR_OriginalICMSSTTaxAmount + doc.BR_FCPOnICMSSTTaxAmount + doc.BR_ICMSSTStatisticalTaxAmount
+ doc.BR_OriginalIPITaxAmount + doc.BR_IPIStatisticalTaxAmount
+ doc.BR_PISTaxAmount + doc.BR_COFINSTaxAmount
+ doc.ImportTaxAmount
end
end
end as BR_NFTotalOperationAmount, -- VL_OPR (only taxes)
/*
case left(doc.ICMSTaxSituation,2)
when '20'
then doc.BR_ICMSTaxExcludedBaseAmount
when '70'
then doc.BR_ICMSTaxExcludedBaseAmount
else 0
end as BR_NFReductionBaseAmount -- VL_RED_BC
*/
case
when doc.BR_MaterialOrigin = '2'
then doc.BR_ICMSTaxExcludedBaseAmount
when doc.BR_MaterialOrigin = '7'
then doc.BR_ICMSTaxExcludedBaseAmount
else 0
end as BR_NFReductionBaseAmount -- VL_RED_BC
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA