SalesOrderPartnerFunction
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrderPartnerFunction
Overview
This reporting view provides information about partners involved in sales documents in SAP systems. It includes details such as customer, vendor, personnel number, contact person, address, unloading point, country, address indicator, one-time account indicator, customer hierarchy type, relevant price determination ID, indicator for customer receiving rebates, level number within hierarchy, customer description of partner, transportation zone, assignment to hierarchy, VAT registration number, indicator for further partners, person number, and maintain appointments in calendar.
Data Sources
| Source Table/View | Description |
|---|---|
| vbpa | Sales Document: Partner Functions |
Key Use Cases
- Analyzing partner involvement in sales documents
- Identifying customer and vendor information
- Understanding the hierarchy of partners in sales documents
- Retrieving address and contact details for partners
- Determining transportation and tax-related information
Query Logic
The view selects various fields from the vbpa table, which contains partner-related information for sales documents. It includes fields for client, sales document number, item number, partner function, customer number, vendor number, personnel number, contact person number, address number, unloading point, country, address indicator, one-time account indicator, customer hierarchy type, relevant price determination ID, indicator for customer receiving rebates, level number within hierarchy, customer description of partner, transportation zone, assignment to hierarchy, VAT registration number, indicator for further partners, person number, and maintain appointments in calendar.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VD03 | Display Customer Master Data |
| XK03 | Display Vendor Master Data |
| PA30 | Maintain Personal Data |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client number | |
| SalesDocument_VBELN | Sales document number | |
| Item_POSNR | Item number | |
| PartnerFunction_PARVW | Partner function | |
| Customer_KUNNR | Customer number | |
| Vendor_LIFNR | Vendor number | |
| PersonnelNumber_PERNR | Personnel number | |
| NumberOfContactPerson_PARNR | Number of contact person | |
| Address_ADRNR | Address number | |
| UnloadingPoint_ABLAD | Unloading point | |
| Country_LAND1 | Country | |
| AddressIndicator_ADRDA | Address indicator | |
| IndicatorOneTimeAccount_XCPDK | Indicator: One-time account | |
| CustomerHierarchyType_HITYP | Customer hierarchy type | |
| RelevantForPriceDeterminationID_PRFRE | Relevant for price determination ID | |
| IndicatorCustomerToReceiveRebates_BOKRE | Indicator: Customer to receive rebates | |
| LevelNumberWithinHierarchy_HISTUNR | Level number within hierarchy | |
| CustomerDescriptionOfPartner_KNREF | Customer description of partner | |
| TransportationZone_LZONE | Transportation zone | |
| AssignmentToHierarchy_HZUOR | Assignment to hierarchy | |
| VATRegistrationNumber_STCEG | VAT registration number | |
| IndicatorFurtherPartners_PARVW_FF | Indicator: Further partners | |
| PersonNumber_ADRNP | Person number | |
| MaintainAppointmentsInCalendar_KALE | Maintain appointments in calendar | |
| DataFilterValueForDataAging_DATAAGING | Data filter value for data aging | |
| DummyFunctionInLength1_DUMMY_SDDOCPARTNER_INCL_EEW_PS | Dummy function in length 1 |