CustomerClearedItems_BSAD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - CustomerClearedItems_BSAD
Descripción general
Esta vista es una vista de informes para sistemas SAP que proporciona información detallada sobre documentos contables y partidas individuales. Combina datos de las tablas BKPF y BSEG para proporcionar una vista completa de las transacciones contables.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| BKPF | Datos de cabecera para documentos contables |
| BSEG | Datos de partidas individuales para documentos contables |
Casos de uso clave
- Se puede utilizar para analizar datos contables para un periodo o rango de periodos específicos.
- Se puede utilizar para desglosar los detalles de documentos contables y partidas individuales.
- Se puede utilizar para generar informes sobre datos contables, como balances de situación y cuentas de resultados.
Lógica de consulta
La vista se crea utilizando una unión externa izquierda entre las tablas BKPF y BSEG. La unión se realiza en los siguientes campos: MANDT, BUKRS, GJAHR y BELNR. Esto garantiza que todos los documentos contables y las partidas individuales se incluyen en la vista, incluso si no hay datos de partidas individuales para un documento concreto.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| FB03 | Visualizar documento |
| FB05 | Visualizar partida individual |
| FBL3N | Lista de documentos |
| FBL5N | Lista de partidas individuales |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| Client_MANDT | Client ID | |
| PurchasingDocumentDate_BEDAT | Purchasing Document Date | |
| YearOfPurchasingDocumentDate_BEDAT | Year of Purchasing Document Date | |
| MonthOfPurchasingDocumentDate_BEDAT | Month of Purchasing Document Date | |
| WeekOfPurchasingDocumentDate_BEDAT | Week of Purchasing Document Date | |
| Company_BUKRS | Company Code | |
| Company | Company Name | |
| PurchasingOrganization_EKORG | Purchasing Organization | |
| PurchasingOrganization | Purchasing Organization Name | |
| PurchasingGroup_EKGRP | Purchasing Group | |
| PurchasingGroup | Purchasing Group Name | |
| VendorAccountNumber_LIFNR | Vendor Account Number | |
| VendorName | Vendor Name | |
| VendorCountry | Vendor Country | |
| FiscalyearVariant_PERIV | Fiscal Year Variant | |
| MaterialNumber_MATNR | Material Number | |
| Plant_WERKS | Plant | |
| MaterialType_MTART | Material Type | |
| POQuantity_MENGE | PO Quantity | |
| FiscalYear | Fiscal Year | |
| FiscalPeriod | Fiscal Period | |
| InvoiceDate | Invoice Date | |
| TotalSpend | Total Spend | |
| ClearedInvoices | Cleared Invoices | |
| YearOfInvoiceDate | Year of Invoice Date | |
| MonthOfInvoiceDate | Month of Invoice Date | |
| WeekOfInvoiceDate | Week of Invoice Date | |
| AverageNetPrice | Average Net Price | |
| TargetCurrency_TCURR | Target Currency | |
| AverageNetPriceInTargetCurrency | Average Net Price in Target Currency | |
| TotalSpendInTargetCurrency | Total Spend in Target Currency | |
| CountRejectedOrders | Count of Rejected Orders | |
| CountNotRejectedOrders | Count of Not Rejected Orders | |
| CountNotDelayedOrders | Count of Not Delayed Orders | |
| CountDelayedOrders | Count of Delayed Orders | |
| CountInFullOrders | Count of In Full Orders | |
| CountNotInFullOrders | Count of Not In Full Orders | |
| CountAccurateInvoices | Count of Accurate Invoices | |
| CountInaccurateInvoices | Count of Inaccurate Invoices | |
| CountPastDueOrders | Count of Past Due Orders | |
| CountOpenOrders | Count of Open Orders | |
| Material | Material Description | |
| MaterialType | Material Type Description | |
| LanguageKey_SPRAS | Language Key | |
| ValuationPrice | Valuation Price | |
| ValuationPriceInTargetCurrency | Valuation Price in Target Currency | |
| PurchasePriceVariance | Purchase Price Variance | |
| PurchasePriceVarianceInTargetCurrency | Purchase Price Variance in Target Currency |