SAP-tabelreferentie
FARR_D_CONTRACT
ContractsBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel FARR_D_CONTRACT.
SAP-tabel FARR_D_CONTRACT heeft 2 primaire sleutelvelden: CLIENT,CONTRACT_ID.
/ Velden
FARR_D_CONTRACT velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sleutel CLIENT | Client | CLNT | 3 | 0 | MANDT | ||||||||
| Sleutel CONTRACT_ID | Revenue Accounting Contract ID | CHAR | 14 | 0 | FARR_CONTRACT_ID | ||||||||
| CONTRACT_CAT | Contract Category | CHAR | 4 | 0 | FARR_CONTRACT_CATEGORY | ||||||||
| CUSTOMER_GRP | Group key | CHAR | 10 | 0 | KONZS | ||||||||
| ACCT_PRINCIPLE | Accounting Principle | CHAR | 4 | 0 | * | ACCOUNTING_PRINCIPLE | |||||||
| DESCRIPTION | Description of Revenue Accounting Items | CHAR | 60 | 0 | FARR_DESCRIPTION | ||||||||
| CONTR_CREATED_ON | The datetime for contract created | DEC | 15 | 0 | FARR_CONTR_CREATED_ON | ||||||||
| CONTR_EEW_DUMMY | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||||||||
| IS_BLOCKED | Is Blocked | CHAR | 1 | 0 | FARR_DPP_IS_BLOCKED | ||||||||
| NUM_OF_POB | Number of Performance Obligations | INT4 | 10 | 0 | FARR_NUM_OF_POB | ||||||||
| CUSTOMER_ID | Customer Number | CHAR | 10 | 0 | KUNNR | ||||||||
| PARTNER | Business Partner Number | CHAR | 10 | 0 | BU_PARTNER | ||||||||
| VALOBJTYPE | Type of the Financial Valuation Object | CHAR | 4 | 0 | * | VAL_OBJ_TYPE | |||||||
| TRX_PRICE | Contractual Price | CURR | 25 | 2 | FARR_TRANSACTION_PRICE | ||||||||
| TRX_PRICE_CURK | Currency Key | CUKY | 5 | 0 | * | WAERS | |||||||
| STATUS | Contract Status | CHAR | 1 | 0 | FARR_CONTRACT_STATUS | ||||||||
| |||||||||||||
| VALIDATE_RESULT | Validation Result | CHAR | 1 | 0 | FARR_VALIDATE_RESULT | ||||||||
| |||||||||||||
| MANUAL_CREATED | Manually Created | CHAR | 1 | 0 | FARR_MANUAL_CREATED | ||||||||
| MANUAL_CHANGED | Manually Changed | CHAR | 1 | 0 | FARR_MANUAL_CHANGED | ||||||||
| MANUAL_DELETED | Manually Deleted | CHAR | 1 | 0 | FARR_MANUAL_DELETED | ||||||||
| MANUAL_ALLOCATED | Price was allocated manually on the Contract | CHAR | 1 | 0 | FARR_MANUAL_PRICE_ALLOC | ||||||||
| SOFT_DELETED | Soft Deleted | CHAR | 1 | 0 | FARR_SOFT_DELETED | ||||||||
| PRICE_ADJUSTED | Allocation Effect Exists in the Contract | CHAR | 1 | 0 | FARR_PRICE_ADJUST_FLAG | ||||||||
| COMPANY_CODE | Company Code | CHAR | 4 | 0 | BUKRS | ||||||||
| SALES_ORG | Sales Organization for Revenue Accounting | CHAR | 20 | 0 | FARR_SALES_ORG | ||||||||
| ALLOC_DIFFER | Contract Allocation Effect | CURR | 23 | 2 | FARR_ALLOC_DIFFERENCE | ||||||||
| MANUAL_PRICE_ALLOC_CONFLICT | Contract has manual price allocation conflict | CHAR | 1 | 0 | FARR_MNL_PRICE_ALLOC_CONFLICT | ||||||||
| PENDING_CONFLICT | Pending Conflict Resolution | CHAR | 1 | 0 | FARR_PENDING_CONFLICT | ||||||||
| RECEIVABLE_ACCOUNT | Receivables Account | CHAR | 10 | 0 | FARR_RECEIV_ACCOUNT | ||||||||
| RECEI_ADJ_ACCOUNT | Receivable Adjustment Account | CHAR | 10 | 0 | * | FARR_RECE_ADJ_ACCT | |||||||
| ASSET_ACCOUNT | Contract Asset Account | CHAR | 10 | 0 | * | FARR_ASSET_ACCOUNT | |||||||
| LIABILITY_ACCOUNT | Contract Liability Account | CHAR | 10 | 0 | * | FARR_LIABILITY_ACCOUNT | |||||||
| REFUND_LIABILITY_ACCT | Refund Liability Account | CHAR | 10 | 0 | FARR_REFUND_LIABILITY | ||||||||
| REFUND_ASSET_ACCOUNT | Refund Asset Account | CHAR | 10 | 0 | FARR_REFUND_ASSET_ACCOUNT | ||||||||
| ASSET_IMPAIRMENT_ACCOUNT | Contract Termination Expense (Loss) Account | CHAR | 10 | 0 | * | FARR_ASSET_IMPAIRMENT_ACCOUNT | |||||||
| HAS_TM_POB | With Time-Based POB or Event-based POB with Rights of Return | CHAR | 1 | 0 | FARR_HAS_TM_POB | ||||||||
| COMPLETION_DATE | Completion Date | DATS | 8 | 0 | FARR_COMPLETION_DATE | ||||||||
| LIABILITY_POST_MODE | Level for Posting Liabilities and Assets to Posting Table | CHAR | 1 | 0 | FARR_LIABILITY_POST_MODE | ||||||||
| |||||||||||||
| LC_CALC_METHOD | Local Currency Calculation Method | CHAR | 1 | 0 | FARR_LC_CALC_METHOD | ||||||||
| |||||||||||||
| ROUNDING_TS | Timestemp for calculating rounding | DEC | 15 | 0 | FARR_ROUNDING_TS | ||||||||
| FIXED_EX_RATE_DATE | The date is used to fix exchange rate | DATS | 8 | 0 | FARR_FIXED_EX_RATE_DATE | ||||||||
| LIAB_METHOD | Contract Balance Presentation | CHAR | 1 | 0 | FARR_CREATE_LIABILITY_METHOD | ||||||||
| |||||||||||||
| ASSET_IMPAIRMENT_DATE | Date on which the contract was terminated early | DATS | 8 | 0 | FARR_ASSET_IMPAIRMENT_DATE | ||||||||
| RAR_VERSION_CODE | RAR version code | CHAR | 1 | 0 | FARR_RAR_VERSION_CODE | ||||||||
| |||||||||||||
| CCM_OCM_RECON_KEY | Reconciliation Key for a Contract in a Revenue Acctg. Period | CHAR | 14 | 0 | FARR_RECON_KEY | ||||||||
| LAST_SAVED_ON | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | DEC | 21 | 7 | TIMESTAMPL | ||||||||
| POSTING_MODE | Posting Mode | CHAR | 1 | 0 | FARR_POSTING_MODE | ||||||||
| |||||||||||||
| EXCHANGE_RATE | Exchange rate | DEC | 9 | 5 | KURSF | ||||||||
| EXCHANGE_RATE2 | Exchange Rate for the Second Local Currency | DEC | 9 | 5 | KURS2 | ||||||||
| EXCHANGE_RATE3 | Exchange Rate for the Third Local Currency | DEC | 9 | 5 | KURS3 | ||||||||
| CREATED_BY | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||||
| CREATED_ON | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||||
| LAST_CHANGED_BY | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||||
| LAST_CHANGED_ON | Last Changed On | DATS | 8 | 0 | FARR_LAST_CHANGE_ON | ||||||||