Fields (649)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument,ClearingAccountingDocument | 13 |
| KEY | AccountingDocumentItem | AccountingDocumentItem | 5 |
| KEY | BankReconciliationDate | BankReconciliationDate | 1 |
| KEY | BankStatement | BankStatement | 1 |
| KEY | BankStatementInternalID | BankStatementInternalID | 4 |
| KEY | BankStatementItem | BankStatementItem | 2 |
| KEY | belnr | AccountingDocument,belnr | 7 |
| KEY | BhvrlInsgtsAccountNumber | BhvrlInsgtsAccountNumber | 5 |
| KEY | BhvrlInsgtsCADocNmbr | BhvrlInsgtsCADocNmbr | 1 |
| KEY | BhvrlInsgtsCalDate | BhvrlInsgtsCalDate | 4 |
| KEY | BhvrlInsgtsSubAccountNumber | BhvrlInsgtsSubAccountNumber | 5 |
| KEY | BOPForm | BOPForm | 1 |
| KEY | BOPRptgCntry | BOPRptgCntry | 1 |
| KEY | bukrs | bukrs,CompanyCode | 10 |
| KEY | bumon | bumon | 3 |
| KEY | bunit | ConsolidationUnit | 3 |
| KEY | BusinessPartner | BusinessPartner | 6 |
| KEY | CompanyCode | bukrs,CompanyCode | 34 |
| KEY | CreditSegment | CreditSegment | 1 |
| KEY | ctrvs | ctrvs | 1 |
| KEY | Currency | Currency | 6 |
| KEY | CustomerNum | PortugueseCustomerWithVersion | 1 |
| KEY | CustomerProject | CustomerProject | 1 |
| KEY | CustomerProjectUUID | CustomerProjectUUID | 1 |
| KEY | dimen | ConsolidationDimension | 3 |
| KEY | DisplayItem | DisplayItem | 1 |
| KEY | EmploymentInternalID | EmploymentInternalID | 1 |
| KEY | EndDate | EndDate | 6 |
| KEY | EngagementProjectServiceOrg | CustomerProjectServiceOrg,EngagementProjectServiceOrg | 3 |
| KEY | EngmntProjectCompanyCode | EngmntProjectCompanyCode | 2 |
| KEY | EntitledToDisposeParty | EntitledToDisposeParty | 3 |
| KEY | EWMStorageType | EWMStorageType | 1 |
| KEY | EWMWarehouse | EWMWarehouse | 3 |
| KEY | EWMWorkloadForecastIndex | EWMWorkloadForecastIndex | 1 |
| KEY | FiscalYear | ClearingFiscalYear,FiscalYear | 13 |
| KEY | FiscalYearVariant | FiscalYearVariant | 2 |
| KEY | GeneralLedgerAgingIncrement | GeneralLedgerAgingIncrement | 1 |
| KEY | GeneralLedgerAgingScope | GeneralLedgerAgingScope | 1 |
| KEY | gjahr | FiscalYear,gjahr | 13 |
| KEY | hbkid | hbkid | 1 |
| KEY | hktid | hktid | 1 |
| KEY | HouseBank | HouseBank | 5 |
| KEY | HouseBankAccount | HouseBankAccount | 3 |
| KEY | IBAN | IBAN | 5 |
| KEY | IssuingOrReceivingPlant | IssuingOrReceivingPlant | 1 |
| KEY | IssuingOrReceivingStorageLoc | IssuingOrReceivingStorageLoc | 1 |
| KEY | kunnr | Customer,kunnr | 2 |
| KEY | Ledger | Ledger | 9 |
| KEY | LedgerGLLineItem | LedgerGLLineItem | 2 |
| KEY | lgort | StorageLocation | 1 |
| KEY | lifnr | lifnr,SupplierAccount | 2 |
| KEY | locid | LocationId,locid | 5 |
| KEY | mandt | mandt | 10 |
| KEY | Material | Material | 1 |
| KEY | MaterialDocument | MaterialDocument | 1 |
| KEY | MaterialDocumentYear | MaterialDocumentYear | 1 |
| KEY | matnr | Material | 2 |
| KEY | MeterReadingDocument | MeterReadingDocument | 1 |
| KEY | mwskz | mwskz | 1 |
| KEY | N_Projectinternalid | N_Projectinternalid | 1 |
| KEY | NominationDoc | NominationDoc | 1 |
| KEY | NominationDocItem | NominationDocItem | 1 |
| KEY | nomtk | nomtk | 4 |
| KEY | Notification | Notification | 2 |
| KEY | PeriodType | PeriodType | 2 |
| KEY | Person | Person | 2 |
| KEY | PersonExternalID | EmployeeExtID,PersonExternalID | 2 |
| KEY | PersonnelNumber | PersonnelNumber | 1 |
| KEY | PL_GoodsMovementTypeCategory | PL_GoodsMovementTypeCategory | 1 |
| KEY | Plant | Plant | 2 |
| KEY | PortugueseCustomerWithVersion | PortugueseCustomerWithVersion | 2 |
| KEY | PPIMDDatasetID | PPIMDDatasetID | 3 |
| KEY | PPIMDPatternID | PPIMDPatternID | 3 |
| KEY | PPIMDProfileID | PPIMDProfileID | 3 |
| KEY | Product | Product | 3 |
| KEY | ProjectInternalID | ProjectInternalID | 1 |
| KEY | ps_posid | Name | 1 |
| KEY | PurchaseOrder | PurchaseOrder | 1 |
| KEY | PurchaseOrderItem | PurchaseOrderItem | 1 |
| KEY | rdiff | OilRoleDifferentiation | 1 |
| KEY | rtype | OilRoleType | 1 |
| KEY | SalesDocument | SalesDocument | 1 |
| KEY | SalesDocumentItem | SalesDocumentItem | 1 |
| KEY | ScheduleLine | ScheduleLine | 1 |
| KEY | shbkz | shbkz | 1 |
| KEY | SitnInstceKey | SitnInstceKey | 1 |
| KEY | SourceLedger | SourceLedger | 1 |
| KEY | StartDate | StartDate | 6 |
| KEY | StatryRptCategory | StatryRptCategory | 1 |
| KEY | StatryRptgEntity | StatryRptgEntity | 1 |
| KEY | StatryRptRunID | StatryRptRunID | 1 |
| KEY | StatryRptSchema | StatryRptSchema | 1 |
| KEY | StatryRptSchemaElementId | StatryRptSchemaElementId | 1 |
| KEY | StatryRptSchemaVersion | StatryRptSchemaVersion | 1 |
| KEY | stlal | stlal | 1 |
| KEY | stlnr | stlnr | 1 |
| KEY | stlty | stlty | 2 |
| KEY | StorageLocation | StorageLocation | 1 |
| KEY | Supplier | Supplier | 8 |
| KEY | swift | ReceiverId,SenderId | 2 |
| KEY | tabname | Name | 1 |
| KEY | TaxType | TaxType | 1 |
| KEY | taxvs | taxvs | 1 |
| KEY | ticket_key | NominationTicketKey | 1 |
| KEY | umskz | shbkz | 2 |
| KEY | UtilitiesBillingDocument | UtilitiesBillingDocument | 4 |
| KEY | werk | Plant | 2 |
| KEY | YearPeriod | YearPeriod | 5 |
| _AccountingDocumentCategory | _AccountingDocumentCategory | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _CompanyCode | _CompanyCode | 7 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _Customer | _Customer | 1 | |
| _FiscalYear | _FiscalYear | 3 | |
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | 1 | |
| _JournalEntry | _JournalEntry | 3 | |
| _Ledger | _Ledger | 3 | |
| _SourceLedger | _SourceLedger | 1 | |
| _SupplierCompany | _SupplierCompany | 1 | |
| AccountingDocCreatedByUser | AccountingDocCreatedByUser,CreatedByUser | 2 | |
| AccountingDocumentCategory | AccountingDocumentCategory | 4 | |
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | 4 | |
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | 1 | |
| AccountingDocumentType | AccountingDocumentType,JournalEntryType | 5 | |
| actdat | actdat | 1 | |
| acttime | acttime | 1 | |
| ActualCost | ActualCost | 1 | |
| actualqty | actualqty | 1 | |
| actualqty_par | actualqty_par | 2 | |
| actuals | actuals | 1 | |
| ActualScheduledQuantity | ActualScheduledQuantity | 1 | |
| ActualScheduledQuantityUnit | ActualScheduledQuantityUnit | 1 | |
| actualuom | actualuom | 1 | |
| aedat | aedat | 3 | |
| aedat_i | aedat_i | 1 | |
| aenam | aenam | 3 | |
| aenam_i | aenam_i | 1 | |
| aennr | change_from | 1 | |
| aezeit | aezeit | 3 | |
| aezeit_i | aezeit_i | 1 | |
| AlphanumericTaxCode | AlphanumericTaxCode | 1 | |
| altkt | altkt | 3 | |
| AmountDebitCreditCode | AmountDebitCreditCode | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 2 | |
| apo_shipment_id | apo_shipment_id | 1 | |
| apo_shipment_num | apo_shipment_num | 1 | |
| assignedqty | assignedqty | 1 | |
| atl_crdt_curr | atl_crdt_curr | 1 | |
| atl_crdt_qty | atl_crdt_qty | 1 | |
| atl_crdt_uom | atl_crdt_uom | 1 | |
| atl_crdt_val | atl_crdt_val | 1 | |
| atl_delv_itm | atl_delv_itm | 1 | |
| atl_delv_number | atl_delv_number | 1 | |
| augbl | augbl | 1 | |
| augdt | augdt | 1 | |
| auth | Authorization_Profile | 1 | |
| AuthorizationGroup | AuthorizationGroup | 4 | |
| awkey | awkey | 3 | |
| aworg | aworg | 6 | |
| awref | awref | 6 | |
| awsys | awsys | 6 | |
| awtyp | awtyp | 6 | |
| Bank | Bank | 5 | |
| BankAccountCurrency | BankAccountCurrency | 1 | |
| BankAccountInternalID | BankAccountInternalID | 6 | |
| BankAccountNumber | BankAccountNumber | 5 | |
| BankCountry | BankCountry | 5 | |
| BankStatementDate | BankStatementDate | 1 | |
| BankStatementShortID | BankStatementShortID | 1 | |
| Bar_Rr_Bhvrlinsgtsnmrctargetva | Bar_Rr_Bhvrlinsgtsnmrctargetva | 1 | |
| Bar_Rr_DelayInNoOfDays | Bar_Rr_DelayInNoOfDays | 1 | |
| Bar_Rr_DelivProcgDelayInDays | Bar_Rr_DelivProcgDelayInDays | 1 | |
| Bar_Rr_Meterreadingstatusisrel | Bar_Rr_Meterreadingstatusisrel | 1 | |
| Bar_Rr_Utilsbillgdociscorrectl | Bar_Rr_Utilsbillgdociscorrectl | 1 | |
| BhvrlInsgtsClusterID | BhvrlInsgtsClusterID | 1 | |
| BhvrlInsgtsNmrcTargetValue | BhvrlInsgtsNmrcTargetValue | 1 | |
| BhvrlInsgtsTgtVal | BhvrlInsgtsTgtVal | 3 | |
| bktxt | RecurringAcctgDocHeaderText | 2 | |
| blart | AccountingDocumentType,blart | 3 | |
| blocked_for_posting | RecrrgAcctgDocIsBlocked | 2 | |
| bloind | bloind | 3 | |
| bloind_i | bloind_i | 2 | |
| bom_versn | BillOfMaterialVersion | 1 | |
| bookts | bookts | 3 | |
| bstat | bstat | 2 | |
| budat | budat | 2 | |
| BusinessPartnerCountry | BusinessPartnerCountry | 1 | |
| BusinessPartnerCustomer | BusinessPartnerCustomer | 1 | |
| BusinessPartnerName | GivenName | 1 | |
| bustyp | bustyp | 3 | |
| butxt | butxt,CompanyCodeName | 4 | |
| carry_forward | carry_forward | 1 | |
| CashDiscount1DueDate | CashDiscount1DueDate | 2 | |
| CashDiscount2DueDate | CashDiscount2DueDate | 2 | |
| CashPlanningGroup | fdgrp | 1 | |
| char_field_ext | char_field_ext,CharFieldExt | 2 | |
| charg_d | charg_d | 1 | |
| charg_d_create | charg_d_create | 1 | |
| charg_l | charg_l | 1 | |
| charg_l_create | charg_l_create | 1 | |
| charg_o | charg_o | 1 | |
| charg_o_create | charg_o_create | 1 | |
| ChartOfAccounts | ChartOfAccounts | 4 | |
| CityName | CityName | 1 | |
| client | MANDT | 1 | |
| ClrgDelayInDaysIsOverThreshold | ClrgDelayInDaysIsOverThreshold | 1 | |
| co_carr | co_carr | 1 | |
| co_ship | co_ship | 1 | |
| co_tsyst | co_tsyst | 1 | |
| commctl | commctl | 1 | |
| comp_balance | comp_balance | 1 | |
| comp_year | comp_year | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 9 | |
| CompanyCodeName | CompanyCodeName | 1 | |
| Confidence | Confidence | 1 | |
| conpat | conpat | 1 | |
| cons | cons | 1 | |
| ContractPartner | ContractPartner | 1 | |
| controlarea | BankAccountCurrency | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCenter | CostCenter | 1 | |
| counter1 | counter1 | 1 | |
| counter2 | counter2 | 1 | |
| counter3 | counter3 | 1 | |
| counter4 | counter4 | 1 | |
| counter5 | counter5 | 1 | |
| counter6 | counter6 | 1 | |
| Country | Country | 1 | |
| cpudt | AccountingDocumentCreationDate | 2 | |
| cputm | CreationTime | 2 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationTime | CreationTime | 3 | |
| CreditAmountInCoCodeCrcy | CreditAmountInCoCodeCrcy | 1 | |
| cum_balance | cum_balance | 1 | |
| curr | ConsolidationUnitLocalCurrency | 1 | |
| curr_local_send | CnsldtnUnitSndrCrcyForLoclCrcy | 1 | |
| Customer | Customer | 12 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 2 | |
| CustomerSupplierAddress | CustomerSupplierAddress | 1 | |
| CustomerVATRegistration | CustomerVATRegistration | 1 | |
| CustProjWrkPckgActualRevenue | CustProjWrkPckgActualRevenue | 1 | |
| CustProjWrkPckgPlanCost | CustProjWrkPckgPlanCost | 1 | |
| CustProjWrkPckgPlanRevenue | CustProjWrkPckgPlanRevenue | 1 | |
| cycle | cycle | 1 | |
| cycle_item | cycle_item | 1 | |
| DataController1 | DataController1 | 1 | |
| DataController10 | DataController10 | 1 | |
| DataController2 | DataController2 | 1 | |
| DataController3 | DataController3 | 1 | |
| DataController4 | DataController4 | 1 | |
| DataController5 | DataController5 | 1 | |
| DataController6 | DataController6 | 1 | |
| DataController7 | DataController7 | 1 | |
| DataController8 | DataController8 | 1 | |
| DataController9 | DataController9 | 1 | |
| DataControllerSet | DataControllerSet | 1 | |
| date | ValueDate | 1 | |
| datuv | ValidFromDate | 1 | |
| dbakz | RecurrenceSchedule | 2 | |
| dbatr | NextOccurrenceDate | 2 | |
| dbzhl | NumberOfPostedJournalEntries | 2 | |
| ddlname | BusEvtLogCDSSourceDDLName | 1 | |
| ddtext | Description | 1 | |
| DebitAmountInCoCodeCrcy | DebitAmountInCoCodeCrcy | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| Decision_Rr_BhvrlInsgtsTgtVal | Decision_Rr_BhvrlInsgtsTgtVal | 3 | |
| Decision_Rr_Meterreadingstatus | Decision_Rr_Meterreadingstatus | 1 | |
| Decision_Rr_Utilsbillgdociscor | Decision_Rr_Utilsbillgdociscor | 1 | |
| DelayInNoOfDays | DelayInNoOfDays | 1 | |
| delind | delind | 3 | |
| delind_i | delind_i | 2 | |
| DelivOfGoodsDestCountry | DelivOfGoodsDestCountry | 1 | |
| diff_balance | diff_balance | 1 | |
| diff_balance_p | diff_balance_p | 1 | |
| dimid | dimid | 1 | |
| Distance | Distance | 1 | |
| doc_type | DOC_TYPE | 1 | |
| docind | docind | 1 | |
| docitm | docitm | 1 | |
| docnr | docnr | 1 | |
| docschedln | docschedln | 1 | |
| doctyp | doctyp | 1 | |
| DocumentDate | DocumentDate,TransactionDate | 6 | |
| DocumentItemText | DocumentItemText | 1 | |
| ebeln | ebeln | 1 | |
| Employee | Employee | 1 | |
| EmployeeFullName | EmployeeFullName | 1 | |
| end_by_type | RecurrenceEndType | 2 | |
| Endbalance | Finalbalance | 1 | |
| EngagementProjectCategory | EngagementProjectCategory | 1 | |
| EngagementProjectCostCenter | EngagementProjectCostCenter | 1 | |
| EngagementProjectReviewStatus | EngagementProjectReviewStatus | 1 | |
| EngagementProjectStage | EngagementProjectStage | 1 | |
| EngagementProjectType | EngagementProjectType | 1 | |
| EngmntProjectHeaderCompanyCode | EngmntProjectHeaderCompanyCode | 1 | |
| EngmntProjReviewYearPeriod | EngmntProjReviewYearPeriod | 1 | |
| erdat | erdat | 3 | |
| erdat_i | erdat_i | 1 | |
| ernam | ernam | 3 | |
| ernam_i | ernam_i | 1 | |
| erzeit | erzeit | 3 | |
| erzeit_i | erzeit_i | 1 | |
| ev_group | ev_group | 1 | |
| event_nr | EVENT_NR | 1 | |
| EWMWorkloadForecastValue | EWMWorkloadForecastValue | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| Feature1Value | Feature1Value | 1 | |
| Feature2Value | Feature2Value | 1 | |
| Feature3Value | Feature3Value | 1 | |
| Feature4Value | Feature4Value | 1 | |
| Feature5Value | Feature5Value | 1 | |
| ferryind | ferryind | 2 | |
| FinancialAccountType | FinancialAccountType | 2 | |
| FinancialStatementItem | FinancialStatementItem | 1 | |
| FINANCIALSTATEMENTVARIANT | FINANCIALSTATEMENTVARIANT | 1 | |
| first_occur_date | FirstOccurrenceDate | 2 | |
| FiscalPeriod | FiscalPeriod | 5 | |
| flag_imex | flag_imex | 1 | |
| ForeignCurrency | ForeignCurrency,OriginalCurrency | 1 | |
| frequency | RecurrenceFrequency | 2 | |
| fsh_seaim | fsh_seaim | 1 | |
| fsh_sealv | fsh_sealv | 2 | |
| ga_allocated_qty | ga_allocated_qty | 1 | |
| ga_allocated_uom | ga_allocated_uom | 1 | |
| ga_conf_qty | ga_conf_qty | 1 | |
| ga_conf_qty_cal | ga_conf_qty_cal | 1 | |
| ga_conf_uom | ga_conf_uom | 1 | |
| ga_nmshipper | ga_nmshipper | 1 | |
| ga_rank | ga_rank | 1 | |
| ga_techsch_qty | ga_techsch_qty | 1 | |
| ga_techsch_uom | ga_techsch_uom | 1 | |
| ga_tsch_qty_cal | ga_tsch_qty_cal | 1 | |
| Gb_Best_Proba_Clrgdelayindaysi | Gb_Best_Proba_Clrgdelayindaysi | 1 | |
| Gb_Best_Proba_Utilsbillgdocisc | Gb_Best_Proba_Utilsbillgdocisc | 3 | |
| Gb_Decision_Clrgdelayindaysiso | Gb_Decision_Clrgdelayindaysiso | 1 | |
| Gb_Decision_Utilsbillgdociscor | Gb_Decision_Utilsbillgdociscor | 3 | |
| Gb_Quantile_Utilsbillgdociscor | Gb_Quantile_Utilsbillgdociscor | 3 | |
| Gb_Score_Clrgdelayindaysisover | Gb_Score_Clrgdelayindaysisover | 1 | |
| Gb_Score_Utilsbillgdociscorrec | Gb_Score_Utilsbillgdociscorrec | 3 | |
| GLAccount | GLAccount,hkont | 5 | |
| glaccount_type | glaccount_type | 2 | |
| grupp | grupp | 1 | |
| gsber | BusinessArea | 1 | |
| housebk | HouseBank | 1 | |
| hwaer | CompanyCodeCurrency | 2 | |
| idate | idate | 1 | |
| ilock | ilock | 1 | |
| imatn | imatn | 1 | |
| impoexpo | impoexpo | 1 | |
| incomplete_flag | incomplete_flag | 1 | |
| incrmt_index | incrmt_index | 1 | |
| inspe | inspe | 1 | |
| int_field_ext | int_field_ext,IntFieldExt | 2 | |
| int1_field_ext | int1_field_ext,Int1FieldExt | 2 | |
| IntraBkStmntImportRuleTimeZone | IntraBkStmntImportRuleTimeZone | 5 | |
| is_constraint | is_constraint | 1 | |
| is_parameter | is_parameter | 1 | |
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | 3 | |
| IsMyProject | IsMyProject | 1 | |
| IsOneTimeAccount | IsOneTimeAccount | 4 | |
| IsReferenceDocument | IsReferenceDocument | 1 | |
| IsReversed | IsReversed | 3 | |
| istat | istat | 1 | |
| isubstat | isubstat | 1 | |
| itbotol | itbotol | 1 | |
| itbotolabs | itbotolabs | 1 | |
| itbutol | itbutol | 1 | |
| itbutolabs | itbutolabs | 1 | |
| items | items | 1 | |
| ittolunit | ittolunit | 1 | |
| Job | Job | 1 | |
| JournalEntryType | JournalEntryType | 1 | |
| ktopl | ktopl | 2 | |
| kurst | ExchangeRateType | 2 | |
| last_occur_date | LastOccurrenceDate | 2 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastName | FamilyName | 1 | |
| ldgrp | LedgerGroup | 1 | |
| ldquom | ldquom | 1 | |
| ldrate | ldrate | 1 | |
| ldtuom | ldtuom | 1 | |
| lesshnum | lesshnum | 1 | |
| lestpnum | lestpnum | 1 | |
| LocationId | LocationId | 1 | |
| locpt | locpt | 2 | |
| locsl | locsl | 2 | |
| lognumber | LogNumberWithZero | 2 | |
| lov_gl | lov_gl | 1 | |
| lov_ind | lov_ind | 2 | |
| MatchingIsUnassigned | MatchingIsUnassigned | 1 | |
| matkl | MaterialGroup | 1 | |
| matnr_i | matnr_i | 1 | |
| menge | menge | 1 | |
| MeterReadingStatusIsReleased | MeterReadingStatusIsReleased | 1 | |
| ModeOfTransport | ModeOfTransport | 1 | |
| MonitorEndDateTime | MonitorEndDateTime | 5 | |
| MonitorStartDateTime | MonitorStartDateTime | 5 | |
| month_name | month_name | 1 | |
| N_Distance | N_Distance | 1 | |
| nmbalch | nmbalch | 1 | |
| nmblock | nmblock | 1 | |
| nmcarrier | nmcarrier | 1 | |
| nmlgort | nmlgort | 1 | |
| nmshipper | nmshipper | 1 | |
| nmshtype | nmshtype | 1 | |
| nmtplst | nmtplst | 1 | |
| nmvehicle | nmvehicle | 1 | |
| nmvessel | nmvessel | 1 | |
| nmwerk | nmwerk | 1 | |
| nomcl | nomcl | 1 | |
| NominationCalendarMonth | NominationCalendarMonth | 1 | |
| NominationCalendarWeek | NominationCalendarWeek | 1 | |
| NominationCalendarYear | NominationCalendarYear | 1 | |
| NominationCarrier | NominationCarrier | 1 | |
| NominationCurrentQuantity | NominationCurrentQuantity | 1 | |
| NominationDocIsBlocked | NominationDocIsBlocked | 2 | |
| NominationExtNumber | NominationExtNumber | 2 | |
| NominationPipelineCycleID | NominationPipelineCycleID | 1 | |
| NominationPlannedQuantity | NominationPlannedQuantity | 1 | |
| NominationPlannedUnit | NominationPlannedUnit | 1 | |
| NominationScheduleDate | NominationScheduleDate | 1 | |
| NominationScheduleType | NominationScheduleType | 1 | |
| NominationShipper | NominationShipper | 1 | |
| NominationVersion | NominationVersion | 1 | |
| nomit | nomit | 2 | |
| nomnr | nomnr | 2 | |
| nomst | nomst | 1 | |
| nomtyp | nomtyp | 1 | |
| nomtypdesc | nomtypdesc | 1 | |
| num_field_ext | num_field_ext,NumFieldExt | 2 | |
| number_of_occur | NumberOfOccurrences | 2 | |
| NumberOfIntradayBkStatement | NumberOfIntradayBkStatement | 5 | |
| objct | Object | 1 | |
| occur_day_type | OccurrenceType | 2 | |
| openb | BankAcctBalanceAmt | 1 | |
| OriginalReferenceDocument | OriginalReferenceDocument | 1 | |
| owner | owner | 1 | |
| partnr | partnr | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| period_text | period_text | 1 | |
| PersonFullName | PersonFullName | 2 | |
| Pi1_Lower | Pi1_Lower | 1 | |
| Pi1_Upper | Pi1_Upper | 1 | |
| Pi2_Lower | Pi2_Lower | 1 | |
| Pi2_Upper | Pi2_Upper | 1 | |
| picnum | picnum | 1 | |
| planind | planind | 2 | |
| PlanningLevel | fdlev | 1 | |
| PostalCode | PostalCode | 1 | |
| PostingDate | DocumentDate,PostingDate | 9 | |
| PPIMDConfidenceValue | PPIMDConfidenceValue | 3 | |
| PPIMDIsMessage | PPIMDIsMessage | 3 | |
| PPIMDLiftValue | PPIMDLiftValue | 3 | |
| PPIMDPatternCondition | PPIMDPatternCondition | 3 | |
| PPIMDPatternConsequent | PPIMDPatternConsequent | 3 | |
| PPIMDPatternStatus | PPIMDPatternStatus | 3 | |
| PPIMDSupportValue | PPIMDSupportValue | 3 | |
| prctr | prctr | 1 | |
| prdha | ProductHierarchy | 1 | |
| pre_exist_ind | pre_exist_ind | 1 | |
| Predict_Confidence | Predict_Confidence | 5 | |
| Predict_Damagecode | Predict_Damagecode | 1 | |
| Predict_Objpart | Predict_Objpart | 1 | |
| Predict_Paci | Predict_Paci | 1 | |
| Predict_Sectind | Predict_Sectind | 1 | |
| Predict_Srci | Predict_Srci | 1 | |
| Proba_Decision_Rr_Bhvrlinsgtst | Proba_Decision_Rr_Bhvrlinsgtst | 3 | |
| Proba_Decision_Rr_Meterreading | Proba_Decision_Rr_Meterreading | 1 | |
| Proba_Decision_Rr_Utilsbillgdo | Proba_Decision_Rr_Utilsbillgdo | 1 | |
| Proba_Rr_BhvrlInsgtsTgtVal | Proba_Rr_BhvrlInsgtsTgtVal | 3 | |
| Proba_Rr_Meterreadingstatusisr | Proba_Rr_Meterreadingstatusisr | 1 | |
| Proba_Rr_Utilsbillgdociscorrec | Proba_Rr_Utilsbillgdociscorrec | 1 | |
| ProductHierarchy | ProductHierarchy | 6 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectAccountantExternalID | ProjectAccountantExternalID | 1 | |
| ProjectControllerExternalID | ProjectControllerExternalID | 1 | |
| ProjectManagerExternalID | ProjectManagerExternalID | 1 | |
| ProjectPartnerExternalID | ProjectPartnerExternalID | 1 | |
| ProjectProfileCode | ProjectProfileCode | 1 | |
| ProjectVisibility | ProjectVisibility | 1 | |
| prorate_routine | prorate_routine | 1 | |
| prorateqty | prorateqty | 1 | |
| qtyfcr | qtyfcr | 1 | |
| qtyfcr_uom | qtyfcr_uom | 1 | |
| qtyin | qtyin | 1 | |
| qtyout | qtyout | 1 | |
| Quantile_Rr_Bhvrlinsgtsnmrctar | Quantile_Rr_Bhvrlinsgtsnmrctar | 1 | |
| quickconf | quickconf | 2 | |
| railcarqty | railcarqty | 2 | |
| rbcur | rbcur | 1 | |
| rbukrs | rbukrs | 7 | |
| rccur | rccur | 1 | |
| rclnt | rclnt | 5 | |
| Rcn_Top_1_Bhvrlinsgtsnmrctarge | Rcn_Top_1_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_1_BhvrlInsgtsTgtVal | Rcn_Top_1_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_1_Clrgdelayindaysisove | Rcn_Top_1_Clrgdelayindaysisove | 1 | |
| Rcn_Top_10_Bhvrlinsgtsnmrctarg | Rcn_Top_10_Bhvrlinsgtsnmrctarg | 1 | |
| Rcn_Top_10_BhvrlInsgtsTgtVal | Rcn_Top_10_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_2_Bhvrlinsgtsnmrctarge | Rcn_Top_2_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_2_BhvrlInsgtsTgtVal | Rcn_Top_2_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_2_Clrgdelayindaysisove | Rcn_Top_2_Clrgdelayindaysisove | 1 | |
| Rcn_Top_3_Bhvrlinsgtsnmrctarge | Rcn_Top_3_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_3_BhvrlInsgtsTgtVal | Rcn_Top_3_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_3_Clrgdelayindaysisove | Rcn_Top_3_Clrgdelayindaysisove | 1 | |
| Rcn_Top_4_Bhvrlinsgtsnmrctarge | Rcn_Top_4_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_4_BhvrlInsgtsTgtVal | Rcn_Top_4_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_4_Clrgdelayindaysisove | Rcn_Top_4_Clrgdelayindaysisove | 1 | |
| Rcn_Top_5_Bhvrlinsgtsnmrctarge | Rcn_Top_5_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_5_BhvrlInsgtsTgtVal | Rcn_Top_5_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_5_Clrgdelayindaysisove | Rcn_Top_5_Clrgdelayindaysisove | 1 | |
| Rcn_Top_6_Bhvrlinsgtsnmrctarge | Rcn_Top_6_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_6_BhvrlInsgtsTgtVal | Rcn_Top_6_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_7_Bhvrlinsgtsnmrctarge | Rcn_Top_7_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_7_BhvrlInsgtsTgtVal | Rcn_Top_7_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_8_Bhvrlinsgtsnmrctarge | Rcn_Top_8_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_8_BhvrlInsgtsTgtVal | Rcn_Top_8_BhvrlInsgtsTgtVal | 3 | |
| Rcn_Top_9_Bhvrlinsgtsnmrctarge | Rcn_Top_9_Bhvrlinsgtsnmrctarge | 1 | |
| Rcn_Top_9_BhvrlInsgtsTgtVal | Rcn_Top_9_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_1_Bhvrlinsgtsnmrctarge | Rcq_Top_1_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_1_BhvrlInsgtsTgtVal | Rcq_Top_1_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_1_Clrgdelayindaysisove | Rcq_Top_1_Clrgdelayindaysisove | 1 | |
| Rcq_Top_10_Bhvrlinsgtsnmrctarg | Rcq_Top_10_Bhvrlinsgtsnmrctarg | 1 | |
| Rcq_Top_10_BhvrlInsgtsTgtVal | Rcq_Top_10_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_2_Bhvrlinsgtsnmrctarge | Rcq_Top_2_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_2_BhvrlInsgtsTgtVal | Rcq_Top_2_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_2_Clrgdelayindaysisove | Rcq_Top_2_Clrgdelayindaysisove | 1 | |
| Rcq_Top_3_Bhvrlinsgtsnmrctarge | Rcq_Top_3_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_3_BhvrlInsgtsTgtVal | Rcq_Top_3_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_3_Clrgdelayindaysisove | Rcq_Top_3_Clrgdelayindaysisove | 1 | |
| Rcq_Top_4_Bhvrlinsgtsnmrctarge | Rcq_Top_4_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_4_BhvrlInsgtsTgtVal | Rcq_Top_4_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_4_Clrgdelayindaysisove | Rcq_Top_4_Clrgdelayindaysisove | 1 | |
| Rcq_Top_5_Bhvrlinsgtsnmrctarge | Rcq_Top_5_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_5_BhvrlInsgtsTgtVal | Rcq_Top_5_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_5_Clrgdelayindaysisove | Rcq_Top_5_Clrgdelayindaysisove | 1 | |
| Rcq_Top_6_Bhvrlinsgtsnmrctarge | Rcq_Top_6_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_6_BhvrlInsgtsTgtVal | Rcq_Top_6_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_7_Bhvrlinsgtsnmrctarge | Rcq_Top_7_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_7_BhvrlInsgtsTgtVal | Rcq_Top_7_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_8_Bhvrlinsgtsnmrctarge | Rcq_Top_8_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_8_BhvrlInsgtsTgtVal | Rcq_Top_8_BhvrlInsgtsTgtVal | 3 | |
| Rcq_Top_9_Bhvrlinsgtsnmrctarge | Rcq_Top_9_Bhvrlinsgtsnmrctarge | 1 | |
| Rcq_Top_9_BhvrlInsgtsTgtVal | Rcq_Top_9_BhvrlInsgtsTgtVal | 3 | |
| rdcur | rdcur | 1 | |
| rdim_attr | attribute | 2 | |
| Reason_Code_Feature_1 | Reason_Code_Feature_1 | 3 | |
| Reason_Code_Feature_2 | Reason_Code_Feature_2 | 3 | |
| Reason_Code_Feature_3 | Reason_Code_Feature_3 | 3 | |
| Reason_Code_Percentage_1 | Reason_Code_Percentage_1 | 3 | |
| Reason_Code_Percentage_2 | Reason_Code_Percentage_2 | 3 | |
| Reason_Code_Percentage_3 | Reason_Code_Percentage_3 | 3 | |
| ReconciliationAccount | ReconciliationAccount | 1 | |
| recur | recur | 1 | |
| recur_schedule_used | RecurrenceScheduleIsUsed | 2 | |
| recurrence_type | RecurrenceType | 2 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| refitem | refitem | 1 | |
| ReversalReason | ReversalReason | 3 | |
| ReverseDocument | ReverseDocument | 3 | |
| ReverseDocumentFiscalYear | ReverseDocumentFiscalYear | 3 | |
| rfccur | FunctionalCurrency,rfccur | 2 | |
| rfcur | rfcur | 1 | |
| rgcur | rgcur | 1 | |
| rhcur | rhcur | 1 | |
| rkcur | rkcur | 1 | |
| rldnr | Ledger,rldnr | 8 | |
| rldnr_auth | rldnr_auth | 1 | |
| rocur | rocur | 1 | |
| route | route | 1 | |
| rpart | OilPartnerRoleType | 1 | |
| Rr_BhvrlInsgtsNmrcTargetValue | Rr_BhvrlInsgtsNmrcTargetValue | 1 | |
| Rr_DelayInNoOfDays | Rr_DelayInNoOfDays | 1 | |
| Rr_DelivProcgDelayInDays | Rr_DelivProcgDelayInDays | 1 | |
| Rr_Meterreadingstatusisrelease | Rr_Meterreadingstatusisrelease | 1 | |
| Rr_Utilsbillgdociscorrectlyrel | Rr_Utilsbillgdociscorrectlyrel | 1 | |
| rtcur | rtcur | 1 | |
| rvcur | rvcur | 1 | |
| rvp | rvp | 1 | |
| rwcur | rwcur | 1 | |
| s_matnr_i | s_matnr_i | 1 | |
| sched_tst_from | sched_tst_from | 1 | |
| sched_tst_to | sched_tst_to | 1 | |
| ScheduledBatchEndDateTime | ScheduledBatchEndDateTime | 1 | |
| ScheduledBatchStartDateTime | ScheduledBatchStartDateTime | 1 | |
| ScheduledMaterial | ScheduledMaterial | 1 | |
| ScheduledQuantityUnit | ScheduledQuantityUnit | 1 | |
| segment | segment | 2 | |
| sentdat | sentdat | 1 | |
| sentnam | sentnam | 1 | |
| senttime | senttime | 1 | |
| shitem | shitem | 1 | |
| shnum | shnum | 1 | |
| shnum_i | shnum_i | 1 | |
| shtyp | shtyp | 3 | |
| sityp | sityp | 1 | |
| sl_process | sl_process | 1 | |
| Slight_Silhouette | Slight_Silhouette | 1 | |
| soldto | soldto | 1 | |
| SpecialGLCode | SpecialGLCode | 1 | |
| stages_id | stages_id | 1 | |
| StartingBalanceAmtInTransCrcy | StartingBalanceAmtInTransCrcy | 1 | |
| StatryRptSchemaParentElementId | StatryRptSchemaParentElementId | 1 | |
| StatryRptSchemaRefElementId | StatryRptSchemaRefElementId | 1 | |
| Status | Status | 4 | |
| stlkn | stlkn | 2 | |
| StreetName | StreetName | 1 | |
| stvkn | stvkn | 1 | |
| sum_of_bseg_dmbtr | AmountInCompanyCodeCurrency | 1 | |
| sum_of_bseg_wrbtr | AmountInTransactionCurrency | 1 | |
| SupplierToPartner | SupplierToPartner | 1 | |
| tank | tank | 1 | |
| TargetNmbrOfIntradayStatement | TargetNmbrOfIntradayStatement | 5 | |
| TaxCalculationProcedure | TaxCalculationProcedure | 1 | |
| TaxReportingDate | TaxReportingDate | 1 | |
| TaxReturnCountry | TaxReturnCountry | 1 | |
| taxrt | TaxRate | 1 | |
| tcitm | tcitm | 1 | |
| tcnum | tcnum | 1 | |
| third_nomnr | third_nomnr | 1 | |
| tknum | tknum | 1 | |
| tktselect | NominationTicketIsBlocked | 1 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| TransportSystem | TransportSystem | 2 | |
| tst_from_min | tst_from_min | 1 | |
| tst_to_max | tst_to_max | 1 | |
| tsyst | tsyst | 3 | |
| type | TYPE | 1 | |
| unit | unit | 1 | |
| unit_i | unit_i | 1 | |
| unit_i_t | unit_i_t | 1 | |
| unlimited | unlimited | 3 | |
| updatexdok | updatexdok | 1 | |
| updflag | UPDFLAG | 1 | |
| upmat | upmat | 1 | |
| usnam | AccountingDocCreatedByUser | 2 | |
| UtilsBillgDocIsCorrectlyReld | UtilsBillgDocIsCorrectlyReld | 4 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| valuationtype_d | valuationtype_d | 1 | |
| valuationtype_o | valuationtype_o | 1 | |
| VATRegistration | VATRegistration | 1 | |
| VehicleId | VehicleId | 1 | |
| vktra | vktra | 3 | |
| waers | TransactionCurrency,waers | 3 | |
| worklist | worklist | 1 | |
| worklist_i | worklist_i | 1 | |
| WorkPackageUnitUoM | WorkPackageUnitUoM | 1 | |
| wwert | ExchangeRateDate | 2 | |
| xblnr | DocumentReferenceID | 2 | |
| xgrdt | xgrdt | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A (
ACCOUNTINGDOCUMENT,
ACCOUNTINGDOCUMENTITEM,
BANKRECONCILIATIONDATE,
BANKSTATEMENT,
BANKSTATEMENTINTERNALID,
BANKSTATEMENTITEM,
BELNR,
BHVRLINSGTSACCOUNTNUMBER,
BHVRLINSGTSCADOCNMBR,
BHVRLINSGTSCALDATE,
BHVRLINSGTSSUBACCOUNTNUMBER,
BOPFORM,
BOPRPTGCNTRY,
BUKRS,
BUMON,
BUNIT,
BUSINESSPARTNER,
COMPANYCODE,
CREDITSEGMENT,
CTRVS,
CURRENCY,
CUSTOMERNUM,
CUSTOMERPROJECT,
CUSTOMERPROJECTUUID,
DIMEN,
DISPLAYITEM,
EMPLOYMENTINTERNALID,
ENDDATE,
ENGAGEMENTPROJECTSERVICEORG,
ENGMNTPROJECTCOMPANYCODE,
ENTITLEDTODISPOSEPARTY,
EWMSTORAGETYPE,
EWMWAREHOUSE,
EWMWORKLOADFORECASTINDEX,
FISCALYEAR,
FISCALYEARVARIANT,
GENERALLEDGERAGINGINCREMENT,
GENERALLEDGERAGINGSCOPE,
GJAHR,
HBKID,
HKTID,
HOUSEBANK,
HOUSEBANKACCOUNT,
IBAN,
ISSUINGORRECEIVINGPLANT,
ISSUINGORRECEIVINGSTORAGELOC,
KUNNR,
LEDGER,
LEDGERGLLINEITEM,
LGORT,
LIFNR,
LOCID,
MANDT,
MATERIAL,
MATERIALDOCUMENT,
MATERIALDOCUMENTYEAR,
MATNR,
METERREADINGDOCUMENT,
MWSKZ,
N_PROJECTINTERNALID,
NOMINATIONDOC,
NOMINATIONDOCITEM,
NOMTK,
NOTIFICATION,
PERIODTYPE,
PERSON,
PERSONEXTERNALID,
PERSONNELNUMBER,
PL_GOODSMOVEMENTTYPECATEGORY,
PLANT,
PORTUGUESECUSTOMERWITHVERSION,
PPIMDDATASETID,
PPIMDPATTERNID,
PPIMDPROFILEID,
PRODUCT,
PROJECTINTERNALID,
PS_POSID,
PURCHASEORDER,
PURCHASEORDERITEM,
RDIFF,
RTYPE,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SCHEDULELINE,
SHBKZ,
SITNINSTCEKEY,
SOURCELEDGER,
STARTDATE,
STATRYRPTCATEGORY,
STATRYRPTGENTITY,
STATRYRPTRUNID,
STATRYRPTSCHEMA,
STATRYRPTSCHEMAELEMENTID,
STATRYRPTSCHEMAVERSION,
STLAL,
STLNR,
STLTY,
STORAGELOCATION,
SUPPLIER,
SWIFT,
TABNAME,
TAXTYPE,
TAXVS,
TICKET_KEY,
UMSKZ,
UTILITIESBILLINGDOCUMENT,
WERK,
YEARPERIOD,
_ACCOUNTINGDOCUMENTCATEGORY,
_CHARTOFACCOUNTS,
_COMPANYCODE,
_COMPANYCODECURRENCY,
_CUSTOMER,
_FISCALYEAR,
_GLACCOUNTINCHARTOFACCOUNTS,
_JOURNALENTRY,
_LEDGER,
_SOURCELEDGER,
_SUPPLIERCOMPANY,
ACCOUNTINGDOCCREATEDBYUSER,
ACCOUNTINGDOCUMENTCATEGORY,
ACCOUNTINGDOCUMENTCREATIONDATE,
ACCOUNTINGDOCUMENTHEADERTEXT,
ACCOUNTINGDOCUMENTTYPE,
ACTDAT,
ACTTIME,
ACTUALCOST,
ACTUALQTY,
ACTUALQTY_PAR,
ACTUALS,
ACTUALSCHEDULEDQUANTITY,
ACTUALSCHEDULEDQUANTITYUNIT,
ACTUALUOM,
AEDAT,
AEDAT_I,
AENAM,
AENAM_I,
AENNR,
AEZEIT,
AEZEIT_I,
ALPHANUMERICTAXCODE,
ALTKT,
AMOUNTDEBITCREDITCODE,
AMOUNTINTRANSACTIONCURRENCY,
APO_SHIPMENT_ID,
APO_SHIPMENT_NUM,
ASSIGNEDQTY,
ATL_CRDT_CURR,
ATL_CRDT_QTY,
ATL_CRDT_UOM,
ATL_CRDT_VAL,
ATL_DELV_ITM,
ATL_DELV_NUMBER,
AUGBL,
AUGDT,
AUTH,
AUTHORIZATIONGROUP,
AWKEY,
AWORG,
AWREF,
AWSYS,
AWTYP,
BANK,
BANKACCOUNTCURRENCY,
BANKACCOUNTINTERNALID,
BANKACCOUNTNUMBER,
BANKCOUNTRY,
BANKSTATEMENTDATE,
BANKSTATEMENTSHORTID,
BAR_RR_BHVRLINSGTSNMRCTARGETVA,
BAR_RR_DELAYINNOOFDAYS,
BAR_RR_DELIVPROCGDELAYINDAYS,
BAR_RR_METERREADINGSTATUSISREL,
BAR_RR_UTILSBILLGDOCISCORRECTL,
BHVRLINSGTSCLUSTERID,
BHVRLINSGTSNMRCTARGETVALUE,
BHVRLINSGTSTGTVAL,
BKTXT,
BLART,
BLOCKED_FOR_POSTING,
BLOIND,
BLOIND_I,
BOM_VERSN,
BOOKTS,
BSTAT,
BUDAT,
BUSINESSPARTNERCOUNTRY,
BUSINESSPARTNERCUSTOMER,
BUSINESSPARTNERNAME,
BUSTYP,
BUTXT,
CARRY_FORWARD,
CASHDISCOUNT1DUEDATE,
CASHDISCOUNT2DUEDATE,
CASHPLANNINGGROUP,
CHAR_FIELD_EXT,
CHARG_D,
CHARG_D_CREATE,
CHARG_L,
CHARG_L_CREATE,
CHARG_O,
CHARG_O_CREATE,
CHARTOFACCOUNTS,
CITYNAME,
CLIENT,
CLRGDELAYINDAYSISOVERTHRESHOLD,
CO_CARR,
CO_SHIP,
CO_TSYST,
COMMCTL,
COMP_BALANCE,
COMP_YEAR,
COMPANYCODECURRENCY,
COMPANYCODENAME,
CONFIDENCE,
CONPAT,
CONS,
CONTRACTPARTNER,
CONTROLAREA,
CONTROLLINGAREA,
COSTCENTER,
COUNTER1,
COUNTER2,
COUNTER3,
COUNTER4,
COUNTER5,
COUNTER6,
COUNTRY,
CPUDT,
CPUTM,
CREATEDBYUSER,
CREATIONTIME,
CREDITAMOUNTINCOCODECRCY,
CUM_BALANCE,
CURR,
CURR_LOCAL_SEND,
CUSTOMER,
CUSTOMERPAYMENTTERMS,
CUSTOMERSUPPLIERADDRESS,
CUSTOMERVATREGISTRATION,
CUSTPROJWRKPCKGACTUALREVENUE,
CUSTPROJWRKPCKGPLANCOST,
CUSTPROJWRKPCKGPLANREVENUE,
CYCLE,
CYCLE_ITEM,
DATACONTROLLER1,
DATACONTROLLER10,
DATACONTROLLER2,
DATACONTROLLER3,
DATACONTROLLER4,
DATACONTROLLER5,
DATACONTROLLER6,
DATACONTROLLER7,
DATACONTROLLER8,
DATACONTROLLER9,
DATACONTROLLERSET,
DATE,
DATUV,
DBAKZ,
DBATR,
DBZHL,
DDLNAME,
DDTEXT,
DEBITAMOUNTINCOCODECRCY,
DEBITCREDITCODE,
DECISION_RR_BHVRLINSGTSTGTVAL,
DECISION_RR_METERREADINGSTATUS,
DECISION_RR_UTILSBILLGDOCISCOR,
DELAYINNOOFDAYS,
DELIND,
DELIND_I,
DELIVOFGOODSDESTCOUNTRY,
DIFF_BALANCE,
DIFF_BALANCE_P,
DIMID,
DISTANCE,
DOC_TYPE,
DOCIND,
DOCITM,
DOCNR,
DOCSCHEDLN,
DOCTYP,
DOCUMENTDATE,
DOCUMENTITEMTEXT,
EBELN,
EMPLOYEE,
EMPLOYEEFULLNAME,
END_BY_TYPE,
ENDBALANCE,
ENGAGEMENTPROJECTCATEGORY,
ENGAGEMENTPROJECTCOSTCENTER,
ENGAGEMENTPROJECTREVIEWSTATUS,
ENGAGEMENTPROJECTSTAGE,
ENGAGEMENTPROJECTTYPE,
ENGMNTPROJECTHEADERCOMPANYCODE,
ENGMNTPROJREVIEWYEARPERIOD,
ERDAT,
ERDAT_I,
ERNAM,
ERNAM_I,
ERZEIT,
ERZEIT_I,
EV_GROUP,
EVENT_NR,
EWMWORKLOADFORECASTVALUE,
EXCHANGERATE,
FEATURE1VALUE,
FEATURE2VALUE,
FEATURE3VALUE,
FEATURE4VALUE,
FEATURE5VALUE,
FERRYIND,
FINANCIALACCOUNTTYPE,
FINANCIALSTATEMENTITEM,
FINANCIALSTATEMENTVARIANT,
FIRST_OCCUR_DATE,
FISCALPERIOD,
FLAG_IMEX,
FOREIGNCURRENCY,
FREQUENCY,
FSH_SEAIM,
FSH_SEALV,
GA_ALLOCATED_QTY,
GA_ALLOCATED_UOM,
GA_CONF_QTY,
GA_CONF_QTY_CAL,
GA_CONF_UOM,
GA_NMSHIPPER,
GA_RANK,
GA_TECHSCH_QTY,
GA_TECHSCH_UOM,
GA_TSCH_QTY_CAL,
GB_BEST_PROBA_CLRGDELAYINDAYSI,
GB_BEST_PROBA_UTILSBILLGDOCISC,
GB_DECISION_CLRGDELAYINDAYSISO,
GB_DECISION_UTILSBILLGDOCISCOR,
GB_QUANTILE_UTILSBILLGDOCISCOR,
GB_SCORE_CLRGDELAYINDAYSISOVER,
GB_SCORE_UTILSBILLGDOCISCORREC,
GLACCOUNT,
GLACCOUNT_TYPE,
GRUPP,
GSBER,
HOUSEBK,
HWAER,
IDATE,
ILOCK,
IMATN,
IMPOEXPO,
INCOMPLETE_FLAG,
INCRMT_INDEX,
INSPE,
INT_FIELD_EXT,
INT1_FIELD_EXT,
INTRABKSTMNTIMPORTRULETIMEZONE,
IS_CONSTRAINT,
IS_PARAMETER,
ISBUSINESSPURPOSECOMPLETED,
ISMYPROJECT,
ISONETIMEACCOUNT,
ISREFERENCEDOCUMENT,
ISREVERSED,
ISTAT,
ISUBSTAT,
ITBOTOL,
ITBOTOLABS,
ITBUTOL,
ITBUTOLABS,
ITEMS,
ITTOLUNIT,
JOB,
JOURNALENTRYTYPE,
KTOPL,
KURST,
LAST_OCCUR_DATE,
LASTCHANGEDATETIME,
LASTNAME,
LDGRP,
LDQUOM,
LDRATE,
LDTUOM,
LESSHNUM,
LESTPNUM,
LOCATIONID,
LOCPT,
LOCSL,
LOGNUMBER,
LOV_GL,
LOV_IND,
MATCHINGISUNASSIGNED,
MATKL,
MATNR_I,
MENGE,
METERREADINGSTATUSISRELEASED,
MODEOFTRANSPORT,
MONITORENDDATETIME,
MONITORSTARTDATETIME,
MONTH_NAME,
N_DISTANCE,
NMBALCH,
NMBLOCK,
NMCARRIER,
NMLGORT,
NMSHIPPER,
NMSHTYPE,
NMTPLST,
NMVEHICLE,
NMVESSEL,
NMWERK,
NOMCL,
NOMINATIONCALENDARMONTH,
NOMINATIONCALENDARWEEK,
NOMINATIONCALENDARYEAR,
NOMINATIONCARRIER,
NOMINATIONCURRENTQUANTITY,
NOMINATIONDOCISBLOCKED,
NOMINATIONEXTNUMBER,
NOMINATIONPIPELINECYCLEID,
NOMINATIONPLANNEDQUANTITY,
NOMINATIONPLANNEDUNIT,
NOMINATIONSCHEDULEDATE,
NOMINATIONSCHEDULETYPE,
NOMINATIONSHIPPER,
NOMINATIONVERSION,
NOMIT,
NOMNR,
NOMST,
NOMTYP,
NOMTYPDESC,
NUM_FIELD_EXT,
NUMBER_OF_OCCUR,
NUMBEROFINTRADAYBKSTATEMENT,
OBJCT,
OCCUR_DAY_TYPE,
OPENB,
ORIGINALREFERENCEDOCUMENT,
OWNER,
PARTNR,
PAYMENTMETHOD,
PERIOD_TEXT,
PERSONFULLNAME,
PI1_LOWER,
PI1_UPPER,
PI2_LOWER,
PI2_UPPER,
PICNUM,
PLANIND,
PLANNINGLEVEL,
POSTALCODE,
POSTINGDATE,
PPIMDCONFIDENCEVALUE,
PPIMDISMESSAGE,
PPIMDLIFTVALUE,
PPIMDPATTERNCONDITION,
PPIMDPATTERNCONSEQUENT,
PPIMDPATTERNSTATUS,
PPIMDSUPPORTVALUE,
PRCTR,
PRDHA,
PRE_EXIST_IND,
PREDICT_CONFIDENCE,
PREDICT_DAMAGECODE,
PREDICT_OBJPART,
PREDICT_PACI,
PREDICT_SECTIND,
PREDICT_SRCI,
PROBA_DECISION_RR_BHVRLINSGTST,
PROBA_DECISION_RR_METERREADING,
PROBA_DECISION_RR_UTILSBILLGDO,
PROBA_RR_BHVRLINSGTSTGTVAL,
PROBA_RR_METERREADINGSTATUSISR,
PROBA_RR_UTILSBILLGDOCISCORREC,
PRODUCTHIERARCHY,
PROFITCENTER,
PROJECTACCOUNTANTEXTERNALID,
PROJECTCONTROLLEREXTERNALID,
PROJECTMANAGEREXTERNALID,
PROJECTPARTNEREXTERNALID,
PROJECTPROFILECODE,
PROJECTVISIBILITY,
PRORATE_ROUTINE,
PRORATEQTY,
QTYFCR,
QTYFCR_UOM,
QTYIN,
QTYOUT,
QUANTILE_RR_BHVRLINSGTSNMRCTAR,
QUICKCONF,
RAILCARQTY,
RBCUR,
RBUKRS,
RCCUR,
RCLNT,
RCN_TOP_1_BHVRLINSGTSNMRCTARGE,
RCN_TOP_1_BHVRLINSGTSTGTVAL,
RCN_TOP_1_CLRGDELAYINDAYSISOVE,
RCN_TOP_10_BHVRLINSGTSNMRCTARG,
RCN_TOP_10_BHVRLINSGTSTGTVAL,
RCN_TOP_2_BHVRLINSGTSNMRCTARGE,
RCN_TOP_2_BHVRLINSGTSTGTVAL,
RCN_TOP_2_CLRGDELAYINDAYSISOVE,
RCN_TOP_3_BHVRLINSGTSNMRCTARGE,
RCN_TOP_3_BHVRLINSGTSTGTVAL,
RCN_TOP_3_CLRGDELAYINDAYSISOVE,
RCN_TOP_4_BHVRLINSGTSNMRCTARGE,
RCN_TOP_4_BHVRLINSGTSTGTVAL,
RCN_TOP_4_CLRGDELAYINDAYSISOVE,
RCN_TOP_5_BHVRLINSGTSNMRCTARGE,
RCN_TOP_5_BHVRLINSGTSTGTVAL,
RCN_TOP_5_CLRGDELAYINDAYSISOVE,
RCN_TOP_6_BHVRLINSGTSNMRCTARGE,
RCN_TOP_6_BHVRLINSGTSTGTVAL,
RCN_TOP_7_BHVRLINSGTSNMRCTARGE,
RCN_TOP_7_BHVRLINSGTSTGTVAL,
RCN_TOP_8_BHVRLINSGTSNMRCTARGE,
RCN_TOP_8_BHVRLINSGTSTGTVAL,
RCN_TOP_9_BHVRLINSGTSNMRCTARGE,
RCN_TOP_9_BHVRLINSGTSTGTVAL,
RCQ_TOP_1_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_1_BHVRLINSGTSTGTVAL,
RCQ_TOP_1_CLRGDELAYINDAYSISOVE,
RCQ_TOP_10_BHVRLINSGTSNMRCTARG,
RCQ_TOP_10_BHVRLINSGTSTGTVAL,
RCQ_TOP_2_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_2_BHVRLINSGTSTGTVAL,
RCQ_TOP_2_CLRGDELAYINDAYSISOVE,
RCQ_TOP_3_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_3_BHVRLINSGTSTGTVAL,
RCQ_TOP_3_CLRGDELAYINDAYSISOVE,
RCQ_TOP_4_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_4_BHVRLINSGTSTGTVAL,
RCQ_TOP_4_CLRGDELAYINDAYSISOVE,
RCQ_TOP_5_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_5_BHVRLINSGTSTGTVAL,
RCQ_TOP_5_CLRGDELAYINDAYSISOVE,
RCQ_TOP_6_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_6_BHVRLINSGTSTGTVAL,
RCQ_TOP_7_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_7_BHVRLINSGTSTGTVAL,
RCQ_TOP_8_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_8_BHVRLINSGTSTGTVAL,
RCQ_TOP_9_BHVRLINSGTSNMRCTARGE,
RCQ_TOP_9_BHVRLINSGTSTGTVAL,
RDCUR,
RDIM_ATTR,
REASON_CODE_FEATURE_1,
REASON_CODE_FEATURE_2,
REASON_CODE_FEATURE_3,
REASON_CODE_PERCENTAGE_1,
REASON_CODE_PERCENTAGE_2,
REASON_CODE_PERCENTAGE_3,
RECONCILIATIONACCOUNT,
RECUR,
RECUR_SCHEDULE_USED,
RECURRENCE_TYPE,
REFERENCEDOCUMENTTYPE,
REFITEM,
REVERSALREASON,
REVERSEDOCUMENT,
REVERSEDOCUMENTFISCALYEAR,
RFCCUR,
RFCUR,
RGCUR,
RHCUR,
RKCUR,
RLDNR,
RLDNR_AUTH,
ROCUR,
ROUTE,
RPART,
RR_BHVRLINSGTSNMRCTARGETVALUE,
RR_DELAYINNOOFDAYS,
RR_DELIVPROCGDELAYINDAYS,
RR_METERREADINGSTATUSISRELEASE,
RR_UTILSBILLGDOCISCORRECTLYREL,
RTCUR,
RVCUR,
RVP,
RWCUR,
S_MATNR_I,
SCHED_TST_FROM,
SCHED_TST_TO,
SCHEDULEDBATCHENDDATETIME,
SCHEDULEDBATCHSTARTDATETIME,
SCHEDULEDMATERIAL,
SCHEDULEDQUANTITYUNIT,
SEGMENT,
SENTDAT,
SENTNAM,
SENTTIME,
SHITEM,
SHNUM,
SHNUM_I,
SHTYP,
SITYP,
SL_PROCESS,
SLIGHT_SILHOUETTE,
SOLDTO,
SPECIALGLCODE,
STAGES_ID,
STARTINGBALANCEAMTINTRANSCRCY,
STATRYRPTSCHEMAPARENTELEMENTID,
STATRYRPTSCHEMAREFELEMENTID,
STATUS,
STLKN,
STREETNAME,
STVKN,
SUM_OF_BSEG_DMBTR,
SUM_OF_BSEG_WRBTR,
SUPPLIERTOPARTNER,
TANK,
TARGETNMBROFINTRADAYSTATEMENT,
TAXCALCULATIONPROCEDURE,
TAXREPORTINGDATE,
TAXRETURNCOUNTRY,
TAXRT,
TCITM,
TCNUM,
THIRD_NOMNR,
TKNUM,
TKTSELECT,
TRANSACTIONCURRENCY,
TRANSPORTSYSTEM,
TST_FROM_MIN,
TST_TO_MAX,
TSYST,
TYPE,
UNIT,
UNIT_I,
UNIT_I_T,
UNLIMITED,
UPDATEXDOK,
UPDFLAG,
UPMAT,
USNAM,
UTILSBILLGDOCISCORRECTLYRELD,
VALIDITYENDDATE,
VALUATIONTYPE_D,
VALUATIONTYPE_O,
VATREGISTRATION,
VEHICLEID,
VKTRA,
WAERS,
WORKLIST,
WORKLIST_I,
WORKPACKAGEUNITUOM,
WWERT,
XBLNR,
XGRDT,
PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, BANKRECONCILIATIONDATE, BANKSTATEMENT, BANKSTATEMENTINTERNALID, BANKSTATEMENTITEM, BELNR, BHVRLINSGTSACCOUNTNUMBER, BHVRLINSGTSCADOCNMBR, BHVRLINSGTSCALDATE, BHVRLINSGTSSUBACCOUNTNUMBER, BOPFORM, BOPRPTGCNTRY, BUKRS, BUMON, BUNIT, BUSINESSPARTNER, COMPANYCODE, CREDITSEGMENT, CTRVS, CURRENCY, CUSTOMERNUM, CUSTOMERPROJECT, CUSTOMERPROJECTUUID, DIMEN, DISPLAYITEM, EMPLOYMENTINTERNALID, ENDDATE, ENGAGEMENTPROJECTSERVICEORG, ENGMNTPROJECTCOMPANYCODE, ENTITLEDTODISPOSEPARTY, EWMSTORAGETYPE, EWMWAREHOUSE, EWMWORKLOADFORECASTINDEX, FISCALYEAR, FISCALYEARVARIANT, GENERALLEDGERAGINGINCREMENT, GENERALLEDGERAGINGSCOPE, GJAHR, HBKID, HKTID, HOUSEBANK, HOUSEBANKACCOUNT, IBAN, ISSUINGORRECEIVINGPLANT, ISSUINGORRECEIVINGSTORAGELOC, KUNNR, LEDGER, LEDGERGLLINEITEM, LGORT, LIFNR, LOCID, MANDT, MATERIAL, MATERIALDOCUMENT, MATERIALDOCUMENTYEAR, MATNR, METERREADINGDOCUMENT, MWSKZ, N_PROJECTINTERNALID, NOMINATIONDOC, NOMINATIONDOCITEM, NOMTK, NOTIFICATION, PERIODTYPE, PERSON, PERSONEXTERNALID, PERSONNELNUMBER, PL_GOODSMOVEMENTTYPECATEGORY, PLANT, PORTUGUESECUSTOMERWITHVERSION, PPIMDDATASETID, PPIMDPATTERNID, PPIMDPROFILEID, PRODUCT, PROJECTINTERNALID, PS_POSID, PURCHASEORDER, PURCHASEORDERITEM, RDIFF, RTYPE, SALESDOCUMENT, SALESDOCUMENTITEM, SCHEDULELINE, SHBKZ, SITNINSTCEKEY, SOURCELEDGER, STARTDATE, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, STATRYRPTSCHEMA, STATRYRPTSCHEMAELEMENTID, STATRYRPTSCHEMAVERSION, STLAL, STLNR, STLTY, STORAGELOCATION, SUPPLIER, SWIFT, TABNAME, TAXTYPE, TAXVS, TICKET_KEY, UMSKZ, UTILITIESBILLINGDOCUMENT, WERK, YEARPERIOD)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA