Fields (486)
| 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 | 9 |
| KEY | BhvrlInsgtsAccountNumber | BhvrlInsgtsAccountNumber | 5 |
| KEY | BhvrlInsgtsCADocNmbr | BhvrlInsgtsCADocNmbr | 1 |
| KEY | BhvrlInsgtsCalDate | BhvrlInsgtsCalDate | 4 |
| KEY | BhvrlInsgtsSubAccountNumber | BhvrlInsgtsSubAccountNumber | 5 |
| KEY | BillingDocument | BillingDocument | 2 |
| KEY | BillingDocumentItem | BillingDocumentItem | 2 |
| KEY | BillOfMaterial | BillOfMaterial | 12 |
| KEY | BillOfMaterialCategory | BillOfMaterialCategory | 12 |
| KEY | BillOfMaterialHeaderUUID | BillOfMaterialHeaderUUID | 12 |
| KEY | BillOfMaterialVariant | BillOfMaterialVariant | 12 |
| KEY | BillOfMaterialVariantUsage | BillOfMaterialVariantUsage | 12 |
| KEY | BillOfMaterialVersion | BillOfMaterialVersion | 12 |
| KEY | BOPForm | BOPForm | 1 |
| KEY | BOPRptgCntry | BOPRptgCntry | 1 |
| KEY | bukrs | bukrs,CompanyCode | 12 |
| KEY | bumon | bumon | 3 |
| KEY | bunit | ConsolidationUnit | 3 |
| KEY | BusinessPartner | BusinessPartner | 7 |
| KEY | CompanyCode | CompanyCode | 47 |
| KEY | CreditSegment | CreditSegment | 2 |
| KEY | ctrvs | ctrvs | 1 |
| KEY | Currency | Currency | 6 |
| KEY | Customer | Customer | 13 |
| KEY | CustomerNum | PortugueseCustomerWithVersion | 1 |
| KEY | CustomerProject | CustomerProject | 1 |
| KEY | CustomerProjectUUID | CustomerProjectUUID | 1 |
| KEY | dimen | ConsolidationDimension | 3 |
| KEY | DisplayItem | DisplayItem | 1 |
| KEY | DocumentItemNumber | DocumentItemNumber | 1 |
| KEY | EmploymentInternalID | EmploymentInternalID | 1 |
| KEY | EndDate | EndDate | 6 |
| KEY | EngagementProjectServiceOrg | CustomerProjectServiceOrg,EngagementProjectServiceOrg | 3 |
| KEY | EngineeringChangeDocument | EngineeringChangeDocument | 12 |
| KEY | EngmntProjectCompanyCode | EngmntProjectCompanyCode | 2 |
| KEY | EntitledToDisposeParty | EntitledToDisposeParty | 3 |
| KEY | EWMStorageType | EWMStorageType | 1 |
| KEY | EWMWarehouse | EWMWarehouse | 3 |
| KEY | FiscalYear | ClearingFiscalYear,FiscalYear | 14 |
| KEY | FiscalYearVariant | FiscalYearVariant | 2 |
| KEY | GeneralLedgerAgingIncrement | GeneralLedgerAgingIncrement | 1 |
| KEY | GeneralLedgerAgingScope | GeneralLedgerAgingScope | 1 |
| KEY | gjahr | docyear,FiscalYear,gjahr | 15 |
| 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 | kunnr | 1 |
| KEY | Ledger | Ledger | 9 |
| KEY | LedgerGLLineItem | LedgerGLLineItem | 2 |
| KEY | lifnr | lifnr | 1 |
| KEY | Material | Material | 14 |
| KEY | MaterialDocument | MaterialDocument | 1 |
| KEY | MaterialDocumentYear | MaterialDocumentYear | 1 |
| KEY | mwskz | mwskz | 1 |
| KEY | N_Projectinternalid | N_Projectinternalid | 1 |
| KEY | Notification | Notification | 2 |
| KEY | PeriodType | PeriodType | 2 |
| KEY | Person | Person | 2 |
| KEY | PersonExternalID | EmployeeExtID,PersonExternalID | 2 |
| KEY | PersonnelNumber | PersonnelNumber | 2 |
| KEY | PL_GoodsMovementTypeCategory | PL_GoodsMovementTypeCategory | 1 |
| KEY | Plant | Plant | 14 |
| KEY | PortugueseCustomerWithVersion | PortugueseCustomerWithVersion | 2 |
| KEY | PortugueseInvoiceNumber | PortugueseInvoiceNumber | 1 |
| KEY | Product | Product | 3 |
| KEY | ProjectInternalID | ProjectInternalID | 1 |
| KEY | ps_posid | Name,ps_posid | 3 |
| KEY | PurchaseOrder | PurchaseOrder | 1 |
| KEY | PurchaseOrderItem | PurchaseOrderItem | 1 |
| KEY | SalesDocument | SalesDocument | 3 |
| KEY | SalesDocumentItem | SalesDocumentItem | 3 |
| 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 | 1 |
| KEY | StorageLocation | StorageLocation | 1 |
| KEY | Supplier | Supplier | 9 |
| KEY | swift | ReceiverId,SenderId | 2 |
| KEY | tabname | Name | 1 |
| KEY | TaxType | TaxType | 1 |
| KEY | taxvs | taxvs | 1 |
| KEY | umskz | shbkz | 2 |
| KEY | ValidityStartDate | ValidityStartDate | 12 |
| KEY | YearPeriod | YearPeriod | 5 |
| _AccountingDocumentCategory | _AccountingDocumentCategory | 1 | |
| _BillingDocument | _BillingDocument | 2 | |
| _BillingPlanRule | _BillingPlanRule | 1 | |
| _BillingQuantityUnit | _BillingQuantityUnit | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _CompanyCode | _CompanyCode | 7 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _Customer | _Customer | 1 | |
| _FiscalYear | _FiscalYear | 3 | |
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | 1 | |
| _JournalEntry | _JournalEntry | 3 | |
| _Ledger | _Ledger | 3 | |
| _Material | _Material | 1 | |
| _ReferenceDeliveryDocumentItem | _ReferenceDeliveryDocumentItem | 1 | |
| _ReferenceSDDocumentCategory | _ReferenceSDDocumentCategory | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesDocumentItem | _SalesDocumentItem | 1 | |
| _SDDocumentReason | _SDDocumentReason | 1 | |
| _SourceLedger | _SourceLedger | 1 | |
| _Supplier | _Supplier | 1 | |
| _SupplierCompany | _SupplierCompany | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| acc_principle | acc_principle | 5 | |
| accasty | accasty | 3 | |
| AccountingDocCreatedByUser | AccountingDocCreatedByUser,CreatedByUser | 2 | |
| AccountingDocumentCategory | AccountingDocumentCategory | 4 | |
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | 4 | |
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | 1 | |
| AccountingDocumentType | AccountingDocumentType,JournalEntryType | 5 | |
| ActualCost | ActualCost | 1 | |
| aennr | change_from | 1 | |
| AlphanumericTaxCode | AlphanumericTaxCode | 1 | |
| altkt | altkt | 3 | |
| AmountDebitCreditCode | AmountDebitCreditCode | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 2 | |
| aufnr | aufnr | 1 | |
| augbl | augbl | 1 | |
| augdt | augdt | 1 | |
| auth | Authorization_Profile | 1 | |
| AuthorizationGroup | AuthorizationGroup | 4 | |
| AvgPeriodStkQtyInBaseUnit | AvgPeriodStkQtyInBaseUnit | 1 | |
| awitem | awitem | 3 | |
| awkey | awkey | 3 | |
| aworg | aworg | 9 | |
| aworg_rev | aworg_rev | 2 | |
| awref | awref | 9 | |
| awref_rev | awref_rev | 2 | |
| awsys | awsys | 9 | |
| awtyp | awtyp | 9 | |
| awtyp_rev | awtyp_rev | 2 | |
| 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 | |
| BhvrlInsgtsClusterID | BhvrlInsgtsClusterID | 1 | |
| BhvrlInsgtsNmrcTargetValue | BhvrlInsgtsNmrcTargetValue | 1 | |
| BhvrlInsgtsTgtVal | BhvrlInsgtsTgtVal | 3 | |
| BillingDocumentItemText | BillingDocumentItemText | 2 | |
| BillingPlanRule | BillingPlanRule | 2 | |
| BillingQuantity | Quantity | 1 | |
| BillingQuantityUnit | UnitOfMeasure | 1 | |
| bktxt | RecurringAcctgDocHeaderText | 2 | |
| blart | AccountingDocumentType,blart | 3 | |
| bldat | bldat | 2 | |
| blocked_for_posting | RecrrgAcctgDocIsBlocked | 2 | |
| bom_versn | BillOfMaterialVersion | 1 | |
| bstat | bstat | 2 | |
| bttype | bttype | 3 | |
| budat | budat | 5 | |
| BusinessPartnerCountry | BusinessPartnerCountry | 1 | |
| BusinessPartnerCustomer | BusinessPartnerCustomer | 1 | |
| BusinessPartnerName | GivenName | 1 | |
| butxt | butxt,CompanyCodeName | 4 | |
| carry_forward | carry_forward | 1 | |
| CashDiscount1DueDate | CashDiscount1DueDate | 2 | |
| CashDiscount2DueDate | CashDiscount2DueDate | 2 | |
| char_field_ext | char_field_ext,CharFieldExt | 2 | |
| ChartOfAccounts | ChartOfAccounts | 4 | |
| CityName | CityName | 1 | |
| ClrgDelayInDaysIsOverThreshold | ClrgDelayInDaysIsOverThreshold | 1 | |
| comp_balance | comp_balance | 1 | |
| comp_year | comp_year | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 9 | |
| CompanyCodeName | CompanyCodeName | 1 | |
| Confidence | Confidence | 1 | |
| controlarea | BankAccountCurrency | 1 | |
| ControllingArea | ControllingArea | 2 | |
| CostCenter | CostCenter | 2 | |
| Country | Country | 2 | |
| cpudt | AccountingDocumentCreationDate | 2 | |
| cputm | CreationTime | 2 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 3 | |
| CreditAccountResubmissionDate | CreditAccountResubmissionDate | 2 | |
| CreditAmountInCoCodeCrcy | CreditAmountInCoCodeCrcy | 1 | |
| CreditRiskClass | CreditRiskClass | 1 | |
| cum_balance | cum_balance | 1 | |
| curr | ConsolidationUnitLocalCurrency | 1 | |
| curr_local_send | CnsldtnUnitSndrCrcyForLoclCrcy | 1 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 2 | |
| CustomerSupplierAddress | CustomerSupplierAddress | 1 | |
| CustomerVATRegistration | CustomerVATRegistration | 1 | |
| CustProjWrkPckgActualRevenue | CustProjWrkPckgActualRevenue | 1 | |
| CustProjWrkPckgPlanCost | CustProjWrkPckgPlanCost | 1 | |
| CustProjWrkPckgPlanRevenue | CustProjWrkPckgPlanRevenue | 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 | |
| DelayInNoOfDays | DelayInNoOfDays | 1 | |
| DelivOfGoodsDestCountry | DelivOfGoodsDestCountry | 1 | |
| diff_balance | diff_balance | 1 | |
| diff_balance_p | diff_balance_p | 1 | |
| dimid | dimid | 1 | |
| DisplayCurrency | DisplayCurrency | 2 | |
| Distance | Distance | 1 | |
| DocumentDate | DocumentDate,TransactionDate | 6 | |
| DocumentItemText | DocumentItemText | 1 | |
| ebeln | ebeln | 1 | |
| Employee | Employee | 1 | |
| EmployeeFullName | EmployeeFullName | 1 | |
| EmployeeInternalID | EmployeeInternalID | 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 | |
| eval_scope | eval_scope | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| Feature1Value | Feature1Value | 1 | |
| Feature2Value | Feature2Value | 1 | |
| Feature3Value | Feature3Value | 1 | |
| Feature4Value | Feature4Value | 1 | |
| Feature5Value | Feature5Value | 1 | |
| FinancialAccountType | FinancialAccountType | 2 | |
| FinancialStatementItem | FinancialStatementItem | 1 | |
| FINANCIALSTATEMENTVARIANT | FINANCIALSTATEMENTVARIANT | 1 | |
| first_occur_date | FirstOccurrenceDate | 2 | |
| FiscalPeriod | FiscalPeriod | 5 | |
| fiscyearper | fiscyearper | 3 | |
| ForeignCurrency | ForeignCurrency,OriginalCurrency | 1 | |
| frequency | RecurrenceFrequency | 2 | |
| fsh_seaim | fsh_seaim | 1 | |
| fsh_sealv | fsh_sealv | 2 | |
| functional_currency | functional_currency | 1 | |
| Gb_Best_Proba_Clrgdelayindaysi | Gb_Best_Proba_Clrgdelayindaysi | 1 | |
| Gb_Decision_Clrgdelayindaysiso | Gb_Decision_Clrgdelayindaysiso | 1 | |
| Gb_Score_Clrgdelayindaysisover | Gb_Score_Clrgdelayindaysisover | 1 | |
| GLAccount | GLAccount | 4 | |
| glaccount_type | glaccount_type | 2 | |
| grupp | grupp | 1 | |
| housebk | HouseBank | 1 | |
| hwaer | CompanyCodeCurrency | 2 | |
| Id | Id | 12 | |
| imatn | imatn | 1 | |
| incrmt_index | incrmt_index | 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 | |
| IsReversed | IsReversed | 3 | |
| Job | Job | 1 | |
| JournalEntryType | JournalEntryType | 1 | |
| K | K | 12 | |
| kdauf | kdauf | 1 | |
| kdpos | kdpos | 1 | |
| kokrs | kokrs | 3 | |
| ktopl | ktopl | 2 | |
| kurst | ExchangeRateType | 2 | |
| last_occur_date | LastOccurrenceDate | 2 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastName | FamilyName | 1 | |
| ldgrp | ldgrp,ldgrp_in,ldgrp_subset,LedgerGroup | 4 | |
| lognumber | LogNumberWithZero | 2 | |
| mandt | mandt | 7 | |
| MatchingIsUnassigned | MatchingIsUnassigned | 1 | |
| MaterialBaseUnit | MaterialBaseUnit | 1 | |
| MonitorEndDateTime | MonitorEndDateTime | 5 | |
| MonitorStartDateTime | MonitorStartDateTime | 5 | |
| month_name | month_name | 1 | |
| N_Distance | N_Distance | 13 | |
| NetAmount | NetAmount | 1 | |
| num_field_ext | num_field_ext,NumFieldExt | 2 | |
| number_of_occur | NumberOfOccurrences | 2 | |
| NumberOfIntradayBkStatement | NumberOfIntradayBkStatement | 5 | |
| objct | Object | 1 | |
| objnr | objnr | 2 | |
| occur_day_type | OccurrenceType | 2 | |
| openb | BankAcctBalanceAmt | 1 | |
| OrganizationalUnitName | OrganizationalUnitName | 1 | |
| OriginalReferenceDocument | OriginalReferenceDocument | 1 | |
| paobjnr | paobjnr | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| period_text | period_text | 1 | |
| PersonFullName | PersonFullName | 2 | |
| picnum | picnum | 1 | |
| poper | poper | 1 | |
| PostalCode | PostalCode | 1 | |
| PostingDate | DocumentDate,PostingDate | 9 | |
| prctr | prctr | 1 | |
| Prdtn_Billofmaterial | Prdtn_Billofmaterial | 12 | |
| Prdtn_Billofmaterialcategory | Prdtn_Billofmaterialcategory | 12 | |
| Prdtn_Billofmaterialheaderuuid | Prdtn_Billofmaterialheaderuuid | 12 | |
| Prdtn_Billofmaterialvariant | Prdtn_Billofmaterialvariant | 12 | |
| Prdtn_Billofmaterialversion | Prdtn_Billofmaterialversion | 12 | |
| Prdtn_Billofmatlvarusge | Prdtn_Billofmatlvarusge | 12 | |
| Prdtn_Companycode | Prdtn_Companycode | 12 | |
| Prdtn_Engchgdoc | Prdtn_Engchgdoc | 12 | |
| Prdtn_Material | Prdtn_Material | 12 | |
| Prdtn_Plant | Prdtn_Plant | 12 | |
| Prdtn_Validitystartdate | Prdtn_Validitystartdate | 12 | |
| 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 | |
| Predtn_Id | Predtn_Id | 12 | |
| PriceDetnExchangeRate | ExchangeRate | 1 | |
| PricingDate | ExchangeRateDate | 1 | |
| Proba_Decision_Rr_Bhvrlinsgtst | Proba_Decision_Rr_Bhvrlinsgtst | 3 | |
| Proba_Rr_BhvrlInsgtsTgtVal | Proba_Rr_BhvrlInsgtsTgtVal | 3 | |
| ProductHierarchy | ProductHierarchy | 6 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectAccountantExternalID | ProjectAccountantExternalID | 1 | |
| ProjectControllerExternalID | ProjectControllerExternalID | 1 | |
| ProjectManagerExternalID | ProjectManagerExternalID | 1 | |
| ProjectPartnerExternalID | ProjectPartnerExternalID | 1 | |
| ProjectProfileCode | ProjectProfileCode | 1 | |
| ProjectVisibility | ProjectVisibility | 1 | |
| ps_psp_pnr | ps_psp_pnr | 2 | |
| Quantile_Rr_Bhvrlinsgtsnmrctar | Quantile_Rr_Bhvrlinsgtsnmrctar | 1 | |
| Quantity | Quantity | 1 | |
| rbukrs | rbukrs | 9 | |
| 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 | |
| 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_schedule_used | RecurrenceScheduleIsUsed | 2 | |
| recurrence_type | RecurrenceType | 2 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 2 | |
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | 2 | |
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | 2 | |
| Region | Region | 1 | |
| ReversalReason | ReversalReason | 3 | |
| ReverseDocument | ReverseDocument | 3 | |
| ReverseDocumentFiscalYear | ReverseDocumentFiscalYear | 3 | |
| rfccur | FunctionalCurrency | 1 | |
| rldnr | Ledger,rldnr | 15 | |
| rldnr_auth | rldnr_auth | 1 | |
| Rr_BhvrlInsgtsNmrcTargetValue | Rr_BhvrlInsgtsNmrcTargetValue | 1 | |
| Rr_DelayInNoOfDays | Rr_DelayInNoOfDays | 1 | |
| Rr_DelivProcgDelayInDays | Rr_DelivProcgDelayInDays | 1 | |
| ryear | gjahr | 1 | |
| SDDocumentReason | SDDocumentReason | 3 | |
| segment | segment | 1 | |
| service_contract_id | service_contract_id | 1 | |
| service_contract_item_id | service_contract_item_id | 1 | |
| service_doc_id | service_doc_id | 1 | |
| service_doc_item_id | service_doc_item_id | 1 | |
| sl_process | sl_process | 1 | |
| Slight_Silhouette | Slight_Silhouette | 1 | |
| solution_order_id | solution_order_id | 1 | |
| SpecialGLCode | SpecialGLCode | 1 | |
| StartingBalanceAmtInTransCrcy | StartingBalanceAmtInTransCrcy | 1 | |
| StatryRptSchemaParentElementId | StatryRptSchemaParentElementId | 1 | |
| StatryRptSchemaRefElementId | StatryRptSchemaRefElementId | 1 | |
| Status | Status | 4 | |
| step_proc | step_proc | 1 | |
| stlkn | stlkn | 1 | |
| StreetName | StreetName | 1 | |
| stvkn | stvkn | 1 | |
| sum_of_bseg_dmbtr | AmountInCompanyCodeCurrency | 1 | |
| sum_of_bseg_wrbtr | AmountInTransactionCurrency | 1 | |
| SupplierToPartner | SupplierToPartner | 1 | |
| TargetNmbrOfIntradayStatement | TargetNmbrOfIntradayStatement | 5 | |
| TaxCalculationProcedure | TaxCalculationProcedure | 1 | |
| TaxReportingDate | TaxReportingDate | 1 | |
| TaxReturnCountry | TaxReturnCountry | 1 | |
| taxrt | TaxRate | 1 | |
| timestamp | timestamp | 2 | |
| TransactionCurrency | TransactionCurrency | 3 | |
| UnitOfMeasure | UnitOfMeasure | 1 | |
| usnam | AccountingDocCreatedByUser | 2 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| VATRegistration | VATRegistration | 1 | |
| vtkey | vtkey | 1 | |
| vtpos | vtpos | 1 | |
| waers | TransactionCurrency,waers | 3 | |
| 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,
BILLINGDOCUMENT,
BILLINGDOCUMENTITEM,
BILLOFMATERIAL,
BILLOFMATERIALCATEGORY,
BILLOFMATERIALHEADERUUID,
BILLOFMATERIALVARIANT,
BILLOFMATERIALVARIANTUSAGE,
BILLOFMATERIALVERSION,
BOPFORM,
BOPRPTGCNTRY,
BUKRS,
BUMON,
BUNIT,
BUSINESSPARTNER,
COMPANYCODE,
CREDITSEGMENT,
CTRVS,
CURRENCY,
CUSTOMER,
CUSTOMERNUM,
CUSTOMERPROJECT,
CUSTOMERPROJECTUUID,
DIMEN,
DISPLAYITEM,
DOCUMENTITEMNUMBER,
EMPLOYMENTINTERNALID,
ENDDATE,
ENGAGEMENTPROJECTSERVICEORG,
ENGINEERINGCHANGEDOCUMENT,
ENGMNTPROJECTCOMPANYCODE,
ENTITLEDTODISPOSEPARTY,
EWMSTORAGETYPE,
EWMWAREHOUSE,
FISCALYEAR,
FISCALYEARVARIANT,
GENERALLEDGERAGINGINCREMENT,
GENERALLEDGERAGINGSCOPE,
GJAHR,
HBKID,
HKTID,
HOUSEBANK,
HOUSEBANKACCOUNT,
IBAN,
ISSUINGORRECEIVINGPLANT,
ISSUINGORRECEIVINGSTORAGELOC,
KUNNR,
LEDGER,
LEDGERGLLINEITEM,
LIFNR,
MATERIAL,
MATERIALDOCUMENT,
MATERIALDOCUMENTYEAR,
MWSKZ,
N_PROJECTINTERNALID,
NOTIFICATION,
PERIODTYPE,
PERSON,
PERSONEXTERNALID,
PERSONNELNUMBER,
PL_GOODSMOVEMENTTYPECATEGORY,
PLANT,
PORTUGUESECUSTOMERWITHVERSION,
PORTUGUESEINVOICENUMBER,
PRODUCT,
PROJECTINTERNALID,
PS_POSID,
PURCHASEORDER,
PURCHASEORDERITEM,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SCHEDULELINE,
SHBKZ,
SITNINSTCEKEY,
SOURCELEDGER,
STARTDATE,
STATRYRPTCATEGORY,
STATRYRPTGENTITY,
STATRYRPTRUNID,
STATRYRPTSCHEMA,
STATRYRPTSCHEMAELEMENTID,
STATRYRPTSCHEMAVERSION,
STLAL,
STLNR,
STLTY,
STORAGELOCATION,
SUPPLIER,
SWIFT,
TABNAME,
TAXTYPE,
TAXVS,
UMSKZ,
VALIDITYSTARTDATE,
YEARPERIOD,
_ACCOUNTINGDOCUMENTCATEGORY,
_BILLINGDOCUMENT,
_BILLINGPLANRULE,
_BILLINGQUANTITYUNIT,
_CHARTOFACCOUNTS,
_COMPANYCODE,
_COMPANYCODECURRENCY,
_COSTCENTER,
_CUSTOMER,
_FISCALYEAR,
_GLACCOUNTINCHARTOFACCOUNTS,
_JOURNALENTRY,
_LEDGER,
_MATERIAL,
_REFERENCEDELIVERYDOCUMENTITEM,
_REFERENCESDDOCUMENTCATEGORY,
_SALESDOCUMENT,
_SALESDOCUMENTITEM,
_SDDOCUMENTREASON,
_SOURCELEDGER,
_SUPPLIER,
_SUPPLIERCOMPANY,
_TRANSACTIONCURRENCY,
ACC_PRINCIPLE,
ACCASTY,
ACCOUNTINGDOCCREATEDBYUSER,
ACCOUNTINGDOCUMENTCATEGORY,
ACCOUNTINGDOCUMENTCREATIONDATE,
ACCOUNTINGDOCUMENTHEADERTEXT,
ACCOUNTINGDOCUMENTTYPE,
ACTUALCOST,
AENNR,
ALPHANUMERICTAXCODE,
ALTKT,
AMOUNTDEBITCREDITCODE,
AMOUNTINTRANSACTIONCURRENCY,
AUFNR,
AUGBL,
AUGDT,
AUTH,
AUTHORIZATIONGROUP,
AVGPERIODSTKQTYINBASEUNIT,
AWITEM,
AWKEY,
AWORG,
AWORG_REV,
AWREF,
AWREF_REV,
AWSYS,
AWTYP,
AWTYP_REV,
BANK,
BANKACCOUNTCURRENCY,
BANKACCOUNTINTERNALID,
BANKACCOUNTNUMBER,
BANKCOUNTRY,
BANKSTATEMENTDATE,
BANKSTATEMENTSHORTID,
BAR_RR_BHVRLINSGTSNMRCTARGETVA,
BAR_RR_DELAYINNOOFDAYS,
BAR_RR_DELIVPROCGDELAYINDAYS,
BHVRLINSGTSCLUSTERID,
BHVRLINSGTSNMRCTARGETVALUE,
BHVRLINSGTSTGTVAL,
BILLINGDOCUMENTITEMTEXT,
BILLINGPLANRULE,
BILLINGQUANTITY,
BILLINGQUANTITYUNIT,
BKTXT,
BLART,
BLDAT,
BLOCKED_FOR_POSTING,
BOM_VERSN,
BSTAT,
BTTYPE,
BUDAT,
BUSINESSPARTNERCOUNTRY,
BUSINESSPARTNERCUSTOMER,
BUSINESSPARTNERNAME,
BUTXT,
CARRY_FORWARD,
CASHDISCOUNT1DUEDATE,
CASHDISCOUNT2DUEDATE,
CHAR_FIELD_EXT,
CHARTOFACCOUNTS,
CITYNAME,
CLRGDELAYINDAYSISOVERTHRESHOLD,
COMP_BALANCE,
COMP_YEAR,
COMPANYCODECURRENCY,
COMPANYCODENAME,
CONFIDENCE,
CONTROLAREA,
CONTROLLINGAREA,
COSTCENTER,
COUNTRY,
CPUDT,
CPUTM,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CREDITACCOUNTRESUBMISSIONDATE,
CREDITAMOUNTINCOCODECRCY,
CREDITRISKCLASS,
CUM_BALANCE,
CURR,
CURR_LOCAL_SEND,
CUSTOMERPAYMENTTERMS,
CUSTOMERSUPPLIERADDRESS,
CUSTOMERVATREGISTRATION,
CUSTPROJWRKPCKGACTUALREVENUE,
CUSTPROJWRKPCKGPLANCOST,
CUSTPROJWRKPCKGPLANREVENUE,
DATACONTROLLER1,
DATACONTROLLER10,
DATACONTROLLER2,
DATACONTROLLER3,
DATACONTROLLER4,
DATACONTROLLER5,
DATACONTROLLER6,
DATACONTROLLER7,
DATACONTROLLER8,
DATACONTROLLER9,
DATACONTROLLERSET,
DATE,
DATUV,
DBAKZ,
DBATR,
DBZHL,
DDLNAME,
DDTEXT,
DEBITAMOUNTINCOCODECRCY,
DEBITCREDITCODE,
DECISION_RR_BHVRLINSGTSTGTVAL,
DELAYINNOOFDAYS,
DELIVOFGOODSDESTCOUNTRY,
DIFF_BALANCE,
DIFF_BALANCE_P,
DIMID,
DISPLAYCURRENCY,
DISTANCE,
DOCUMENTDATE,
DOCUMENTITEMTEXT,
EBELN,
EMPLOYEE,
EMPLOYEEFULLNAME,
EMPLOYEEINTERNALID,
END_BY_TYPE,
ENDBALANCE,
ENGAGEMENTPROJECTCATEGORY,
ENGAGEMENTPROJECTCOSTCENTER,
ENGAGEMENTPROJECTREVIEWSTATUS,
ENGAGEMENTPROJECTSTAGE,
ENGAGEMENTPROJECTTYPE,
ENGMNTPROJECTHEADERCOMPANYCODE,
ENGMNTPROJREVIEWYEARPERIOD,
EVAL_SCOPE,
EXCHANGERATE,
FEATURE1VALUE,
FEATURE2VALUE,
FEATURE3VALUE,
FEATURE4VALUE,
FEATURE5VALUE,
FINANCIALACCOUNTTYPE,
FINANCIALSTATEMENTITEM,
FINANCIALSTATEMENTVARIANT,
FIRST_OCCUR_DATE,
FISCALPERIOD,
FISCYEARPER,
FOREIGNCURRENCY,
FREQUENCY,
FSH_SEAIM,
FSH_SEALV,
FUNCTIONAL_CURRENCY,
GB_BEST_PROBA_CLRGDELAYINDAYSI,
GB_DECISION_CLRGDELAYINDAYSISO,
GB_SCORE_CLRGDELAYINDAYSISOVER,
GLACCOUNT,
GLACCOUNT_TYPE,
GRUPP,
HOUSEBK,
HWAER,
ID,
IMATN,
INCRMT_INDEX,
INT_FIELD_EXT,
INT1_FIELD_EXT,
INTRABKSTMNTIMPORTRULETIMEZONE,
IS_CONSTRAINT,
IS_PARAMETER,
ISBUSINESSPURPOSECOMPLETED,
ISMYPROJECT,
ISONETIMEACCOUNT,
ISREVERSED,
JOB,
JOURNALENTRYTYPE,
K,
KDAUF,
KDPOS,
KOKRS,
KTOPL,
KURST,
LAST_OCCUR_DATE,
LASTCHANGEDATETIME,
LASTNAME,
LDGRP,
LOGNUMBER,
MANDT,
MATCHINGISUNASSIGNED,
MATERIALBASEUNIT,
MONITORENDDATETIME,
MONITORSTARTDATETIME,
MONTH_NAME,
N_DISTANCE,
NETAMOUNT,
NUM_FIELD_EXT,
NUMBER_OF_OCCUR,
NUMBEROFINTRADAYBKSTATEMENT,
OBJCT,
OBJNR,
OCCUR_DAY_TYPE,
OPENB,
ORGANIZATIONALUNITNAME,
ORIGINALREFERENCEDOCUMENT,
PAOBJNR,
PAYMENTMETHOD,
PERIOD_TEXT,
PERSONFULLNAME,
PICNUM,
POPER,
POSTALCODE,
POSTINGDATE,
PRCTR,
PRDTN_BILLOFMATERIAL,
PRDTN_BILLOFMATERIALCATEGORY,
PRDTN_BILLOFMATERIALHEADERUUID,
PRDTN_BILLOFMATERIALVARIANT,
PRDTN_BILLOFMATERIALVERSION,
PRDTN_BILLOFMATLVARUSGE,
PRDTN_COMPANYCODE,
PRDTN_ENGCHGDOC,
PRDTN_MATERIAL,
PRDTN_PLANT,
PRDTN_VALIDITYSTARTDATE,
PREDICT_CONFIDENCE,
PREDICT_DAMAGECODE,
PREDICT_OBJPART,
PREDICT_PACI,
PREDICT_SECTIND,
PREDICT_SRCI,
PREDTN_ID,
PRICEDETNEXCHANGERATE,
PRICINGDATE,
PROBA_DECISION_RR_BHVRLINSGTST,
PROBA_RR_BHVRLINSGTSTGTVAL,
PRODUCTHIERARCHY,
PROFITCENTER,
PROJECTACCOUNTANTEXTERNALID,
PROJECTCONTROLLEREXTERNALID,
PROJECTMANAGEREXTERNALID,
PROJECTPARTNEREXTERNALID,
PROJECTPROFILECODE,
PROJECTVISIBILITY,
PS_PSP_PNR,
QUANTILE_RR_BHVRLINSGTSNMRCTAR,
QUANTITY,
RBUKRS,
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,
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_SCHEDULE_USED,
RECURRENCE_TYPE,
REFERENCEDOCUMENTTYPE,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
REFERENCESDDOCUMENTITEM,
REGION,
REVERSALREASON,
REVERSEDOCUMENT,
REVERSEDOCUMENTFISCALYEAR,
RFCCUR,
RLDNR,
RLDNR_AUTH,
RR_BHVRLINSGTSNMRCTARGETVALUE,
RR_DELAYINNOOFDAYS,
RR_DELIVPROCGDELAYINDAYS,
RYEAR,
SDDOCUMENTREASON,
SEGMENT,
SERVICE_CONTRACT_ID,
SERVICE_CONTRACT_ITEM_ID,
SERVICE_DOC_ID,
SERVICE_DOC_ITEM_ID,
SL_PROCESS,
SLIGHT_SILHOUETTE,
SOLUTION_ORDER_ID,
SPECIALGLCODE,
STARTINGBALANCEAMTINTRANSCRCY,
STATRYRPTSCHEMAPARENTELEMENTID,
STATRYRPTSCHEMAREFELEMENTID,
STATUS,
STEP_PROC,
STLKN,
STREETNAME,
STVKN,
SUM_OF_BSEG_DMBTR,
SUM_OF_BSEG_WRBTR,
SUPPLIERTOPARTNER,
TARGETNMBROFINTRADAYSTATEMENT,
TAXCALCULATIONPROCEDURE,
TAXREPORTINGDATE,
TAXRETURNCOUNTRY,
TAXRT,
TIMESTAMP,
TRANSACTIONCURRENCY,
UNITOFMEASURE,
USNAM,
VALIDITYENDDATE,
VATREGISTRATION,
VTKEY,
VTPOS,
WAERS,
WORKPACKAGEUNITUOM,
WWERT,
XBLNR,
XGRDT,
PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, BANKRECONCILIATIONDATE, BANKSTATEMENT, BANKSTATEMENTINTERNALID, BANKSTATEMENTITEM, BELNR, BHVRLINSGTSACCOUNTNUMBER, BHVRLINSGTSCADOCNMBR, BHVRLINSGTSCALDATE, BHVRLINSGTSSUBACCOUNTNUMBER, BILLINGDOCUMENT, BILLINGDOCUMENTITEM, BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALHEADERUUID, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION, BOPFORM, BOPRPTGCNTRY, BUKRS, BUMON, BUNIT, BUSINESSPARTNER, COMPANYCODE, CREDITSEGMENT, CTRVS, CURRENCY, CUSTOMER, CUSTOMERNUM, CUSTOMERPROJECT, CUSTOMERPROJECTUUID, DIMEN, DISPLAYITEM, DOCUMENTITEMNUMBER, EMPLOYMENTINTERNALID, ENDDATE, ENGAGEMENTPROJECTSERVICEORG, ENGINEERINGCHANGEDOCUMENT, ENGMNTPROJECTCOMPANYCODE, ENTITLEDTODISPOSEPARTY, EWMSTORAGETYPE, EWMWAREHOUSE, FISCALYEAR, FISCALYEARVARIANT, GENERALLEDGERAGINGINCREMENT, GENERALLEDGERAGINGSCOPE, GJAHR, HBKID, HKTID, HOUSEBANK, HOUSEBANKACCOUNT, IBAN, ISSUINGORRECEIVINGPLANT, ISSUINGORRECEIVINGSTORAGELOC, KUNNR, LEDGER, LEDGERGLLINEITEM, LIFNR, MATERIAL, MATERIALDOCUMENT, MATERIALDOCUMENTYEAR, MWSKZ, N_PROJECTINTERNALID, NOTIFICATION, PERIODTYPE, PERSON, PERSONEXTERNALID, PERSONNELNUMBER, PL_GOODSMOVEMENTTYPECATEGORY, PLANT, PORTUGUESECUSTOMERWITHVERSION, PORTUGUESEINVOICENUMBER, PRODUCT, PROJECTINTERNALID, PS_POSID, PURCHASEORDER, PURCHASEORDERITEM, SALESDOCUMENT, SALESDOCUMENTITEM, SCHEDULELINE, SHBKZ, SITNINSTCEKEY, SOURCELEDGER, STARTDATE, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, STATRYRPTSCHEMA, STATRYRPTSCHEMAELEMENTID, STATRYRPTSCHEMAVERSION, STLAL, STLNR, STLTY, STORAGELOCATION, SUPPLIER, SWIFT, TABNAME, TAXTYPE, TAXVS, UMSKZ, VALIDITYSTARTDATE, 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