Billing
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - Billing
Descripción general
Esta vista proporciona un conjunto de datos completo para la elaboración de informes de sistemas SAP, que combina datos de las tablas VBRK y VBRP junto con cálculos y dimensiones adicionales. Ofrece información sobre documentos de facturación, información de clientes, detalles de productos y métricas financieras, lo que permite realizar análisis e informes detallados.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| vbrk | Tabla de Cabecera de Documento de Facturación |
| vbrp | Tabla de Partidas de Documento de Facturación |
| aggkonv | Vista personalizada para el cálculo de descuentos |
| currency_decimal | Tabla Decimal de Divisas |
| currency_conversion | Tabla de Conversión de Divisas |
| calendar_date_dim | Tabla de Dimensión de Fechas del Calendario |
Casos de uso clave
- Análisis de ventas por cliente, producto y región
- Informes financieros sobre documentos de facturación e ingresos
- Seguimiento del estado de facturación y pago
- Segmentación de clientes y campañas de marketing específicas
- Monitorización del rendimiento de los equipos de ventas y los productos
Lógica de consulta
La consulta combina datos de las tablas VBRK y VBRP mediante una unión interna en el campo VBELN. A continuación, realiza cálculos para el descuento, el valor neto y los importes de los impuestos, y se une a la vista AGGKONV para obtener información sobre los descuentos. La consulta también incluye lógica de conversión de divisas y se une a la tabla calendar_date_dim para añadir dimensiones temporales. Por último, calcula métricas adicionales, como el recuento de pedidos para diferentes periodos de tiempo.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| VF01 | Crear Documento de Facturación |
| VF02 | Modificar Documento de Facturación |
| VF03 | Visualizar Documento de Facturación |
| FBL1N | Visualizar Partidas Individuales: Cabecera de Documento |
| FBL3N | Visualizar Partidas Individuales: Cuenta de Mayor |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| Client_MANDT | Client | |
| BillingType_FKART | Billing Type | |
| BillingCategory_FKTYP | Billing Category | |
| SalesOrganization_VKORG | Sales Organization | |
| DistributionChannel_VTWEG | Distribution Channel | |
| Division_SPART | Division | |
| SDDocumentCategory_VBTYP | SD Document Category | |
| SalesDistrict_BZIRK | Sales District | |
| PriceListType_PLTYP | Price List Type | |
| BillingDocumentIsCancelled_FKSTO | Billing Document Is Cancelled | |
| Payer_KUNRG | Payer | |
| IncotermsPart1_INCO1 | Incoterms Part 1 | |
| IncotermsPart2_INCO2 | Incoterms Part 2 | |
| DestinationCountry_LAND1 | Destination Country | |
| Region_REGIO | Region | |
| CountryCode_COUNC | Country Code | |
| CityCode_CITYC | City Code | |
| TaxClassification1ForCustomer_TAXK1 | Tax Classification 1 For Customer | |
| TaxClassification2ForCustomer_TAXK2 | Tax Classification 2 For Customer | |
| TaxClassification3ForCustomer_TAXK3 | Tax Classification 3 For Customer | |
| TaxClassification4ForCustomer_TAXK4 | Tax Classification 4 For Customer | |
| TaxClassification5ForCustomer_TAXK5 | Tax Classification 5 For Customer | |
| TaxDepartureCountry_LANDTX | Tax Departure Country | |
| OriginOfSalesTaxIDNumber_STCEG_H | Origin Of Sales Tax ID Number | |
| CountryOfSalesTaxIDNumber_STCEG_L | Country Of Sales Tax ID Number | |
| ReferenceDocumentNumber_XBLNR | Reference Document Number | |
| CustomerPriceGroup_KONDA | Customer Price Group | |
| StatusForTransferToAccounting_RFBSK | Status For Transfer To Accounting | |
| BillingDate_FKDAT | Billing Date | |
| FiscalYear_GJAHR | Fiscal Year | |
| PostingPeriod_POPER | Posting Period | |
| RecordCreationDate_ERDAT | Record Creation Date | |
| LastChangeDate_AEDAT | Last Change Date | |
| CustomerGroup_KDGRP | Customer Group | |
| PaymentMethod_ZLSCH | Payment Method | |
| CompanyCode_BUKRS | Company Code | |
| DunningKey_MSCHL | Dunning Key | |
| DunningBlock_MANSP | Dunning Block | |
| SoldToParty_KUNAG | Sold To Party | |
| AccrualBillingType_FKART_AB | Accrual Billing Type | |
| AccountingDocumentNumber_BELNR | Accounting Document Number | |
| ShippingConditions_VSBED | Shipping Conditions | |
| SdDocumentCurrency_WAERK | Sd Document Currency | |
| BusinessArea_GSBER | Business Area | |
| BillingDocument_VBELN | Billing Document | |
| BillingItem_POSNR | Billing Item | |
| SalesDocumentItemCategory_PSTYV | Sales Document Item Category | |
| ItemType_POSAR | Item Type | |
| CostCenter_KOSTL | Cost Center | |
| SalesGroup_VKGRP | Sales Group | |
| SalesOffice_VKBUR | Sales Office | |
| ProfitCenter_PRCTR | Profit Center | |
| ControllingArea_KOKRS | Controlling Area | |
| DocumentCategoryOfPrecedingSDDocument_VGTYP | Document Category Of Preceding SD Document | |
| MaterialNumber_MATNR | Material Number | |
| PricingReferenceMaterial_PMATN | Pricing Reference Material | |
| BatchNumber_CHARG | Batch Number | |
| MaterialGroup_MATKL | Material Group | |
| ProductHierarchy_PRODH | Product Hierarchy | |
| Plant_WERKS | Plant | |
| MaterialPriceGroup_KONDM | Material Price Group | |
| StorageLocation_LGORT | Storage Location | |
| InternationalArticleNumber_EAN11 | International Article Number | |
| MaterialGroup1_MVGR1 | Material Group 1 | |
| MaterialGroup2_MVGR2 | Material Group 2 | |
| MaterialGroup3_MVGR3 | Material Group 3 | |
| MaterialGroup4_MVGR4 | Material Group 4 | |
| MaterialGroup5_MVGR5 | Material Group 5 | |
| BOMExplosionNumber_SERNR | BOM Explosion Number | |
| CustomerGroup1_KVGR1 | Customer Group 1 | |
| CustomerGroup2_KVGR2 | Customer Group 2 | |
| CustomerGroup3_KVGR3 | Customer Group 3 | |
| CustomerGroup4_KVGR4 | Customer Group 4 | |
| CustomerGroup5_KVGR5 | Customer Group 5 | |
| TaxJurisdiction_TXJCD | Tax Jurisdiction | |
| ShippingPointReceivingPoint_VSTEL | Shipping Point Receiving Point | |
| DocumentNumberOfTheReferenceDocument_VGBEL | Document Number Of The Reference Document | |
| ItemNumberOfTheReferenceItem_VGPOS | Item Number Of The Reference Item | |
| SalesDocument_AUBEL | Sales Document | |
| SalesDocumentItem_AUPOS | Sales Document Item | |
| ActualBilledQuantity_FKIMG | Actual Billed Quantity | |
| Volume_VOLUM | Volume | |
| GrossWeight_BRGEW | Gross Weight | |
| NetWeight_NTGEW | Net Weight | |
| NumberOfTheDocumentCondition_KNUMV | Number Of The Document Condition | |
| ConditionItemNumber_KPOSN | Condition Item Number | |
| YearOfBillingDate_FKDAT | Year Of Billing Date | |
| MonthOfBillingDate_FKDAT | Month Of Billing Date | |
| WeekOfBillingDate_FKDAT | Week Of Billing Date | |
| DayOfBillingDate_FKDAT | Day Of Billing Date | |
| NetValue_NETWR | Net Value | |
| TaxAmount_MWSBK | Tax Amount | |
| TaxAmountPos_MWSBP | Tax Amount Pos | |
| Rebate | Rebate | |
| YearOrderCount | Year Order Count | |
| MonthOrderCount | Month Order Count | |
| WeekOrderCount | Week Order Count |